Search results

I have 2003 Access and Adobe Professional Writer v6. I have a 100 page MS Access report that I wish to convert to PDF. Anybody got any experience in this area and can give me some pointers? Regards

Fantastic, that worked great, perfect in fact Thank you to you both for your suggestions Regards

Hi Lee, I have just tried that and I still get zero returns Regards

First Off:- Pat Hartman, if you happen to read this message, I would like to Thank you for solving the normalisation query I had. I can't find the original thread to thank you on there. Anyway, down to this problem. I have a field that contains ## as part of the content within the field. An...

Sorry Pat, misread what you put, here it is in Access format Sorry

I have exported the table to a txt format Thanks Pat

How do I do that Pat?

I will be honest herer Pat, and I migh be being stupid, but I am struggling to visualise what you are telling me. Any chance of the idiots guide? Thanks in advance

Thanks Pat, I will look up normalising in my Access 2k3 book and try to understand to what you are trying to refer. Thanks Toni

I have a table that contains a number of fields. 5 of these fields are named prop_1 through to prop_5. Also within this table is a src_date field. I have a form that the user selects the date they want and then the prop code they want. For this example I will use the code of 'AC'. AC could...

Ahh that sounds a bit easier Thanks

I am trying to digest your response now. Thank you for the suggestions. In answer to your question on how Ice Rhino arrived. It was because I was playing one of my favourite games, Battlezone II. One of the levels involved the escorting of a key vehicular unit within the game. The escort was...

I am looking to create a query that only displays to me the top 10 (or less) records. I am of course using the Select Top 10 method When I say or less, I mean that currently my report is showing 14 records. However 5 of the values in the result set are the value of '2'. Is there anyway that I...

I have an Access 2000 DB thats table content is based soley on Linked tables from a SQL2K DB. I have set up the System DSN information in ODBC (Windows XP Pro) to include all the login info etc etc. I have also tried File DSN just in case it was that. Periodically though when running a report /...

I am still trying ideas to solve thsi one myself. I have found that if I create a text box and in the control source place the value of =[FreeMemory]/1024/1024 Then I get the right answer. If I try to place this expression in the original txt box however I get #Error. Yes a workaround would...

I have a form that displays information from two different SQL databases. One of the fields, well actually several, has a Byte figure within them e.g. 73363456. For display purposes only I would like the txt box to change the value to display MB e.g. 69.96MB. If my calculations are correct that...

Ahh OK understood

Mucho Mucho Thanks, that worked great. Question:- I just used the first example you posted, what does the 2nd line containing dateadd part do that is any different?

Thank you and I apologise for the cheeky request of elaboration

Thank You, you would care to elaborate a little would you?