Search results

I have a data entry form (frmHourEnter) where hours are entered a TextBox (Hours_Worked). The next tabbed TestBox (txtHrsTotal) gives a running total of hours – the code in Control Source being: =DSum("Hours_Worked","tblHourEnter","Staff_ID =" & [Forms]![frmHourEnter]![Staff_ID] & " AND...

I have a form with numerous textboxes, when using the enter key to tab to the next textbox the form closes. If I click in the next textbox it stays open. The tab order is correct. How do I solve this form closing problem? Thanks Sandy

I have a timesheet table (tblHourEnter) which has a staff field (Staff_ID), week number field (Week_No) and hours field (Hours_Worked). The data is entered through a form (frmHourEnter) which has a staff textbox (Staff_ID), week number textbox (Week_No) and hours textbox (Hours_Worked)...

I have a form (frmCompany) which has two combo boxes (cmbCompany and cmbCity) which is used to add field data into a table (tblCompany). The Company field is the only required field the other is optional. In some cases I may wish to add a City, at a later date, to an existing Company using...

I have a form (frmJob) that has a combobox (cmbCompany). If a new company is not in the table the NotInList code opens another form (frmCompany) and a new company is added into the textbox (txtCoName). The code below is the code that closes the frmCompany after entering new company. The...

I have created an accdb file and saved as an accde file. The accde file opens with a form with command buttons. But the commands buttons do not work with the accde file (they do work with the accdb file). How do I get them working. Thanks Sandy.

I have a form (frmHourEnter) with textbox (Week_Ending) to select a date, and a command button (cmdStaffReport) to open another form (frmStaffReport) with textbox (txtDate). The Week_Ending is not related to any table, it is just a date on a form. The first form code is: Public sDate As...

I have a date textbox (Week_Ending) and number textbox (Staff_ID) in a form (frmHourEnter), when both have values I open another form (frmStaffReport) with textboxes (txtDateStart and cmbStaff). How do I open the second form with the values of the first form pre-entered? Thanks Sandy

I have a form (frmHourEnter) with a textbox (Week_No_Calc) which has a calculation, in Control Source, based on another textbox. After exiting from Week_No_Calc how can I get a field (Week_No) in table (tblHourEnter) to be updated with the calculated value? Thank Sandy

I have a form (frmHourEnter) with a combo box (cmbJob) and if the number entered into the combobox is not in the list then another form (frmJob) is opened and a new number is entered. On closing this form I run: Me.Form!frmHourEnter!cmbJob.Requery The combo box (cmbJob) does not show...

I have an "on the fly" query within a form that has a checkbox (ckReWork) and a table (tblHourEnter) with a Yes/No field. When the query is run with the checkbox un-ticked I get results of all line items in table except those that are ticked. And when ticked get results of all ticked items. All...

I have a query in form which has two date-pickers, a start date (txtDateStart) and finish date (txtDateFin), both being in UK format (dd/mm/yyy). The query runs OK but shows no results. The code is” If Not IsNull(Me.txtDateStart.Value) Then strSQL = strSQL & " AND...

I have a form to enter data into a table. On completion of entering the last of a series of records there is always a blank form. On closing form there are two messages - "You must enter a value ......" and "You cant save this record at this time". How can I stop these messages appearing? Thanks...

I am using the following code in a textbox (CountryID) to show a country name (CoName) from a table (tblCountry). If the comboBox (cmbCoName) in current form (frmCountry) has no entry then CountryID remains blank, great. If I use the form to add a new entry then CountryID flashes because it...

I have used the following code (with the help of others) to make a query "On the Fly". It works but the results are in Detail (line by line) form for each Job Number. How do I get it to Sum the result rather than Detail? Thanks Sandy. Dim db As DAO.Database Dim qdf As DAO.QueryDef Dim...

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

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

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

I have a combo box (cmbJobs) in a form (frmData) which links to another table (tblJobs) . If the data entered into the combo box in not in the table (tblJobs) I wish to open the form (frmJobs) associated with that table. I will then create a new record, close the form and carry on entering data...