Search results

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...

Bob, you are the greatest! Who knew the solution would be so easy. It would be nice to find an Access book that covered everything....any suggestions?

Bob, thanks for the reply. I have tried the conditional formatting from the format menu, but it doesn't seem to allow you to determine the formatting by the value of another field. When I select a value of "Y" from the combo box in the row, I want all of the fields (in that row) to be...

I am trying to conditionally format the foreColor and backColor of several fields in a datasheet based on a combo box which has 2 values. I would like to have the entire row change colors if the combo box has a "Y" selected and vice versa. I can get the formatting to work, however, the...

Singh, are you saying, for example, in the form_onload: setWarnings = no ?? I have tried this to no avail. I am not getting the message when I open a web page from a button, but specifically when opening a pdf file.

Is there a way to disable the warning message that is displayed when opening a pdf from a button? I have already changed the macro security setting to low but it doesn't seem to affect this message. Any help will be greatly appreciated. Thanks, Josh