Recent content by ranen

Requery? no idea how to do that. thanks for the response.

Hello! Need some help cannot figure out how to do my idea. my problem is i have a combo box with a normalization within meaning the table query fields is 3 but I can you can see one field only, the field that you can see is not the one i am saving, since I have column counts as 0;1, the...

Here is my code for inserting record to sql server. i do get an error stating that "microsoft[odbc sqlserver driver][sql server] line 1: incorrect syntax near ',' I check all the commas but don't see any error can you please help me look for that error. Thank you so much " strSQL = "INSERT...

Hi guys, this is the code that I think I also got in this forum, anyway, i hope this will help someone someday Dim conn As New ADODB.Connection Dim rs As New ADODB.Recordset Dim strSQL As String Set conn = New ADODB.Connection Set rs = New ADODB.Recordset...

Hi pdx_man, Thank you for the reply. I fixed it already by searching all over the net and test all the info I've searched. Thanks so much. I do appreciate the response.

Hello! this is my first time to use sql as backend i don;t know how to use connectionstring and how it works... PLEASE HELP ME!!!!:(

Tried I tried to filter on the form open's event but I cannot get the right field that I will filter coming from the Switchboard. Thank you for the respond.:)

:( I am using a switchboard in my database, I have 3 forms using the same query,formats,etc but the 2 of 3 have filters. My question is how can I filter the form when I click a button in the Switchboard. I tried to do docmd.applyfilter but when the form is open nothing happens. And I also...

Hi! I made a code in sending an email and it is working fine. But when I logon to the server and send an email on that server I cannot receive any emails. but with my computer it is working fine. Is there any requirements/references needed to be add or check. or do i have to add something on...

I am trying to use my modules and very confuse how to use it. First I want to use it because I do have a redudndant info on every form I have and I want those Public Sub be in global. Second confuse because most of the code I have read they use module for functions. Can you please help me...

is this code possible I do have this code where I have to filter or look for the name and phone number of the person because when I am saving this record the one edited was the first record not the record with this previous information. Does my story make any sense? Please help me...I cannot...

I don't know how to explain my problem. my problem is if a record exist and want to update it using code. how can I filter that record and update it. my code updates the table but it updates the first record. so how can i go to that record and update it. i do have an error "syntax error FROM...

email www.paulsadowski.com/WSH/cdo.htm try to read this page it might help you...;)

log file Hi. sorry to bother anyone i'm just wondering is it possible to save all the changes in one table? I really need this one but i'm not sure if what i want to do is possible. Thank you so much...:)

Confuse I studied all the forms aand the code you post but still confuse on how to de it. The reason is I am using many tbales in one form and I don't know how the code will save it to one table only. any way thanks for the response.