Search results

Member or Object not found That seems to be the error I am getting. Apparently, it does not recognize the ListBox1 as an object in Me or ThisWorkbook or Sheet1. Can you help? Nashat

A friend is trying to paste multiple values selected from a listbox into a named range. Is there any way this can be done? Any and all help will be greatly appreciated. Nashat

umm, i believe all the forms are unbound, and there are on average about 10 ppl hitting the db at any given time. the db is separated into a front- and back-end and these are both access dbs.. to the first of your two posts, i never wrote anything in code for this access db - i created it all...

at least once a day when the db goes into an unrecognized state.. sometimes more than once a day.. i do backup every half hour and plenty of times, we've had to bring in individual records from the backups when the #signs overwrote the record. nashat

hello.. of late, my db's back end has been "blowing up" - i.e. "Unrecognized db format". although the back end repairs fine, i have noticed that several relationships are being deleted and the primary key in one or more tables is also being deleted. for example, last night, following the...

did you try appending the records from the imported make-table into the empty table that you created in the new db?

the answer to 1 is yes and the answer to 2 is no.. we tried to implement workgroup security but every user in this office has administrative privileges and i did not (and still do not) know how to bypass that issue. the other problem we were having with limiting privileges is that people could...

hi kevin.. i went thru a similar problem sometime ago when i consolidated three dbs into one with many many more tables than in the original so i know exactly what you're experiencing. after i created the make table queries in the old databases, i imported the tables into the new db and used...

hello! lately our db has been giving us the error "Unrecognized database format" and we have had to repair our back end (at least once every day). After we have repaired, we normally find one or more records full of ### signs in one or more tables and delete them. The past few times, though...

Hi all! Since early this morning, our front end db has been giving us major problems. None of the buttons on the forms work, or they work for a couple of times, then they give the errors "You cannot carry out this task at this time" OR "Error executing the command." When I try to close the...

hi again.. thanks for the tip, but our db was in A2K.. but ihad backed up so I had ultimately convert to yesterday morning's version of the db so in effect we lost a day's worth of work.. oh well.. but thanks for all your help! nashat

can't even open the back end!!!!!!!!!!!! i even tried Microsoft's Jet Compact Utility.. no luck! Nashat

thanks for the reply.. unfortunately, i cannot get to the tables in the backend to be able to import or manipulate them in any way.. any other ideas? nashat

Hi there.. A few months ago we were having major problems with our database becoming an unrecognized database format, etc.. The majority of suggestions from this forum were to split the db into a front end and back end.. i did that and it has worked very very well for us - thank you! however...

thanks for your responses... we are seriously considering splitting our database. however, does this mean that we will not be getting any more "unrecognized db format" errors? if we would, does it repair and compact the same way as it does now? also, how can the tables, forms and other db...

hello.. we just converted to a new db last weekdn.. for the first couple of days we blew up once a day and the db compacted and repaired fine. however, today we've had an unusual number of blow-ups (by that i mean that the db is in an unrecognized format and requires repair)... it started when...

Hi! We have been having issues recently where our Access database, when being used by multiple users, and when one user exits and relaods the database gets the error, "unrecongized database format" and asks to repair the database. We feel that this may be the cause of multiple users tyring to...

Hi! We recently converted to a new database. I managed to bring in all the data from the previous database with no major problems. However, I had one table "Project" that assigned a ProjectID automatically using the AutoNumber Data Type. Now that my Project data is in the new database, the...