Search results for query: *

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

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

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

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

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

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

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

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

Hello! I'm working on a form in Excel. There isn't any set order in which the users have to move from control to control; they can go in whatever order works best for them. However, there is an OnExit event for one drop down box that I would like to change if they go from it to a particular...

Hello, I have a form (cleverly named Form2) with a tab control (equally cleverly named tabctl29). The tab control has ten tabs, named TabA, TabB, etc. When the form is opened, I'd like to have the captions on those tabs change to values looked up from a table. So, the form opens and...

I'm trying to create a form/report combination that will allow my users to select items in combo boxes on the form that will define the sort order(s) on the report. I can use the CreateGroupLevel function to make a new sort level and the .SortOrder or .ControlSource to modify an existing sort...

This one has several of us stumped. If I write my query constraint as *Test*, it will find any record where "Test" appears in the field in question. If I write my constraint as [Forms]![Form1]![Combo0], it will find any record where the field is the same value as whatever is in Combo0. My...

Is it possible to change the properties of a text box on an Access report based on the value of the text box? I'd like to have a text box that changes it's back color based on the value displayed in the text box. I know how to do this on a form, but I can't find a way to make it work on a report.

Is it possible to change the properties of a text box on a report based on the value of the text box? I'd like to have a text box that changes it's back color based on the value displayed in the text box. I know how to do this on a form, but I can't find a way to make it work on a report.