Search results

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

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!!!!:(

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

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

help please...I do have a form where there are multiple checkbox our user need to choose I need to filter in the table all the checkbox chose. I'm having a hard time trying to figure out how tofilter it....Please help me... thank you so much...:(

Hi! I really need help withi question as soon as possible. I do have a database, I want to log all the things inside my db. every time they save every time someone do somethng on the database i should log it. how will i do that...thank you for the help

Help!!! need help!!! I do have this form where I use to count all the calls we receive.. I am not the only one using it but also some staff here. my problem is when I open the form and update it the same form open in other user is not updated. so what will I do with that??? please help me...i'm...

I'm just wondering, is it possible to put a graphics in the code? the reason I want to know is that I will put a sad face on each customer every time they call. so if they will call me 5 times i will see a 5 sad smiley face on the customer information. Can you please help me with this one. or if...

HELP!!! :confused: I do have a 5 tables 4 tables do have a foreign key of the main table. I join the 4 tables with the main table but when I am editing the information I cannot edit it. and no error appears. so I am just wondering what happen with my joined tables? please help me!!!!Thank you in...

i do have a form with a subform when i am searching record thru the subform i cannot find a record. how will i do that when i click search and the focus is in subform?thanx in advance

I do have a form wth a subform, i tried to change the backcolor if its locked. when i load the form the textbox in the form change its color but in the subform it doesn't...I just need help for this one but i will continue to figure it out. thanx a lot :confused:

I do have a form with fields new and number, everytime a new records will be added in other form, the records should appear in my form. can you please help. i tried to requery the tables and refresh it but nothing is happening.