Search results

Hi, I have code for a Open Dialog box, But have been unable to find code for a save dialog box. Attached is an example of the code I have for a Open Dialog, If anyone has a save as Dialog or knows how to covert the code to a save dialog please post. Reagrds, Todd

Hello, I want to be able to pass arguments to an access file on start up. I want to be able to grab this value and then perform an action based on this. Background: The program will send an email with details for a change request, the recipient will then need to click on a link to...

Hi, I want to be able to find out what record was updated and I need to then log some details to another table. If I use the Form_BeforeUpdate event to detect that the recored will be updated, then How do I find out what record was updated. Thanks, Todd

Hi, I have images that need to be displayed on a form of varing sizes. I am currently using the bound object frame to display them (Zoom format). But they do not center. Is there an image control or a work around to get the images appear centered. Thanks, Todd

Hi, In one of my tables I have an alphanumeric field that we now need to sort by. the usual values in the field are like: 1, 5a, 10, 10a, 20, 50a, 50b, 999 Using order by will sort 1, 10, 10a, 20, 5a,... Is it posaible to use some sort of format or filter in the sql to only...

Hi, I have looked around but still I am unable to find an answer. How do I use doCmd.TransferSpreadsheet to import an excel sheet to access. Here is what doesn't work: DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "DrawingSheet", fileName, True, "DrawingSheet" 'fileName is a...

Hi, I have a database in Access with the Interface created in VBA, the reports are created in Excel by filling in each cell. Set xlw = xlx.workbooks.Open(reportLoc()) Set xl = xlw.worksheets("PMP") xl.Activate xl.cells(2, 8).Value = rs.Fields("xxxx") This work fine, but now I am...