Search results

When try to access the Tools|References option you need to have the cursor in a code window. The VBA reference will have MISSING next to it if it can't be found by Access.

Try the field property AllowZeroLength (see below) Set fld = tdf.CreateField("FieldName", dbText, 15) ' Allow zero-length strings in field. fld.AllowZeroLength = True

Have you created modules that manipulate the Class modules. You have to setup a normal module in the same database as the Class module and let procedures in this module handle the classes. The problem I found was that if the .mdb with the class modules is password protected then I couldn't...

Thank you Bob this works well. I hadn't realised that the recordset object property Name had the recordset field names.

Below is code I'm using to export Tables or queries to Excel. It sets up the table or query to a specific range in a specific worksheet. My problem is that I don't know how to transfer the table or query field column names aswell. I know that I could use TransferSpreadsheet method and there...

If I understood correctly from your problem description, below is some code that may help. This is used in a Listview control double click event from an application I worked on. The user doubleclicked on a list item in the listview. The request_ID could be your forms underlying query ID for...

I have just found a wizard on the internet called a references wizard. It checks if references are broken for the application you are in. I don't think I can attach it here but I found it at the following link: http://www.mvps.org/access/bugs/bugs0001.htm. This is a good Access site well...

I solution I have used for reducing network traffic is to write a download application. This application will take a snapshot of the database and create a .mdb file locally. The front-end application will then query the local mdb and not the server across then network. The user has to realise...

This would imply that you don't have the correct reference to a DLL for that function. When in the module go to Tools References menu option. My references were: Visual Basic for Applications Microsoft Access 8.0 Object Library Microsoft DAO 2.5/3.5 Compatibility Library Microsoft forms 2.0...

The TransferSpreadsheet method may help. This example is taken from the Help file The following example imports the data from the specified range of the Lotus spreadsheet Newemps.wk3 into the Microsoft Access Employees table. It uses the first row of the spreadsheet as field names...

When you open the .MDB file keep the shift key pressed. You will be put into design/database window view for the database rather than startup the application as you wanted the user to see it. Hope this helps

Have you tried the properties of the section in question. Each section has it own set of properties and events. The force new page property gives you the options to force new pages after each section. Click on the section header, click on the mouse right button and access the properties.