Search results

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 got it working by adding the "Me." and deleting the ".Value". Thanks for your help. Cheers Sandy

I still could not get it to work. But this is my first database, it has been a steep learning curve. I find vba/Excel easier! I did solve the date transfer problem by storing the date in the first form as a public variable and recalled it in the second form. So problem solved. The only reason I...

I will try that tomorrow and let you know.

tblStaff is current record source and the name transfers from the first form OK. If I change the record source to tblHourEnter the name and the date does not transfer. I do get a "Enter Parameter Value" message.

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 will close this question and reissue the last part.

Thanks again csh. The first part works fine but I am still having problems with the date part. The date I want transferred to the second form (which is now bound to tblStaff) only exists on the first form, not in any table. As an interim measure I am retaining the date selection textbox which...

Thanks csh. The staff name worked just like I wanted it to.:) My labeling and naming for the date on frmStaffReport was not good! The label for txtDateStart should read "Week Ending" and its textbox (txtDateStart) should get the date from the form (HourEnter), textbox (Week_Ending). Can you...

Attached is shorten version of database. Select a staff member, pick a date and hit the command button. You will see the second form I want the data transferred to.

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

Thanks anyway, Sandy.

The calculation I am doing is "=DatePart("ww",[Week_Ending],1)" and the calculated field in the table wont allow this!

Hi Paul, Once the calculation in the form has been done I want the result to go to the table. I do not want the result in the table field to change even if the the other field does change. I do not want to use "calculated field" in the table (available in Access 2010. 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

Thanks for your help JHB (the code worked fine) and Mark, I have almost completed my first database. Cheers Sandy.:D

It fail silently. Attached is database in question (with non relevant bits removed). If you open frmHourEnter and enter a job number that is not in the list and tab to the next field, frmJob opens. Add a new number and press "Save & Close". Its now that I would like the new number appearing in...

I changed the code, still no joy!:banghead: Interestingly I tried similar thing on two other forms and the requery worked, which makes me think it is a properties issue? Any thoughts?

JHB - I did not have cmbJob's property "List Items Edit Form" set to "frmJob", so I did this but it still did not show new item. Mark - The object of my database is to enter hours from a time-sheet and allocate them to a job number. If a job number is not in the list then the operator cannot...

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