Search results

In the properties of your report what is the row source data? Is it pulling information from a query? If it is all you have to do is find the date filed (in design view) of your query and in the criteria section type Between [Enter Start Date] and [Enter End Date].

When you go throught the lookup wizard are you selecting the name and hiding the PK? If so and you are using the info on a form you can go into the properties of that control. Look at number of colums and make sure it has 2. Next if you have two colums look at the colume size. If it only have...

So if I understand correctly my parameter query pulls infomation from tbltimetracking with a criteria of Between Enter Start Date and Enter End Date. So my reference needs to be Table!tblTimeTracking!Enter Start Date?

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

Here it is: SELECT tblemployee.UserId, tblemployee.FirstName & " " & tblemployee.LastName AS Expr1 FROM tblemployee; Once again I am sorry for being a pain. Tim

Alright I am very sorry for being a pain in ______. But it doesn't seem to want to work. I have tried this in my standard modual that gets the current users name and in the form and nothing happens: Private Sub EnterName() Dim RetVal As Long RetVal = Nz(DLookup("UserID", "tblemployee"...

I put this code into the on enter event of the form and it is cumming up with a false of the filter and closing the database. The FieldThatHasNTLogin is not located in the empoyee table is that a problem? The form that contains the NTLogin is frmLogin and the control is LoginName. The form has...

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

Enter Between[Enter Start Date] and [Enter End Date] into your critiria field of the date

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

WHERE (((tblprojectnumber.Date) Between [Enter Start Date] And [Enter End Date]) AND ((tblprojectnumberadditions.Date)>=[Enter Start Date] And (tblprojectnumberadditions.Date)<=[Enter End Date])); This is a sql that I have to sort by date it is 2 tables but It might help

Figured it out good old typo's thanks anyway

Can't you load in the criteria of the date field between>=[Enter Start Date] and<=[Enter End Date]

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

2 tables in a query that don't produce all results 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...

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.