Search results

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

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 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 All, I am using Access 2000. I have already created a database in which the Front-end and Back-end is stored on the Server. My question is on the Front-end which are a series of Forms where the user can do their data entry, data edits, run their reports, etc., should the setup...

Hello All, I am using Access 2000. I have a table named tblExport. The table contains three three fields: Computername, Date, and Time. The table gets populated when a user clicks on the Export button on the front-end. What I would like is when the table tblExport is updated from the...

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

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

Hello All, I am currently using Microsoft Access 2000. I have a table named tblclient. In the table I have fields named: FirstName MiddleInitial LastName ETC.... I have a number of data sources that I would like to import into tblclient. The...

Hello All, I am currently working with Access 2000. I am trying to create a mailing label. The label is setup as: FirstName LastName, Title Organization Address City, State Zip The problem that I am having is the Organization...

Hello All, I am currently using Access 2000. I have a table called tblclient. In this table I have a field called zipcode and the data type was set as text. When I export out to Excel I get error at text instead of number. I have tried changing the field data type as number but it...

Hello All, I'm using Access 2000. I have a form that is constructed as Query by Form that is populated with combo boxes, listbox, and text boxes. When the user completes with their selection of the unbound controls and clicks on the command button out comes a report. My...

Hello All, I am working with Access 2000. I have already created a form with unbound controls such as combo boxes. Currently, I have the combo boxes reference the lookup table for the items in the combo boxes for the user to select. On the query grid where the criteria line I put in...

Hello All, I am using Access 2000. I'm having a hard time to make the Query by Form to work, here is what has been done: Table = tblClient Query = qryLabel Form = frmReport Report = rptLabel As I understand it in the Query - criteria area for each field of the...

Hello All, I am using Access 2000. I would like to create something called "Query by Form" where I put a series of unbound controls such as combo boxes, listboxes, and text boxes then with a command button I can generate a label report. How can I make this happen? Thanks for your help...

Hello All, I am using Access 2000. I am wondering if it is possible to update data / import data into the database when the data is for both the one-side and the many-side of the database? If it is possible how can I do this? The tables are: tblClient - one side tblContactType...

Hello All, I am using Microsoft Access 2000. I have created the report which is using the Avery Label using 5160. There are four rows for the label. The format is: Row 1: First Name Last Name, Title Row 2: Organization Row 3: AltAdddress1 Row 4: City, State Zip...