Replies

Mark–

I liked your solution, since the only thing I could do would be to ignore the record and not count the time for that call. Your solution would give me a 0:00 call length for that call. However, it does not work since the time_out field defaults to ” ” (8 spaces) when empty.

Hans, I think I’ve answered your questions: I want to ignore those records with no time_out recorded and the field is neither NULL nor “”, but rather ” “.

Thanks for your time. If you have any other suggestions, I am eager to try them.

Sorry abouy the time lag. Too many projects going on a once.

In step 3, I selected “using an existing list” and clicked on browse. It is an Access database that I connect to. Check the attached gif. Only tables are listed in the resulting dialog box. Yes, there are queries defined in that database. Any suggestions?

Hans– You da man!!

Your answer was right on! I don’t know what I’d do without you and the rest of the Loungers to turn to for support. Thanks to all.

Thanks for the response, Hans. I was not aware of the Switch function. My query now works like a charm.

Thanks for your response. I actually need to use code that will open Explorer to a folder at the end of a procedure. The folder could be one of several folders, depending upon certain variables in the procedure.

Actually, I have a listbox filled with different datasets that can be exported to Excel or text files. Different lists are exported to different folders. I want Explorer to automagically open in the destination folder.

Bryan–

Thanks for your piece of code. It worked for creating a directory.

Mike–

There is a FolderExists and a FileExists method. For the little function I’m creating, I also need to determine if a certain file name exists. The documented syntax for FileExists is object .FileExists(filespec) where Object is always the name of a FileSystemObject. How do I determine the name of the FileSystemObject that I need to use?

Application.run was the ticket. I wouldn’t have thought App.Run would fire a Function. That’s what love about this board–I just keep on learning!!! Thanks Charlotte!!

Which brings me to a very good question. What reference would you recommend as a good primer for Access’ Object Model? I have a few good books, but none of them detail how the Model hangs together. What do each of the DoCmd methods do? What else can App.Run do?? What other objects and methods are available that I don’t even know about?

Thanks for your reply.

I want the file to save to a specific folder, but I want the user to be able to determine the specific file name.

Regarding the hidden time in the DTPicker when it is formatted for shortdate: When my DTPicker gets the focus and I can see the time, it does not read 12:00:00 AM. The time is always the current system time. YES, I have checked to make sure that all of the controls are formated with the shortdate format.

I personally think that the version of the DTPicker I have does not work correctly with AXP. I think the current version is Ver 6 SP4. I only have ver 6. I need to find the more up-to-date version so that I can test this.

Thank you for all your help. We have all spent too much time on this problem.

OK, I’m starting to feel very inept with this control. It still is not working. Mark and Charlotte–thanks for your suggestions. I created the textbox as you recommended. The textbox appears to update correctly, except that when I bring the focus to the textbox itself, the text change from short date to date and time. It returns to just the short date when the focus is moved elsewhere. The date is the date of the Picker, but the time is that of the current system time. Is this normal?

I have double checked and the format property for the query field, DTPicker and the new textbox: they are all set to Short Date. And I have double-check the spelling and syntax of the query criteria. Everything is the way all of you have suggested–that way I thought it was suppose to be all along. I even tried referencing the new textbox instead of the DTPicker in the query. I still get an empty recordset when I run the query. I know the rest of the query works because if I change the query criteria to a hard-coded date, I get the data I expected.

I have Ver. 6 © 1997. Could there be an incompatibility with this version and AXP.

Unless someone sees something I’m missing, I’ve got to move on and do something different.

Should this form I’m working on that includes the DTPicker be showing up in the Project Explorer? all my other forms are there, but this form I’m working on is not listed. Neither is it’s subform. Yes, I’ve saved the forms.

Same result. I still get 0 records in the recordset. I know the syntax is correct, otherwise it would interpret it as a parameter. It is like the date format of the DTPicker is different than that of the table data. If I manually enter in a date, I get the records I expect. Whatsup with that?

The problem with getting a result set based on the DTPicker still exists (as described in my earlier post), but the end result of what I am trying to do is to display records in a subform based on a date chosen by the DTPicker. Well, as far as I can tell, the records displayed in a subform have to be related in a one-to-many fashion to a field in another table or query–upon which the main form must be based. Is it possible to even use the DTPicker in this manner??? Any suggestions around this dilemma will be appreciated.

I stand corrected. Thank you, Pat and Wendell!! The solution was so easy, I overlooked it. Isn’t that the way it usually is!

Is far as I can tell, you only have access to one ODBC connector at a time. And you can only access one database with each ODBC connector. Is there something I am missing?

I believe that the field has been formatted with both date and time, which would account for no data on the last day of the month. I guess I have to look for “between 9/1/2002 and 10/1/2002” in order to get at the last day of the month. From what you indicated, this would not include data from 10/1/2002, as long as the field was actually formated with date and time.

Thanks for your help!