Search results for query: *

I have a pivot table where the drop PAGE field which in the sheet covers a1 and b1, the drop Column is also in column B. But in the pull down menu for the drop PAGE i want to be long maybe covering 3-4 columns as i can expand the column width but this also expand the drop column so looks funny...

I have columns in an excel spreadsheet with thousands of rows of data that is based on date e.g. 01-JUN-03 or 10-JUN-03. I need to count how many rows are present per month. tried dcount but not sure what am doing.

Hi, can someone help me out and inform me what the exit codes mean e.g. exit code 0,1,2,3,4,5, etc... for scheduled tasks. Thanks in advance.

Hi, I am trying to do a microsoft query to pull data from a csv. And in field date is as a string. but once the microsoft query has run i need the date field to be a date field, so i can sort it by date. Can it be done in the query?

Hi, I am trying to query a table using a form which the user selects their desired options from a number of pull down, the person may not want to use all the pull down just some, can anyone help me on this, i have set up the form with the pull downs on which gives the user his selection...

HI, Am in Excel, in cell A1 I have =today(), this is formatted as custom ddmmyy(which is 300902). when I reference the cell in a2 (=A1) it comes out as a1 (300902), BUT when I reference it in a3 (=d1&"/"&a1&"/"&f1) it comes out as 37502, which i guess is the unformatted...

I want to protect a sheet in excel but also in a macro I copy the sheet and move in down a row to leave row 1 empty. It does not seem to like this as it is protected any help?

I have a section of Cells that when a person types into the Cell, if the person has typed it all uppercase it leaves it alone. If the person has typed lowercase or mixed it makes them uppercase.

I Have text "G1" in a cell on sheet1, and in sheet two in cell a1="MONTHYEAR" b1="AST" c1="RSG" d1="KET" e1="G1". I wish to have a formula that will tell me that "G1" is in column 5 for me to put into another formula...

Hi, I have a little system in excel: When you press a button it collects data from external by opening the file, copying and pasteing into the system file and then closing the external file. but it prompts asking if i want to save on the clip board. how do i stop this as it stops the macro...

I have been given an excel spreadsheet, and the person who designed it has left. They protected the spreadsheet but noone knows the password, how can i break the password? or find out what the password is? Please help

Hi, I have 5 numeric fields, with % inside I wish to add these together in a totals field (It updating when I am putting the numbers in above). I know one way of the totals box control being the sum, but that way it does not get written to the table it is visible in the form only. anyone?

I would like to learn some VBA, but will have to teach myself a little. Does anyone have any suggestions? Books Web sites etc.... Thanks for any help

I have two tables, And I want to make a record continuous so record 1 in table 1 should be the same in table 2. I have a field called ID in Table 1 if this helps. So when inputing in form 1 (writing to table 1) I have a button to take me to form 2 (writing to table 2) do I have to do anything...

I have two text boxes 1) Division Name 2) Organisation Name I type into Division Name e.g. Abbott. When I get to text box Organisation Name, I want it to show the same as Division Name unless I overtype it. Is this Possible? Thanks

Hi, On a form I have a combo box of Yes and No. When they choose No I want a popup form to appear. If they choose Yes nothing else happens. Anyone?

HI, I am designing a database and on the login screen I want the background to be white and a logo to fade in and then fade out in the centre of the screen, then it go onto the main menu. One way I thought of doing this, but not sure if it will work is getting a blank white form (on a timer)...

I am trying to put a button onto a tab control to open the next tab & previous tab don't know how to do it.

I would like to put a button to help the flow in the database onto a tab control ( i know your gonna say why? as it is a tab control) but I have tried and cannot find the way to do it? Thanks

I would like to get text to blink or flash pls help