Search results

Hi biskra, and thank you for your answer. I've been away a couple of days, hence the late reply. I have not tried it out yet, but as I understand from the posted code, it's the reports aeactivate and deactivate that is truggered when the report prints. I presume here that you must send the...

I have a report which the user can preview. If he sends it to the printer, is there some way I can know that it has been sent to the printer/print manager ? I need tohave a timestamp when the report was printed, not only previewed. Is this possible? Thanks in advance

Hi, I'm making a report in Access which I output as an Excel file. I'm using the Outlook library from Access to prepare the file for sending as an attachement. How can I insert the Excel file into the body of the e-mail, using the Outlook library from Access? Thanks in advance

Hi Greg! Thanks for your reply, but I don't find the solution very good, since I've then have to code the user names some way, and test accordingly. I would rather that Access some way checked the permissions the user has, and opened the form or displayed a message 'You don't have...

I have an additional question regarding the Switchboard. My db is secured using the built in MS security. If a user who don't have access to a form, tries to open it, an error message appears - saying 'There was an error executing the command'. It should have read something like 'You don't have...

Yes, this seems to be working. Haven't moved it to VBA yet, but it looks good. Thank you both for your help and interest. Much appreciated.

Thanks Calvin, Pat is right. I've already tried it without any luck. Pat, this thread is really a continuation of my 'Access to Oracle' thread burried under a ton of threads now. The dBase file has data from a spectograph (to analyse concentrations of different metal alloys). The software...

Thanks for your reply. Just what I suspected. So how do I build a good 'routine' to make an Access table from the dBase file? It must prevent duplicate records/to be added to the Access table? TIA

I have a linked table (dBase iV format) which I can't alter the structure of. I need to define a primary key, and enforce reference integrity (delete and update options checked) What would be the best way to do this, if it's even possible? TIA

Thanks for your hrlp both. You're spot on Clueless. Haven't tried it yet but it seems right. I don't like the wizzards very much, but thanks for the tip.

Query to find records not matching? Hi, How do I do this: I have two tables. Both has a field that has the same values (ID number). A second field (quantity) in both tables, contains a numeric value. How do I find the records that don't match for the quantity field? One of the tables is a...

Hi Pat! Thank you very much for your time and advice in this matter. I'm having a meeting with the people who will receive the data next week. 'll see what we fall down on. Foe me it is important to know if it's possible to do, so I don't go down a dead end. I share your view when it comes to...

>So your Access data just needs to be appended to the Oracle tables? Yes >How often? Will probably happen after each analysis is run, since there are other events happening in the Access 'send' db that can trigger the transfer process. An alternative could be on a periodic interval which...

Hi Pat! I know it might be difficult to automate the process entirely, but it would be great to know if it's possible. The data I want to make available for the other company is metal analysis data. This data will only be 'sent' from the Access database to the Oracle database. I wondered if...

Hi, I need some advice transfering data from MS Access to an Oracle db. The two databases are not on the same networ, since this is two different companies. The Access data should also be automated into the Oracle db. I have no knowledge of Oracle db's, so I would like to get some point of...

Thanks for the replyes. I have tried configuring the Microsoft MouseWare to match 'Logitech's' here, but it won't scroll the VBE code window. The Mouse wheel works in the VBE when it's installed on another computer. As mentioned, I have downloaded updates from Windows Update. Thanks for the...

Hi, I'm using Office XP, and when programming in VBA, the mousewheel don't scroll the code window. The mouse is a Logitech wireless optical type. I've used Windows update, re-installed Office, updated mouse driver and checked all other options I can think of, without any success. If I click...

Hi, Does anyone know if Intersolve ODBC drivers is freeware or if it has to be purchased? Where to get it? I want to link to a Microsoft Interbase database from Access. Any information regarding this will be greatly appreciated! Thanks

sudo, Just an idea I use myself Place a command button below the field you want to set to Null (or someplace else), and use the button's OnClick event to run this code: Me.YourFieldName1=Null You could make the button's Caption something like 'Reset' You could use a command button for each...

Could anyone please tell me if they use the same command in VBA, and a snapshot file is created successfully or not?