Recent content by rglman

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...

Problem Updating MainForm - Revisited... Hi Guys, I had essentially the same situation, and used this solution too. Then, after having it in production for a while, and getting user feedback, I realized it is easier for your users if you can leave out the "MsgBox" code and just...

Can a maketable query generate the output table name dynamically? Is it possible to have a maketable query that generates the table name dynamically? The example would be something like this: SELECT qryComp.EmplID, qryComp.EmplName, qryComp.MgrName INTO [=tblMyNewTable & " " & Date()] FROM...

Thanks for the suggestions! Thanks for the suggestions! I guess I deserved the "send them an e-mail" responses...:o

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...

Sorry.... I've been asleep at the switch!! This was all I needed: DoCmd.OpenForm "frm_quarter_for_import", acNormal, "", "", acEdit, acDialog Thanks for your help!

The rest of the code runs, BEFORE the form even opens! Then after everything has finished the form pops open. I have tried "acDialog" and it doesn't appear to make any difference. I think the solution is going to be some kind of "If - Then - Else" or maybe a "Do - Loop" statement to keep 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...

Thanks! Your help was right-on! :)

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!

Thank you! RV - Thank you. That's what I figured. I was just being lazy and trying to save the extra work!:rolleyes:

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...

Try a compact and repair... I had the same problem once before, and it was the result of an indexing error that was corrected by running a "compact & repair".