Search results

Hi Gina thanks for the offer of help. I am working on my first database (all my previous experience has been with Excel/VBA) so I will need some help. Where do I find the Cycle All Records? I could not find it the form properties? Can you give me the actual code for the Go To New Record...

Thanks for the link GinaWhip I will work through the code in the next couple of days and get it working in my case. Cheers Sandy

Thanks JHB, that was the clue I was looking for. Cheers Sandy

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

I have a form with 10 textboxes (say txt1, txt2 txt3 etc). The tab order is txt1, txt2 txt3 etc. When the form is opened data is entered into txt1 first then txt2 etc. After entering data in txt8, I want to start a new record rather than tabbing through all the remaining items on the form. How...

I have form (frmHour_Enter) that has a textbox (Hour_Rate) which has the Control Source with a DLookUp to find data on another table. The form (frmHour_Enter) is based on a table (tblHour_Enter) and this table has a field (Hour_Rate). The form finds the DLookUp data OK and it appears in the...

Hi Paul (Baldy), the problem seems to have solved itself! Its working fine now, thanks. Cheers Sandy

Thanks Mike, your code worked just like I wanted it to. Cheers Sandy

I have a form with date formatted textbox (Week_Ending) and a number formatted textbox (Week_No). On exiting Week_No I wish to show the corresponding week number in Week_No using DatePart function. I wish to know the correct code (related to the two textboxes) and where to put the VBA code...

I have changed the dash to underscore. We have partial success! The Staff_ID remained with the new entry. But the textboxes with FirstName and LastName were blank until I tabbed into that textbox and then the relative name appeared. How do I get the names to stay with the new entry?

File attached. It is a bit messy at the moment, its my first time creating an Access database. Learning as I go!

Still got problems. I get a run time error 2465, stating Access cant find Staff_ID which is the name of the combo box and the name of the field in the table.

I have added the following code: Private Sub Staff_ID_AfterUpdate() Const Staff_ID = """" 'Thats two quotes Me!Control.DefaultValue = Staff_ID & Me!Control.Value & Staff_ID End Sub Where Staff_ID is the name of the combo box that links to my staff table. It is not working for some reason?

I have a combo box in a form to select a name from a dropdown list. How can I get the last selected name to remain in the comb box when moving to a new entry? I wish the last selected name to remain until a new one is selected. Thanks Sandy

Hi ByteMyzer, Thank you very much, the problem I have had for over a year has been solved. It now saves as an xlsm file, all the macros work and the file opens OK. Cheers Sandy

If you are into hiking (tramping in NZ) you see that scenery all the time.

That worked, sort of! The Excel is saved with the correct name and as a .xls file. But when re-opened a message says that the file type and file extension don't match. But the file does opens and the macros within Excel work. I manually did a saveas and changed the .xls to .xlsm and that worked...

Hi ByteMyzer, the save code is If strFullPath <> "" Then objWorkBook.SaveAs FileName:= _ strFullPath, FileFormat:=xlTemplate, Password:="", WriteResPassword:="", _ ReadOnlyRecommended:=False, CreateBackup:=False End If Hi Steve, I can set the display alerts to false...

Its an even smaller world! My wife met an American couple when she went to her brothers wedding in Quincy and they invited to to stay with them at Lake Tahoe, which she did. I have traveled through Lake Tahoe going from Reno to Quincy. Adult beverages sounds good. Cheers Sandy Thanks Dayton.

We stayed a week at Quincy, my brother-in-law lives there.