Search results

Thanks for the reply. What I am wanting to do is enter (daily) employee overtime to a table called "Overtime". This consists of three fields - 'Date' which is a date/time field, 'Initials' which is a text field and 'Overtime' which is a number field. We have a large number of employees and...

Hi All I am having diffuculty entering or changing data in a subform I have created. I have basically 2 tables. One called "Date" and one called "Overtime". I have joined these as a 'one to many relationship' and set a primary key to my date table on a field called date so that no duplicates...

Thanks Mile-O-Phile Its worked a treat.

Colin I have another query now!! I used your module in my database form and changed the name of the form and field so that it would work with a form I have produced, which it does. I applied this to a field called Date From so now in my module's details it reads ctl =...

Hi Colin Thanks for your reply. After changing the name of the fields it works a treat and was just what I was looking for. Cheers.

Hi All I have created a database to log all employee absence and overtime details throughout the year. At present I have various forms reading from tables which contain date fields. I have inserted a calendar through Active X Control. Is it possible so that once I select a date from the...

Will Do Thanks

IMO Your bloody good at this! - It's worked a treat Cheers.

Hi All I have created a form from a table comprising of numerous list box's. Three of these list box's are set to "not required" in the table's properties. However, I am having difficulty de-selecting the item once I have chosen one of these items from the list box in the form even though the...

Thanks IMO Problem solved - That's twice today you've helped me out. Cheers.

How do I change it to a text box when it automatically recognizes this as a list box from the table/query? I can't find anywhere in its properties to do this.

Hi All I have designed a report from a query which comprises of various fields whish are list box fields. When I preview the report the list box fields are constantly highlighted in black - (which is due to that item being selected). Also unless you shrink the height of this field in the...

Thanks It's worked a treat. The amount of times I have used the control source, I have never noticed the build button towards the left. Cheers.

Yes, the record Entry field which is the primary key is Autonumber. Does that matter?

IMO Thanks for replying so soon, however unfortunately nothing happens. My control name is List8 which is my name of my list box in my form which shows all records. Therefore my control box now reads: - Private Sub Form_Open(Cancel As Integer) Me.List8.SetFocus DoCmd.GoToRecord , , acLast...

Hi All I have created a form from a table called Record Selection which is basically a list box showing various record information. I have set the primary key on record entry. Upon selection of a record in the list box it opens that record in full from another form based on a query. When the...

Hi Rob Thanks it's worked a treat.

Hi I have created a database which we are using as a telephone log. I have then created a form called "Telephone Log Amend - Select" which shows a list box comprising of 4 colums drawing the information from the main table - Call no which is the primary key, Date, Time & Caller. I have...