Recent content by gocoder

I've posted the same question in a new thread as this thread is more related to LAN .#post1407388 You can leave your reply there directly. I've tried this command for the field which needs to go blank, before update event->code builder. Like you said, it shows run time error 424. Private Sub...

-There is a form which the user fills in 8 fields and saves it. Once saved, a new record opens. However, I want to modify the save button to save the previous record and display a new record with only a limited no of fields to display from previous record, say 4 fields display from previous...

Thanks for your suggestion, CJ_London!! Before I try this across LAN, there is a small constraint which i need to fix. -There is a form which the user fills in 8 fields and saves it. Once saved, a new record opens. However, I want to modify the save button to save the previous record and display...

How to let multiple users work on the same data base on LAN ?

Can some one tell me how mutliple users can work on the same database across LAN, without using share point

The following code solves my date issue based on time, 7:00 AM to 06:59(Day+1). Option Compare Database Function Calcul_Date_mi() Dim date_m As Variant Dim nn As Variant nn = Time If nn >= TimeSerial(0, 0, 0) And nn < TimeSerial(7, 0, 0) Then date_m = Date - 1 Else date_m = Date...

yes,The form is for entering one record at a time.It is a bound textbox to a field SCRAP_DATE I want the code to check the current time between 7 am today to 7 am tomorrow and display today's date. After tomorrow's 7 am, it should display tomorrow's date.

Partly..yes. This form where date appears is not datasheet form. Users don't enter date. Date has to be automatic based on time.7:00 am(d) to 7:00 am(d+1) Users enter other data like name, ID, machine etc in this form and save it. The above data is stored in a table. Using other forms, I would...

I have a form and I want the dates to be displayed based on predefined time. In this case, I want my form to show present date from present day's 7:00 AM to next day 7:00 AM.

I'm yasir. I've started working on MS access from 2 months. I am based near Banglore, india. I like reading books and traveling.