Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: osera
  • Content: Threads
  • Order by date
  1. osera

    Delete file from Sharepoint with Access VBA

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

    Updating Data on a 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...
  3. osera

    Hiding the Ribbon in Access 2010

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

    Force a text box to retain focus

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

    Word/Excel Mail Merge Error

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

    Using a variable name to update a control

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

    Importing a .DBF File to Access

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

    Tabbing with in a text box

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

    Identify which control has focus

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

    Change Tab Captions on a Tab Control

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

    Using VBA to delete a GroupLevel on a report

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

    Query constraint that is "Like" the current value of a text box

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

    Changing Text Box Properties on a Report

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

    Changing Text Box Properties 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.

Part and Inventory Search

Back
Top