Search results

Access '97. I've built a report based on nested queries which require 5 parameters. I can run the report and have it ask for each parameter in turn or run the query with parameters from the form. How can I pass the form values into the report so I just have to call the report with the right...

Short answer .. never tried it but suspect not. You could trap specific error numbers in your error handler like ... on error goto err_hand err_hand: ' Error 3376 is something that might ' occur in the With loop that you want it to ignore if err.number = 3376 then resume next

If you're using Access '97 Investigate TransferSpreadsheet method.

I have a text file (a dump of a Unix system report) which I need to import. The file has several lines which can be discarded and relevant information about an item split between multiple lines e.g. Item Number: fred Gll+Bulk Past 12/11/01 19/11/01 Gross Reqs...

What circumstances will trigger a message ? Is it an automated 'must happen at 8pm daily' or some set of data ? If it's a data set put tests on the changing of each element that check all involved elements and trigger the message. If it's at a time consider using an external scheduler (NT's AT...

What circumstances will trigger a message ? Is it an automated 'must happen at 8pm daily' or some set of data ? If it's a data set put tests on the changing of each element that check all involved elements and trigger the message. If it's at a time consider using an external scheduler (NT's AT...

Does your C application have a defined API? If yes, can you write a shell function in C to show us what you need. Otherwise look at the previous post about calling Lotus Notes objects for ideas.

Try Int(). Work out your field offset and divide by 15 to get a fields offset using int to ensure the fields offset was incremented by integers This is pseudocode to give you an idea: i=600 for i = 600 to 2415 then j= int((i - 600)/15) + 1 rec.fields = j next i. 600 to 614 -> 0+1-> 1 615 to...

Can you test for the current state of the spellchecker by reading a different Notes Object then only turn it off if required? Which version of Notes are you using? We're on 4.6.3. BTW - the code you've posted for sending email from Access via Notes will be useful.

Is the function public? Otherwise when you run the report the function may be out of scope if the function is scoped to another form or module

Suggestion: Dump your email + attachment to a file and use a command-line mailer to email it or find a fixed version of SendObj. Or ... split the file into 2000 character chunks and send as a multi-part Mime ...

'Make a pointer (instance?) of your query Set qdf = db.QueryDefs("qry_effect_report_mt") ' Set parameters for query based on values entered qdf.Parameters![lowdate] = var_low_date 'execute the query qdf.Execute

hmm... The model we've used allows a lot of re-formatting and re-calculation based on triggers in the master spreadsheet and the extracted data. It just uses VBE rather than VBA. The users don't get an option to interfere, they just see the VBE doing it's work. VBE will work just as well as...

hmm... The model we've used allows a lot of re-formatting and re-calculation based on triggers in the master spreadsheet and the extracted data. It just uses VBE rather than VBA. The users don't get an option to interfere, they just see the VBE doing it's work. VBE will work just as well as...

Post the relevant fragment of your code and we'll take a look.

Access '97 I've got different back-end databases, all with a table e.g. tblProcess in them. How can I link to all of them simultaneously from VBA controlling their aliases? Access allows me to link, appending 1,2,3 suffixes depending on the link order from the Tables view: How do I mimic this...

Ensure none of your back-end tables are connected using something like: Dim dbs As Database Set dbs = CurrentDb dbs.TableDefs.DELETE "tblbackend" Then launch your file using something like: (this launches Excel, you'll need to launch something which understands your ini file) strExcelPath =...

Review postie. It's a low-cost command-line email program or look for pointers at e.g. http://www.emailman.com/win/tools.html which includes some tools offering the ability to email from your applications. http://www.swsoft.co.uk/index.asp?page=freesoftware offers smtpmail which may suit...

Yes. Applications e.g. Winfax and zetafax have 'fax printer' drivers which appear as a printer on the pc and direct anything printed to a fax number you specify. This requires a fax modem on each pc. If you're building the fax facilities into your application you'll need some form of API to the...

2 thoughts: Is the app using a font which isn't on that pc? If so, Win' can usually substitute a font but this isn't always clean. Screen resolution: Is your defective screen at lower resolution? IF so the fields may be showing blank because the contents can't be rendered. This is more...