Search results

I have a report based on a simple query but the report only shows every other record so I only get half of the reports I need. I am sure it is a simple setting somewhere but I cannot find out why. Here is the database. There are 14 employees in the table, 14 employees in the query derived from...

I have a form that is bound to a table (tblBids). On the form is a combobox that is bound to a different table (a list of all employees and their employee ID) The employee id is a text field. When the user selects an employee in the combobox the form is set to the bookmark for the appropriate...

I figured it out. I wasn't thinking about the DMax function being part of the DLookup function and was already enclosed in quotes. So you have to double up on the quotes. Here is the correct version: =Dlookup("comments", "tblDocsIssued", "EMP_ID = '" & [EMP_ID] & "' AND...

I have a control on a report that I need to set the properties to get the following data. The report has a textBox control called EMP_ID and I have a table called tblDocsIssued. This table has the fields EMP_ID, docDate and docType. I need to get the comment that has the most recent docDate and...

I have a form that I want to be populated with bound textbox controls. The record source for the forms is a query and I believe my problem is that the query in not able to be updated. To get the query I have a table (TablePositions) that has FacilityID as one of the fields. I then have another...

Thanks a million!

Is it printing 2 or 3 blank pages? Or is it pages with data? Make sure that your report in design view is not bigger than the paper you are using. Also check the page set-up for the report and adjust margins if you need to.

Well, I tried it and I got #Error in the control....:banghead: (my turn) I attached the DB for you to see what I am talking about. One little glitch can be such a pain... I appreciate all your help!

I tried it and got a syntax error Missing Operator: I did modify it to take into account the text field. I used: =Iif(Dcount("docDate","qryTop2Dates","((docType = 1) AND (EMP_ID='" & [EMP_ID] & "')) > 1, DLookUp("MAX(docDate)","qryTop2Dates","docType=1 AND qryTop2Dates.EMP_ID ='" & [EMP_ID] & "...

Isskint, Thanks, I ended up figuring it out..I also had the issue that EMP_ID is actually a text field so I had to put in a few parenthesis. But then when it worked, I found another error. I use the MAX to fill in the value in one text box and the MIN for another textbox. The problem is that if...

I have a report that is bound to a query (qryReport) in this report I have a few textboxes that I need to get the data from another query (qryTop2Dates) I tried to use the DLookup function but I couldn't get it to work. :banghead: qryTop2Dates has the following Fields: EMP_ID 'used as an...

I have a table that is used to track staff training. This table has 3 fields: EMP_ID (Staff ID number) docType (identifies the type of training, will be a number from 1-4) docDate (identifies the date that training was given) Staff can be trained several times on the same training type...

I have a report that I need to include data from another table. This table lists training dates for an employee. There are 4 types of training (1-4). The query for the report has several aggregate functions and that works properly but I don't think I can join the other criteria to the report...

Well I found the problem...I think. The query that I was using, was pulling information from two tables and a query with a couple of inner joins...It worked fine for populating the form but had issues with updating the recordset (the query was too complex) I just created another query that...

Wierd...I ran it on three different computers at work-----Access 2000 on XP worked fine, Access 2003 with XP didn't work....And then on another XP with 2003 didn't work, then I tried it at home Access 2007 on Vista...didn't work.

fdcusa, did it save the data changes??

Here is the DB. The problem lies in the form frmEditIncident.To duplicate the problem, click on the Data button and then select an incident from the Log# box and then select a name from the name box. Change any of the data and save the changes. The save data function does not work. I hope you...

I am not quite sure what you are wanting to do, what kind of information are you wanting to add? Is it the same for all employees after they hit the 3 month mark? I think you can accomplish this by using 3 tables. The first one will just have the basic employee information, ie. name, position...

The DAO 3.6 object library was selected. The information does not get saved....No error Message either. I have used the dim statement may times without the DAO reference and have never had any issues. I changed the reference to DAO.recordset and when run I did not get an error. After looking...

I have a DB that was written in Access 2000 that works. When I try to run it in Access 2003 it doesn't work. I tried to convert it from 2003 but that did not fix the problem. The form has several controls (text boxes, checkboxes and combo boxes) The form controls are populated from the result of...