Search results

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

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

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

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

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

Hi Folks, hope someone can help me on this one. I have a report that contains several subreports, each subreport has several fields that are totalled in a text box. I need to have a textbox on my report that shows the value from this textbox on the subreport....easy enough to do that. My problem...

Hello All, I have a table in Access 97 that is used to record the issue of books of tickets that are serial numbered with 50 tickets per book. When I ussue a new book of tickets to someone, I enter the first serial number in field firstnum, I then enter the number from the last ticket in field...