Recent content by ahvc

Hello All, One big database in our office just crashed a week ago. This is the message we get "The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time." There are only 2 users, with one with limited access. I...

Hello all, I hope this is a right place to ask this: I have a small application. I was asked if I can just make sure i can restrict the # of records in a few tables. For example, just max of 5 records in the member table. If the user tries to add the 6th member, it should say, 'Sorry this...

Thanks, Pat. Regarding the Like operation for program, it is a drop down list. like has been working good. Is there anything I am overlooking by not using '='. Thanks. I am still struggling to apply your suggestion. I am going all around but not getting there. The example I gave was more...

Hello Access friends, I have a query named qryMemberfilter like this: SELECT Name FROM members where Member_ID In ([Forms]![frmMemberfilter]![member_id_list]) and program like ([Forms]![frmMemberfilter]![program]); In a form called frmMemberfilter, upon an event completion, member_id_list...

zoom works Thank you. I tried DoCmd.Maximize DoCmd.RunCommand acCmdZoom100 and it worked. For some reason, DoCmd.RunCommand acCmdZoom100 did not work by itself. Thanks again. AHVC

2 queries worked Jon Thanks very much for the idea.. I have never used it like this before(using one query in another query).. THanks for showing it to me.. you saved lot of time for me.. Good day. Regards AHVC

Dear Access friends, Can you please tell me how I can make sure all my reports open in the same window size. I hope it is possible. that will help it look more professional, instead of all windows not being the same, and always having to be expanded to full size. Right now I open the reports...

Hello Access friends, Can you please help me with a query which I have tried to make work for more than a month, but in vain. Query 1: It works, but logic is wrong. SELECT ... FROM Profile, (tblClient INNER JOIN tblAuthorization ON tblClient.Member_ID = tblAuthorization.Member_ID) INNER JOIN...

Hello, I used this query alone and it worked: INSERT INTO MLog (member_id,service,month_year,units_qty) values("78","Quilt","01/2005",0) I would like to use this within a procedure, something like this: If condition then insert record endif But Access does not seem to encourage this. Can...

Which is avery 3x10? Thanks for that Neil, Would you know which Avery type should I use to get 3x10. Also what may be a source where I try to get the dimensions of a 3x10 Avery if I want to customize it? Thank you so much AHVC

Dear friends Is there much difference between 2000 and 2002 versions. I wanted to get a friend a 2000 copy, assuming it will be cheaper and have almost all of the features of 2002. But I have not been able to find one 2000 version in the web easy. Can you please advise the possibility of...

Dear Access friends, I am trying to create a label report for a friend who is using Avery 8160 label sheets. I used the choice of 'Label wizard' under New Reports. I chose the table, then I chose Avery J8160, 38.10 mm x 63.50 mm 3 down; Metric Measure, Sheet feed. But it produces 3x7, while the...

Dear All I am using the following date controrl in my forms: Class:MSComCtl2.DTPicker.2 OLE CLass: DTPicker Do any of you know of any short cuts to choose the date just by keyboard instead of pulling down the controrl and choosing the date by mouse-clicking. Let's say I click and choose...

Hello all, I use a delete button in a couple of forms. The basic delete code is the same in both.: DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70 DoCmd.DoMenuItem acFormBar, acEditMenu, 6, , acMenuVer70 But in one, it asks before hand, "You are about to delete 1 record(s)...

Farmat works; but no right align Rich, Thanks for that. But as Ally said, it does not do right align even though it is currency. I tried the Rset command as suggested by Ally, but it did not work in the query. (After changing it to string). Is there any way to right align em in the list...