Recent content by rod1968

This problem is now resolved.

I have a Dymo EL60 Labelwriter on my system but since reinstalling XP, on every boot it detects the Dymo EL60 as "new hardware" even though the latest XP drivers, from the Dymo site, are loaded and the software works perfectly. My question is , can I suppress the new hardware detection...

I have been asked to investigate providing an Access frontend to an Oracle database and I'm wondering if anyone can advise me how to do it or tell me the pitfalls. This project is in its very early stages and i don't have alot of information as yet. If anyone can offer any assistance I would...

James, Sorry to have been so long getting back to you. Your suggestion about setting the warnings to FALSE have done the trick. Many thanks

Many thanks for your help, this has now proved to be the answer to my problems.

I'm still having problems :( When ever I run an action query, a nag screen pops up for confirmation (Yes, No, Cancel). As I always want the action query to run, I have set the Options, Edit, Confirmation checkboxes to un-checked. However, these options are not being set when I run the...

James, The Form I'm using does have buttons but not Edit or Add button. Does it have to be a form without buttons? I'm invoking my code "On Open" in the form properties. I will try it again tomorrow and let you know exactly what the message says ... It's something like &quot...

Thanks for the tip about not using "=". That allowed the code to run. But it doesn't seem to stop the record edit conformation nag screens unfortunately. Not sure where I go from here?

Hi James, Well as I mentioned, I'm not a programmer but this is what I have tried and the response I got. I created a "splash" form as suggested and created the DoCmd.SetWarnings = False in an event "On Open". When I open the form I get a Compile Error "Arguement not...

Thanks for the quick reply James. I will try this out and see if it does suppress the confirmation messages. I can see that I might have problems if it also suppresses error msgs too though. The particular confirmations I want to automatically accecpt are:- "Record Changes&quot...

I have converted a database to Access2000 from Access95 and I have attempted to run them on a machine with Access Run-Time. However I am now getting prompts for confirmation of record deletions and appendments which I had suppressed on the Access95 Run-Time version. It now seems impossible for...

I have converted a database to Access2000 from Access95 and I have attempted to run them on a machine with Access Run-Time. However I am now getting prompts for confirmation of record deletions and appendments which I had suppressed on the Access95 Run-Time version. It now seems impossible for...

Yes it does allow me to select from a list of 30 possible users, but I want it to detect the "logged on" user and for the value of Forms!StartForm!GuardianID combobox to be strUserID. In most cases this is how the users will be using the software, to look up items belonging to...

Hi Kathryn, That works and I can now see my userID in the MsgBox on the second form. However, what I really want is to have the userID, obtained from the API call, as the default value for my Combobox on the Start form but also allowing me to select any other userID from the droplist if I...

Hi Kathyrn, I'm still struggling with this. I am also very aware that I'm taking up your time and that my main problem is lack of VBA knowledge. I now think I am not understanding how to "call" the function properly. I will reproduce here exactly what my UserID module says:-...