Recent content by tbclbd

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 need to create an OCR-A barcode in a access database. Does anyone know of a function, like MD_Barcode39 which creates a Code 39 barcode?

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

To modify the ribbon Holding Shift Key, open database. Click on File/Customize Ribbon. The options available on the ribbon are listed on the right hand side of the screen, uncheck all. Access will prompt you to close the database and then reopen. When you reopen the database normally, the...

There is no way of getting the "File" tab to disappear, but, you can modify which options are available to the users. I haven't done it in quite a few months, but I will go over my notes and get back to you.

In order to turn off the "backstage" 1. Create a table in your database "USysRibbons", which has two fields "RibbonName" (Text) and "RibbonXML" (Memo). You will define which buttons should be available to the user in the RibbonXML field. 2. Add a record to USysRibbons RibbonName =...

I don't know if corrupt is the correct word. But, here's what is happening. There are records in the table, and the autonumber field values are from 1 to 48875. When I manually add another record to to table, the value of the autonumber is 48876, but if I go into the program and try to enter a...

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

Thank you Remou. With just a couple of tweaks, I was able to get my signature into the e-mail. Now I just have to clean up my code, and work through the security. Thanks again!

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

When you put the subform on the form, did you link the two by a unique field? If you don't link them, the subform will show all records. Also if your PONO field is text you would have to change the syntax of stLinkcriteria stLinkCriteria = "[PONO] = '" & Me![PONO] & "'

When you define the "Type of Payment" field on your report use an IIF statement in the control source for the field, instead of the field name. =IIF([Type of Payment] = 1,"Medicare","Private")