Recent content by metalboy

Hi all, I have a query SELECT LHENDT, MQUSER, COUNT(*), ITEGNG FROM HDPULSE4DX WHERE (ITSTAT = 'N' AND ITENNG = 0 AND (LHJUCG = 'A' AND LHJVCG IN ('ED','RDH','RGJ','RGD','RGC','RHH','RIH','RKC','RLC','RMC','RNG', 'RPW','RQC','RQD','RQE','RQF','RQG','RQH','RQI','RQJ',...,'RXB') OR LHJUCG = 'D'...

I have a query: SELECT LHENDT, MQUSER, COUNT(*), ITEGNG FROM HDPULSE4DX WHERE (ITSTAT = 'N' AND ITENNG = 0 AND (LHJUCG = 'A' AND LHJVCG IN...

Hi all, Does anybody have the crystal.mdb which comes with crystal 7? i need do work through the tutorial but this is not on our system. Thanks All Metalboy “It is a mistake to think you can solve any major problems just with potatoes.” Douglas Adams

thanks all! have a star each! “It is a mistake to think you can solve any major problems just with potatoes.” Douglas Adams

i tried that and it will not work. both queries are looking at the same table... my head will not work this out for me..:o( “It is a mistake to think you can solve any major problems just with potatoes.” Douglas Adams

Hi all, I have two queries to pull data which is used in one spreadsheet and i am having trouble putting them into one query: SELECT COUNT(*), CAUSER, CADATE, CAFEE FROM CALDET WHERE (CADATE = 1041209 AND CATYPE = '2' AND CARETN = 'Y') GROUP BY CAUSER SELECT CAUSER, COUNT(*), CADATE, CAFEE...

hope you can help :o) “It is a mistake to think you can solve any major problems just with potatoes.” Douglas Adams

Hey all, Is it posible to stop a user opening a spreadsheet if another user already has it open? Thanks for any advice. Regards ALex “It is a mistake to think you can solve any major problems just with potatoes.” Douglas Adams

Hey all, Is itpossible to show with a message box who and when last updated a workbook with a message box on open? Regards Alex “It is a mistake to think you can solve any major problems just with potatoes.” Douglas Adams

Hi I am wondering you can stipulate the day's in a week similar to the Week to date from Sunday Function, Day order would be M,T,W,T,F,S,S Thanks “It is a mistake to think you can solve any major problems just with potatoes.” Douglas Adams

Thanks for that that is a great start. I needed to sect the user name because each person needs to enter different data. So once they have selected their name they will be presented with a specific form with only the data they need to input.. Regards Alex “It is a mistake to think you can...

Hi All, I am trying to create a spreadsheet which many people need to input information in each day. To make sure people input the correct information i wanted to do as follows. When opening the woorkbook it opens to the sheet which is for todays date. A form then opens which a person can...

Is there any other way at all of doing this? or could you give me a detailed version with code? Sorry i am a beginner.... Regards “It is a mistake to think you can solve any major problems just with potatoes.” Douglas Adams

Hi all, I am using a piece of vba code to log the users who use a confidential spreadsheet. The only problem being is you get the option to disable macros which stops the logging. is there any way to disable the dialog box so macros are auto enabled? Regards to all.... “It is a mistake to...

thanks for that. its my first time using VBA for excel though where would i place the code and what is the specific code? Regards “It is a mistake to think you can solve any major problems just with potatoes.” Douglas Adams