Search results

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

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

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

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

Dear friends How do i format numbers in a list, while they are calculated and not from a specfic table. For example, Iwant to show the hours, rate, and total for many jobs, where only hours and rate are part of the database. The query had to fill in the list box with the total also. My...

Hello, Can you please tell me how to create an index or PK for multiple fields in a table. I want three fields together to be unique (to avoid duplication). Thanks VC

Hello I am not too sure what is the technical difference between the functions date and now. Which one has more advantages. Thank you VC

Hello When I try to compile an access 2000 mdb file to make it into an mde file, I get this message" Microsoft Access was unable to create an MDE application. It does not give any other msg. This is the first time I am doing this. Pl help with your ideas. Thanks VC

Hello I am using a query in a list in a form. The query fields depends on some values from another form. If the data is not available in the other form, the query is returning 'NULL' value. Their data type is integer. How can format the 'NULL' value fields to a 'zero' value, in the SQL...

I am trying to disable the mouse wheel (the small wheel in between the left and right mouse buttons). this is taking me through the records, and I would like to disable this feature of navigation. I tried to find the keycode for that in the keydown event, but I was not able to discover how to...

Hello I remember in VB, we could lock the controls on a form, so that we do not move the controls by accident. This was helpful. Is there any feature like that in Access? I looked, but could not find a similar feature in Access so far. Thanks VC

Greetings. I have an issue with my first report for the application. When I open Access, Form1 pops up. Then Clicking on a button, Form2 comes up. Clicking on another button, Form3 comes up. All these 3 forms have the modal and popup properety set to 'Yes'. Then I click on another button on...

Hello All I would like to keep some shortcuts in my application for the user. But I have not been able to suceed yet. Can you please help? The form I am using this has 5 pages in one tap controrl. I would like to assign one shortcut key for each page in the tab controrl. I wrote this code , to...

Hello, I am using the Docmd command to close a form. I use this in the cancel button for the form. I hoped that the following line will do it, without saving the information. But it does save the record changes anyway. DoCmd.Close acForm, "frmDailyLog", acSaveNo I would like to avoid it...