Search results

Hi there, Im trying output a report to a word document, well its actually .rtf format, and then id like to password protect the document. Heres a snippet of the code, everything works a treat except for the password protection, please help. With DoCmd .OpenReport...

HI all, I want to open a DAO recordset for the sole purpose of appending new records (.addnew). Thus, I do not wish to return any records (im a bit of a network conservationist), since I do not need them. My current method is to use an SQL statement with a WHERE clause on the primary key with...

Hi all, I understand that ADO was officially introduced with A2K but you can still use ADO with 97, although it ist supported much. Well, the problem is, as highlighted by member dcx693 also, that currentproject is not supported in 97. How do i go about making a connection to the...

Hi all, i have a system that relies upon data from another database. When the data is extracted from the database, to be updated into my system, it undergoes a series of action queries, most of which are wrapped in a transaction. The only step that are not, are the transfertext steps. Here...

Hi all, i have a strange little problem... I dont know if the title actually describes what it is!!! I have a startup form with a button that opens a another data entry form. When the startup form's pop-up is true, and the data entry form is opened as dialog, every works nice. I want to...

Hi all. I would like to run an update query to update rows in a table, and update only those rows that appear in another select query. I could do this using the IN clause with a sub-query but it takes too long. I would like to do this by joining the table with the query but i seem to get the...

Hi, Im exporting data from access to excel using access as the server. I was wondering what type of things can be done to speed up this process. I am getting a recordset then looping through and making the cell values of the spreadsheet equal to values from my recordset fields. Thanks

Hi all, I have two things that Id like to be able to do. 1. Open an attachment in a Lotus email via VBA 2. Save an attachment in a lotus email via VBA I have a situation where users are sending spreadsheets back to a mailbox and there are plenty of them. So i want to automatically search the...

Hi all, I am opening a form via a button using the usual docmd.open "myform" In the form_open event, I am making a function call, and in a given circumstance, a handled error occurs. how do I set cancel = true when the error occurs in the called function? Thanks in advance

Hi all, I have a problem that seems to be fairly common around the place ive noticed, after doing some googling. It seems cell references made in an Access module need to be hung off the excel.application object, and if they are not the code runs and then hangs without the user knowing. But...

I have two class modules that were once behind forms. Ive deleted the forms, the modules are still there, and being a massive pain in the back end!!! How can I rectify this? Thanks

Hi, I have a module that imports data from CSV files and then deletes and modifies certain data using a number of action queries. It works fine but when I attempt to open a query based on one of the tables that has been modified, it tells me that the table is opened exclusively by another...

I have the following table structure: tblEmployees EmpID [Other Info] CCentreID (the ID of the Cost Centre to which the employee belongs) tblCCentres CCentreID [Other Info] CCM_EmpID (EmpID of the Cost Centre Manager) DivID (the ID of the Division to which the Cost Centre belongs)...

Hi all, This is a fairly simple one, but im not sure exactly how to go about it... Lets say a Company can have many Divisions. Each Division has 1 Division Manager (CGM), and manages many Cost Centres. Each Cost Center has 1 Cost Centre Manager (CCM) and employs many Employees. Im thinking...

Hi all, Ive looked everywhere but can't find the solution... How do i add items to a multi-column listbox? Thankyou in advance

Could anyone point me in the direction of some code that checks the nullness of fields in a form? Id like it to work in conjunction with the Required property in the table design. Heres one attempt by myself: Public Function check_FieldNullity(frmName As Form) check_FieldNullity = 0 If...