Search results

Hi, I don't know why, but my Microsoft Access 2000 Help's Answer Wizard and Index Tabs are completely empty! These pages are completely blank, with no dialog boxes or anything. How can I fix this? Thanks, Jean-Guy

I’ve loaded the combo boxes at load time (i.e. On Got Focus event procedure for Me.txtSomeField.RowSource = "SELECT …") as suggested in http://www.granite.ab.ca/access/performanceforms.htm, and it significantly loaded much faster! Thanks for the tip RuralGuy! Jean-Guy

I have 6 combo box controls that are based on queries that have as filter criteria, the values of other controls of the form itself. Other than that, there are about 25 text boxes for fields of the query that the form itself is based on. I believe the problem has to do with the 6 combo boxes...

Why is it that Access truncates real numbers when exporting a table into a CSV or DBF file? When exporting to an Excel spreadsheet (not with the “Office Links” menu option), I see these single quotation marks at the beginning of every text cell – why is that? If I try the roundabout way of...

I have a form that takes a long time to open – around a minute and sometimes longer. The form is based on a query, and this query on its own opens almost right away. Why would a form take so long to load up? What factors can increase a form’s load time? Jean-Guy

Thanks -- good work around Thanks a bundle ... this is a good work around till Microsoft eventually fixes this problem. I've modified your query slightly, as shown below, to also display the table's database with its associated path. ------ SELECT MSysObjects.Name, MSysObjects.Database FROM...

How do you get to see the entire file path in Access Linked Table Manager of linked tables that are located in a folder with a long path? The problem is that you can only view the first 64 or so characters of the table’s path. This is a real problem when these linked tables need to be updated...

I have several dbf files that I’d like to link into MS Access 2000 that have filenames longer than eight characters. Access by default doesn’t allow dbf filenames longer than eight characters. I really need to keep my dbf filenames the way they are right now (i.e. longer than eight characters...