Search results for query: *

just want to top this - still trying to figure it out. thanks, Brandon

to clarify this code hide zeroed rows on a spread sheet...so it should go to a specific column in each sheet and look at all the values in that column. If the cell reads hide it should hide the row and if it reads show it should leave it showing. Sorry for any confusion. Brandon

That worked like a charm...now how can I do the same with the following code? Thanks for the help. Sub HIDEROWS() ' ' Sheets("sheet 1").Select range("P1").Select range(Selection, Selection.End(xlDown)).Select For Each X In Selection If ActiveCell.Value = "HIDE" Then...

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

I was looking for somethign similar to the code I already head, however instead of writing "sheet 1" I would insert the range of sheets ie. sheet 1:sheet6

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

Works like a charm...thank you very much sir

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

I'm sorry, I'm pretty new to using code in access...most of what I have came from using the wizards and some other simple methods. Do I put this code in the code in which my query is based on? I'm really not sure where to put either of these codes. I'm sorry to be a bother, I just don't...

I only linked the form and subform by dept ID...now I get all of the data for each department, however nothing happens when I type an account number into the combo box. Anything else I could try. Thanks, 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...

Also...I've created a seperate database with the same forms that i could send to you to look at...it's only 1.74 mb right now.

Hey...If you're still out there Chris I'm stil havin an issue with getting the form to use the month/year criteria to search the database. I created all the text boxes and labelled them correctly...and I included the between function in my criteria for the subform...I'm not sure if that was...

Chris...thank you for all your help today...I'm miles ahead of where I was. I gotta get going though...if you're around here tommorow I'm sure I'll try and pick your brain again...thanks alot for your help. Brandon

ok...I put the between function in the query for the subform...is that right? I also think I have to link the months up with numbers 1-12 to get them to go in order. bye the way...the VB window is taken care of...not a problem any more.

I'd say we should stick with the first one...I would send you the database, but it has some info that others aren't supposed to see...that'd probably make things alot easier.

Private Sub Combo10_AfterUpdate() Me.Amex_per_EE_query_subform.Requery End Sub this is the visual basic code I wrote. also...the data I was given comes with a month and a year column ie. column 1 column 2 March 2003 I want the user to be able to search from march 2003 to...

Also...now that I've put in the code...when I type in the box I'm getting taken back to the VB window. Brandon

Chris, you've been a huge help. I wrote the VB code and everything else...now how do I actually enter the ranges...should I make the text boxes combo boxes? right now i have mthrng : Text Box yrrng : Text Box