Search results

I created an Access database in 2003 format and have upgraded from windows xp and office 2003 to Windows 7 with Office 2010. I have a table (tblemployee) that is using a autonumber as a primary key. Everything has been working fine with it but when I upgraded I needed to add a new employee. I...

I have a simple query to look at a table for a part number. There are 48 possible fields that the part number could be in. Can I make the criteria based on field 1 = to the other 47 fields? An example would be in Part_Number_1 criteria [Enter Part Number], in fields 2-48 criteria...

I have a table named tblProjectNumber that has a autonumber field. In design view under the format property I have "NC07-"00000, this returns the a new project number with the text in front of it. What I would really want is for the text the change dynamically with the year. So an example would...

I have a perameter query that tracks everyone's time on different projects. When they click on the command button to run the query they are asked for the current start data and end date (this is loaded into the date field within the query on the criteria cell). When they click on this query I...

I have a report named "rptTimeTracking" that is generated from a parameter query named "qryTimeTracking". The report works fine but I would like to have the parameters droped into the Report. This report was created by the chart wizard if that makes any difference. I have tried making an unbound...

I am new to both Access 2003 and VBA and need some help. I have a database I am building and would like to autopopulate the Name controls with the current user that is logged in. I have got the code to capture the current user from the Windows login and made some changes to it. The modual with...

I have created a form and modual to capture the current user. The problem is I want to use this infomation to populate a name field in my project form. The modual and form are capturing the login name of tpeter which is correct, but that is not listed name that I want. I need to to associate...

I have two tables put into one query to generate a report. One table is Projects and the other is Project Additions. Both tables have the same fields and I want to be able to sort using date criteria. It will sort by the Project table dates but not by the Project Number Additions table. I have...

I have 2 tables a project table and a project additions table, they have a relationship of 1 to many. When I run the query using both tables it only gives me the results of the project numbers that match in both fields. I need to have all information from both fields.