Search results for query: *

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

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

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

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

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.

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.

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

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

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

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!

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

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

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

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

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

Thank you so much guys. It functions almost exactly like I need by default, so I should be able to adjust from here no problem. Cheers! Chris

I've realized why I was getting errors. I had to post that code in a code module as apposed to tyring to use it in the form's code. Now I'm trying to figure out how to properly call on it(execute it) from the form, if anyone's interested in having a look. thanks Skip, I've posted a thread...

Hey, I've created an Access 2003 application, but I'm not using the Developers package, so I don't have access to the Common Dialog Control and need to use its functionality. I found this code online which is supposed to provide the same functionality. I dropped the code into a module and I'm...

Hey, I've created an Access 2003 application, but I'm not using the Developers package, so I don't have access to the Common Dialog Control and need to use its functionality. I found this code online which is supposed to provide the same functionality, but it is generating erros based on the...