Recent content by maniatis

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