What code will "flag"end of record in an access memo field?
I have to create a csv file that contains 8 different record layouts from data in Access tables. In the header record, the record length is 61, while in the next record, the record length is 121, etc. I created an Access table with one...
I have Windows XP SP3 machines running Office 2007 (Excel and Word Only) and Access 2002. All was running fine until last Tuesday (8/14). Since then the users are getting intermittent errors "MouseMove you entered as the event property setting produced error: There was an error loading an...
We have a report in an Access 2010 database (database was written in Acc-2000, upgraded to 2003 and now again upgraded to 2010) where we set the filter on/off based upon criteria that the user selects from a form. The report runs fine in Access 2003, and on one machine in Access 2010. On the...
We have an Access database that was developed in Acc2003. It is broken up into the front-end and back-end. We want to upgrade to Acc2010, but found that in several tables the autonumber fields became corrupt(?). I then rebuilt the table structures in Acc-2010 and then ran a query to append all...
I'm working in Access 2003, and have a database in the 2000 format. If I open the database, stay on the main form and exit, access is released from the task manager. If I open any other form from the main form, when I exit, access.exe stays in the task manager. I've gone through the database and...
I have an access 2003 app from which I can select files and attach them to e-mails. I have no problem getting Outlook to open, show the attached files. Is there a way that I can get the signature file from Outlook and add it to the body of the e-mail>
I have a database written in Acc-2003 which executes a mail merge. We enter account numbers in a work table, populate the table with the customers names and addresses (Access), and then open an instance of word through code and merge the access table with the word document. All was working well...
I have inherited a Paradox 10 Application that is having some problems. I do not know anything about Paradox, so please bear with me. The files keep getting corrupted, and when they are not corrupt, the response time is slow.
My questions
The application is set up on a server, and all users use...
We have an access database that was written in Access97 and has been converted to Access2000. It is divided into a FE and BE. When using certain forms we sometimes get an error Jet Database Engine has stopped, record is locked by another user, even thought only one person is in the database at...
Msg#1 INVALID BOOKMARK
I have a simple Sales Order form with a subform for items, qty & price.
Recently we're getting an Invalid Bookmark error (Bookmark command is not used in code). Occasionally a "Jet DB Engine Stopped .. record in use by another user" error (even though no one...
I have an access database which was just converted from Access97 to Access2000. The user is running Windows 2000, and we thought converting the database to 2000 would alleviate the problem of slow response when opening the forms. The program resides locally, while the data resides on the server...
I have an application in which I have defined a query, and am trying to execute it using querydefs and parameters (The code follows below). If I open the query in design view, and manually enter the selection criteria, I receive the correct results, but, when I try to run the query from code...
I have a form, which has a subform onto which the user is entering a text field. (they do not want to use a memo field because they want to see all that they've entered without scrolling). When the user enters text which will wrap over the length of the text field (60 char for example), I want...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.