Search results for query: *

Hello RamziSaab, If I understand what you are asking then you can: Divide the database into two parts, one being the backend and the other being the frontend. On the front-end you can supply the user with a form where the user can select their criteria and the output is either displayed on...

Hello All, Thank you all for your time in responding to my request. I appreciate all you inputs and agree that it may not be a viable solution so I need to think it through more. There are just too many variables and not predictable in a mixed environments. Thanks again for all your help...

Hello James, Thanks for your response and I'll have to try it out just to see if it would work. Appreciate your time - Thanks!

Hello All, I am currently a Microsoft Access Programmer. However, I need to create a program that resides in a USB ThumbDrive - 128mb. I understand that Microsoft Access can't do it and wondered if Borland Delphi can do it. What I need is two things: 1. Be able to create a...

Hello James, Thanks for your response to my question. The purpose of the database is to collect information, so it would be very small. I just need to know if the target PC doesn't have Microsoft Access, can I install all the appropriate files to run the runtime of the database on my...

Hello All, I am working on Access 2002. I am wondering if anyone or developer have tried using the "ThumbDrive" - a USB Drive connected on the USB port which acts as another drive. I would like to know if I create a database in Access 2002 and using the Access 2002 Developer's...

Hello Sarah, If I understand what you are asking then you can do this in a macro. Select the TransferText in the Action column of the macro and fill in the properties on the bottom then save the macro. Next on the form create a button and on the "On click" event attach the macro...

Hello Ragu, If I understand what you are asking then you need to create two forms. The first form would be to create a form reference to the table you want to update and drag the field list on to the form. Next either in macro or vba create the openform formName on the on click event to...

Hello Ken, Thank you so much for your response. You're right I could have a delete query to clear the null field on the table. Why couldn't I have thought of it. Still a newbie? Again, I appreciate your quick response and Thank you very much for your time and assistance. Benny

Hello Ken, Thanks for your response. I tried it and is working just great! I having a different problem in that when the user enters data into the spreadsheet and skips any number of lines when I import the spreadsheet into the database it carries over the number of lines. How can I just...

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

Hello All, I am using Access 2002. I am in the beginning of a project and wanted to know how I can create what I called a "Cascading Combo-boxes". An example to this is of the following: 1. Product 2. Category 3. Type 4. Model The above is a list of Combo-boxes. What I mean is...

Hello FancyPrarie, THANK YOU! THANK YOU! THANK YOU! That did it! I really appreciate your help and your time with the quick response! Also Thanks to Nealv for his time and efforts! Time for me to try to digest all the codes. Benny Wong

...and is located on your local computer hard drive C:\COMPLETE_DB.xls" Set dbs = CurrentDb Set rst = dbs.OpenRecordset("Select * from tblExport Where User = '" & User & "';") If (rst.BOF) And (rst.EOF) Then rst.AddNew rst!User = CurrentUser...

Hello Nealy, Thanks for your response. I really appreciate all the help from this website. Anyway, I tried your code and compiled it just fine. I ran it and the export went fine but I get a Run Time error '-2147217900(80040e14)': Syntax Error in insert into statement. The complier stop at...

...and is located on your local computer hard drive C:\COMPLETE_DB.xls" Set dbs = CurrentDb ' Set rst = dbs.OpenRecordset("Select * from tblExport Where User = '" & CurrentUser & "';") Set rst = dbs.OpenRecordset("Select * from tblExport Where User =...

Hello MHUK, How about spending $34.95 to solve your problem? Here is the website that may help? http://www.acc-technology.com/scwiz.htm Here is some details about the product. SCHEDULE THE RUNNING OF YOUR MS ACCESS TASKS! The Schedule Wizard will allow you to...

bump, bump Me too!

Hello All, I am currently using Access 2000. I have a mailing list database which I would like to add a simple audit trail to record when a user exports out the whole database into Excel. This is important to the Management to maintain security of the information of the clients in the...

Hello All, I am using Access 2000. I am working on a form where there is a bunch of combo-boxes. I am able to make one of the combo-box to drop down in the on enter event. Here is the code that I use to do this: Private Sub Combo72_Enter() Me.ActiveControl.Dropdown End Sub I know that I...