Search results for query: *

Geoff, Funny...I did try that and it didn't work but I tried it again it's ok now. Thanks, Simon

This is my code: I want the user to be able to open up CalNov and CalDec with 1 password. Option Explicit Option Compare Text 'Password to unhide sheets Const pWord = "Calgary" Const pWord1 = "Quebec" Const pWord2 = "Central" Const pWord3 = "Western" Sub HideSheets() 'Set worksheet to...

Ok...it works now but how do I set up 1 password to open up more than 1 worksheet in the same workbook? It works for 1 worksheet.

anotherhiggins: Thanks but how do I set up a password for each worksheet?

Hello: My qestion is how do I send a workbook with 5-7 worksheets in it but set a password for viewing specific workseets(i.e Atlantic workshhet-only user from Atlantic can view this worksheet by entering an assigned password). Is this possible? Thanks!

Thanks. But now how do i show them on the reports? I need one text box showing the Criteria 1(current month) and another showing Criteria 2 (YTD) totals? Also, how would i but in criteria for NOv 1/03 - now? i tried >=11/01/03 and "now".

I was wondering if it was possible to have 2 criteria's when running a query? I want to prompt the user to specify a date range and also have a running total. (i.e Totals for month of Feb and also a running total from Nov - Current date). Is this possible?

Sam, I clicked your site, figure this!!!

VBAjedi, Thanks for your help but the combobox2 still appears but is in a smaller font. I changed the properties to Visible=false. And used the code you wrote. What should I do?

Basically I have a combo box with items: Approved, Declined, Cancelled. What I want to do is prompt the user/ remind the user to select a Decline Reason when Declined is selected from the box. Does anyone know how to do this?

I seem to be having a problem running this Macro. It seems to list all my options in the one cell continously, with no space. I want the user to be forced to choose on option when they space over to the specific cell. Basically it's a tracker with a list of Product Codes. They must chooose...

How do I prompt a user that if C16 has a value($Amount), that C15 must have a code(ProductCode) and vice versa?

Thanks for the suggestion. I changed the setting to AGP and...nothing...screen went blank. So, I reset the CMOS jumpers and tested another video card. VOILA!! it appears the answer is because I have a faulty card..

The "cold video card boot problem" is when the computer consistently does not see the video card when the computer has cooled down, but the computer always sees the video card after the computer has warmed up by waiting five minutes or so and then pressing the reset button.

Hello: Just wondering if anyone knows how to solve a cool boot problem? Is it just a matter of downloading the VGA drivers for my MB? This is what I have: AMD XP 1700 256 MB 40 GB HD Win XP Geforce 440 mx 64MB

i'm not sure...as this belongs to someone else and he is on vacation...but i cannot seem to find the code so it might be coming from somewhere else.....can you help me with both?

How do I add a record to an existing list box in Excel2000? Thanks in advance, Simon

I have a Sales table with fields Agentname, Date, CustomerName, Account Number, ProductCode and Dollar. Using ADO, how do i search by Agent name and have all the Agent's Sales for the day displayed?

I know that for Data control you can use the Index and Seek function to search for records in the db , but what do i use for the Ado control? I seem to be getting an error when i use Adodc1.recordset.index and Adodc1.recordset.seek Also, how do i set conditons? eg. User cannot go on to the next...

I know that for Data control you can use the Index and Seek function to search for records, but what do i use for the Ado control? Also, how do i set conditons? eg. User cannot go on to the next field without entering something in the previous field. Simon