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

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

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

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

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

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

Hi All, I have a query which searches post codes to bring up and account. i want to have the results displayed in a list box on a form. how do i do this when the user has to input infomation into the query? Regards ALex “It is a mistake to think you can solve any major problems just with...

Hi All, I have a query which searches post codes to bring up and account. i want to have the results displayed in a list box on a form. how do i do this when the user has to input ifomation into the query? Regards ALex “It is a mistake to think you can solve any major problems just with...

Is it possible when a form opens a text box is filled randomly from a set of 10 value in a table? Hope that makes sense? Regards Alex “It is a mistake to think you can solve any major problems just with potatoes.” Douglas Adams

I have a dbase which logs sales in a call centre. on team enters the sales while another team verifies them. I need to be able to have a facility where by you can enter the sales id into a form and it brings up all the details of that sale. my sales id is the primary key. Thanks in advance...

Sorry about the vague Subject but describing my problem confused me. I have a form which is used to enter data on calls recieved in a small call centre. I have a combo box which source is a table with sales persons details.the field is thier sales id. i have a text box also on this form which i...

I know how tho copy a value from one text box to another on the same form but how do you do it from one form to another? Regards Alex