Getting data from two sources into one table
I have a form that will add data to say mainTable. In the form, I want to get some data like last name, first name and client_number from a linked master table (using a combo box) and have that data added into mainTable . I would also like to enter data (last name, first name [...]

Answer Question   |  January 14, 2013  5:48 PM
Microsoft Access 2010, Microsoft Access tables

Update query doesn’t update table
This is a really basic question, but I can’t seem to make it work. I have a simple table with 3 fields. StartTime EndTime ElapsedTime Each field is defined as a date/time datatype. StartTime and EndTime are manually entered. I’m trying to use the DateDiff() function in an update query to populate the ElapsedTime field [...]

Answer Question   |  January 14, 2013  3:12 AM
Microsoft Access 2010, Microsoft Access tables

Formatting Cells individually in a Table – Microsoft Access
I am currently in the process of using a Table to track employee annual leave, I need to be able to highlight all the weekends (saturday and sundays) in a different color to make easier to read. How do I do this?  

Answer Question   |  November 7, 2012  12:17 PM
Microsoft Access 2010, Microsoft Access tables

Cannot find tables
I am working with a ms access file. When I look at the objects in the access objects window using a category of “object type” I only see one table, when I use the category “Tables and views” I see three tables, these extra two tables are in the dropdown list if you try to [...]

Answer Question   |  October 12, 2012  6:16 PM
Microsoft Access, Microsoft Access tables

Date format in table
I record dates of birth and death from headstones. Often I only know the year, or sometimes the month and year. How can a create a table field to accept the info I have and not require a full date (month, day, year). I also would like to have a DateDiff field that will show [...]

Answer Question   |  October 12, 2012  10:44 PM
Microsoft Access 2003, Microsoft Access tables

Access
How do I change the selected columns to be required pieces of information?

Answer Question   |  October 10, 2012  4:30 PM
Microsoft Access 2010, Microsoft Access tables

columns in table (Access)
I am trying to create a table in Access and every time i do, my field/columns are starting from the right side instead of the left side.  Nobody seems to know how to change it.  Help.

Answer Question   |  March 5, 2012  8:15 PM
Microsoft Access, Microsoft Access tables

How to Set Active Period in a table
I have defined financial periods in table. In this table i have defined 3 fields, 1-StartDate, 2EndDate, 3-ActiveDeactive. Field type of “ActiveDeactive” is set to Yes/No. One record should be ON and remaining all OFF I want to set any financial period as active period at any time

Answer Question   |  June 1, 2010  12:03 PM
Microsoft Access, Microsoft Access tables, Toggle buttons

Make Table query Produces different result than same select query
In MS Access what would cause a make table query to produces differnet results than same query as a select query

Answer Question   |  April 16, 2009  7:20 PM
Access query, Access table, Microsoft Access, Microsoft Access tables

Paste from Microsoft Excel cells to Microsoft Access table successfully but…
When I perform a Paste Append into the table, the field I need that is a hyperlink is being truncated, thus link fails. How can I get the link to pates exactly as is from Excel?

Answer Question   |  March 30, 2009  10:51 PM
Hyperlinks, Microsoft Access, Microsoft Access tables, Microsoft Excel

Replace an Exsisting Table
I want to make a Table in Access. I figured this out but how do I overwrite this table because obviously I don’t want to make new tables again and again. Right now i have just implemented a simple table. Any help would be help. Thanks

Answer Question   |  January 2, 2009  7:50 PM
Microsoft Access, Microsoft Access tables

Beginner – How to move a table
I have one database, called Mask List. It contains two lists, Mask List and VIP Visits, which are unrelated and unlinked. I’d like to move VIP Visits out as a separate table I can call up and use without having to go into the Mask List database. I have created a link directly to VIP [...]

Answer Question   |  November 25, 2008  7:32 AM
Microsoft Access, Microsoft Access tables