Search results for query: *

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.

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

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

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

Hi, <br><br>I have a form (orders) with a sub form that allows the user to select products to include.&nbsp;&nbsp;The sub form uses (SELECT DISTINCTROW Order Details.*,...) as its query.&nbsp;&nbsp;What I'd like to is incrementally number each item/record as the user adds it to the...