Search results

I have a challenging Access to Excel export problem: I would like to export the results of a query to excel such that each record is exported to it's own excel workbook, and within each workbook, I would like certain data fields to appear on different worksheets. I was able to export to unique...

Is there a way to send another user a message within Access? (Like "Instant Messenger" or Lotus Notes "SameTime") If you have any experience or info I would appreciate some info. Thanks in advance!

Next challenge; I used to do this with a macro, but now I want to do it in VB. I had a macro that would open a modal form with an unbound listbox control, the user selects a value from the drop-down list, and then clicks an "OK" button. The button would fire another macro that would set the...

Please help; I have a module that imports data from an Excel speadsheet into a staging table. Then it runs various queries to append the data to the appropriate tables within the db. Previously it was an annual process, and it was easiest to simply modify the query defs once a year to...

I have a db where I have set the form properties to only allow edits in the design view, and I have disabled the tool bars/menus, but users can still right-click on the forms and get into the design view. How can this access be blocked? :confused: Thanks in advance!

I have a module that uses an "InputBox" to prompt a user to submit an administrative password. I would like to specify the height and width of the box. Can this be done? If so, how? Here's my code: strInput = InputBox(Prompt:=strMsg, Title:="Administrative Mode Login") Thanks in advance!

Has anyone experienced this: I have a module that imports data from an Excel spreadsheet using "TransferSpreadsheet". The spreadsheet is one of many protected worksheets in a protected workbook. In order to use "TransferSpreadsheet" the file has to be open in Excel, or Access will throw a...

Does anyone know if it is possible to export the results of an access query into an excel worksheet, but have the output data skip one of the columns on the excel sheet? Put another way: Access table has columns "A", "B" & "C" Excel worksheet has columns "A", "B", "C" & "D" I want to...

My database has a number of modules that import data from multiple Excel tables which I receive from multiple people. After using "DoCmd.TransferSpreadsheet" to load the data into the first 33 fields of a staging table (tbl_current_import), I update the 34th field with a value representing the...

I am trying transfer data from an Excel spreadsheet using the TransferSpreadsheet action. If the password protected excel file is not open I get an error message "#3161 Could not decrypt file." The excel file has to remain password protected, so I would like to add an error trapping routine to...