Recent content by AndrewCorkery

Hi, I have the SQL below and cannot get it to work, please could you add the code for me? thanks v much. SELECT Current_issinfo.[Partner Name], EQTradingAustralia.[Risk Class], Current_issinfo.[Partner Key], EQTradingAustralia.[Risk Domicile], Current_issinfo.[Internal Country Rating]...

Hi, I have a query that I wish to limit data retrieved based on data from another table. The field contains data of many country names and I only want to return country names that are NOT included in a seperate table. The field below contain data that needs to be queried: Country Name...

Hi, Just wondering if someone knows how to do the following: I have a field that contains numerical data daily data and I need to get a average of this data for a 3 day period. For eg: DailyPrice RollingAverage 3 4 5 4 6 5 7 6 Any ideas would be...

I cannot add a primary key as I am doing a query from an ODBC linked tables- is there VBA code that will do this?

Hi, Just wondering if someone had some code to automatically compress a database on exiting. Thanks Andrew

Hi, I have the following data and need to return just the one record for 2 fields and if it does have a duplicate still return the record but have a zero value in the numeric field. Company Field1 Field2 Field3 Field4 A 12 121 122 232 B 11 144 431...

I am getting this information from two tables joined by unique fields using an ODBC connection to a professional accounting package. I wish I could fix it from the source but it is more of a running total figure and therefore all I need to get is the one figure and make the rest of the dups...

Hi, I have the following data and need to return just the one record for 2 fields and if it does have a duplicate still return the record but have a zero value in the numeric field. Company Field1 Field2 Field3 Field4 A 12 121 122 232 B 11 144 431...

Hi, I have got a pivottable with two Sum of GrossInvoices and Sum of COGS fields in the data area of the sheet. I have also two other calculated fields GP$ and GP% that are simply functions of the two other data fields. The problem is that I have selected for the Rows Grandtotal to be on and...

Hi, I have a problem with this routine not acknowledging the UID and PASSWORD. The database runs code automatically after being opened so that users have data updated in the morning. Therefore I need to make sure that the MS Access DB can log on to the Main DB via an ODBC connection to...

Hi, I need to import a few tables using an ODBC driver. I have used the Transfer database macro and then converted it to VBA. Everything works fine except that I have to enter the UID and Password even though I have specified it in the code. Is there any other way of doing this? Thanks...

Hi, I need to get Access to run some code after opening the Application which will be done by the Windows Scheduled Tasks. Ideally I would like a MsgBox to pop up after the application has opened, giving the user 10secs to cancel the macros from running- ie when the application is opened by...

Hi, Just wondering if it is possible to run a query in an Access DB at a certain time. This is so when staff arrive in the morning the information has already been updated (it takes along time to run the queries) Does access have to be open for this? ie can you run a some windows script that...

finally got it to work thanks GLS!!

come up with the same error: "run time error 424 object required" on line: retValue = modStripChr.StripChr(tblValue, AppValue(cnt)) it looks like it is not carrying out the function?