Recent content by jsmith1611

Mailman, that worked like a charm. Thanks again for your patience.... :)

Here is my actual sql update statement from the debug window: update incoming_wires set date = #6/30/2008# where incoming_wires.wire_id =156 Thanks, Josh

I will try breaking it up into several lines. The reason I am not creating one update statement is because the edit form allows a user to update one, several, or all of the fields in the main form (and underlying table). Each update statement starts with: If not isnull(me.newDate) then This...

Ok, I have been able to successfully update the number and text fields in the incoming_wires table, but I am still having trouble with the date field. Here is my successful number field: 'update incoming_wires.acct Dim strsql_1a As String strsql_1a = "update incoming_wires " & _ "set acct =...

Mailman, your last post was exactly the kind of useful information I was looking for. Thank you to everyone that replied. I had no intention of offending anyone with my "useful" comment, but when you are already frustrated and you get a comment with no suggestions or even further questions, it...

OK, the wireid on the form is a text field. The wire_id is an autonumber field in the incoming_wires table. I am trying to update the incoming_wires table based on the text entered into an edit form using a sql statement. This form also uses sql insert statements to record the changes in an...

Does anyone want to post something that is actually useful?

Hello, I am trying to update a table using a sql statement in vba. I am getting a data type mismatch error and I think it is in my "where" clause. The wire_id field on the incoming_wires table is an autoNumber field and the primary key of the table. The wireid field on the form is a text...

Thank you for all of your help. Setting AllowAdditions was all I needed to solve the problem. I just added it to my addRecord code from the main form.

I have a parent form with two levels of child forms. I have set all forms to default to AllowEdits = False. When I click an Edit button on the main form, it sets the AllowEdits to True for itself and both child forms like this: Private Sub editRec_Click() Me.AllowEdits = True...

Here is the code that I am using on my sequence form: Option Compare Database Public increment As Integer Private Sub Form_Current() If Me.NewRecord = True Then increment = DMax("seqNum", "Sequence") seqNum = increment + 1 End If End Sub It is giving me a seqNum of 10 when it should be a 1...

HiTechCoach, Yes, group is the table and groupNum is the field. The problem may be that the group numbers are repeated on different tapes: Tables: tape group sequence The tapeNum field is the foreign key on group. The groupNum field is a foreign key on sequence. All the tables have...

HiTechCoach, I have tried to implement the dmax function to auto increment and default my group numbers. Here is the code from the form: Private Sub Form_Current() If Me.NewRecord = True Then group_num = DMax(groupNum, Group) groupNum = group_num End If End Sub group_num is a public string...

Hello, I need to have some default values for fields that increment. I have 3 tables for a database that tracks microfilm tapes: tape, group, and sequence. There are multiple groups per tape and multiple sequences per group. I have a main form for the tape, group is a subform of tape, and...

Hello, I am using conditional formatting on a date field on a form. I have a short date input mask on the field and a default date using the date() function. The conditional formatting is based on an expression which checks the value of another text field on the form. When I added the...