Recent IT Questions

1 - 8 of 8
<<PREVIOUS 1 NEXT>>

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

Answer Question   |  Jun 28 2008   5:53 PM GMT   |  asked by Ttstudio
Access, VBA, MDB


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

Answer Question   |  Jun 16 2008   2:08 PM GMT   |  asked by Herdine
Access 2003, Access 2000


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

Answer Question   |  May 13 2008   7:38 PM GMT   |  asked by Santa
Access 2000, Unicode text column error, Data recovery


Save Access 2007 format as 2000 format with VBA

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

View Answer   |  May 6 2008   10:23 AM GMT   |  asked by Dave b
VBA, Access 2007, Access 2000


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

View Answer   |  Apr 30 2008   11:23 AM GMT   |  asked by VBAccess
VBA, Access 2000, Microsoft Access


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

View Answer   |  Apr 18 2008   5:53 PM GMT   |  asked by Samotek
Access 2000, Database, DELETE statement


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

Answer Question   |  Feb 27 2008   7:16 AM GMT   |  asked by Peljo
Access 2000, Microsoft Access


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

View Answer   |  Feb 19 2008   9:46 PM GMT   |  asked by Dlc9ball
Microsoft Access, VBA, Access


1 - 8 of 8
<<PREVIOUS 1 NEXT>>