Search results

I need to export the contents of a table (table1) to another database (table2). I want the contents of the table1 to be appended to the contents of table2. I would appreciate any help getting this started. I understand the the TransferDatabase command does not allow the data to be appended but...

Thanks, I will try using the recordset approach.

Thank you both for the quick responses. I am not sure I know how to do either of the things suggested. The database is being written from scratch to take the place of older (read that as poorly written) databases, but I am learning as I go. I have written a number of procedures in VBA that...

I have a form which includes a field for a program description. When a program is chosen, I want to have certain controls available for entry. Programs have overlapping fields. I have a table in my database that resembles the following (the fields a-d are check boxes): Program # Field A...

Never mind. I realized that the Primary Key on the Employees table was on the wrong column, it should have been the employeeid column. Now all is good.

Unfortunately I cannot post the DB due to confidential information, but here are the table structures: Clients: clientid - TEXT PRIMARY KEY clientname - TEXT clientAddress - TEXT clientCity - TEXT clientState - TEXT clientZIP - TEXT randompool - TEXT Employees: employeeid - TEXT ename - TEXT...

I have two tables that are the called "Clients" and "Employees". These tables are the result of merging similar tables from three other databases. The client table has a single entry for each clientid but the employee table can have multiple employees for each clientid. I need to create a...

I am trying to write a program in Access 2003 VBA that can import tables from three different databases, combine the tables and perform a query against the combined tables. There are two tables: a client list and an employee list. The client list has a single entry for each clientid but the...

Rabbie - The database is about 13 years old, originating from an Access 97 database (might actually be older). It was made into an Access 2000 database about 9 years ago and contains about 80k records. I like the idea of splitting the front end and back end but have no idea how to do that, or...

I have an Access 2000 database that I would like to secure. I was hoping to get some feedback about the best way to proceed. The databases are accessed by about 5 people. Each user must login to the network and into the server where the databases are stored. The database can be accessed...

Thanks Kafrin the forms call solved my problem. I was missing the "forms!" from the command. Because the panelId has to be entered and is used to determine which report is used, this was the easiest way to go.

I have a combobox in a form which lists the PanelID and PanelDescription from a query. Column 1: PanelID (This column is bound) Column 2: PanelDescription The row source for the combobox is SELECT [PanelDescriptions].[ID], [PanelDescriptions].[panelDescription] FROM PanelDescriptions; The...

Thank you. I feel a little stupid that I didn't notice that.

Here is a copy of the database table with all other information removed for privacy reasons.

The same result occurs. The fields that did not convert are left blank.

As far as I can tell, none of the data has any spaces or O's (letter). I tried exporting the table to and excel document and creating a new column of numbers, but cannot designate these as numbers when importing the table back into access.

I have a datatable with a column of numeric data. The column was originally assigned a type "number" but was converted to "text" by a user. I need to change back to "number" but I get an error message that says: I tried adding a new field and running an update query which assigns the value...

First, I am new to Microsoft Access, and am using Access 2000. Now that the disclaimer is out of the way, I need to create a report that combines information from two tables. The first table contains: Customer ID Customer Name Contact Person Contact Address, City, State, Zip The...

I have a database which is the combination of data from tables from several other dbs. The merged database was originally created by importing specific tables from the original databases. The data had to be combined and exported for manipulation by a third party program. After manipulation...

Thank you for your help. I don't know why this didn't occur to me.