1
Writing to multiple fields with one text box
I am trying to find a way to get a single text box to write to multiple fields within a table. The reason I want to do this is for graphing purposes (with an outside source) and to not over crowd/complicate a form for the operators who will be using it. If this is not [...]
Answer Question
| February 28, 2012 2:20 PM
Access Database, Access query, Access Tables, MS Access 2007
I am trying to find a way to get a single text box to write to multiple fields within a table. The reason I want to do this is for graphing purposes (with an outside source) and to not over crowd/complicate a form for the operators who will be using it. If this is not [...]
Answer Question
| February 28, 2012 2:20 PM
Access Database, Access query, Access Tables, MS Access 2007
How do I convert rows to columns in aAccess using Ms-access query(select statment)
Hello all, please I want help with the following issue: I have the following table named “CHECKINOUT” in ms ACCESS USERID NAME CHICKTIME 1 K1 5:45:11 AM 1 [...]
Answer Question
| February 15, 2011 10:57 PM
Access Functions, Access query, Access Tables
Hello all, please I want help with the following issue: I have the following table named “CHECKINOUT” in ms ACCESS USERID NAME CHICKTIME 1 K1 5:45:11 AM 1 [...]
Answer Question
| February 15, 2011 10:57 PM
Access Functions, Access query, Access Tables
Linking Fields from different tables (one table empty)
So I have 3 tables (table 3 being the issue but I have to explain the relationships for clarity): Table 1: Information is provided by Home Realtors into our online database and updated automatically to an access database on my computer. Info given: Home Serial # Home sq footage Home Location Table 2: Is in [...]
Answer Question
| March 11, 2011 8:51 PM
Access Tables, Linking fields
So I have 3 tables (table 3 being the issue but I have to explain the relationships for clarity): Table 1: Information is provided by Home Realtors into our online database and updated automatically to an access database on my computer. Info given: Home Serial # Home sq footage Home Location Table 2: Is in [...]
Answer Question
| March 11, 2011 8:51 PM
Access Tables, Linking fields
Access or SQL Server tables
Yes I am consultant for a small business, and currently they have a Access database that works pretty decently. At the current situation, the owner needs another database. I really do not want to have to ask the developer to keep creating different databases that includes him having to put more separate tables on the [...]
Answer Question
| December 16, 2010 4:02 PM
Access Tables, SQL Server administration, SQL Server Table Migration, SQL Server tables, SQL tables
Yes I am consultant for a small business, and currently they have a Access database that works pretty decently. At the current situation, the owner needs another database. I really do not want to have to ask the developer to keep creating different databases that includes him having to put more separate tables on the [...]
Answer Question
| December 16, 2010 4:02 PM
Access Tables, SQL Server administration, SQL Server Table Migration, SQL Server tables, SQL tables
Combining Access 2003 Queries for Dates Criteria
I have a MainInfo table and 3 different Log tables (PleadingsLog, LitigationLog and DiscoveryLog) that are linked to the MainInfo table by an IDnumber. Each of the log tables contains a date field and a notes field. I am trying to find a way to query all records from the MainInfo table that show a [...]
Answer Question
| December 14, 2010 12:43 AM
Access 2003, Access 2003 date query, Access query, Access Tables, Windows XP Professional, Windows XP Professional SP3
I have a MainInfo table and 3 different Log tables (PleadingsLog, LitigationLog and DiscoveryLog) that are linked to the MainInfo table by an IDnumber. Each of the log tables contains a date field and a notes field. I am trying to find a way to query all records from the MainInfo table that show a [...]
Answer Question
| December 14, 2010 12:43 AM
Access 2003, Access 2003 date query, Access query, Access Tables, Windows XP Professional, Windows XP Professional SP3
Get the latest unique entries for user ID in Access database
I have a database with a table that lists message entries. Each entry has an autonumber field ID, and a UID field that groups messages. My question is, how can I get the latest entry for each UID? Example Table: ID UID Message 1 1 Some Text 2 2 More Text 3 1 [...]
Answer Question
| November 24, 2010 3:46 PM
Access, Access Database, Access Database Format, Access Tables
I have a database with a table that lists message entries. Each entry has an autonumber field ID, and a UID field that groups messages. My question is, how can I get the latest entry for each UID? Example Table: ID UID Message 1 1 Some Text 2 2 More Text 3 1 [...]
Answer Question
| November 24, 2010 3:46 PM
Access, Access Database, Access Database Format, Access Tables
How do I copy an Access 2003 database and table?
I’m using Microsoft Access 2003. How do I copy a database and table? They were set up by someone that’s no longer with the company.
Answer Question
| October 27, 2010 5:29 PM
Access 2003, Access Database, Access Functions, Access Tables
I’m using Microsoft Access 2003. How do I copy a database and table? They were set up by someone that’s no longer with the company.
Answer Question
| October 27, 2010 5:29 PM
Access 2003, Access Database, Access Functions, Access Tables
Creating Access table
How do I create an ERDiagram from this table of information? Table=CUSTOMER- Customer_ID LastName FirstName Address PhoneNumber ContactNumber Email Address and add the following tables with this information: Table names: COSIGNEE -DRIVERS- PICKUPMANIFEST-DELIVERY_TRUCK_DETAILS-DELIVERY_MANIFEST
Answer Question
| October 18, 2010 8:04 PM
Access, Access Database, Access Database Design, Access Tables, Database design, ER diagrams, Windows 7
How do I create an ERDiagram from this table of information? Table=CUSTOMER- Customer_ID LastName FirstName Address PhoneNumber ContactNumber Email Address and add the following tables with this information: Table names: COSIGNEE -DRIVERS- PICKUPMANIFEST-DELIVERY_TRUCK_DETAILS-DELIVERY_MANIFEST
Answer Question
| October 18, 2010 8:04 PM
Access, Access Database, Access Database Design, Access Tables, Database design, ER diagrams, Windows 7
In Access 2007, how do I increase the file lock capacity so I can split an existing table into smaller ones?
In Access 2007, how do I increase the file lock capacity so I can split an existing table into smaller ones? Thanks
Answer Question
| September 2, 2010 11:14 PM
Access 2007, Access 2007 functions, Access Tables, File locks, Windows 7, Windows 7 in 2010
In Access 2007, how do I increase the file lock capacity so I can split an existing table into smaller ones? Thanks
Answer Question
| September 2, 2010 11:14 PM
Access 2007, Access 2007 functions, Access Tables, File locks, Windows 7, Windows 7 in 2010
Subquery in Microsoft Access
[em] Trying to create a subquery for a table in Access. I am trying to pull out of a table all records where Sales amount is greater than 1000 and the discount rate is less than 5%. I have to calcuate the discount percentage in the table, and don’t want to create another [...]
Answer Question
| August 20, 2010 7:13 PM
Access, Access query, Access Tables, Subquery
[em] Trying to create a subquery for a table in Access. I am trying to pull out of a table all records where Sales amount is greater than 1000 and the discount rate is less than 5%. I have to calcuate the discount percentage in the table, and don’t want to create another [...]
Answer Question
| August 20, 2010 7:13 PM
Access, Access query, Access Tables, Subquery
Query that uses input data from another form
OK..I need to query a data form that is set to extract data from one table, but I have other fields on the same form that needs to extract data from another table. I have a query that I intend to use to reference the data I need…but my question is what is the syntax [...]
Answer Question
| August 16, 2010 4:42 AM
Access 2007, Access query, Access Tables, Data Extraction, Query Parameters
OK..I need to query a data form that is set to extract data from one table, but I have other fields on the same form that needs to extract data from another table. I have a query that I intend to use to reference the data I need…but my question is what is the syntax [...]
Answer Question
| August 16, 2010 4:42 AM
Access 2007, Access query, Access Tables, Data Extraction, Query Parameters
In Microsoft Access is there a way to put IIF statement criteria into a table for easier management and reference?
I have some data with a list of Product IDs and I want to assign the Product IDs a category name based the criteria below. <br><br> IIF Product ID = #*C#* then category name = Cable <br><br> IIF Product ID = 00#* or 497* then category name = Component <br><br> … <br><br> I can get [...]
Answer Question
| June 25, 2010 1:52 PM
Access 2003, Access Tables, IIF function, IIF statement, Microsoft Product ID
I have some data with a list of Product IDs and I want to assign the Product IDs a category name based the criteria below. <br><br> IIF Product ID = #*C#* then category name = Cable <br><br> IIF Product ID = 00#* or 497* then category name = Component <br><br> … <br><br> I can get [...]
Answer Question
| June 25, 2010 1:52 PM
Access 2003, Access Tables, IIF function, IIF statement, Microsoft Product ID
Linking Carrier and Products in Access 2003
I have a carrier table and a product table. The Carrier table i have CarrierID and Carrier Name. In the Product Table I have ProdID,Carrier, and Product name. What I want to accomplish on a form is when I select a carrier in a combo window and then select Product in another window , I [...]
Answer Question
| June 24, 2010 5:17 PM
Access 2003, Access 2003 forms, Access Datasheet, Access Tables, Microsoft Access ComboBox
I have a carrier table and a product table. The Carrier table i have CarrierID and Carrier Name. In the Product Table I have ProdID,Carrier, and Product name. What I want to accomplish on a form is when I select a carrier in a combo window and then select Product in another window , I [...]
Answer Question
| June 24, 2010 5:17 PM
Access 2003, Access 2003 forms, Access Datasheet, Access Tables, Microsoft Access ComboBox
Report Page Header tied to Field in a Make Table in Access 2000
In Microsoft Access: How do I write the control in (properties) of an unbounded box created in a report header to display the a month I query (Criteria -Enter: Month) which then converts to a Make Table? When I run the query and am asked, “Enter: Month” and I type in “May”, I want May to show up in my report page [...]
Answer Question
| June 24, 2010 1:54 PM
Access 2000, Access query, Access Tables
In Microsoft Access: How do I write the control in (properties) of an unbounded box created in a report header to display the a month I query (Criteria -Enter: Month) which then converts to a Make Table? When I run the query and am asked, “Enter: Month” and I type in “May”, I want May to show up in my report page [...]
Answer Question
| June 24, 2010 1:54 PM
Access 2000, Access query, Access Tables
Assign Indicators to an Access Table
I have a table in Microsoft Access that has duplicate customer numbers. I want to auto assign a number to the records,i.e. 1 thru 6. But reset to 1 each instance the customer # changes. Is there any easy way to do this?. Thanks
Answer Question
| June 7, 2010 6:38 PM
Access 2003, Access query, Access Tables
I have a table in Microsoft Access that has duplicate customer numbers. I want to auto assign a number to the records,i.e. 1 thru 6. But reset to 1 each instance the customer # changes. Is there any easy way to do this?. Thanks
Answer Question
| June 7, 2010 6:38 PM
Access 2003, Access query, Access Tables
Joining 2 tables in MS Access and Searching & Retrieving records using ComboBox in VB and ADODC control
How can I join 2 tables in MS Access (e.g,tbl1 and tbl2)and Searching & Retrieving records using ComboBox and will display in a textbox after i click Search button in VB? I am using ADODC control as datasource
Answer Question
| April 7, 2010 8:50 AM
Access Tables, ADODC, ComboBox, Microsoft Access
How can I join 2 tables in MS Access (e.g,tbl1 and tbl2)and Searching & Retrieving records using ComboBox and will display in a textbox after i click Search button in VB? I am using ADODC control as datasource
Answer Question
| April 7, 2010 8:50 AM
Access Tables, ADODC, ComboBox, Microsoft Access
in Access 2003, adding data in a table affect queries?
Hi, I am using Access 2003. I am working on a database that already exists. I want to add a name of a location in a field in some existing tables. Basically I want to add a name of a location to a field that is a drop down list of locations. There are queries [...]
Answer Question
| February 9, 2010 10:37 PM
Access 2003, Access Tables, Microsoft Access
Hi, I am using Access 2003. I am working on a database that already exists. I want to add a name of a location in a field in some existing tables. Basically I want to add a name of a location to a field that is a drop down list of locations. There are queries [...]
Answer Question
| February 9, 2010 10:37 PM
Access 2003, Access Tables, Microsoft Access
Access Course/Student Database
I work in an educational environment. I have created a database that includes a table of courses, certificates & students. The relationships are correct, because when I look in certificates, I can see the courses for that certificate and under that the students enrolled in that course. Same with the students table, I can see [...]
Answer Question
| May 5, 2009 1:23 PM
Access 2007, Access Database, Access Tables, Microsoft Access
I work in an educational environment. I have created a database that includes a table of courses, certificates & students. The relationships are correct, because when I look in certificates, I can see the courses for that certificate and under that the students enrolled in that course. Same with the students table, I can see [...]
Answer Question
| May 5, 2009 1:23 PM
Access 2007, Access Database, Access Tables, Microsoft Access
Access 2007 table versus forms
I use Access for contact mgmt. database. I have my “main” table that has all my client info. If I create a form (looks like spreadsheet) and it is populated by the names in the table and I need to delete names from the FORM, not the original table, does it delete also from the [...]
Answer Question
| April 21, 2009 2:45 PM
Access 2007, Access forms, Access Tables, Microsoft Access
I use Access for contact mgmt. database. I have my “main” table that has all my client info. If I create a form (looks like spreadsheet) and it is populated by the names in the table and I need to delete names from the FORM, not the original table, does it delete also from the [...]
Answer Question
| April 21, 2009 2:45 PM
Access 2007, Access forms, Access Tables, Microsoft Access
1
