Search results

This message board is really great. I am a newbie at ms access and since it is not feasible for me to take a course I am trying to teach myself solely by using the internet. I hope one day to get a job in using ms access, right now I am just practicing. The following: If...

I have a combo on my main form with serial numbers. After selecting the appropriate record the user can choose to do a host of activities by clicking the appropriate command button. I felt that it was neater to choose the serial number from the main form and pass it over rather than having the...

"If the OpenArgs are null you know you have an new part other wise you have an existing part." Please excuse me but I do not understand what that means. The openargs will never be null because either newdata from the NOTINLIST procedure is being passed or the sn (cmbdserialnumber) is being...

I have a combo on a form that has contains serial numbers. If the user selects the appropriate serial number a form opens for the record to be edited. If the serial number does not exist the user adds it to the combo and a form opens so the user can add the rest of the information. Opening...

the second combo pulls up the correct task no's. I don't have a problem with notinlist. I have a problem with the record that is being chosen is not populating the fields in order to be edited.

First Combo - working appropriately Private Sub cmbDSerialNumber_AfterUpdate() Dim rs As DAO.Recordset If Not IsNull(Me.cmbDSerialNumber) Then 'Save before move. If Me.Dirty Then Me.Dirty = False End If 'Search in the clone set. Set rs = Me.RecordsetClone rs.FindFirst "dserialnumber = '" &...

I have 2 tables. Dockets and Tasks. Dockets contains the serialnumber (DSerialNumber) and the attorney docket number (DocketNumber). Tasks contains the serial number (TSerialNumber) which is related to the serial number in dockets, the task no (no) because there could be several tasks, the...

SOLVED!! A reply from a different forum So you're basically trying to (a) add a new record to the TaskList table, then open your "Task" form to further edit that record? If that's the case, then comment out these two lines; 'DoCmd.RunSQL "Insert Into Tasklist( TSerialNumber ) Select '" & Sn &...

One combo box is used for the dockets. The other is used for the tasks. If the user chooses the correct serial number then there are a list of tasks. The user could choose to add a task by pressing the correct command button. Is there a way I can upload or email the program so someone could...

Sorry. I have 2 tables in a database. The Dockets table has the serialnumber, Field is Dserialnumber which is the primary key. TSerialnumber is in the Task Table and is related to DSerialNumber. The Dockets table has the fields regarding the Inventor and Examiner and Attorney information...

I appreciate your consideration and your patience. I am trying to teach myself ms access with as little means as possible. I find the best way is to do this hands on. I have 2 databases. One is dockets and the other is tasks. Each docket could have many tasks. The primary key in dockets is...

Thank you for responding. Since sn seems to be the only variable having the right value I was hoping to pass it on to the Task form. But openargs and tserialnumber both don't have values. The serial number is saved in the previous record through the insert command. So I thought the dlookup...

Thank you for responding. I am trying to pass a variable to a form. It seems to me that when I open the form only the sn has the right value. The openargs is null as well as the TSerialNumber. However the previous record does contain the TSerialNumber. What I am trying to accomplish is that...

I have a command button on a form to add a task Private Sub AddTaskBttn_Click() Dim Result As String Dim Sn As String Sn = Me.cmbDSerialNumber.Column(0) DoCmd.SetWarnings False DoCmd.RunSQL "Insert Into Tasklist( TSerialNumber ) Select '" & Sn & "' As Expr;" Result =...

Okay, now I am getting an error "The Microsoft Database Engine can not find a record in the table with key matching fields. How can I pass the content of the serial number field from the combo box on field one to field 2 in order to add a record to the child database?

Okay now I am getting an error that the Microsoft Jet Database Engine can not find the record in the table with the key matching field. How can I pass the serial number from the combo box on form one to form 2?

When the add task button is pressed the form is supposed to collect the rest of the information for the record. The form opens and the serial number is added to the database however the rest of the field content on the form does not save Private Sub AddTaskBttn_Click() Dim Sn As String...

I have the following code if a command button is pushed DoCmd.OpenReport "RCE", acViewPreview DoCmd.OutputTo acOutputReport, RCE, "SnapshotFormat(*.snp)", "C:\MyDocuments\" & DocketNumber & "RCE.PDF". How can I make it pause to see if the user likes the preview in order to save it as a PDF file.

I thought of handling this differently. I am wondering if it is possble to have 2 different inputs masks depending is the field starts with a YO. Is something like this possible? IF left(nz([fieldname],vbnullstring),2)="yo" THEN input mask = "LLL00000-0000" ELSE input mask =...

I am a newbie to MS Access and I have been trying to find out information about the DOEvents() function. From what I understand it delays code from being executed until a form or report is closed. It is usually used in conjuntion with a loop. But I don't know what I am looping. Could...