Search results for query: *

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

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

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

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

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

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

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

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