Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. AndrewCorkery

    Query Data excluding records based from another table

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

    Running average of 3 previous Records

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

    Automatically Compress on Exit

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

    Only return unique row and make value 0 for duplicates

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

    How not to have Duplicates in Rows

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

    Pivot Table Bug or my fault?

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

    Placing Password in TransferDatabase Command?

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

    Import ODBC database tables

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

    Run Code automatically 10 secs after opening Access

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

    Run a query at a set time

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

    Removal of Street Types from Address Field

    Hi Quick question: Address line 1 Top Ryde Shopping Centre Blaxland Road Blaxland Road Charles Street Karen Moras Drive Blaxland Road Ryde Tafe Blaxland Road Church Street In need to strip out the Road, Street, Avenue etc out of the about field above,and place that Road, St etc...

Part and Inventory Search

Back
Top