Search results for query: *

Thanks guys - I've taken note of your comments and I am going to redesign the entire structure of the database on the lines of your suggestions. I just hope I can get the queries to pick up the dates from the form I'm going to create!

In order to select a dataset, I have to run five queries, three of them requiring date parameters, and two which use a date to calculate a week number. I accept that what I have created is a bit clumsy, and someone with better skills than I possess could probably write a single query to do...

In Excel 2003 and prior versions, if I wanted to convert a table (with headers along the top of the columns and down the left-hand side) to a list suitable for importing into another application, I could use the PT wizard, and by choosing the "Multiple consolidation ranges" option, then "I will...

Thanks for your help, guys; Skipvoight's suggestion has been the easiest to implement, so I've gone down that line. Regards Warren

Thank you Finglem, but I could do with a little more help please. I have identified the code needed, namely Range(Range("A1"), ActiveCell.SpecialCellsxlLastCell)).Select but I don't know where it fits, and what I delete from my existing code...

I've created a macro, and it does the business for me. However, the is a line in the macro which pre-selects the cells. The snag is, I want to use the macro with other sheets, and the cells I would want to select would be different in each case. As it stands, my code reads: SourceData:=...

Thanks for your interest Bob. I have set the format of the date field to "Short date", but when I export, it still puts the time in. I don't mind starting from scratch if you can tell me how I should set the field up. Thanks again Warren

When I export a date from an Access table, I invariably get it formatted with the time (set at 00:00:00). I can't see how I can suppress this. What I have to to is either edit the .csv file with notepad, using Search-and-Replace, or export it to Excel, and then save that file as a .csv. Is...

Thank you very much guys, for those suggestions. I have used a variation Zameer's suggestion, using a input mask of a's which permits the use of alphas, numerics and spaces, but nothing else. This is ideal for addresses, when the user cannot enter a comma, or put a house name in inverted...

I am designing a database for a remote workers to enter data into, and since this data will eventually be exported into a csv file, I want to suppress the use of commas anywhere in a particular table. Is there a way of prohibiting the entry of a comma in the text fields, or alternatively is...