Search results

I am trying to make a form that is user friendly and easy to expand. I have the following table: [Panels] PanelNo - unique number CatA - yes/no CatB - yes/no CatC - yes/no PanelNo 1 = CatA CatB PanelNo 2 = CatA CatC PanelNo 3 = CatA CatB CatC I have fields on a form for each of...

I am having two problems with the Date function. I am using Access 2003. Hopefully someone has some idea what happened and can help. First problem: I have a table and need to add a column with the current date. The following has worked perfectly for 2 years, until today...

I have been making a personal database to catalog articles I want to save from a number of woodworking magazines. The DB is fairly simple but I cannot attach it due to the size. There are three tables; three forms linked to the tables; and some reports. I want to include a picture of each of the...

I have a table with a list of people. I am creating a new table including a specific number of people selected "at random" from the first table. Here is the code that I am using: Dim strSQL As String Randomize strSQL = "SELECT TOP " & NumberToPick & " * INTO [Random Selections] FROM [Random...

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

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

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

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

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

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

I need to merge data from several tables for analysis by a third-party program. The TPP will cause the data to be reordered, amongst other actions. After TPP analysis, the data is brought back into Access for reporting. I need to know which table the data orignated from. Is there some way to...