Recent content by Benny Wong

Hello Chad, Thanks for your quick response, I will looking into the linking of tables then. If the tables that I import into the new database is linked and I want to append the data will the append action query append both the one-to-many to the destination table? Thanks for your response.

Hello All, I am using Microsoft Access 2000 and wanted to know how to import data from another Access database that was done in Visual Basic. I know how to import flat-file database such as Excel but how do I import data that has a One-To-Many Relationship? The end user will need to...

Hi All, I am working with Microsoft Access 2000 and I have created two forms. The forms are frmClients and frmFindClients. The frmClients contains all the field from the table tblClients. The form frmClients has a command button that opens the frmFindClients form. The frmFindClients is an...

Hello debbied, I'm a beginning programmer myself but here are some suggestion that might help: 1. Backup the database before attempting the following: 2. Since the users are running in Access XP, then it would be better to upgrade the Access 97 database to Access XP...

ThumbDrive running Access Hello Brad, Thanks for the quick response. I didn't expect the response so quick. Anyway, if I understand what you are saying then the runtime can reside on the "ThumbDrive" however, I still have to install on the client PC the installation files in order to...

Hello All, I am working with Access 2002 and wondered if I purchase the Microsoft Office 2002 Developer Toolkit to create a runtime version of the Access Database that I created, can it be installed into the "ThumbDrive"? By the way, the "ThumbDrive" is a USB type drive where you...

Maybe this helps - Bruce Wayne? Hello NJudson, I am a newbie myself but from what I understand what you are doing is "importing several text files to perform some function" which cases bloating on your backend database because the data being imported has a range between 4000 to 12000...

Same problem before Hello Essendon, I have the same experience before but I took some precautions. What I did was: 1. create a new database and import everything into the new database. This way I can eliminate the database container being intermittant. 2. Periodically run...

MSPAINT.EXE Hi Essendon Try this code on the on-click event of the button. Private Sub Command0_Click() On Error GoTo Err_Command0_Click Call Shell("C:\Program Files\Accessories\MSPAINT.EXE", 1) Exit_Command0_Click: Exit Sub Err_Command0_Click: MsgBox Err.Description...

Hello All, I am using Access 2002. I want to be able to store a and run a simple database in a USB - THUMBDRIVE, is this possible. I heard that since the THUMBDRIVE does not have Microsoft Access then I would need to purchase a Runtime version of Access 2002? If I purchase this will...

Hello Pattyt, I'm a newbie but how about "requery" since the record is saved and the multiple users want to access the record but possibly the "timing" is the issue. Just a thought. I had a similar issue. Good Luck! Benny Wong

TransferSpreadsheet questions? Hello Fornatian and dcx693, Thanks for your quick responses. I have tried it and it works great. By the way, have you encounter the same problem that I'm having when the user enters data into the spreadsheet and either skips any number of rows or...

Hello All, I am using Access 2000. I am using the feature TransferSpreadsheet and if the path of the spreadsheet is present then the database works fine. If the spreadsheet path is not the same I get the VBA Run-time error as such: Run-time error '3011' the Microsoft Jet database...

Hello All, I am using Access 2000. I currently have a form that has three buttons. The three buttons are: cmdClickme = TransferSpreadSheet cmdstep1exit = Quit Application cmdReturnToMainMenu = Return to Main Menu The...

Hello Robert, Thanks for your response. I will try your suggestion tomorrow when I do the installation. I appreciate your quick response. Have a great day! Benny Wong