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 Allen, thanks for the link, looks like the answer is in: http://support.microsoft.com/kb/208801/EN-US/ Cheers, Andy

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.

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

Yes, maybe not very clear I want the data only to be imported to the existing linked table 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 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...

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

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

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

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

Many thanks, 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

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

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

Thanks, Andy

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

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

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

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