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!

  • Congratulations Wanet Telecoms Ltd 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: bbannock
  • Content: Threads
  • Order by date
  1. bbannock

    refreshing a range of tabs.

    Hi everyone, I'm not very VB savy and I'm looking for some help improving some macros that I use. Right now the macro that I use to refresh a group of sheets looks something like the following: ----------------------------------------------------------- Declare Function EssVRetrieve Lib...
  2. bbannock

    VB code to reference a series of worksheets

    Hi everyone. I'm looking to write code for some macros that I'm creating, the only problem is that the way I'm doing it now is very tedious. I am manually changing the macro so that id references every tab individually. I'm wondering if there is a way to reference the series of sheets as a...
  3. bbannock

    Referencing a series of sheets in VB

    I'm trying to create a print all sheets macro in excel. Rather than listing all of this sheets in an array is there any way write a code that will print the range of sheets? ie. sheets 1 through 20 Thanks for the help. Brandon
  4. bbannock

    Want to show all entries when the value in combo is null

    hey everyone, I've got a quick question...I'm sure this is not too hard to do, but i'm hitting a wall. I have a form/subform set up which looks up entries based on department ID and Account. Right now you need to enter an account number for any data to be shown in the subform, however I...
  5. bbannock

    Finished database and forms now how do I make it secure

    Hi...I've just recently finished creating my first real database which is going to be used my other. I now need to figure how I can make it so they can use the switchboard and the combo boxes in the forms to look up data, but can't change any of the actual data, the format or add data to the...
  6. bbannock

    Including date range as a combo box.

    Hi everyone...I'm an access dummy, so bare with me. I'm creating a database for my boss and I've run into a small problem. I have a form which uses two combo boxes...one for employee name and one for employee ID. Once the user enters something into the box it populates the subform. Now my boss...
  7. bbannock

    Closing forms with return to menu button

    hi, I'm creating a database which contains alot of links to other forms...each form has a return to menu link at the bottom right which takes the user to the previous menu. The only problem is that when I click that button, the previous form stays open in the background while the new form is...
  8. bbannock

    Form shows record when there is none.

    I'm creating an expense database and I already have a good amount of the form and query work done, however I'm having trouble with a particular form. I've set the form up so that when you enter an employees ID # you see their expenses for the month. The problem is that not all employees incur...
  9. bbannock

    Navigating forms (searching fro desired form)

    Hi, I'm creating a database and I have a series of forms and querries already created. One of these forms shows all employee info, and then as a subform lists all of their expenses. I want to create a function so that anyone using the database can type in the employee name or employee...

Part and Inventory Search

Back
Top