Search results for query: *

Hello, I am trying to create a macro in Excel in which for a given range of data, say A32:L100, if a cell in column C has a certain value, the macro will copy and paste data from that row onto another sheet in the next empty row. Below is an example of the code I have, which gives the right...

Hi - I am trying to create a macro in Excel which will update the print area range based on cells I have designated using an "address" function to locate specific start and end cells. I am a novice user and tried to use the "record macro" feature of Excel. The code I am trying to manipulate...

Hi - I have a control on a form with its control source set to: =Interface_Rejection_Subform.Form.RecordsetClone.RecordCount (to count the number of records on the referenced subform). This works fine on non-xp workstations, but for several users who were upgraded to xp, the control shows...

Hi - I have very little knowledge of VB coding, but am trying to set up what I believe is fairly simple. This is the code I have so far: Sheets("exc34").Select Range("A9").Select Range("A9:G35").Select Selection.Copy Sheets("data").Select Range("A1").Select...

I previously posted a thread, thread 702-1209150. Recently, I began seeing this problem again. At the time of my post, there was one very similar, thread 702-1199169, which I hadn't noticed at the time of my original post. Has anyone who had this problem successfully resolved it? P.S. the...

Hi - I wanted to set up a command button that would perform a "compact and repair" upon click. I found an old thread - thread 181-73087 - that had a simple suggestion. The "compact" macro (sendkeys %TDC) seems to work great, but the "repair" macro (using sendkeys %TDR) doesn't seem to work...

Hi - I have a database set up in a multi-user environment. Most of the time, it works fine, but I have had a few instances where a user tries to edit a field on a form and the message "Could not update; currently locked" comes up. The field is not set up as a locked field, and again, it...

I am trying to create a form (Start/End_date_form) with several unbound list boxes, from which I want to base a parameter query. This is what the SQL looks like for the query: SELECT Batch_Info_Table.BA, DOC_List.MD_Name, Batch_Info_Table.[#OFTKTS_IN_BATCH] FROM Batch_Info_Table LEFT JOIN...

Hi - I am trying to run a query based on three tables(Batch, Rejection, Error) with established relationships. For example: The Batch Table has fields: KEY,BA,DOC,DOS,#oftkts The Rejection table has fields: REJ_ID,NAME,MRN (Also "ForeignKEY" field joining to batch table "KEY" field) The Error...