Search results

1) I suppose I could bind the form to the query, but now that you have me thinking, I could really just bind it to the table and open form with the CUST_ID as the criteria and get rid of the query altogether. 2) My intention in using .FindFirst as opposed to MACH_ID as criteria in this case is...

Hi folks, So I solved an earlier problem loading a specific record and now found myself with a new issue. While my code opens the correct form on the correct record I find the form opens without properly drawing boxes, lines, and the record navigation pane. If I move drag the form off the...

Thanks folks, I solved the matter by moving through the record set as follows: With Forms!frmCustomerRecord.Recordset .FindFirst "CUST_ID = " & lstCustomers.Column(0) If .NoMatch Then MsgBox "The selected record no longer exists." End With I also set the listbox to...

Ah. Thank you for that. Makes perfect sense. He list box contains the customer Id(hidden) and the customer name. When the user double clicks the record I want to open another form and navigate to the correct record. As I do not expect to filter this list the customer id and the customer Id is...

[SOLVED] GotoRecord 1 and 2 mixup Hi there folks, Little trouble here. Probably a simple thing that I'm overlooking. I was using the following line of code in the double-click event of a list box to allow users to navigate a form to a particular record: DoCmd.GoToRecord acDataForm...

I can't actually post one with my example as it won't let me save my example. If I hit my clear data button and save its basically back to that sheet.

I hope this works still. I had to wipe a lot of the information for security reasons. I'll test the aggregation in the morning to see if it still works. A department will typically have 10-20 sheets per period. I've tested it before with 150+ but I cant get it to work right now with 30+. If you...

Not sure what's caused this. But now that the import works I get the following error when I try to save: I don't see how it can be a data volume issue, as before the first error I was easily aggregating 100 sheets with no error and now it breaks when I'm trying to save with only 20 aggregated...

Not quite solved. Progress. But a new error popped up which I'm not sure whether or not it's related. Ill post the final results over here.

Saw it. Did it. Conquered it. Thank you my friend! I still have no idea why it would just stop recognizing sheet and worksheet like that. Anyway, cheers!

Installing it now.

So I move i = - 1 to the top and added in your error trap. I still get exactly the same error and no additional information: Current Code: Sub Aggregate_Click() Dim MyPath, MyFilename As String Dim vNames() As Variant Dim i, intSheetCount As Integer On Error GoTo MyXLError i = -1...

Hey folks, Not entirely sure whats going on. I keep getting the 'variable not defined error' in the following code: Sub Aggregate_Click() Dim MyPath, MyFilename As String Dim vNames() As Variant Dim i, intSheetCount As Integer If Worksheets(1).Cells(14, 15).Value = "1" Then intSheetCount...

I don't know how I posted this on the access forum. I meant to post it under excel. I'll move it across there. It is a click in excel. When I attempt to step through the code I instantly get the error.

[SOLVED] Variable not Defined: Sheet and/or Worksheet Hey folks, Not entirely sure whats going on. I keep getting the 'variable not defined error' in the following code: Sub Aggregate_Click() Dim MyPath, MyFilename As String Dim vNames() As Variant Dim i, intSheetCount As Integer If...

Ah, obviously! Too many hours staring at code :D! I'll clean that right up.

Brian, Logic would dictate that yes. And that was my original code (i = i+2). But for some strange reason that does not work. I do delete the rows, but that is handled by a separate sub which does not run until after this one completes.

Hey folks, So I have a raw data dump from my server which unfortunately uses two rows for each record, with the second row containing data in only one cell. The cell above this one data item has a useless piece of data which i would like to replace with it. Currently I have the functionality I...

Happens all the time!

Bob, Or something. My brain has a funny way of focusing on old habits and forgetting new pearls until I've used them a couple times!