Search results

Hello, Database now added later in message I have converted from 97 to 2003, amd the following code fails at the place where I have placed bold comments. It ran well in 97 so I can't understand why there is a mismatch. Hopefully brains greater than mine can see the error. So that will be most...

I have converted a 97 db to 2003. The code below fails where I have commented with 3 ??? in front are the relevent bits. I have changed bits of code as annotated. I wonder if someone can help, I am happy to Send full db if required via Email it is making me MAD Thanks in anticipation Robbie...

On a network using Access 2003 (the users have runtime) I have linked Excel spreadsheets, these are set up for shared working. Yet when the db is opened by 2 users the 2nd one can't open the form that is linking to the spreadsheet, it is saying that the .xls is the problem. If the spreadsheet...

I am working on a new system. Have been given Full MS Access but Link Table Manager fails it gives a standard security warning that this new system enforces it says Opening: C\Prog..Files\MSOffice\Office11\ACWZTOOL.MDE however on selecting OPEN nothing happens. If Cancel is hit then long...

I have to create a db that will log the sales of items. The whole prcess of selection must not be written to the db until the payment has been received. So it is really how to select the items display the total for goods etc, with the final click to confirm the sale. Maybe someone has a...

This is easy and I think I have forgotten how I want to return a Pass or Fail on a number being between 2 values ie ResidualChlorineFreeAns: IIf([tblWater]![ResidualChlorineFree]>1 &<5,"Pass","Fail") Of course it is not working Thanks in advance

Using XP OS and Access 97 Date() - DOB = Age this is correct however on a NT OS any DOB within 2 weeks of today's day and month ie 10/05/59 shows the age 1 year younger. ie 44 where as the XP platform shows 45. The NT in Regional setting has the Gregorian Calender but this cannot be changed...