Search results for query: *

I have an MS Access macro that calls a VBA function several times in a row and I'm getting incorrect data in some of the fields. I suspect that the function is collecting the results for the first call, then the function is being called again, and might be sending back the results from the 2nd...

Hi All: I'm working on an Excel spreadsheet where I need to compute values in several hundred cells, and the formula will vary depending on the values in the first few columns. I think the best way to accomplish this is through a formula that would spin through each range. Here's the general...

I need help on a "QueryTables" module that prompts the user for a .csv file name, then imports it into the current worksheet. The file will be ";" (semicolon) delimited. I've created the basic code using the RecordMacro feature, but I can't get it to work with the prompt for a file name...

I have an Excel workbook with a combo box to choose a value. The form triggers VBA to selectively hide or display certain rows that apply to the selection (the rows contain groups of check-boxes that are also hidden with the rows). This works fine on the screen, but as soon as I print the...

The following code is producing the error "Run time error 3265, Item not found in this collection". The comments sum up what the code is intended to do. It produces the error when I pass the value through the function using the function RowsToColumns("Free Format Instructions"), and the...

I need help changing hard-coded file paths to relative paths so my MS Access database will work on other networks or on a local PC. Please let me know if there’s a different forum where this should be posted (it’s specific to MS Access, but not particularly a VBA issue). Here’s what I have...

I'm manipulating a data extract that defines each new customer record in a header row, but doesn't attach the customer name to each record. I need to create a key lookup table by populating a "customer name" value for every row in the customer record until another customer name (header)...

I need your help to automate the process to break a text field in MS Access(with multiple lines separated with the line break character) into separate columns. I've struggled for several days and have seen various code samples using the "Split" function, but nothing that exactly works. Here's...