Search results for query: *

Hi, Just wondering if anyone knew of a quick way to sort columns in Excel. I have column headings in row 1, and I want to sort the data in alphabetical order. The long-winded way would be to copy, paste special values & transpose, then sort, then copy, paste special values transpose back...

Hi, I was messing around with Word the other day, with WOrd Art and all the effects you can assign to your text (eg. flashing text, 'blurry' effects etc.) Somehow I have set it to automatically have this effect on every worksheet I open, and I can't remember what menu I need to go in to change...

Hi, I need to get a function to produce years, months and days from a given Start Date up till Today. Here is what I've come up with so far - the years and days arre working fine: Years =YEAR(TODAY())-YEAR($A2) Days...

Hi, I can't find how to get my ProgressBar to work on my Access form. I want it to show the progress of the queries I have running behind a button. It's not essential, just aesthetic, so if anyone thinks it might be a struggle please let me know! I am a VBA beginner, so any help would be...

I need the bar to refer to a set of queries I have running behind a button, and I can't find anything to assist me with this in the 'Help'. Can anyone help me? Louise

Hi, I have a button on a form that runs a list of queries (thanks to some help from a couple of people on here!) I'd like to display the steps of what is actually happening once the button is pressed. I'd probably call it 'Progress: ', and I'd like it to say "Running" whilst it is...

Hi, I have a table with 3 fields - one is the name of the query ( so each row has a different query name), another is an order number (ie. the order I want that query to be run - 1 = 1st query to be run, 2 = 2nd query to be run etc.)and the 3rd field is simply a check box. My plan is to have a...

Hi, I'm quite new to using forms in Access. I want to create a drop-down list in my form which has the data from a specific field in a specific table. I have made a combo box, but I don't know how to link it to the table. Any ideas?? Louise

Hi, Was wondering how I could create a tick box in Word - I'm not much of a Word - wiz!! Any suggestions will do!! Thanks. Lou

Hi, No idea how to do this one! I'm wanting to create a drop-down list for users to choose from when they put cetain criteria in my form. I have queries reading off this form for their criteria. Any ideas? Louise

Hi, I'm not familiar with forms in Access. I have designed one called parameters with the intent to use it as a 'criteria' form i.e have users type in their criteria on the form, and my queries to read off the criteria selected in the form. I tried putting [forms]![parameters].[Start Date] in...