Recent content by osera

That did it. Adding "CreateBackup:=False" to the command to save the new file replaced the old one in Sharepoint. Thanks!

Good afternoon. I'm trying to have an Access database automatically create an Excel spreadsheet and save it to Sharepoint when the database is first opened on any given day. The end user wants the file in Sharepoint to have the same name every day, so I can simply replace the previous file...

I think I've found the answer to my own problem. If I disconnect the source object (me.subform.SourceObject=""), process my data then reconnect the source object, my new data is showing up in the subform.

Hello, I am unable to get a subform on a tab control to update with new data. I'm going to try to give a detailed explanation of the situation, so please bear with the length of this. The database opens to the main form, on which is a tab control. The first tab is where the users select the...

Perfect! Thanks again!

That worked, PHV, but a little too well. It not only closed the ribbon, but also the menu bar and the quick access toolbar at the top of the screen. Are they all considered to be one as the ribbon? Perhaps I'm asking the wrong question. Maybe I'm looking for a way to minimize the ribbon...

Good morning, I have an Access 2010 database with a couple of forms that allow my users to select from a group of comman buttons. Unfortunately, a good number of my users insist on setting their screen resolution to 800x600 which results in the ribbon covering up the top portion of the form...

Thanks, TheAceMan1 Putting the "If me.dirty...." code in the On Exit event is giving me the function I want. I'd prefer to have my users commenting right after they check the 'no' box, in hopes that their reasons will be forefront in their minds.

thread702-1559904 Good afternoon. I am having an issue very much like (perhaps the same) as in the referenced thread. My form has 'yes' or 'no' option buttons in a frame. If the user checks the 'no' button, focus is sent to a text box (me.MER_Comments) where the user has to enter comments...

Brilliant! When she asked me to have it sent to that printer, I assumed she was already connected. I set her up on that printer and it worked just like it should! Thank you!

Dim MergeDate As String Dim ConfirmPrint As String MergeDate = InputBox("Enter date on data file (yyyymmdd)", "Merge File Date") ActiveDocument.MailMerge.OpenDataSource Name:= _ "T:\OUT_OPS\Mail_Merge_Docs\MergeFile" & MergeDate & ".xls" _ ...

No. I haven't fought that battle yet in this office. However, I did take that into account and changed the code when I opened the template on my co-workers computer. The macro doesn't have a problem on the .OpenDataSource line, so I'm pretty sure I have that part right.

Good afternoon. I created a Word template with a macro to perform a mail merge from an Excel file. Everything works perfectly on my computer. However, when I open the template on a co-workers computer (the template is stored on a network drive) and run the macro, I am getting Run Time Error...

Brilliant! I love this site. Thank you very much!

Good morning! I have a form with several sets of text box/combo box pairings. My hope is to have control buttons that will call a function that will perform operations on a specific text/combo pair, depending on which button is clicked. Essentially, I click a button, pass the combo box and...