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...
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...
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
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...
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...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.