• Add module to remote access database

    I have 100+ access 2000 .mdb's that I need to add a specific module to. What I want to do is loop through all mdb files in a specific directory and add a standard module to each one. Any ideas as to how to accomplish this from within access vba would be appreciated. I intend to do this from within...

    Ttstudio45 pointsBadges:
  • Problem deleting an object(form) in Access 2000

    When I try to delete a form that is visible in the object list a message 'could not find the object' is being returned. I have tried compact/repair and decompile on the database to no avail. Any ideas....

    Eamonngarvey5 pointsBadges:
  • Date Ranges in Access 2000

    How do I show multiple date ranges in Access 2000. I need to see counts of items that are 0 to 15 days old, 16 to 30 days old and so on, on my reports?

    LVogel5 pointsBadges:
  • limit number of users in access 2003

    I converted access 2000 to access 2003 and I did the front end/back end approach. I need to limit the number of users accessing the front end so it doesn't lock up the application and not populate the look up table...I inherited this application

    Herdine30 pointsBadges:
  • How Can i restrict the user to insert next record

    Hai all, I have a requirement that , i have to display the data from a table in the subform in a datasheet view mode. I should validate the fileds in such a way that i can restrict the user to insert a next record when the one of the fields in the previous record is null. And also i should pop up a...

    VBAccess5 pointsBadges:
  • access2k unicode text column even # of bytes error

    a certain row(s?) in an access2k table is corrupted. it causes the application to fail quite often requiring a messy procedure of bringing it up to date each time and it's been like this for years so no older backup exists. archive and fix fails for the same reason (unicode text column width must...

    Santa35 pointsBadges:
  • Save Access 2007 format as 2000 format with VBA

    how can i save the curent database as a 2000 format with vba

    Dave b10 pointsBadges:
  • Delete query

    Can you help me solve the following problem. Whenever i have an order where the field Audit = True, i will have to delete all the previous orders having the Audit = True. And only when customerid = 121. With other words i have to delete the previous orders having Audit = true but not the last one....

    Samotek15 pointsBadges:
  • How can i express the percent margin in a query for Microsoft Access?

    How can i express the percent margin in a query? I have a field PurchasePrice and a field Salesprice. the field Purchaseprice is the price at which we buy the products and the field salesprice is the field at which we sell the products.I tried to substract the salesprice to the pruchase price and...

    Peljo20 pointsBadges:
  • How supply password in VBA during CompactOnClose for back-end password-protected db?

    Access 2000: Goal: to open and close a password-protected public access db (which compacts on close) and hide the "Password Required" prompt on open and on close. Purpose: Provide public access to Main.mde and protect Main.mde from remote connections, i.e, import & link. I have password protected...

    Dlc9ball20 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following