Search results

Hi, I am trying to export a record from Access 2007 to Excel spreadsheet. I use the following code: ... wkbDest.SaveAs strReportPath & "\Initiative Details - ID " & Me.ID, xlOpenXMLWorkbook ... When running the code, if a file name already exsits, I get a popup box mentioning: "A file...

How to write On Error code for opening a file? Hi, I want to use On Error code for opening a file. Something like: On Error GoTo findtemplate_error Set wkbDest = xl.Workbooks.Open(strReportPath & "\Template.xlsx") findtemplate_error: If {find [Template.xlsx]} Then {GoTo ...continue}...

Thank you boblarson and pr2-eugin. It works.

Hi, I am using the following code to use Template.xlsx file that is under the path "C:\App": Application.FileDialog(msoFileDialogFolderPicker).Show strReportPath = CurDir () Set wkbDest = xl.Workbooks.Open(strReportPath & "\Template.xlsx") But, I got error message, i.e.: After I...

Thank you GinaWhipp.

I want to create a [Modified Date] field as a time-stamp. I followed the steps mentioned @ office.microsoft.com/en-us/access-help/store-the-date-and-time-when-a-record-is-modified-HA010241284.aspx. 1) Add the [Modified Date] field to a table 2) Create a macro that records the date 2.1) On the...

I am working with a data entry form application via MS Access 2007 for some users to add records or modify/update existing ones. I create a blank form (Form1), and put a query object (Query1) on the upper part of it. The list generated from Query1 displays 3 fields: ID, User Name, Project...

Hi, I am making a data entry form application for some users. I want to add a user login form when opening the MS Access 2007 database. No password needed. So, after the application is done, it can be used like that: 1. Give the accdb file to the 1st user. The user can use the login form...