Recent content by JReichnan

Thanks Robert88....very interesting code. I can use this for a number of applications Im working on. later brother. Jeff

Very interesting code. Id like to spend some time analyzing it. Thank you.

Hello all, I would like to be able to change the default date in a table or the related form by posing an input box and having the user select the new default date. What is the code that can get the user input date into the Table or Forms Default property. Thanks. Jeff

Thanks Banana, it works perfectly

Thanks Banana, I think you are on the right track with the Public pathway. Just so you know. When I press the button on the switchboard... at that point the name of the report is identified as EvalByAllPoints. If I were to hit another button on the switchboard the report would be "Summary"...

Thanks all...this will not be a multi user environemnt. It will be single user with an upload to a SQL server for just the data on a later date.

This is for a number of single user installations in remote locations. Eventually just the date will be uploaded to a SQL server, possible

Hello, I have a switchboard with 3 buttons. Each button calls up a different report. Each report uses a similar form so that the user can input starting date and ending date via a calendar. Once the dates are established an OK button is pressed to call up the appropriate report. Since the...

Hi RG, Its me again. I noticed the hard drive acting up. However I was also reading some stuff about the error message where there are a couple of service bullitins out for MS office which may solve the problem as well as a way of self packaging the jet database enging and data files so that...

Hello, I have written an extensive Access DB Application for my company and have placed it on a cd for distribution. When we try to copy it from the CD to a folder on another machine the above mentioned error comes up. Any Suggestions. Jeff

Hello RG and Oldsoft....I triedthe calenders you mentioned and am glad to report i loved them....Im going ot test the program out tomorrow on an 2003 machine and hopefully it will work. With the modules self included I dont see why it wouldnt....thanks so much....you are both great teachers. jeff

Hello, I wrote an access program using version 2000 and the activex calendar 11.0 which came with the software. When i tried to run the same program on access 2003 none of my dates worked and I got error messages all over the place. Help!

Thanks Emp...but with substituting numbers it just wouldnt seem to work. say end time = 2pm and start time = 1 pm then the equation would yeild 24 which would be worng. The idea is to take an end time of 1pm and a start time of 11:54 which would yeild a total time of 1hour 6 mins. The...

I ended up using this. TotalTime: Round(Hour([ConEndTime]-[constarttime])+Minute([ConEndTime]-[constarttime])/60,2)

Thank you rural guy. I aprreciate your forthrightness