Search results

The table is large so I had put it into another dB to help with size management. If nothing else I’d like to learn how to execute what I’ve described. Thanks for your feedback.

Looking for help with syntax to do the following: While in database1 I’d like to delete records from a table in database2 where ‘year’ = X. After this, append the same table with an imported Excel file. Thanks in advance.

Does not seem to like the last line you gave me. States "Method or data member not found" Not sure if I've clarified well but this code is taking place in Access. Does the version matter?

When trying to run the below code in Access I get the following Run-time '1004' error: "To paste all cells from an Excel worksheet into the current worksheet, you must paste into the first cell (A1 or R1C1)." Set wkBkObj = Workbooks.Open("Somewhere" & strName) Set wkBkName =...

It wasn't identical but was enough to get me pointed in the right direction. Thanks!!!!!!

I've got two forms, frmA and frmB. frmB loads after clicking a button on frmA. There is an image on frmB that I would like to load depending on the value of a combobox on frmA. Any ideas? thanks in advance, Pikeboy

That's exactly what I had done. Thanks for the response.

I've got a tab control with 4 tabs on a form. If I select the 2nd tab and update a couple of subforms based on a listbox I have, everything works great. However, if I then select the first tab to do something similar, some of the labels from the 2nd tab show through. How to stop this? thanks...

Here is what I ended up getting to work (I changed daysremaining check to '0' as less than 1 but greater than 0 meant pay day still hadn't come yet :o( If daysRemaining < 0 Then rs = InputBox("Please enter next pay date:") rs = "#" & rs & "#" Me.txtNextPayDay = rs End...

I've got a form that performs some vba on load. It does a datediff to see if the current date is less than 1 when compared to the current value of a textbox. If this value is indeed less than one, it asks the user via an input box when the next pay day is. However, upon doing so it populates the...

I'm currently populating a listbox using the results of a query as its rowsource. However, I need to also ADD the entry of 'ALL' to this listbox for use later. I know the down and dirty way would be to add a record to my root table with 'ALL' in each of the fields where I might like to have this...