Recent content by mchris

Also Can I have to Me.Filter statement in one event??

not sure I think what I'm trying to do should look something like this. Me.Filter = "dtmCallDateTime=" & >= DATE() AND dtmCallDateTime < DATEADD(dd, 1, DATE()) Me.FilterOn = True But, I can't get this to work??? Any help??

Hello All- I have a form that contains a subform. On the 'on open' event of the subform I have the following code: Private Sub Form_Open(Cancel As Integer) On Error GoTo Failure Me.Filter = "lngAgentID=" & lngSessionAgentID Me.FilterOn = True ExitRoutine: Exit Sub Failure...

@@Identity in Multi User Setting??? I have the following code attached to a submit button on a form. When clicked it updates the entered information to tblContacts. It then returns the primary key, lngContactID, to the text field txtCID. I am having trouble finding out if this will work in a...

Thanks for the advice...I will heed it. I just started learning access and VBA like two weeks ago...it's a slow process, but I'm catching on.

Resolved GOT IT..... the last line..... 'WAS THIS strSQL = strSQL & " chrPhoneNumber = " & "'" & Me.txtPhoneNumber.Value & "', " 'SHOULD BE THIS strSQL = strSQL & "chrPhoneNumber = " & "'" & Me.txtPhoneNumber.Value & "'" How bout that??? Thanks!

It could be. The chrAddress2 field can sometimes be null, and is in my test example? Need I change anything to accomadate this? Also, I don't understand what you mean by Nz(me....),"" Is this what you mean...for each line: strSQL = strSQL & " chrFirstName = " & "'" &...

Hmmmm. Mailman- thanks for the quick reply and tips...much appreciated. I updated the code as you suggested...it is now: Private Sub cmdEdit_Click() On Error GoTo Err_cmdEdit_Click Dim strSQL As String strSQL = "UPDATE tblContacts SET " strSQL = strSQL & " chrFirstName = " & "'" &...

I have an edit button that when clicked should edit the values in my tblContacts. The code attached to the button is: Private Sub cmdEdit_Click() On Error GoTo Err_cmdEdit_Click Dim strSQL As String strSQL = "UPDATE tblContacts SET" strSQL = strSQL & "chrFirstName = " &...

[Unresolved] I've got the combo boxes to work. I just used your code and linked forms instead of a subform. Job done. Know I have a different problem. For some reason I can't have multiple entries. Here's an example. The cascading combo boxes first choose the product type (pen, pencil...

Resolved thanks...I copied your text and it worked fine..I must have had an extra character somewhere..I looked it over 1000 times I just overlooked it. I still haven't found the problem Either way, thanks

The names are spelled correctly. The form frmSaleProductInfo is the same form that contains the combo boxes...so, doesn't that mean the from is open?

I'm trying to design some cascading combo boxes for a form. The tables I'm using are as follows. tblProdType lngProdTypeID.........primary key chrProdType tblProductInfo lngProdID.........primary key chrProductName chrProdTypeCR......this is for commission purposes chrState...

Maybe this is because I'm completely new to this, but I'm not entirely sure what you mean. I understand the idea of the combo box with four fields. First you choose zip code and then it limits the choices in state and city respectively. I don't understand the bit about basing my form on a...

Hmmmm I was originally going to try that, but had trouble with the cascading combo boxes. Upon entering the zip code, the combo box for the city would need to change. I couldn't get this to work either. Any suggestions or resources? Matt