Search results for query: *

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

Hi guys, Is it possible to log all users who open a spreadsheet and what time they opened it? Thankyou all who look at this.. Regards Alex “It is a mistake to think you can solve any major problems just with potatoes.” Douglas Adams

Ok i have one cell which is a regular number and one cell which is time format 00:00:00. Ok this is hurting my head! I need to divide my number by the time so if the number is calls it tells you how many calls are taken each hour. Please help guys! Regards all Alex “It is a mistake to think...

I am using =CONCATENATE("00:0",L4,":",N4) to have a field show the time in 00:00:00 but when the secons from N4 is only 1 digit it will show 13:30:7 instead of 13:30:07. Any ideas to get this to show correctly? Kindest regards to everyone. “It is a mistake to think you can solve any major...

when opening windows nt explorer the right hand pane has dissapeared .. after investigating we have found that it had moved all the way to the right hand side and we had to dragg the windows explorer screen all the way to the right hand side to find the right hand pane .. this happens quite...

is it possible to have a form with a list box which shows all users logged onto the database? Regards Alex “It is a mistake to think you can solve any major problems just with potatoes.” Douglas Adams