Search results

If you're changing the plate number in Table 2, and plate number is the key in Table 2, then I'd say do a lookup of the plate number in Table 3, not the (customer) ID. Also - if you set up "Enforced Referential Integrity" in the Relationships window, then it should make the changes for you.

You can either put both subforms in the same position and when you click a button set one to visible=yes, the other to visible=no or have one subform control and change its Source Object property eg procedure button1_onclick() subform1.SourceObject = "name of subform" subform1.Visible...

Oh yeah... looks like you're right! :D Good move on their part I think.

I had a similar problem with a .NET app I wrote for my (recent) previous employer... I packaged the app & installed it from the MSI. After making some changes to the app, I tried to just overwrite the exe with the new one. Try to run it & it complains about not being installed. So I ended up...

You don't want the user to have to give a password, & you don't want it stored in the ODBC... maybe I'm not understanding, but where else are you wanting it to get the password from?

Only if you download them before November! Get in quick! :D

VB6 is almost the same as Access VBA. I'd say you should be OK without training... if you get stuck on something, just read the help or search the net - it's what I do! :D

Best? hmm... Pro's: Faster execution, and reduced load on the network. Con's: Harder to maintain (see below). You mean ODBC settings? Yep. Yep.

If the new spreadsheet has the same name as the old, yes. The users shouldn't be allowed to see the tables anyway! :p

For ix = 0 to Users(CurrentUser()).Groups.Count - 1 MsgBox Users(CurrentUser()).Groups(ix).Name Next

You don't need to recreate the report every time. Just create it once (manually, or using the Wizard), then open it after importing the new roster table. You also don't need to "link" the Employee table to the new roster table. Basically, Access is just looking for a table with a specific name...

I don't think you can enclose macros in VBA transactions... but you CAN convert the macros to VBA! (automatically, even!)

(I still don't see why it couldn't be done as a query... or subforms) :confused:

I can't remember, but maybe Recordcount is 1-based & record number (in code) is 0-based?

There are standard deviation functions in Access: DStDev & DStDevP They may do what you want...

hmm... maybe the object.CurrentUser syntax is only for VBA? Have you tried just CurrentUser() in your query? btw, you're using a WinXP theme there? nice... what's it called/where can I find it?

Be careful with non-builtin cheats... apart from danger of malware as mentioned, if you do ever decide to play online, your old cheats (or remains of them) may be detected & get you kicked off. A lot of online games now have PunkBuster or similar to detect cheats, and they don't just look for...

Solved... The comments textbox had Hide Duplicates = Yes so any time there were 2 (or more) consecutive records with the same comments, only the first would show. (Why the hell was this ticked in the first place? I hate maintaining other people's code...) :mad:

including or excluding ".com"? eg, do you want http://apps5.oingo.com or http://apps5.oingo What about sites that have a different ending, eg http://www.access-programmers.co.uk You can use the InStr function to find the location of one string within another, and then use Left function to...

the Application object If you open Help from the VB editor in Access, it has an "Applies To" dropdown which tells you this... if you open Help from the object browser it apparently doesn't... gotta love MicroSloth :rolleyes: