Search results

Ok. I see whats going on.. sigh... I apologize profusely. I was correct that all records are returned, and with all of them in a meaningless jumble of all possible combinations of records. Setting the Max value seems to have no affect whatsoever. But ordering the 2 dates by Descending seems...

Agreed. But now the question then gets back to the very first quesion I had in the first place. How to get the appropriate Shift & Budget IDs ( And now on top of the EmployeeID) to be put into the attendance table showing all 3 approbriate IDs pertinent to that moment. Creating a query to...

But then I'll basically bet duplicating all the data in shift and budget. That was my whole point from the beginning. Why add 2 new fields to attendance for the shift and budget table, thus doubling the size of the attendance table with ALL PERTINENT data relating to this information is...

CRAP! I think you might have it Len. I think it would work for individual incidents, like below: how to display an incident by a shift or budget, especially when the dates are different. Attendance would return date 2/5/06 for an incident. Budget and Shift both, respectively, have dates of...

If I remember correctly, PHP can connect to just about any database, including Access. But then all you would be getting is basically a static data storage from access and PHP just linking to drag the data out. No forms, no reports, none of the fancy stuff access does.

I agree, there might be a missing table, but i honestly cannot see it. All data is in its approbriate place, as best as I can see it, each linked / connected to ONLY the primary key, period. This is exactly what I have, as I stated earlier / before. The ONLY exception to this list that I...

DoCmd.TransferDatabase acLink, "Microsoft Access", "PathToDB\Name.mdb", acTable, "NameofTableinBE", "NameofTableinFE"

Must admit I am still a little lost on what you are trying to do but a few comments. 1) When you create a shift/budget records you have a single date (maybe date the combination was created) Then when you get the Max of date you get a single pair of values. But then I have to create ONE table...

do something along the same lines. code for on click. (Things in () are explanations, don't put them in the code) ***Subformname is the NAME GIVEN by the main form. Highlight the subform and find out what its name is if Txtboxname & "" = "" then (If the txt box is empty)...

That is understood Len. But at this time, the Date is inputted by a user. IE they have to type in the month / day / year. So max of such (or descending order, chose record one) will show the latest info for the budget or shift. Except, that if you want to put in attendance information for an...

Well, thank you len... But that doesn't help me much now does it... lol. The point is not whether there can be 1 foreign keys, the point is that two foreign keys with the idea that there is a "time" flow. IE only one valid set of shift and budget information at any ONE time. There are many...

I'm not new to access, and I understand normalization at pretty much all its levels, but right now I'm curious about a situation that I have just come across. The first time I've been in something like this, so I thought I would ask. This is the setup. I have employees. They are apart of a...

Honestly, at the moment, the only option i can think of is to keep a copy of all the FEs in the directory with the databases. When a server change, support company change, ZZZ change because of XXX, WHATEVER... The company can simply regenerate the FE's by going to the FE's in the directory...

Apologies.. But the moving servers etc is not a current situation. I'm setting up for possible changes / etc. The reason, because they already did this, and since everything was statically applied, changing servers and site upgrades (especially when changing tech support companies) can cause...

Yes, that would work, but if you link a table / etc to a front end, and they can get to the database window, they will be able to read ANYTHING that is linked to it, even if you set up your froms to "hide" data by only selecting certain fields to be shown. Linking the table will still allow the...

Not bad for a start... but, in some ways.. all wrong :D. In order to link relationally, the items have to be SET THE SAME!.. so a text -> autonumber or vice versa will not work, (as was stated above). So while you have right idea Company -> customer etc.. you are linking it wrong. As for the...

I have been having issues dealing with "moving servers" addresses, file relocations, and folder name changes. this makes 'linking' quite difficult. I came up with this option, and am wondering if this would work. 'Delete old table connection DoCmd.DeleteObject acTable, "ExampleTableLink"...

wrong, you can still edit it. All the menu bars etc are stil there. Unless you choose to have them ALL OFF. ALso, shift when starting the database opens that DB window. The best option you can have is to lock everything down so that nothing can open it, then have a administrator location...

I'm assuming in your table with the payment plans, you have each one identified by "monthly, quarterly, yearly" etc... My suggestion, instead of a field with "montly, quarterly, yearly" in the field, put in there the number of months those plans equate to. IE: montly =1, quarterly = 4 yearly...

In the same place that smart said... You can change the App title as well as Icon... if you create it. Tools -> Startup. Application Title: Application Icon: Change to suite. Kelemit