Search results

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

Solution found I found the solution. I am able to loop through the NotesDocumentsCollection and call the EXTRACTFILE method on the EMBEDDEDOBJECTS property for each embedded object. One trick was to use the EMBEDDEDOBJECTS property of the RICHTEXTITEM class, not the NOTESDOCUMENT class. If...

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

That makes sense ghudson. The things is that the error is actually generated in a function that is called by the Form_open event, and that is the error number that needs to be in place of 12345 Any thoughts?

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

Place a unique index on the table in the customer name column If you want to allow duplicates in First Name or Surname, create a composite index and force uniqueness

RoyVidar, Looking at you line of code, i see what my problem was. The Cells reference that was inside the Range object wasnt hung off the excel.application variable.

A possible workaround If you build the range argument as a string then pass it to the range object, the problem is avoided...

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

Solution found I think I have found the solution perhaps. I havnt tested it but it looks good! http://support.microsoft.com/kb/176391/EN-US/

Hi, Im also having a similar problem and ive narrowed it to this... Firstly, when referencing any ranges, it must hang off the excel.application object variable. So i took care of this, and i guess those who are having this problem have done the same thing. BUT... When using the Cells...

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

No. There arent any recordsets opening. However, I do wrap the executions in a transaction. If an error occurs before it commits, does this leave the transaction open? Would that be the problem? 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)...

Thanks for the reply, i guessed that might have been the solution. There is no cross-charging so i can omit the fldEmplCDivID from the employees table. A question regarding the relationships between the tables... Reltaionships b/w the employees table and the FK's in the CC and Div tables...

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

You could do it a couple of ways. 1. When you open a recordset, the first thing you should do is rst.movelast, in order to force the entire recordset to load. Then you could check rst.recordcount, and if its greater than 0, run your msgbox function. 2. Use the EOF (end of file) property of the...