Search results

Thanks RG, Thank you once again for your help I have yet to test it completely but it's looking good. I am down with the Flu bug at present but you are as good as 5 Lemsips :D Regards Robin

You can use a Macro and call that from code Creaye new macro TransferSpreadsheet as Action Then at the bottom table id table to import in to

Thanks, I have zipped it and also added the link tables. The opening of frmMaimMenu gives the error. It is a db that when it works allocates duties to a list of people. At present there are only 2 people populated. I'm on day 3 of banging my head against the wall so any help will be GREATLY...

RuralGuy, thanks for taking the time to reply. I have tried that for 2 days now playing around. Would you be interested in seeing the db?? Regards Robin

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 some code I can send you with everything you need if you want. Give me an Email address

Thank you that has cured almost all the errors, I am now working on the others and will return here if I fail. I made your suggested changes throughout all the code. Thanks again Robbie

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...

Thanks Thank you to both of you. As a matter of interest I looked at the forum this morning with a memeber of our site support team and you both backed up what I was saying. I have even been requested to send a screen dump to them. Lets hope I win the battle, 2.5 days and counting since the...

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...

Thanks Thanks Pat, See I knew it was easy the same as I know how I am not so good. :)

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...