Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. rod1968

    New Hardware detection

    This problem is now resolved.
  2. rod1968

    New Hardware detection

    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...
  3. rod1968

    Acesss frontend to Oracle database

    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...
  4. rod1968

    ACC2000 Run-Time Options Setting

    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
  5. rod1968

    2000 Runtime Tools Menu?

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

    2000 Runtime Tools Menu?

    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...
  7. rod1968

    ACC2000 Run-Time Options Setting

    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...
  8. rod1968

    ACC2000 Run-Time Options Setting

    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?
  9. rod1968

    ACC2000 Run-Time Options Setting

    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...
  10. rod1968

    ACC2000 Run-Time Options Setting

    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...
  11. rod1968

    ACC2000 Run-Time Options Setting

    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...
  12. rod1968

    2000 Runtime Tools Menu?

    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...
  13. rod1968

    Networked Database - Detecting User ID

    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...
  14. rod1968

    Networked Database - Detecting User ID

    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...
  15. rod1968

    Networked Database - Detecting User ID

    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:-...
  16. rod1968

    Networked Database - Detecting User ID

    Hi Kathryn, I am something of a novice with VBA .. a complete novice actually :) I'm not sure how to declare the UserID as a global variable? I assume it is done in the the module? I can see how this may well be the answer to my problem. Rod
  17. rod1968

    Networked Database - Detecting User ID

    Hi Kathryn, Thank you for responding. I mean that function works, telling me the "UserID" from Windows (it does not get the full name) but the "Fullname" and "UserID" are related in "User" table. I use this table to provide me with the droplist...
  18. rod1968

    Networked Database - Detecting User ID

    Hi, I have a networked database used by 30-40 people and I want to make it detect who is using the database when they log-in. I have the following code that returns the userID in a message box:- Declare Function GetUserName Lib "advapi32.dll" Alias "GetUserNameA" (ByVal...
  19. rod1968

    "Read-Only ?" What have I done?

    Well it appears that I had somehow removed myself as administrator from all the databases I wrote and administer. I bit of a problem eh ? :-) The good news is that, as if by magic, I seemed to have become administrator again ... not sure what had happened but every thing seems OK again...
  20. rod1968

    ACCESS 2000 Runtime Distribution

    Hi, Can anyone tell me if Access 2000 can produce Runtime executables ? I have done this with Access95 + Advanced Development Toolkit but I believe Access 97 and 2000 have the necessary tools built in. If anyone can point me in the right direction to find how to do it in 2000 I would be...

Part and Inventory Search

Back
Top