Search results

Thanks Paul, that worked. Cheers Sandy

I will always select a job number BUT want an hours summary for all staff members for that job OR select a staff member and get hours summary for job selected.

When I create a form in design view and then open it, the form fills the whole area. The Fit To Screen property is set to No, and Auto Resize makes no difference no matter what it is set at. How can I reduce the form size (so it looks like an Excel form)? Thanks Sandy

I have used the following code in a command button, on a form, to build a query: Dim db As DAO.Database Dim qdf As DAO.QueryDef Dim strSQL As String Set db = CurrentDb Set qdf = db.QueryDefs("JobSummaryQuery") strSQL = "SELECT tblHourEnter.* " & _ "FROM...

Hi JHB, I found the link in the Control Source of ckEmploy. Thanks again Sandy

That worked great, thanks. Question - the form (frmStaff) has the checkbox (ckEmploy) and by ticking this checkbox the field (NoLongerEmployed) in table (tblStaff) gets ticked. How are the two linked? Cheers Sandy

Hi JHB, file attached. Thanks for your help, Sandy

Followed the link, Thanks JHB. But I am still unsure of how I tie the code into the form with the checkbox to limit what is viewed. Cheers Sandy

I have a form (frmHourEnter) with a combo box (Staff_ID) that lists staff members from a table (tblStaff). The table form (frmStaff) has a checkbox (ckEmploy) which indicates if a staff member is still employed. If the checkbox is checked how do I exclude that staff member from the combo box...

Thanks Catalina that worked fine. Cheers Sandy

I have combo box that lists data from another form (frmCity) . If the required data in not in the list then frmCity is opened, a new record is entered and form closed. The combo box in the first form (which has remained open) does not show the new entry unless it is closed and re-opened. How can...

Thanks again. I visited Ohio in 1978, but more recently I was in Vermont (during the fall) and northern California (San Francisco and Quincy), and before that Alaska. Great country! Cheers Sandy.

Hi Gina, On_Exit Event was the way to go! It now works fine. Thanks again for your patience and help. Another question: How can I put VBA code in a command button on a form to bring up another form, without using the Command Button Wizard? In Excel I would use "frmJob.show". And is there any...

Thanks Gina, I will try that tomorrow. Its home time here in New Zealand. I will let you know how I get on.

If there is no code present the Ellipse button brings up an Expression builder, Code builder etc options. I went to Form Design Tools-Design-View Code and entered code, see attached. But then got a run time error, see attached. Thanks for your patience.

Removed the = sign and did not get the Invalid Syntax message. See properties window attached. But entering data into the Hours_Worked textbox I got another message, see attached.

This is the code in After Update: = DoCmd.RunCommand acCmdRecordsGoToNewLooking in the Properties/Event for the textbox "Hours_Worked" there are no other events that I can see!

Textbox "HoursWorked"

I found the correct properties window (easy when you know how!) and made the changes. I copied the code you gave and entered it into the After Update Event using the Expression Builder. But get an Invalid Syntax message. Do I have to change the code to suit my form? The form name is...

Hi Gina, I have looked for the Cycle All Records but cant see it (domestic blindness!), see attached. Is it called something else? Cheers Sandy