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 Chriss Miller 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: *

  • Users: AGGGG
  • Order by date
  1. AGGGG

    Transpose Fields

    Hi, I am trying to transpose data in a table, so that it can be imported into another software package. Hence, I cannot change the format. Hopefuly the data below will help explain my request. Any help would be appreciated. Cheers, Andy Current Data: From To 0-10 11-20 AMS GLA 1...
  2. AGGGG

    Memo Field Limited to 256 When Export to Excel

    Hi Allen, thanks for the link, looks like the answer is in: http://support.microsoft.com/kb/208801/EN-US/ Cheers, Andy
  3. AGGGG

    Memo Field Limited to 256 When Export to Excel

    I am using SP3, Hope this isn't a silly question, in design view of the table, when I select the memo field, there is an empty list box when I select it.
  4. AGGGG

    Memo Field Limited to 256 When Export to Excel

    Hi, I have created a macro that exports a query to excel, but it appears to be limitting to the first 256 characters of a memo field, hence I lose any data > 256 characters, when I open in excel. Any pointers ? Cheers, Andy
  5. AGGGG

    Importing Table Data to Linked Table

    Yes, maybe not very clear I want the data only to be imported to the existing linked table Cheers, Andy
  6. AGGGG

    Importing Table Data to Linked Table

    Hi, I am trying to import a table to a linked table via a macro using version 2000 The result of the Macro is that a new table is created in the front end application with an additional "1" at the end, ie, it looks like it is not seeing the linked table as linked ;o( Pls c macro below, the...
  7. AGGGG

    Union Query to Update to Table

    Hi Duane, Thanks for the help. I have created a select query (QPlanner1) that is based a union query. The select query is used to pass parameters from a form. I require a query that will update QPlanner1 to tblPlanner_Airdrie I am not a programmer, so apologies in advance for my method...
  8. AGGGG

    Union Query to Update to Table

    Looks like I answered in haste ! I need the script below to an update query ? Cheers, Andy INSERT INTO tblPlanner_Airdrie SELECT * FROM QPlanner1;
  9. AGGGG

    Union Query to Update to Table

    Hi, Apologies for not replying sooner ;o) Used the INSERT INTO TheTable SELECT * FROM qryMyUnionQuery and it is working Thanks for all ur help, Cheers, Andy
  10. AGGGG

    Union Query to Update to Table

    Hi, I have already created a table, but not sure how to create the script to update the table. Cheers, Andy
  11. AGGGG

    Union Query to Update to Table

    Hi, I have created a union query (works ok), and trying to update the query results to a table. I cannot use the 'make table' as I want to update the table at regular intervals. I think (hope) that I am missing the obvious solution ! Thanks in advance, Andy
  12. AGGGG

    Excel: Rounding down to nearest half no.

    Many thanks, Andy
  13. AGGGG

    Excel: Rounding down to nearest half no.

    Hi, I am trying to round a number down to the nearest half whole no.: 97.9 would become 97.5 97.6 97.5 97.5 97.5 97.4 97 Help would be appreciated, Andy
  14. AGGGG

    Set dbs = CurrentDb

    The code runs on 2 other pc's running Access 2002, What I did notice was the other pc's had 'Microsoft Access 9.0 Object Library' enabled, while the pc that produced the error had 'Microsoft Access 10.0 Object Library' enabled
  15. AGGGG

    Set dbs = CurrentDb

    When I run the code below I get the error message: Run time error 13, Type Mismatch After I select the 'debug' option the following line is highlited: Set dbs = CurrentDb I am using Access 2002. Help would be appreciated. Dim dbs As DAO.Database Dim MyRecSet As DAO.Recordset Dim SQLString...
  16. AGGGG

    Update Query 'Suppress Confirmation Message'

    Thanks, Andy
  17. AGGGG

    Update Query 'Suppress Confirmation Message'

    Is it possible to 'turn off' the 'confirmation message' when you run an Update Query ?
  18. AGGGG

    Unique Records in Header

    Hi Duane, Success !!! Using your suggested 'total query'approach, did the job Andy
  19. AGGGG

    Unique Records in Header

    Hi Duane, Thanks for such a quick response. You answered the query I requested, but, (there's always a but :) If the record had multiple week numbers, adding the text box to the Report Footer, will give a grand total for all the unique post codes. I was wanting to sub-group the number of...
  20. AGGGG

    Unique Records in Header

    I am trying to count the unique number of records, to be displayed in a grouped header. The fields are: week_no delivery_date delivery_postcode delivery_id There are 7 records with only 4 unique delivery_postcodes The first 3 fields have been grouped with their own group header, with the...

Part and Inventory Search

Back
Top