Recent content by mattsmusicpage

OK. I tried what you said, and added all the not commands to cover the text boxes. I'm pretty sure I got all of them. see code below. So now, instead of that object error, I just get a blank microsoft access msgbox. Once again, if I dont click OK right away, the rest of the code still runs...

OK. I'm almost there. The problem is, after you click the msg box saying "connection lost, trying to repair", another box pops up saying "Object doesn't support this property or method." I've tried the On Error If Err=(I think it's 438) as that error message, and that doesn't suppress the...

OK. I tried your first round of code (Just copying the data to the local table). I got several errors I cannot figure out. I kept playing with it and then later checked the local table. It did copy everything once, but I couldn't tell which time I played with the code that made it work. Any...

OK. I look forward to seeing the code. So the only way to reset the link to the table is by closing the form and reopening it? There's no code to re-establish the link on the fly? I've tried using the code that updates linked tables and it stays stuck in the network error. I want to say I've...

Phil. I actually had the same problem. I was trying to create a work-around where the data would be saved to a temporary table on the FE of the database, and then reconnect to the BE, and copy that data from the temporary table to the BE again. I couldn't get it to work properly though. For...

still a lil confused Hi again. I did some more research and it seems to suggest that modifying the database with others having it open should not cause problems (so long as you do not change the tables. I only made new queries and changed forms on the version of the front end database I was...

Hi. I have been fixing up some access 97 programs on the computer systems at my work. The main changes I made was creating a search function using a query behind a form to search the database (no more than only 90,000 records). I am running a novell server. The data tables are in a database...

Using Access 97, I have a form and a report. There is text in a memo field on the form. I want the text to appear the same exact way on the report. The problem is that when the text goes to the report, the word wrapping (and spacing) of the text changed. If I were to print the form just...