Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. warren66

    Putting Date Parameters into a Query/Table in Access 2010/13

    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!
  2. warren66

    Putting Date Parameters into a Query/Table in Access 2010/13

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

    Pivot Tables in Excel 2007

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

    Excel Macro/VBA

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

    Excel Macro/VBA

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

    Excel Macro/VBA

    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:=...
  7. warren66

    Date/Time problems when exporting tables to text files

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

    Date/Time problems when exporting tables to text files

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

    No commas please, we're British....

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

    No commas please, we're British....

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

Part and Inventory Search

Back
Top