Recent content by ohio

Nice to hear from you, I think the better way is when the user open a new form to create new log, the alert will popped up to tell him those > 7 days outstanding logs. Something as your 1st suggestion. Any clues? Really appreciate your guidance. Thanks!

Anyone know how to write a code in order to alert those outstanding call logs after 7 days. My form has Status field and Date Logged field, how to link up in order to alert such way. I think can use DateAdd or DateDiff but i am new to VB code, hence will need some expertise.

I have designed a helpdesk log program using Access and shared by couples of users. THe problem is users always forgot to keep track the status of the problem. Currently there are 3 status : Outstanding,Monitoring and Completed. I am thinking how to activate an alert message for users in order...

Hello, I have some fields which the "required" property is set to "YES". This means that the users got to fill up these fields before they close the form. I also add in a Close button into this form. The problem is this Close button won't respond to those "required" field upon closing the form...

Presently i don't have any duplicate refrence, the problematic one is missing number. How can i install lock conflict procedure, could you pls elaborate more. Where can i set the time between new creation Auto Number & save record? Sorry, i am a bit lost!

Hi, I have developed a call log program which almost completing but now I have one more headache. This program is shared among some users in the network. I have one field for call log reference no. which is Auto Number generated. I realise that the call log no. will go haywire if some users...

I only have one table connect to this form. I didn't use subform.

I have a call log form with a log no.field with AutoNumber type. This form will be accessed by several users, i realise that if user A add a new log half way, user B open another new log and save followed by user A save his log, I only can see the record for user A. Moreover the log no. will...

I am creating a Call log program, in the call log form i have 2 fields which are date log and time log which generated from the system. How to lock the date/time in order to prevent the date/time overwrite the previous one when the particular call log form opened at second time. What i mean that...

Thanks. It is working.

I have created a combo box which the values retrieved from one of the field in my query. In the combo box, how can i make the value to one each instead of repeating. There are more than one record under the particular values(field)in my query therefore it will repeat in the list. But i want to...

It sounds simple but i still can't find the way how to add items to a combo box which created in a form. I want this combo box link to one of my query/table but i don't know how to link it.

I have created a form and table as a shared db in the network. Although i have set the users not allowed to edit the data in security right but i found that when they accidentally key something wrong in the existing form and close, then the data will automatically modified. How should I prevent...