Search results

I have written a query that between two tables ORDERDETAILS AND INVOICE LINEITEMS, determines : for a given job number in ORDERDETAILS - if this jobnumber does not exist in the INVOICELINEITEMS table i.e. has not yet been invoiced, update the currentqty field with value 'n' SELECT...

Cheers ! That works - Im sure I did this though when I first built the dialog. After all - thats basic stuff!

The boolean is a flag value representign whether a client is overseas...... DoCmd.RunCommand acCmdFind This correctly finds the invoice record required (search on Invoice No. - unique ID), however the export flag as prev. mentioned is required to set the value of a command button. If I bind...

Sorry Rich - but both of these do exactly what I already have in place...... i.e. they error with the same runtime 3001!

From the help files : You can use the DoMenuItem action to carry out a Microsoft Access menu command. Note In Microsoft Access 97, the DoMenuItem action has been replaced by the RunCommand action. The DoMenuItem action is included in this version of Microsoft Access only for compatibility...

Hi People! I am using the following code to display the Find dialog : Private Sub cmdInvoiceSearch_Click() On Error GoTo Err_cmdInvoiceSearch_Click Screen.PreviousControl.SetFocus DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70 ' Exit_cmdInvoiceSearch_Click: Exit...

Jon Thanks for the info and the sample DB you have posted. I have now managed to get this query working as requested. (Looks like its been of interest to a number of others as well!) Thanks again - much appreciated. GJT

Jon I have tried in vain to get this query to work. The resulting data set contains the currnecy information but each end date is the current system date eg. date on which the query is run. This of course is no good, I need the following : START END RATE USD...

Thanks for the info - looks good, however you have used todays date for the final day of 'change' period. What I will need to generate is : the day before the proceeding exchange rate for each currency, as the EndDate. How would you do this?

I'm not too clear on the problem ..... do you want the form open? Do you run the query from a button on the form? You mention running the query when the form is closed I presume you mean from the Access DB Window and bypassing the query param as opposed to running from within the form on a...

I have these two tables in a 1:M relationship. One called CURRENCY and the other CURRENCY_HISTORY containing the exchange rates and the dates on which the revised rates are added to the table, respectively. Problem I have is this : For 'n' orders during the year, the exchange rates change...

Thanks for your help - you were right, in the anals of this Database I found the SQL answer I was looking for. 2 inner joins were required. Thanks again

Rich I have tried to do this without success. SELECT DISTINCT CURRENCY_HISTORY.CurrencyId, CURRENCY.ShortCurrency, Max(CURRENCY_HISTORY.RateRevised) AS Revised FROM [CURRENCY] INNER JOIN CURRENCY_HISTORY ON CURRENCY.Id = CURRENCY_HISTORY.CurrencyId GROUP BY CURRENCY_HISTORY.CurrencyId...

I have 2 tables. The main table holds currencies info and that to which it is linked contains a historical list of these exchange rate values and when they were updated. What I need to do is ONLY return the current exchange rates i.e. recent (most recently updated - to todays date) DISTINCT...

I am using Access 97 on XP and wish to use the Briefcase replication feature included with MS Office. I have installed the Briefcase feature from the CD but the icon does not appear on the desktop as it should? Is this a known bug in Office 97 and sufficient reason to upgrade to Office XP or...

Is it possible to change the fore / back color of a text field on a report depending upon the string value contained within????? If so - how? Thanks GJT

Of course - I should have known that! Thanks for your help - works just as expected!

Rich Where exactly are these query parameters. I cannot find any on the properties dialog for the subreport......?????? The only references to the parent form are by way of the : Link Child / Master Fields, these are of course already linked. My search just needs refining......

Hi I am using a sub report to list details of items that match the details on the main report. This works fine, I now need to minimise the results in my sub report by restricting the search to only display those items whose balance exceeds the qty count on the main report ie. main report count...

This does work - you need to enmsure that you have an image control on your form called 'picControl'. The returned string from ahtCommonFileOpenSave() is the picture path the user has selected . HTH