Hello guys,
I got this tricky stuff from my boss and I am not sure I can achieve this using access 2003.
I have this request form to be filled in by user and should have button Email which will attach the form to Novell groupwise and then user just fill the user id and pre defined subject Form requested and in body "Dear Customer,
Please check the form and let us know any changes to be made. Thanks"....
vs2k8
Last Activity: Aug 26 '08, 03:06 PM
Joined: Jun 30 '08
Location:
-
Thanks for your reply and making query look better, sorry that you can't get my question,
...Code:SELECT Log_Tbl.DocType, Log_Tbl.DocGroup, Count(Nz([Log_Tbl].[PName],1)) AS TotPname, Count([EDes_Tbl.ELogType] & [EDes_Tbl.ELogName]) AS ECounts FROM Log_Tbl LEFT JOIN EDes_Tbl ON Log_Tbl.IdNum = EDes_Tbl.IdNum WHERE ((Log_Tbl.DocType Is Not Null) AND (Log_Tbl.Log_DtLeave a comment:
-
Need report help
Hello guys,
My report is based on below query:
User wants to run this report every quarterly(Q1:...Code:SELECT Log_Tbl.DocType, Log_Tbl.DocGroup, Count(Nz([Log_Tbl].[PName],1)) AS TotPname, Count([EDes_Tbl.ELogType] & [EDes_Tbl.ELogName]) AS ECounts FROM Log_Tbl LEFT JOIN EDes_Tbl ON Log_Tbl.IdNum = EDes_Tbl.IdNum GROUP BY Log_Tbl.DocType, Log_Tbl.DocGroup HAVING (((Log_Tbl.DocType) Is Not Null));
-
Network record locking
Hello guys,
I am using my application on shared network, can anyone tell me what properties I have to set that someone has opened the application is notified that this userid is using the application, and it can be opened in read mode only.(It works for Excel why it doesn't work for access 2003)
I tried in option setting ,Default record locking to Edited record and All records also but none work.So I am guessing I am... -
How to use Calendar in Access 2003
Hello guys,
I am using Access 2003 and in my form I have 3 date fields,Ord Date, Recvd Date, Due Date, user needs a calendar button so when clicked it shows calendar and when date is selected in reflects into the date field and after selection it minimizes the calendar , so any suggestion how I can achieve it and will it obey the validation rule too if selected from calendar as I have beforeupdate it checks Ord Date and Due date should be... -
Thanks a lot, it worked for me.
-visaLeave a comment:
-
How to get deleted autonumber
Hello guys,
I have this field name OrdNum which is AutoNumber, my issue is whenever I cancel or undo the record I entered I miss my OrdNum sequence, like I had OrdNum 7002, I canceled the record when I tried to enter the number it starts with 7003 instead of 7001 so now I have 7001 then 7003, how I can achieve the missed number.
My table name is OrdEnter
My Field name is OrdNum
Thanks in advance.
... -
Hi H,
Thanks for ur reply,I got it what u r saying, if Before update works at form level then it wouldn't be problem, user says we want that after entering the wrong value it should fire the trigger so I am trying to meet their requirement, can you tell me how I should convince user saying that this will work only at form level,while saving your record. I am not that expert in access so I dont know how to explain them.
One more thing...Leave a comment:
-
Thanks H. I don't know y its not working, do we have to change any properties of the field? I used ur code at form level beforeupdate, but nothing happened ,my cursor went to next field, it works only if I hit the save button, so I used the code at field level beforeupadte it works there if I hit tab it fires the trigger when criteria not matched, but issue is that it doesn't allow me to do any changes to be made in Indoc or Indoc2 or product field...Leave a comment:
-
Thanks H for ur reply, I tried ur script beforeupdate, its still not working, so I used validation rule what u suggested before, instead Ord_Rcvd_Dt < Ord_Comp_Dt AND Len(Ord_Comp_Dt )>0 , I just tweaked it to < Ord_Rcvd_Dt and is not null, it works very well.
Now I have another question if you can help I have this combo box ord status, open (default) & closed, if user changes to close it should check other combo box...Leave a comment:
-
Thanks H. for reply, I used your method but it seems Validation rule property is not working properly in access 2003, if I entered wrong date or kept null and hit the tab key it didn't fire the event, it works if i enter the date and remove the date and hit tab it says it cannot be null but it doesn't fire for wrong date.It should stop user there unless it enters right date.
Secondly I entered the code at form before update event,...Leave a comment:
-
Validating the date field using VBA code
Hello guys,
New to this forum and new to access programing, my issue is
I am comparing 2 date fields, I have to validate that Order Rcvd Dt should be less then Ord Comp date and Order Comp date cannot be null.
So I written a function to validate the field which is shown below,
If I write before update on Order_comp_date field then I get run time error message : You must save the field before you execute setfocus...
No activity results to display
Leave a comment: