Search results for query: *

Hi there I am currently using Outlook with my Access application. I´ve just been given the "good news" that we are changing to Lotus Notes at corporate level (great...) Anyway, I have checked the Forum and found out it is quite easy to change from Outlook to Lotus Notes. No problem...

Bujin Me too (but we are stuck with MS)

Hi there The error 94 I was getting was related to something else... I´ve just put the following on its own and it seems to work ! Me.Freight3Desc = Me.Freight3Desc.ItemData(1) But I had also tried the following last weekend and it didn´t work. Now I´ve used it again and IT WORKS...

thanks for the input pgk Sorry, it didn´t work... it gives me a "NULL VALUE not VALID (Error 94)" (sorry, I use a spanish version of Access so I am not sure if I translated the error description correctly...) The error happens on the following code line... Me.Freight3Desc.Text =...

Hi there I have a combo box which is populated via SQL. After the SQL runs, I want it to select the first record on the list... I have tried mycmbbox=mycmbbox.ItemData(0) as I believe this is the way to do it (from other messages on the forum) HOWEVER this doesn´t seem to work correctly. IS...

Thanks for your reply SBendBuckeye, I don´t think that´s what I wanted... The subform has several lines (continuous form) which means the control is always the same name, so I can´t do a reference to the same control for 3 different lines... Any other way?

Hi I have a Puchase Order form with a subform. I can enter as many lines as I want on the subform. What I need to do is the following: When exiting the PO form, I need a routine to check the 3 lines (or whatever many lines that have been entered...) to see if a certain field matches a certain...

jjonesal IT WORKS GREAT !!!!!! THANKS TO ALL FOR YOUR FANTASTIC INPUT !!!!

thank you all for such helpful replies. I will try them out later today.

HI... Is there a limit on to how long an SQL query can be??? I have the following query which gives a TOO LONG error. I´ve used & vbCrLf which I found in one of the threads, however it doesn´t seem to help... ANy ideas... lafecha = Format(Date, "mm/dd/yyyy") sqlline = sqlline &...

thanks!

Doesn´t work for me... this is my work around and works fine...the only thing is that I had to add a record to match the criteria cmbPOL=VALENCIA cmbPOD=VALENCIA eitherwise it loops continuously... After I press the SEARCH button,I run the following SQL Private SEARCH_click Me.RecordSource =...

Hi I have a continuous form which displays records matching a query. The query is created and run using Me.RecordSource = sqlline ' sqlline being the SQL query I now need to use the recordcount property to find out how many records have been selected by the query. I don´t know how to do this...

thanks for the positive comments. I´ll re-check if I can change when the routine runs. I wanted to make it run when the subform changes, so I thought of using the Oncurrent... Regarding the LONG CODE, I mean it is long to put here on the forum (most people wouldn´t bother to look at it. Note...

Hi there I´ve done what you´ve told me, but it doesn´t work. I put the focus to another (invisible) combo box I added. When I click the SEARCH button, I have Private Sub cmdsearch_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single) cmbtrick.SetFocus End Sub If the value...

I´ll do that thanks

thanks for your reply I have none of those (Requery,Refresh,GoToControl,GoToRecord) on the code for either the mainform or subform (apart from procedures within buttons which only run if we press those buttons... I´d love to put the code BUT it is EXTREMELY LONG. I think you´ll get confused...

Hi there I have a form with subform with the following problem. The code on ONCURRENT event for the SUBFORM is to run a procedure called CHECKDATECREATED It is called only once within the code. However when I open the form with a record on it, it runs the CHECKDATECREATED 3 times. There is...

Hi there I am glad to know that I am not the only miserable person having this problem! Nope, I haven´t found a solution. I can´t believe no one in the forum has got this problem. It is such an important thing (to do searches, etc) but no one mentions it... Anyway, there are ways around it...

thanks for your reply. Sorry, I didn´t explain myself correctly. If I select the correct values and a matching record(s) is found, the information displays perfectly. So the SQL and combo boxes work fine. HOWEVER; it is when there are no records found that the value on the combo boxes dissapear...