Search results

Great. Thanks for your help.

Thanks for the link. Where do I put the "If Me.Dirty etc" code? I am much more familiar with Excel!

So for option one I would add - "Hours_Worked" + DSum(etc) into the Control Source? For option two would I add code to save record on exiting Hours_Worked" textbox?

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

Hi MarkK, sorry for the delay in getting back to you. I found the offending Command Button and all is now well. Thanks Sandy

I did have alter the code slightly: =DSum("Hours_Worked","tblHourEnter","Staff_ID =" & forms![frmHourEnter]! [Staff_ID] & " AND Week_No=" & forms![frmHourEnter]! [txtDateCalc])

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

Hi JHB, that worked a treat, thanks for your help, 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)...

Thanks to the article I think I have found the problem. I had a Many to Many relationship, so have added a join table.

Hi Mihail, "Happy Christmas" or "Merry Christmas" are the English expressions, you will have to wait until next December to use it! Thanks for the link regarding Normalization. Cheers Sandy

Thanks Guys. It is quite possible that there is something wrong with the form or DB as it is my first attempt in the world of Access. I will attempt to find the error today and then go on my Christmas holiday until mid January.

I am updating an existing record. The cmbCompany combobox (in frmCompany) lists all the existing companies. So I select an existing company, select a City from cmbCity combo box and then close the form. When I open tblCompany I have two companies, one with a city and one without a city. The...

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

Hi Madefemere, I have been struggling for weeks to find the right code to do what your code does. It worked perfectly. Many thanks for your help, Sandy.

Hi Madefemere, unfortunately that did not work. The new company has definitely been entered into the table but it just doesn't show in cmbCompany!

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

Thanks CJ. Hopefully someone else can help! Probably something simple. Cheers Sandy.

I never get that message. I went into File/Options/Trust Center/Macro Settings and set "Enable all macros". They still don't work. I went into File/Options/Trust Center/Active X Settings and set "Enable all controls". They still don't work. I am using Access 2013.

I don't get any messages, it just does not work. How do I enable the accde file?