Search results

Any chance you could upload a copy of your DB with some sample data?

I don't believe a Join would work based on the way the query is setup. Since the update value is a query, it doesn't contain a unique identifier to pass through to the FoodTable. You simply need a WHERE statement on the main update query to tell it which record to update. Simplified Code...

That would be a limitation of continuous forms. Even though Access shows you multiple records, Access only sees one form, so anything outside of a bound field will show the same across all records.

I just realized what you don't have is a Where statement in the actual update query. You're telling it to update FoodTable.DeliverySize, but you don't tell it which account in FoodTable to update.

If you want to use code, it would be: DoCmd.SetWarnings False DoCmd.OpenQuery "QueryName" DoCmd.SetWarnings True

Question: when you run the select query and view the results, does the query allow you to add new records or change the data shown in the query results? If not, your select query isn't an updateable query. If that's the case, go to Access Help and search troubleshoot queries - under the select...

What about using this simple code after the setFocus command? DoCmd.RunCommand acCmdRecordsGoToNew EDIT: RG beat me to it... His code will take you to the last visible record - my code will take you to the new blank record.

Just want to make sure it's not a copy/paste error, but in your original post, there's a space where it looks like there shouldn't be one. Formulation_Combo.Se gment_Combo) AND May not actually be a problem, but want to make sure.

I'm guessing so, although I've never done it. If I didn't have a bunch of work to get done today, I'd do a google search and see what I could find. You might try doing a search to see if anyone has built the code to do it.

Okay -- put these lines right before your transferspreadsheet line Dim stamp As String stamp = Month(Date) & Day(Date) & Year(Date) Then, to date stamp the spreadsheet, you do this: DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "Month End On Hold", "\\usnfs0\RoyerD\2008...

That's because you can't export to a sheet that already exists. You have two options - you can either create a unique name for the spreadsheet (like a date-stamp on the spreadsheet name) or you can delete the old spreadsheet before exporting the new data. I've got date-stamp code if you want...

If that doesn't work, this thread has some options for you to try. http://www.access-programmers.co.uk/forums/showthread.php?t=117753&highlight=lost+menu

This is actually very simple VB code. The easiest way to get the code you need is to create a button that opens the form. Using the wizard, you can match up the field that you're looking up. Create a code block for the double-click event, then open up the code and paste the code from the...

The value you enter as the second parameter in the call should match the sheet name in the excel file. Double check that value.

You want just the public sub. You are correct about how to create a module. You don't want to use the exact same name as the function though (it can confuse Access). To use that code as a module, you'll want to change the word sub to function. I've updated the code below -- I also realized...

You should create a module where you can then paste the guts of the function. I would think you can call it from the On_Open event, but I've never tried.

Did you change the name of the function? The function I provided is ModifyExportedExcelFileFormats You just have ModifyExportedExcelFile

What is your call statement? Make sure you have quotes around the location of the spreadsheet.

With a little VBA code, you can do quite a bit of formatting from within Access. In my case, I've got a transfer spreadsheet command followed by a call of my modify format function: 170 DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "QueryName", "\\server\filename.xls", True...

Go into Access help and search for Troubleshoot Queries - Under the Select query type it explains the situations in which you can update the data (or add new records) in a query.