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

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

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.

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

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

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

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.

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.

Hi, I have a table with various columns one of which has a code in it which is not unique. I would like to flag each time this value changes to make it easier to spot. i.e. name code jon 1234 dave 1234 sue 1234 martin 2345 alan 2345 gary 8910 jeff 8910 to name...

Hi, I'd like to run a report for a number of stores which includes a price list created in Excel. There are 50 different price lists but each store should only receive the lists applicable to them. I have a table with a record for each store and 50 fields, one for each price list, which is...

hi, i would like to put a new column in a table and put a flag in every 6th record, can anyone tell me how? thanks, mark.

Hi, I have an access database with a bad field structure e.g.:- firstname - lastname - age - height david - 25 - 6ft mark - smith - 29 - 5ft10 collins - 34 - 5ft11 richard - jones - 6ft1 so some data is missing which is OK but where data is missing the remaining data is ranged left into the...

Hi, I am struggling to add a running number to a select query and group them in blocks of 6. So say my table has a field 'colours' and I run a select query where 'colour'='red'. I would like to display a new column which counts down but not 12345678 - instead it gives the first 6 selected...

Hi, I have this query inv date value balance 1 05/12/04 £25.00 £25.00 2 05/12/04 -£20.00 £5.00 3 06/12/04 £10.50 £15.50 4 06/12/04 £8.00 £23.50 5 06/12/04 -3.00 £20.50 6 07/12/04 £40.00...

Hi, In need to run a query to create 'newfield' below, basically there are a random number of people in each areacode - i'd like to insert a new field and mark with an x or whatever everytime the value changes to aid sorting. id name areacode newfield 1 mark 1234 X 2 dave 1234 3 gary...

Hi, I need to show opening and closing balance on my report, i can draw the information from a running sum but if someone runs a report on say 07/20/04 to 07/27/04 the starting balance needs to be the value before 07/20/04, how do I call this? Thanks for looking, Mark.

Hi, I'm putting together a simple project which records peoples weight loss/gain, they are measured from time to time but I need a query to compare with the previous value in a report and don't know how to calculate the loss/gain field, as below. id name date waist loss/gain chest...

Hi, I need a field which keeps a running total when a form is filled in i.e. ref value total 1 £12.00 £12.00 2 £9.00 £21.00 3 -£6.00 £15.00 4 £5.00 £20.00 and alternatively... ref value loss/gain 1 12 0 2...

Hi, I'm trying to use different styles in my html email by using:- @media screen { .tables { background-color: #999933; color: #FFFFFF } } @media print { .tables { background-color: #FFFFFF; color: #000000 } } embedded in my document, this isn't working, as soon as I enter the @ etc, Outlook...