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

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

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

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

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

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 have asked this question before without an answer. I am hoping someone has an xplanation now... I have a form with 4 combo boxes and a SEARCH button. When I click the search button it runs an SQL which uses the values on the combo boxes. All works fine EXCEPT that the value on the...

Hi, I have an SQL query with what appears to be a very long IIF formula (see below). I have tried to take half the conditions out and it works fine, so I assume is because it´s too long. Is there a way of achieving the same thing, doing it some other way, or am I stuck with deleting some of the...

Hi I have a combo box. One of the columns is calculated from a value on another column. Example ALBANY NEW YORK 123 110.7 CHICAGO NEW YORK 450 405 My code is.. SELECT ORIGIN,PORT,KMS,KMS*0.9 AS RATE All works well, however the formula KMS*0.9 needs to be "dynamic". I...

Hi there I have a form with a subform. OnCurrent it refreshes the screen (fro example, it makes certain fields invisible, etc etc). It appears that for every record (of the form) it refreshes the screen MORE THAN ONCE. Sometimes 2-3 times. On a fast computer you are unable to see this...

Hi there I have 5 different forms that I jump from one to another all the time. I would like to add Hotkeys (alt+number) so the form required opens with the same hotkey regardless in which form you are at the time. Any ideas ?

Hi, I have a listing (continuous form) which shows all the records matching a certain criteria (but only showing the main fields). I can click on any of the records and the DETAILED form opens up with all the fields/data for the record chosen. The problem is that, for a fraction of a second...

Hi, I have a query which also creates a new field, which is the addition of several fields within the query. The problem is that it gives me either null values as the result or a "weird" number. For example, value1=1275 value2=107 value3=500 value4=0 value5=6 all of the above give me...

Hi I have a query which returns 100+ records. The thing is that I need columns not to show on the query if ALL the records are empty for that column. For example, if all records are empty on COLUMN5, then don´t show that column on the result. I am exporting the query to EXCEL once finished, and...

Hi I know how to export a query/table to an excel file. I would also like to format the excel spreadsheet, mainly adding an autofilter (selection.autofilter with Excel VBA) from within Access. I would also like to BOLD the text on a certain column, etc. Basically I need to use the VBA comands...

Hi there I seem to be having a major problem with a query routine which consists of 4 combo boxes. I select different options from the combo boxes, and then press SEARCH button, which runs an SQL to select and display the info. Everything works fine HOWEVER it appears the combo box values BLANK...

Hi there I have a record header (client details, invoice number, etc) and a subform which displays a number of lines for than "invoice". I need to do exact copies of them by simply clicking a button when displaying the current one. For example, I am viewing (form) invoice no.555 with...

Hi I have a FORM ("Quotes") which opens another form ("Clients") when I double click on a field. The "clients" form has a cmdclose button with the following code in it... Everything works fine HOWEVER the original FORM

Hi I am really going blank today... I have a query which shows many records, one of the fields (country_Code) being duplicated many times (all other fields are different though). I need to create a report/query which will only show as many records as there are country_codes, without...

Hi, this might be something simple but I can´t manage to make it work... I have 2 tables, "Cities" and "New DAta" Cities has a field called CITY New Data has a field called CITY. I am trying to get a query to show me CITY field in "New Data" NOT finding a match...