Search results for query: *

as I understand it, you can either have a report print to the default printer or a specific printer. You may wish to look at a utility program called fineprint which captures print commands, allows various options to be changed, including which of many printers it goes too... of course then...

Look into autocorrect spelling within access. you'll probably find it's a default word for auto corrcting. I'm sure this is your problem, and that this at least puts you on the right track... Cheers, Jon.

Hi folks, I'm opening a form using this command: DoCmd.OpenForm "Orders", acNormal, , , acAdd and I get a message dialog pop up that says I can't use find or replace now. anyone know how to prevent the message appearing? btw, if i use acEdit instead of acAdd the message doesn't...

Hi folks, I have a datasheet form with a number of columns, in this order, they are: Item #, part #, product desc. The last two are drop down lists. The part # is the unique field. The problem is this: If I paste a number of items into the columns (line by line), the lookup occurs first...

Hi, Has anyone got any bright ideas on how to check a datasheet control for uniqueness? The data doesn't get stored anywhere, it just displays in the datasheet... Cheers, Jon.

Glad to hear it works... The reason the false was included was when navigating through records. I found that the image for the previous record would remain unless the pix field was re examined... Jon

Thanks guys, it was a null field I'd overlooked and have set it as required before form can be closed now. Cheers, Jon

I don't know if this code sample will help you rosti, I use a local and mapped network drive for linked pix, with their settings stored in a field ([pixlocation]). These are for products, but could apply for anything. Then in the product form i have a true/false flag ([pix])to check if the...

Thanks for tyhe input guys, most helpful. i can't use a specific printer as I have no control over what printer is used in reality. Cheers, Jon

Hi, Can anyone shed some light on why a report set to print landscape should sometimes default back to portrait? I've set the paper size in the report settings, but still it does it... Surely this shouldn't happen??? Hmmm... ok, so maybe it's just one of those things, but a solution would...

Hi folks, I'm getting an inavalid use of null error when i run a query of: SELECT DISTINCTROW Orders.CustomerID, Orders.OrderDate, Orders.FreightCharge, Orders.SalesTaxRate, Sum(CLng([Quantity]*[UnitPrice]*(1-[Discount])*100)/100) AS [Total Sales], Sum([Order Details].Quantity) AS [Total Units]...

Nick, Thanks very much for your reply. I've now settled on a method of a default paper size setting, chosen by the db admin, with an option to override that on the reports selection menu, on a temporary basis. that, coupled with 2 report versions using same width settings but different...

Hi, Has anyone found a way of having a report adjust to a paper and margin size automatically? I'm trying to find a way to have the paper size (a4 or letter) detected from the default printer setup, and then apply that setting to the report, along with an small increase in the left margin size...

Hi Robert, Thanks for your input but i think you miss my point. That is, I already have a help compiler, and a help file (extensivly used) but i don't see a way to specify my help file in the properties for a table. Thus, when i insert a table as a lookup in a form and then click the ? what's...

Hi folks, I'm trying to locate where I can set the help topic for a table. Scenario is this: have form, mapped to help topic 10, form has field pulling data from a table and when i click it using the 'whats this' help arrow it displays the default access help rather than my help file/topic...

Thanks guys, I had been saving the settings in design view, but wasn't aware of the bug fix... I'll check it out... Jon

Hi, My reports keep losing their settings for page layout and margins. I seem to recall someone mentioning an faq that dealt with these types of problems? Could some post a link to it, or maybe offer their own thoughts? Thanks, Jon.

Hi, can anyone tell me what the best image settings to use in reports are please? I'm looking to include a small greyscale logo, and it looks fine when printed or viewed in an image viewer, but terrible in the access report preview. I'm at a loss what to do next as i've tried various things...

Hi, can anyone tell me what the best image settings to use in reports are please? I'm looking to include a small greyscale logo, and it looks fine when printed or viewed in an image viewer, but terrible in the access report preview. I'm at a loss what to do next as i've tried various things...

Hi, Can anyone shed any light on why the can grow/shrink property in a report doesn't always work?<br><br>Can give good example.&nbsp;&nbsp;Take 4 address fields, each using the dlookup function to display data - they grow/shrink just fine.&nbsp;&nbsp;One other field (the country in address...