Search results

Hi everyone I have a new problem with MS Access 97. I was shown how to decompile this program a few years ago solving an original problem thanks to one of your Members. I've attached a snapshot of a new window which pops up when I try to load the program. Unfortunately the original MS Access CD...

I'm having trouble duplicating in Access a report (Spreadsheet) that I've produced in Excel. The report is a list of golf player tee times for a particular day. You can vie the spreadsheet in Dropbox - see below. I simply need 3 sub-forms each containing 3 columns of data (Times, Names, type)...

Hi I have MS Access 97 that has been very stable. This week I am suddenly presented with a situation where I'm able to open my program but it then crashes after a few seconds. This program has evolved over many years and I have saved a lot of previous versions which also crash. Would appreciate...

Here's an easy one for you Access experts. I have a Select query from which I wish to extract values either less than or more than Zero. The two fields generating the value are [Paid] and GF: IIf([Greenfee Payments].[PaymentID]=6,0,24.5) The value field is UO: [GF]-[Paid] I put <>0 in the...

Can somone help me with this problem please. I have designed a golfing green fees booking system for my club using Access 97. The green fee payment options (via a combo box) are Cash, EftPos and Cheque. In my report which is a list of tee off times with the relevent members names I would like to...

I have StartDate and EndDate fileds where I enter the date and time the employee starts and finishes his shift (in dddd dd mmmm yyyy hh:nn AM/PM format). However there is a penalty issue that starts at 7.00 PM. How do I set up a non changing reference for 7.00 PM that I can reference to make a...

I have StartDate and EndDate fileds where I enter the date and time the employee starts and finishes his shift (in dddd dd mmmm yyyy hh:nn AM/PM format). However there is a penalty issue that starts at 7.00 PM. How do I set up a non changing reference for 7.00 PM that I can reference to make a...

I have StartDate and EndDate fileds where I enter the date and time the employee starts and finishes his shift (in dddd dd mmmm yyyy hh:nn AM/PM format). However there is a penalty issue that starts at 7.00 PM. How do I set up a non changing reference for 7.00 PM that I can reference to make a...

I'm a novice needing to convert a short time value to a decimal so that a calculation of Time X Rate of Pay can be made. I've tried the following Microsoft code after resetting the format to short time but I still get a short time result. Public Function timetodec(Time1) timetodec = CDbl(Time1)...

I have created a database using access 97 which is used to register players tee off times at my golf club. A tee off time report is then created and emailed out of access to the pro shop. My problem is that sometimes the opertator inadvertantly enters 5 names instead of 4 for a tee off time...