Search results

I am trying to be able to have the user log into the database by selecting there name from the list of Users, then saving the user name as a TempVar, and then showing this field as a text field on other forms. I don't want the user to need to select there name each time they end up on the main...

I need to track orders and shipments from two different data sources, along with other items about the orders. Basically my thinking here is a main table for the tracking, appending the new orders to it, then mapping the appropriate shipments to it. Currently I have a query pull the orders...

I searched and found other issues with importing Dates, but none addressed the issue I am having. I am importing an Excel 2007 worksheet into Access 2007 via Access - External Data - Excel My spreadsheet, Access, and Regional setting are all for US. The date in the spreadsheet is in...

In my current system I have absolutely no control over two other sources which I need to map together based on items not being an exact match, but I do know the pattern of the differences (namely one system for what ever reason sometimes adds an "S" prefix to the front of a character string...

I have an access database front end to a SQL Server back end, written in Access 2003, stored on a shared drive. Some people have upgraded to Access 2007. Each time the database is opened in a different version of Access from the last time, the tables need to be re-linked or the person gets...

Is it possible to run a query against one table which will have one distinct result set, and then use that result set as the column headings within another query?