Search results

Yea, I really am struggling to even get the initial coding right. The data I want to export is in a select query named: "qry_export" The name of the sheet I want to export to is: "Export" The excel document is located at: C:\Documents and Settings\Admin\Desktop\testexcel.xls Can you please...

Does all that code go in a module? Then call the module from my form button?

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

Thank you. That cleared it up. I had it set up correctly, I just had the Requery code requerying the first combo box, instead of the 2nd (dependent) list box. Thanks!

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

Thank you very much! Works perfectly.

I understand. How can I create this to display in a query? I'm not familiar with the DateAdd or IFF functions. I need some way to separate records that need to be addressed by this month end, or next month end. Thank you for the quick reply.

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

To all- Found the answer here: http://support.microsoft.com/kb/109376 No real solution other than putting a dummy row of data in the Excel spreadsheet. Thanks for the help all.

I've attempted to attach the .xls file. The column/field that is giving me issues is column D. As you can see its mostly numbers with a few N/A's throughout. I have my table in access with these exact column headings.

Yes I can, I'll remove sensitive information and post momentarily...

The properties for the field are as follows: Data Type: Text Field Size: 50 Required: No Allow Zero Length: Yes Indexed: No Unicode Comp: Yes IME Mode: No control IME Sentence Mode: None All others: (blank) Thanks for your help SOS. I have a decent amount of experience with Access and this...

I have already created the table I want the data imported to and have set the Field type to Text before running the macro. However it's still dropping out the non-numeric values? Am I missing something simple? Thanks!

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

Ok, that seemed to lock it down when I check it. But one more request, any way to allow users to uncheck it? Since its locked now, can't uncheck it to reallow editing. Sounds weird, but a pretty specific form I'm trying to work on... Thank you!

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

Ok, how can I correct this?