Search results for query: *

I can verify that the objects are definitely gone. Hmmm... that gives me something more to explore. Thank you both. The machines that this is happening on are all running WinXP with SP3. Could it be an issue with the 32-bit that will go away with a Win 7 64-bit machine? It would be...

Thanks for your response. This is a self contained DB stored on our shared network. The user having issues with it is also the professional developer. If it were anyone else, I would totally agree that it's probably user error, but the DB is build so the user really has to know what s/he is...

I am having an issue with Microsoft Office 2010 Access product. I have a rather complicated DB with multiple objects and VBA code. The product was written in either 98 or 2000 version of Access. Every few weeks, all the objects within forms, reports, macro's, and modules disappear. I...

The formula compiled in select expert based on my criteria is as follows: {@Arrival Time FORMULA} = {?StartTime} and {@NewDate} = {?Date} and {CADUNITLOG.CADUNITLOG_DISPOSITION} in ["90", "35", "16", "01"] and {CADUNITLOG.CADUNITLOG_ON_DEPT} = "01" My parameters are set up for Start Date date...

That worked great. Thank you for the formula. I believe the report is just about working. I'm having a secondary problem, however, and not sure where to even start. I'm hoping someone has an idea. I have a report of Calls For Service from a dispatch center based on date range (arrival date)...

Thank you so much. I'll try that. Looks like it'll work and it's cleaner.

My first post explained how I have to come up with a formula that converts a number to a field. An example of the data looks like this: 172,954 (is really military time for 00:17:29:54) 1,365,765 (is really military time for 01:36:57:65) 16,293,935 (is really military time for 16:29:39:35) I...

Thanks so much. That worked! I'll be completely set if I can train the users to enter criteria in the proper format. Thank you so much for your assistance.

I've done a step by step in several different formulas, from turning the numbers into text, adding several zero's in front of the text, then using the right & mid functions, pulling out the hh/mm/ss to put together in a time formula. So far that's working, however only if the field option for a...

No, it's military time for 4:29PM, but I need the format to stay military time and also need to make sure that the decimal points are truncated.

Any help is greatly appreciated! I'm working with Crystal Reports 11. I have a field that's formatted as a number field that I need to convert to a time field. The data in it looks like this: 172,954 (which I need to convert to time 00:17) 1,365,765 (which I need to convert to time 01:36)...