Search results

Hi, Thanks for the reply, I have actually done it another way now, I gave up on this method. It did not look clean or easy. I opted for a menu with buttons for each machine, that works very well Thanks again.

Data Entry Form for Multiple Records Hi, Long time since posting on here :-) My Problem: I have a bank of 8 machines, I need the user to enter one record for each machine in order. I currently have these machines in a combo box, but any other method would be fine. When the user opens the...

I thank you all Pat, Whilst the code I used following help given to me earlier works fine, after reading your answer, I revisited the DatePart function, and yes, you are correct, all I needed was the code below. I must get a decent reference book, or read the online help more :D Private Sub...

Thanks GumbyD, I opted for your code, modified as below it works perfectly when I changed the -1 to +1 -1 was making it go to the previous week. i.e Friday 22/08/2003 is last day of week 34 your code as is made Saturday 23/08/2003 week 33 when it should be first day of week 35. Thanks to both...

I live in UK, and where I work, the week starts on a Saturday, I have a form based on a table with several fields, four of which are "Date" "Week" "Month" and "Year" When the user enters the date, the other three fields are filled automatically from the date using the following code, my problem...

Hi, Both your examples let me exit the field with a duplicate value, only when I try move to the subform does access generate a duplicate record warning (field is indexed no duplicates) Dave

I have searched for and found several examples, but none that help me. My Base table (tbl_base) has a Date/Time field (dd/mm/yyyy) named "Date" My data entry form is based on tbl_base with various subforms linked. When a user enters a new record, I need it to check if one exists for that date...

Hi Bob, thanks, I will give it a whirl. Though AncientOnes method works ok in my case. I am always willing to learn new methods, and grateful for any pointers. I am getting to grips with it slowly. Dave

Ancientone, thanks, that does the trick. Dave

Hi, and thanks, This code gives me a compile error "variable not defined" and the line StrMyMonth = highlighted Help !

I have been working on a database that has thousands of records. One field contains the Month as a text value, i.e "January" rather than the Month Number. My question is. On a Form, I need a hidden textbox that will take the value from this Month Text Field, and return the correct Month Number...

Thanks, I managed it using method below. I managed to get it by adding combo boxes on the main form, and referencing them in the default value properties of the field in the subform, and just as long as the combo boxes are changed before moving to next record, it works just fine. Dave

Thanks Jack, I managed to get it by adding combo boxes on the main form, and referencing them in the default value properties of the field in the subform, and just as long as the combo boxes are changed before moving to next record, it works just fine. Dave.

Hi Folks, Is it Possible to get a field in a subform to fill with the value of the same field in previous record......easy with Alpha Five !! and then to recognise when the value has changed. I have to do this without using linked fields to the mainform, as the data can change from record to...

Thanks Jack, the following code does exactly what I need, after tormenting my fried brain for an hour, I came up with the goods. If [frm_repel_produced_sub].[Form]![Text14] <> [frm_reduce_stocks_sub].[Form]![Text20] Then MsgBox "The Totals Do Not Match" DoCmd.CancelEvent Else DoCmd.Close ...

Hi Jack, I do not have a problem with referencing subforms, I have done that bit and it works ok, The problem I am having is with displaying the message "The Totals Do Not Match" The rest of the code works just fine. If the totals do not match, the form will not close, if they do, it does. I...

I have a form with a subform, the subform contains several fields that are summed in a textbox [Text14]. The form has a second subform that the user types amounts to reduce stocks by, these fields are summed in a textbox [Text20] If the totals in the two boxes are not the same, I need a message...

One untidy way, keep your textbox in the detail, set running total property to over all, set visible to no, then put a text box in footer =[HoursWorked]

Thanks Rich, I had got it sussed shortly after posting. Thanks. Don't suppose you could help with this one. I have a form that has a subform used for data entry, is there anyway that I can make a field on the subform default to the value of the same field in the previous record on the same...

Hi, Thanks for your help, where would I put this ? I have tried allways with it. maybe I am just a bit thick :-)