Recent content by robmkimmons

Okay, so this is what I came up with: SELECT tbl_Master.Name, tbl_Master.PosNum, tbl_Master.RptToPosNum FROM tbl_Master WHERE (((tbl_Master.RptToPosNum) In (Select [PosNum] FROM [tbl_Master] WHERE [RptToPosNum] Not In (SELECT [PosNum] FROM [tbl_Master])))); ...runs but produces no results...

Maybe this helps to illustrate it visually: *Note - The numerical "levels" used below are for explanatory purposes, the real data uses arbitrary numbers. 100's = Individual Contributor (not listed in [RptToPosNum] field because no one reports to them) 200's = Front-Line supervisor (has at...

Thanks for the reply PHV, Unless i'm missing something, that's going the wrong direction. All employees in this table report to someone so there is always a value in that field. SELECT tbl_Master_1.Name AS SupvName, tbl_Master_1.PosNum FROM tbl_Master INNER JOIN tbl_Master AS tbl_Master_1...

I have an employee table tbl_Master that has a list of employees including their position number [PosNum]. Another field in the table identifies who they report to [RptToPosNum]. I am trying to query the "front-line" leaders aka: Employees who's direct reports do not have direct reports of...

Hi, I have summary information in Access 2000 that I wish to publish to our SP site. When I select the "Export to Windows SharePoint Services()" option it exports the information just fine (and i prefer this format over exporting it as .xls or .html formats). However, now that I have...

Thank you for your response. So that I understand correctly, tblAlias will only actually have TWO fields, each a foreign key and combined together making a composite key for that table? Also, tblAlias.AliasID will reference tblTerm.TermID? Thanks for your help! ~Rob If we expect the...

In creating a glossary I have tblTerm. A term might have one or more aliases that are also terms within the same table. For example: Term X = Aliases Y & Z Term Y = Aliases X & Z Term Z = Aliases X & Y Term A = No Alias Term B = Alias C Term C = Alias B My current table structure: tblTerm...

Barbola, In Access 2007 click the office button in the top left of the screen. Then click "Access Options" at the bottom of that window. Then click "Current Database" on the left-hand column. Then just a little ways down in the info. displayed on the right there is "Display Form:" section...

Hello! I’m looking for some direction. I believe that I’m doing “OK” on the relational data design, but am struggling with the syntax and details of the coding. I have the following tables created (see picture). Essencially, I want a simple form with two unbound text boxes, [txtBadgeScan]...

Hello, I’m pretty familiar with Access, but just not in a multi-user environment. Right now, there is only one terminal that the application is saved on, but I have three different users that can logon. I put the application within a shared folder for all users to access. I can access it...

Jonfer - I thought that would violate database normalization rules...?? One possible solution i've been working on through the modification of the above example is to have an "IN/OUT" field. So my table would look as such: [EmployeeID],[DateTime],[InOut] My query works as such: SELECT...

Yes, thank you it was. I changed the folder and that seems to have solved half my problem. Yet still it states that the file is in use or i don't have permission to view it though. ~Rob If we expect the unexpected, does that make the unexpected... well, expected?

Hi, I'm running windowsXP and have three different user logons on the same terminal. I placed the db in the shared folder so that whoever is logged-on can see/use particular access applications. However, the apps can only be accessed through my logon. If you are logged on as anyone else it...

I've tried the example above and it works great.. However, what can be done to account for more than one punch in the day? i.e. punch out for lunch and then back in. From what i understand this would significantly change the setup b/c you are using Min/Max right now. Can it be done? ~Rob...

I'm trying to decide which barcode symbology to go with for our warehouse. Ideally, i'd like to be able to label cases/containers with both the stock# as well as the quantity. Is that possible to code within one scan? If so, which symbology should i go with? Doesn't code128 support this...