Search results for query: *

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

As always, I can find my answers here. Thanks, Kevin, works perfectly!

Good evening. Once again, I find myself turning here for assistance after the 'Help' function in Access turns out to be anything but. Here's my situation. I'm pulling a data file off a government website. The file saves as a .DBF document (FileName.DBF) and that's pretty much the only...

Thanks DaveInIowa. I don't see anything in the code that is changing the setting on the TabKeyBehavior (or MultiLine - which is apparently similar and related). But now that I know what to look for, I can track it down the next time it happens.

Hello, I have an Excel workbook in which I put a user form so I can control the destinations of the data entered by the users. Everything works as I want it to with one exception: occasionally, the tab key doesn't shift the focus to the next text box on the form. Instead, it tabs over within...

Thank you all for your responses. I have a block of code that is essentially doing what MarkWalsh suggested. It seems to be working for me. Hopefully, none of my users will find a way to screw it up :)