Search results

Hello all - I'm trying to export 1 field from my table ("ID Code") to a specific Excel workbook range (lets say A2:A10). I see you can not specify a range using the TransferSpreadsheet argument when exporting, so what are my other options? Is this possible via VBA? Thank you for your help!

Hello, I need a way for a query to select all records based on the product numbers I have listed in an Excel column. I tried copy and pasting the Excel product numbers into the Criteria of the query, but it does not work properly. It pastes them "horizontally" rather than "vertically" (in the...

Hi all, I have a simple form with 1 combo box and 1 list box. I have the combo box with all manufacturing sites, and the combo box with products at those mfg sites. I have the dependent (list box) criteria set to the combo box. I also have the combo box onChange event set to...

Hello all, I have 2 date fields [Date Received] and [Actual Due Date] in my table. A user types a date (mm/dd/yyyy format) in [Date Received] and I want the [Actual Due Date] to auto-populate based on this value. For example: "3/13/2010" is typed in [Date Received], I want [Actual Due Date]...

Hey all, I have the following code that opens an excel file, adds a row and value to cell D2, saves and closes the book, and runs a macro in access to import data (I know it works up to this point). However, I'm trying to add some code to reopen the same book, and delete the entire row 2...

Hey all, So I have an Excel macro that has the following: Sub Test() Rows(2).EntireRow.Insert [D2] = "ABC" End Sub which adds a new row (at row 2) and inserts "ABC" in cell D2. However, I need some way to embed this code behind an Access button in VBA. I understand that you can call an Excel...

Hey all, I'm using the TransferSpreadsheet action to import data from a .xls to "tbl_master" in Access. I have the field and column headings match so it should be a direct import. All data but 1 field/column is working correctly... I have a column in Excel that is on General formatting that...

Hey everyone, This one seems pretty easy, but can't figure it out. :( I have a check box on a form. How can I create an If statement that "If the check box is checked, then lock the form so data can't be changed" And only allow the form data to be edited if the box is unchecked. Something...

I have been working with the Users and Groups security permissions on my database, and I wanted to offer an option on my switchboard for the user to change their password if they wanted. I was thinking a button that ran a macro to bring up the password change form...but I cant figure out how...

Hey everyone, I have a database that users use monthly for some financial reporting, I'm trying to prevent users who use the database from going back and editing data for previous months. (Ex: going back to January to edit data when it is March) The database is based off of 1 table. I was...

Hey all, I have a form (based on a query) that displays a variety of data in text boxes. I have the form properties set to allow edits, but I am not able to change data/numbers in the text boxes. The text boxes are not locked either. The form uses parameter values passed from another form to...

Hey everyone, I have a report that shows sales by month. I have it set up so the user selects which month they want on a form, and then that filters the report. Values in the month field are: Jan, Feb, Mar, Apr, May, etc. Is there any way to include a YTD (Year to date) column in my report...