Recent content by RossG

I would like to launch a custom Outllook form (using followhyperlink) then copy some of the database fields to fields in the form. Is this transfer of data possible, and if so can someone provide an example ? Can't find any specific info on the MS site :-(

I am having problems with what I think should be an easy query...can someone offer advice please? I have a database logging faults in numerous markets of our operation. Details of each fault includes the date and a yes/no field for each market indicating if it was affected by the fault. By the...

I have a similar problem, but when I make the label invisible it still occupies space in the report. I can't find how to set a 'can shrink' property or anything like that to effectively delete the label when there is no associated data.

Here's a problem I would appreciate some urgent advice on! I'm using a function to grab the date from a calendar control (it's then passed on to a query). How do I reference the calendar control in the function when the calendar control is on a form (frmCalSearch) which is used as a subform on...

Thanks Jack, Yes this works fine, but I need to open 'formname' using a query to select the appropriate fields - then have it pop up in the tab control. I've not been able to work out how to do: Me.SubformName.SourceObject = "FormName showing results of a query" So far I only understand the...

I have a tab control with a sub-form on it. Can I open a form with Docmd.OpenForm ( including a query as filter) and have that form appear as the tab control's sub form? If so, what is the correct syntax to use? TIA

Is it possible to 'nest' pieces of SQL code ? For example if I need a query such as: " where (A = 1 AND B = 2) OR (A = 1 AND C = 2) " can this be nested into something like: " where (A = 1 AND (B OR C = 2)) " Sorry if it sounds like a dumb question but I'm struggling with this SQL...

I had the same problem as NP during my first exercise in QBF coding. I used code from the MS Knowledge Base as a template but just could not get dates to work in the SQL. Eventually found that the dates had to be in mm/dd/yy format, not dd/mm/yy as used locally. [This message has been edited by...

I have a generic form which displays the results of queries. The form is opened by using DoCmd and providing a string representing the SQL/filter. The form includes a 'Record X of Y' display. It works fine for most queries, but on a more complex query the form opens showing 'Record 1 of 1'...

Maybe not a very neat solution but on the form that calls the report could you have 2 command buttons, with each one opening a different version of the report? The different report versions then have the appropriate printers saved as the defaults. Label the command buttons with the appropriate...

Found some info on the MS site that might help, try this: http://support.microsoft.com/support/kb/articles/Q129/3/97.asp Hope it helps! [This message has been edited by RossG (edited 06-15-2001).]

Sorry, I misunderstood. The code above will bring up the Print Dialogue box, in which you manually choose the printer, number of copies etc. As for selecting a printer in code....sorry, I'm up to speed on that (yet?).

Could you choose the printer via the Print dialogue box? If so, in the reports OnActivate event use DoCmd.RunCommand acCmdPrint

YAY....Success!! Glad to say it's now fixed! It finally dawned on me the error message was not being generated within the Load/Open events of the new form, but rather in the command button click event on the FIRST page (which contained the DoCmd.OpenForm code). In the error handling of this...

Nope, that still isn't working :-( After clicking the OK button on the message box I get the Error 2501 and warning saying the OpenForm method was cancelled. Then have the option of debugging or End. The latter gets rid of the warning and everything is then OK. This is the warning I want to...