Search results for query: *

Hi there, I use the AFTER UPDATE event to all important fields that got updated and which when updates will subsequently update the STSdate ( short for Status changed date). This is how i did it. Lets say I have two fields in a table called PAt and there is a Main form called FORM PAT and a...

Hi there, Yes I can add another table to the database. I will follwo your instructions and let u know how it went. thks for the input. The table I have is called Pat There are fields within that table for registration date; dishcarge date etc. Every month we have to report on each field.. I...

Hi there, I have a problem displaying zeroes if there are no orders in a specific month. Lets say for this year for example this is the scenario, Jan- 10 orders feb - 20 orders March - Zero orders April - 10 orders May - Zero orders My crosstab shows the numbers as in running...

Hi Golom, Thks for the Tip. For other users who have encountered this problem, all you have to do is find SETVALue and if yours has =0 then remove the = 0 and then the error message does not come. that is all there is to it.. it took me a while to figure it out and once i removed the = 0 (...

Hi there, I am not sure if any of you have encountered a message that comes up when a user presses a particular option button with "The object doesn't automation object "recordSetclone" . if I press OKay it still filters and shows me what the user needs to see but they have to go through this...

Hi there, I wld appreciate any help in this. I have 4 areas that use an access database each one in a separate folder on our server. These Db need to be kept separate. So far, every month I import the major tables to create a regional one and then use the Regional one for reporting to...

Hi there, I managed to get the lat month working with PHV's help. and many thanks for the same. Is there a function that can be used similar to what PHV gave that will show all activities for this mth. the SQL i have now is as per shown to me ; SELECT WorkLoadTypeDesc, ResourceDesc, tdyr...

Hi PH, The query worked and showed me only the records that were supposed to be seen. this query is the forerunner for another crosstabe query. Is there some way ican allow the user to just enter 1 to 12 for the mths they want to see. in this case the first query for which you helped me can i...

Hi PH, Thank you ever so much. It worked. Thks for the prompt response and glad there are such helpful people around. thks Again Usha

Hi PHV, Here is the sql view of that query: SELECT PATACTIVITY.WorkLoadTypeDesc, PATACTIVITY.ResourceDesc, PATACTIVITY.WorkLoadTypeDesc, PATACTIVITY.tdyr, PATACTIVITY.tdy, PATACTIVITY.ActivityDateTime, PATACTIVITY.TEAMS FROM PATACTIVITY WHERE (((PATACTIVITY.WorkLoadTypeDesc) Not Like "Others")...

This will not work as it gives me an error. my date is in this 01-Mar-2008. I Put the =(date()-31) in the criteria field. Pls let me know what can go into the criteria field comfortably ? :-) Usha

Thks for the fast response. What i am looking for is when the supervisors run their team stats, lets say they run it on the 1st of every mth, and today's date is 01-apr-2008 or 4-apr-2008, they want to see all stats for the mth of March ONLY. that meeans at any given point in time they want to...

Hi there, I have tried all of the above help material and nothing seems to work. What i am looking for is this. I have stats that need to be extracted without me having to manually change the between periods.. for an activity date. The help I am looking for is that that of the 200,000 records...

Thanks for your prompt response. I tried it and it works for some and for some it did not.. atleast i dont have to go through couple of thousands to see if it worked.. Your help is muc appreciated and thanks for the same Usha

I am sorry at sounding repetitive.I cannot see the question i posted so i am posting. Could you please help me on how separate a fullname into 2 fields. Let say the full name was TOM Jones. And it is in a name called FULLNAME I want to separate that name into tow fields namely lastname and...

Hello all you helpful gals/guys, Thks for all your input. I got it working. What i did was this as suggested 1. built my union query with the tables from the 4 sites. Sabed it. Ran it to check all records were picked up. 2. Next used the saved Union query as source and appended it to a blank...

Hi there, I tried everything on earth and still wont work. I reduced the number of fiels just for test purposes. if 5 fields can be successfully inserted then all can was what i was going with . I created identical tables with the 5 fields and then tried this code: INSERT INTO EMPTYPAT...

Hi Leslie, Thks for ur message. I had a doc's appt and had to rush. I will try this first thing in the morning and let u know how it went. Thx again Usha

Hi, Wow u are super fast.. I am still having probs.. it says there is problem with the Insert Into .. Syntax errorin Insert into statement thx Usha

Hi, thks for ur input. I tried it exactly like u said.. Some of the tables may or may not have all the flds. I am going to update all of the f4 sites with similar structure which makes coding so much easier. But for now, i am just trying to see if it will work.. Without the Insert it shows me...