Search results
-
J
Open Form to new Record and don't save
Thank you. But honestly I have never heard about it. -
J
Open Form to new Record and don't save
Hello friends, back for some other useful help. On a form I have placed a button to go to a new records: DoCmd.GoToRecord , , acNewRec. It cold happen that users don't want to save this entry or accidentally erroneously clicked on the New Records Button. Is there a way, you can recommend me to... -
J
Populate form with cbobox
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"... -
J
DOB/AGE Error
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... -
J
Display folders and files
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 -
J
Display folders and files
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... -
J
Export Records to PDF File
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... -
J
Unbound TextBox showing year and month from DOB
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... -
J
Subform on TabControl
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... -
J
Subform on TabControl
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... -
J
Combo and Sub Form
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. -
J
Combo and Sub Form
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...