Search results

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.

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

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

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

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