Search results

I am running some code that searches one data set looking for matches in another. The code works fine until it finds a match that involves the last data entry in one of the data sets and then it seems to get caught in a loop at that entry. Here is the code: Set rstCheckInfo =...

I am trying to get a report to give an hourly average for each record it lists. The catch is that the average could be based on an 8 hour shift or a 12 hour shift depending on the shift designation from the query. I have put code in the report's Activate event to handle it but it is only...

Is there a good quick way to define the print area of an Excel spreadsheet using automation that would only include the range of cells with data in them?

Unfortunately George Too's code didn't work either. However your idea intrigues me. I am not opening an existing file but rather opening a new file, adding data and the saving as ... I am wondering if the original empty file might be doing as you say. I'll let you know.

Here is the starting and ending code as it stands right now. I'm posting it together here in hopes that someone will see the error of my ways. Unfortunately despite numerous variations, the problem remains. Someone HELP please!!! Dim rs As Recordset Dim intFieldCount As Integer...

Was MyExcel your object variable for the session that you defined or is that a built in name?

Already tried that. Thanks anyway. Any other ideas anyone?

I seem to remember coming across a thread about this once but for the life of me I cannot find it now. I am using Automation from Access to create/populate/format/save an Excel file. Everything works great with it. Unfortunately, after I've saved the file, quit the sessions and set my object...

The combo box pulls its values from a stand-alone table. The combo box retains the other values even when All is selected.

I have a combo box that uses the code from Microsoft Knowledge Base to add 'All' as an option in a combo box. Now that feature works fine. The problem comes in when you use the value selected in the combo box as a criteria for a query. The All option does not work correctly because the criteria...

Does anyone know of a way to make 'All' as a choice in a combo box that would be used as query criteria? :confused:

I have gone with Automation instead of trying to use brute force to export the data. However, if anyone has an answer to my questions, I would still be interested in hearing it.

I am a bit puzzled by the behavior of the transfer spreadsheet command that I am using. I am using it in a macro as a test. (forgive me oh mighty Access master for that. right now I'm just testing the results, but I promise I will write the code for the final project) :rolleyes: I was...

Is there a good way to export a table/query to Excel onto an existing sheet and maintain the existing formatting that is on the sheet?

Thanks.

I am using a command button to open a form and am linking the data on the two forms by passing the CaseNum field value. The first form does not allow data edit/entry but the newly launched one does. How do I get the data entry form to automatically fill the CaseNum field with the linked value...

I have figured out that this peculiarity only occurs when the Master/Child field (the field that links the two forms) is null when switching between forms. If the field has a value in it, then nothing happens. The only thing I can figure is that when the subform is deactivated and the main form...

Actually the data is being stored to the table and not just the data that's being generated by code but any data that happens to be on the subform. If/when I figure it out, I'll let you know.

OK. I resolved the close button issue. That was a simple matter of the modified code I put behind it. (Dummy me only coded the error trap side of it and ignored the normal exit condition. Go figure) The form behavior is now different. I put the code assigning the case number on the before_update...

Sorry. The forms are linked Child/Master. I don't know why I said that before.