Search results

i did it it worked it must be that i wanted to enter value not to the first column but to the second one of the table thanks a lot you helped me understand how it maybe working. thanks man

you are my only hope nobody else is answering.could you please test the above code in order to se what's wrong.thanks

i did what you suggested which i found it very logical but still not working.can you test it? i cannot find what's wrong.But I am thinking that the problem is that it doesn't save the new data.

i did what you suggested which i found it very logical but still not working.can you test it? i cannot find what's wrong.But I am thinking that the problem is that it doesn't save the new data.

the code I wrote is from the site www.fontstuff.com I just copy the whole procedure. if i change to to text box then i cannot say notinlist.

Private Sub CURRENCIES_NotInList(NewData As String, Response As Integer) 'On Error GoTo currency_NotInList_Err Dim intAnswer As Integer Dim strSQL As String intAnswer = MsgBox("The currency " & Chr(34) & NewData & _ Chr(34) & " is not currently listed." &...

When I Did What You Suggested It Reports Syntax Error Of The Insert Into Command

The Problem Is That It Executes But It Doesn't Append The Record To The Table Or It Doesn't Save It. I Figured It Out Because It Executes All The Code It Says That The Value Was Added Baut Then It Says Item Not In List. What Do You Think?

Sorry but i changes the name of the table and the name of the field but still no result.Any other idea?

i have a field in a table which takes date from a table named currency through a combobox.i have writen the following code in order the user to add the currency that there isn't in the list of the combobox: Private Sub currency_NotInList(NewData As String, Response As Integer) On Error...

:( here's the problem: I have a table named case and it is connected with a table named categories .the table categories is connected to a table named subcategories. For every record in the table case the categories and the subcategories are the same. Is there a way that I can copy all the...

here's the problem: I have a table named case and it is connected with a table named categories .the table categories is connected to a table named subcategories. For every record in the table case the categories and the subcategories are the same. Is there a way that I can copy all the...

thanx for helping me it worked (not capitals) ;-) why is say my text is too small

I HAVE A FORM WHICH I WANT TO ADVISE ME TO DO THINGS. I HAVE A TEXT BOX=DATE() , ANOTHER TEXT BOX WITH LATEST ARRIVAL.I WANT WHEN TO FIELDS ARE EQUAL THEN IN ANOTHER TEXT BOX TO SHOW ME A MESSAGE. I WON'T ENTER VALUES TO THE FIELDS USING THIS FORM THEY WILL BE ALREADY ENTERED IN THE TABLE OR...

I HAVE A FORM WHICH I WANT TO ADVISE ME TO DO THINGS. I HAVE A TEXT BOX=DATE() , ANOTHER TEXT BOX WITH LATEST ARRIVAL.I WANT WHEN TO FIELDS ARE EQUAL THEN IN ANOTHER TEXT BOX TO SHOW ME A MESSAGE. I WON'T ENTER VALUES TO THE FIELDS USING THIS FORM THEY WILL BE ALREADY ENTERED IN THE TABLE OR...

I Have 3 Tables Case Table, Forwarder Table, Orders Table I Have Connected Them With 1 To Many Relationship. 1 Case Has Many Forwarders And Each Forwarder Many Orders. I Tried To Make A Query Connecting For Start Case And Fowarders And Even I Start Writing...

I Have These Tables: Case, Agents, Forwarders, Orders. 1 Case Has Each Time 1 Agent, Many Forwarders And Each Forwarder Many Orders 1 Agent Many Forwarders Can Someone Suggest The Best Way To Link Them?

ihave one form with data from 4 tables that i have union them with a query.i mean the form is having data from 1 query. there are the following fields location, agenname ,agentadress ,agenttelephone. i want to choose a location and brings me the records for the agent and agent details for the...

i want to thank you a lot.my mistake was that i was uploading all fields as i noticed and you load only records matching the criteria.one final question if i use it to make a form with linked tables using a query will it bring all the records except the agent details? many thanx

here is the database thanx for your help once again