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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by krissrites

  1. krissrites

    Date Format Issue (Access 2003)

    Resolved. Thanks for your help guys. I changed the Regional Language settings to (English) US, and set the location as US as well and the problem went away. Don't ask me why, because when I had location set to Canada, it had a Date format of M/D/Y. But the problem is solved and that's all...
  2. krissrites

    Date Format Issue (Access 2003)

    Yes I agree, I don't want to store it as text, I want to store as date. That's the only formatting I have set. At the table level, its data type is set to Date/Time. General Date as format. I just spoke with a colleague. I asked him to run it on his computer, because this little database...
  3. krissrites

    Date Format Issue (Access 2003)

    I don't have an input mask set. I toyed with it a bit to see if it would protect the data input, but it was performing the same way, swapping month and day. I only have the Data Type set at the Table level. I want to store date values, so I selected Date/Time. I think you're suggesting that...
  4. krissrites

    Date Format Issue (Access 2003)

    No April fools joke. I'm the only programmer working on it. I haven't implemented any code to muck with the date formatting. That's kind of the nice thing about having the data format set at the table level. Obviously if I type a day greater than 12, it knows how to handle it. Its clear...
  5. krissrites

    Date Format Issue (Access 2003)

    Actually I was able to get into Regional Settings and make changes, but there's nothing to change. The date format contained was 04/01/2009 meaning April 1st, which is what I want. On my form in Access, if I type 04/01/2009, as soon as I navigate away from that field, it changes to 01/04/2009.
  6. krissrites

    Date Format Issue (Access 2003)

    I haven't but I'm in a new location and these machines are pretty locked down. I don't think I would have the access to change that. I'll try n take a look.
  7. krissrites

    Date Format Issue (Access 2003)

    Hi there, I have a problem with the Date Format in Access. I have a form linked to a back end table that has a date field set to 'General Date' format. The date format is set for MM/DD/YYYY. The problem arrives when Access automatically flips the MM with the DD. For example if I type...
  8. krissrites

    SQL Statement: Query Bulider - Count Fuction Issue

    Yes, very simple and works perfectly. I was using Query builder and was trying all sorts of things, but that's exactly what I need. Thanks so much!!!
  9. krissrites

    SQL Statement: Query Bulider - Count Fuction Issue

    Hi there, I've been battling with this for awhile now. I'm trying to count all of the records in a field that share the same name. I'm trying to filter the results using a field that I don't want to see. I also don't want to the field to disrupt a count of the unique values that I'm trying...
  10. krissrites

    Use Form to Produce Report Like Results

    Continuous forms, great! You're right I'm gathering any number of data entered by a user, and using that data to filter a report results. That part is alright. Thanks for your help!
  11. krissrites

    Use Form to Produce Report Like Results

    The variables are string and date data types mostly that I'm gathering from fillable fields. Forms do have a Detail section (I noticed after I posted) but I can't get the detail section to repeat itself multiple times on the same form. In a report, the detail section repeats itself as many...
  12. krissrites

    Use Form to Produce Report Like Results

    Hi there, I'm working with MS Access 2003. I've been trying to send x amount of variables to a report so that it will produce results based on which criteria are needed. The problem I've run into in Access is that the Report wants to know exactly how many variables it is expecting and of...
  13. krissrites

    Use Form to Produce Report Like Results

    Hi there, I'm working with MS Access 2003. I've been trying to send x amount of variables to a report so that it will produce results based on which criteria are needed. The problem I've run into in Access is that the Report wants to know exactly how many variables it is expecting and of...
  14. krissrites

    Shell Function Permissions Issue

    OK, so I found out why. It will not open the file if there is a space anywhere in the file path, possibly in the file name as well. That isn't very helpful when there are folder paths that by Default have spaces in em like "My Documents" for example. Anyone deal with that problem before? Chris
  15. krissrites

    Shell Function Permissions Issue

    Hey, I'm working on an Access 2003 db and I'm having a problem with the Shell Function. I'm using the function to open a Word document. stAppName = "WINWORD.EXE C:\Documents and Settings\ChartrandC1\My Documents\DialogTest.doc" Call Shell(stAppName, 1) When this runs I get an error message...
See more

Part and Inventory Search

Back
Top