Search results for query: *

Thanks Joe you were right. The null was taking place where i thought but upon debug i've already passed the error so it told me that there was no null. It was giving me a null because i have a private sub with onenter event which wasn't working properly so it just proceeded directly to that...

Why do i get "Invalid use of Null" on this little snippet of code? Me.OpenArgs is not null when this is populated so i'm lost. Thanks in advance. <code> Private Sub Form_Load() Direction = CStr(Me.OpenArgs) End Sub </code>

My form doesn't open to the specified record? Why doesn't this code work? It just opens to the first record in the table insteand of the queryjobnum. <code> Private Sub SubmitJobNum_Click() On Error GoTo Err_SubmitJobNum_Click Dim stDocName As String Dim Where As String stDocName...

Ok so i have a form where i can enter the job number, on submit opens the form edit job. how can i get the open form to either hide or close itself after the edit job form has been opened?

Why do i get an error for this code snippet "Error you can't reference a property or method for a control unless the control has focus" <code> On Error GoTo Err_SubmitJobNum_Click Dim stDocName As String Dim QueryJobNum As Variant QueryJobNum = Text0.Text stDocName = "Edit job"...

Hi guys, i'm hoping one of you pro's can help this novice out and write some quick code for me. I don't know the syntax to create a database query in a form module. Here's what i want the query to do. 1 - Query database and retrieve all records. 2 - With query result assign variable to each...

Hi guys, I'm looking to have a form where i can enter a job number, on submit it will open editjob.form and populate the form elements with the database values. I'm new to vba with access so i don't know how to do it. How can i pass my variable from jobnumber.form to editjob.form, perform my...

Hi guys, I'm new to using VBA with access. I have a form with some checkboxes and textboxes that correspond to fields that are in my database table. What i would like to do is have a form pop up in the beginning asking the user for a job number and when the user clicks the submit button it...

I am going to have more than one checkbox and textbox that will set the date in the same form. Is there a way to get element id or something. Like javascript you can get the element id for the checkbox so you only have one Private Sub to enter the date for the pertaining textbox. Can we do...

I am new to coding with vba in access. I have a checkbox and a textbox. I want to be able to check the checkbox and it sets todays date in the textbox. How can i do this? Thanks in advance.