Recent content by AGGGG

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