Search results for query: *

Hi, I have my default field size for a text field set to 50 chars in Access. When I import a CSV it comes in with all text fields set at 255 chars. Can I either change something on import so that the CSV fields all come in as 50 chars or even better, can I run a query or macro to change all...

Hi, I have an Access DB which contains some names which are written in Thai non-latin characters. When I open the table in Access it looks OK. When I either output it as a text file or try to link to MS Word as a mail merge the non-latin characters are replaced by question marks. I've tried...

Thanks everyone for your responses. I used the first reply from dhookom and it worked great. Thanks again, Mark.

Hi, I have a table which has a initial record with a name, followed by a variable number of records without a name, then another record with a name etc. I would like to fill in the records without names with the preceding name eg:- BEFORE id,name 1,'dave' 2,'' 3,'' 4,'' 5,'john' 6,'' 7,''...

Haven't been able to get this working yet but it looks like it might work with some fiddling. Thanks a lot for your help. I will work on it and post to let you know how I've got on.

MMSMSD: I am running the report from a flat table. I understand that this would be a million times better if I was dealing with a proper relational structure with a 'customer' table and a 'invoice line' table. If I had that I wouldn't be bothering you guys. I am dealing with the output of some...

Filtering the report like this would cause the same problem as amending the query:- My table is like a series of invoices – Record 1 is a 'header' record, it has the customers name and address etc, this is followed by a variable number of associated records (the invoice lines). Then it hits the...

Hi, I have a report which I would like to have print only pages where textboxA = "mystring" (I can't filter these pages out with the query that runs the report because I have multiple records on a page and dropping the records at that stage would break my formatting.) Thanks, Mark.

that worked great, thanks very much.

Hi, I have a table like this:- name a b c d john 0 0 5 0 dave 2 4 0 5 mark 0 9 0 8 i would like one line for each name where the value isn't zero i.e. name item value john c 5 dave...

afraid i couldn't get this working at all. for anyone interested, here's how i solved the problem another way:- 1. leave the report caption blank 2. insert the following page event (wouldn't work when attached to the report header, i think because the source field hadn't loaded before it was...

Hi, I have produced a macro which loops to automate the printing of a series of reports which works fine. However I would like to instead save these reports as pdf by just printing to distiller. To do this i need to deal with the save as dialog box. I would like to call them reportX.pdf...

Sorry I don't understand. The point is that I don't know what the old table name is. The reason why I need to change the name is so that I can reference it. What I'm asking for is some code which says either: 'change name of table i just linked to 'whatever' or 'change name of all tables (there...

Hi, In have a macro running which processes some data. To get the data in I use DoCmd.RunCommand acCmdLinkTables The user selects the table they wish to process and it is linked but it is named as per the table they selected. I would like the link to be automatically renamed to a standard...

I changed my approach based on what you said and have now got it working. Thanks very much for your help.

It's not behind a form. Field1 is one of the columns in the recordset i.e. SELECT TOP 50 Table1.Field1, Table1. Field2, Table1.Field3 FROM Table1; to SELECT TOP (Table1.Field1) Table1.Field1, Table1. Field2, Table1.Field3 FROM Table1; supposing every record has the same value in Field1...

Hi, Can anyone tell me is it possible to use a number from a field value in a TOP query i.e. instead of SELECT TOP 50 FROM... this SELECT TOP ([FIELD1]) FROM... I can't get it to work but maybe my syntax is wrong. Thanks, Mark.

PHV. I have tried to set up an ODBC on the desktop machine. In order to select the remote database I think I would have to map the web server so I can browse it but I'm unsure how to do this other than by FTP which doesn't seem to work. thanks, mark.

PHV. Thanks for your response, sorry if this is a dumb question but should I try to set up the ODBC connection on the desktop machine or on the webserver? If I set it up on the webserver how would I then address it? Locoman. Thanks also, the webserver is totally remote, locally I am using XP. I...

Hi, From my desktop when I go: > get external data > link tables is it possible to find a table in an access db which is on my webserver? Thanks, Mark.