Search results

Thank you

Hello friends. I would appreciate any help with this small problem. I have designed a form with a records source to table "tblCustomers". This table has fields like, ID, LName, FName, DOB, etc. When I open the form, it automatically goes to a new record: DoCmd.OpenForm "frmCustomers"...

Thank you. That works fine.

Hello friends, I have an unbound text box on a form named Age with the following code in the control source box: =DateDiff("yyyy",[DOB],Date()) & "." & Int(Format(Date(),"mm")-Format([DOB],"mm")) Unless I type a DOB in the appropriate DOB Text box, the Age text box shows the following error...

Fantastic Arnel. Great job as always. Thank you

Thank you Arnel. I have made the change to the cbo row source as recommended (C:\Folder) but getting an error message: The expression After Update you entered as the event property setting produced the following error: Variable not defined. Thank you

Hello friends, Searching around, I have found a great code to create a form that displays folders and files directly from MS Access. I know is simply replicating file explorer, but I would like to customize this code and having problems. On the form I have a cbo and two list boxes. The combo...

Hello, I have been exporting date from a form to MS Word with no problem, using bookmarks in the word file and appropriate VBA: On Error Resume Next Dim objWord As Object Dim strPath As String strPath = DLookup("[TemplateLocation]", "TablePath", "[TemplateID]='" & Me.[TXTPATH] & "'") Set...

Hello, can you please help me with the following code I have places in a unbound txtbox: =DateDiff("yyyy",[DOB],Now())+Int(Format(Now(),"mmdd")<Format([DOB],"mmdd")) I have a date of birth control. After I type the DOB, I would like to unbound text box to show the age format as years and month...

Great. Thank you

hello, I have noticed your have changed the code in the macro and added to autonumber but there is still something confusing me. If I open the form just as form (not from the frmMenu....meaning on the TAB) the combo, works fine although it should show no data (it shows test). If, I open the...

Appreciate your help. Thank you

Hello, I am designing a simple db and have created a main form (frmMenu) with a tab control with three pages. On each page, I have placed a different subform. On page1, I have Subform1. This form gets its records from Table1 and has an unbound combo box that allows to move directly to the...

Thank you. I think I have been able to sort the problem simply creating again the form and adding the combo. A nice macro in the after update event makes the record set change based on the selection in the combo. Thank you for your assistance and time.

Hello, I have created a form on which I have placed a tab control with two pages. On page1, I have a combo with its record source from a table (tblState) and a subform (SubState) with its record source from a query (based on the same tblSate). On the same page1 I have placed a textbox that...

Thank you.

Thank you. Considering that these field can even be left blank (not update), should I also indicate REQUIRED YES?

Hello, I am getting the following error message when closing a form: Run Time Error 3315 – Field XXX cannot contain zero length string. My db is update every month with data that I import from a text file. Data is imported in a table (table1) and displayed in form1 using a query as records...

The big problem I have faced in the years with the split db is having someone on the other hand running the refresh link table manager and other simple routing maintenance tasks.

Hello, I would appreciate any help with some code or advice on how to provide future assistance with my db. Since I have completed the database, periodically it may happen that some office may require an update or change to a query, form, etc. I was thinking of a way (copy object method?) that...