Recent content by djpearce

Yes I did. Did it again and still have a larger-than-2MB file. However, I did find a way around it. Export the table from the old DB as CSV or Excel file. Import it into the new DB , modify and save the spec. BINGO! Thanks so much for your help.

I deleted EVERYTHING in the object list ... including modules. I use the "compact on close" option which compacted the database from 500 mb to 37 mb then zipped it to 5 mb. Dont know what to do to reduce the size. Could I send it to your email?

Thanks. I had already done 1,2,3. Didnt think to zip. File is now zipped. The zipped file Size is 5,952 KB, which is still larger than maximum of 2.0 that the forum allows for this file type. I am not sure how I could further reduce the size to upload it. Any additional suggestions?

database size is 37,360 kb. 2 attempts to upload failed. Deleted all objects and compacted. Size reduced from 502,128 kb to 37 kb. What else can I do? Error Message: vBulletin Message <window heading> Your submission could not be processed because a security token was missing. If this...

Hi. I followed the steps for transfering an export/import specification from one database to another but keep getting "The search key was not found in any record". Other object will export without problem. I even created a new (blank) database to import to, and even used different databases...

AHA! I discovered that the .Name property value had a space between tow-word field names. For example, PensionNo was typped as "Pension No", FirstName as "First Name" ... Thanks to all who tried this.

I have a simple 8-fields form bound to a table. I want to change the fore color property for each field if a check box is clicked. I am creating an “on-click” sub. When I type “Me!PensionNo.”, 2 of my 6 text fields do not allow me to change the color; in fact, it only shows “value” in the...

Hey KenHigg, thanks for your professional help. :D RAK, I visted the site. This is exactly what I am looking for. Thanks a million!:) :) :)

Hi, I would like to move some Access 2000 applications to VB5. Is it possible without re-designing the forms? I can cut and paste the codes but how about the tables, queries and forms? Thanks

Thank you for the clue, and the education. After reading about updating queries, I reverted to using VBA. A little more time in the begining, but is saves me time in the end.

Editable form I can not edit the record in the query. How do I make it editable? The query properties in design view does not show this. I think this is my problem. ;)

Hi. I created a form to be used for editing records. It displays ALL records in a "Files" table that match the BoxNo entered on a previous form. The record source is a query which has a relationship between the tblBoxes (one) and tblFiles (many). The records are showing in the form correctly but...

Hi. I created a form to be used for editing records. It displays ALL records in a "Files" table that match the BoxNo entered on a previous form. The record source is a query which has a relationship between the tblBoxes (one) and tblFiles (many). The records are showing in the form correctly...

I received a table with "#" in the first position for inactive records. Of the 8k+ records "DeleteCode = #" shows the correct number of inactive records when queried. However, when I use "DeleteCode <> #" I do not get any record in the query. Any Clue?

I set up user level security and printed my report. Then (for reason I do not understand) I followed the instructions and ran WRKGADM.EXE. Now, I am prompted for password each time I try to open any database. I have tried all the passwords on the report and none works. I get the message "Not...