Search results

Thanks for your help. In response to your "Why" question - its because I have been told thats what the users want ;-( How do I use Bookmark to open another form at a particular record when a field is clicked?

I need some help!! I have a form which has a "search button" where users can look to see if a person is already entered on the database. The search button opens another "search form" which consists of a combo box at the top and a list of all people already on the database below. When a...

I have a form which has a combo box and a button which opens a report relevant to what is chosen from the combo box list. It all works very well if a user types the full name in the combo box or choses an item direct from the drop down list. The problem is if a user types in part of a word...

I have a check box which is ticked depending on the date in another field on the form. When a date [Post_EndDate] is entered into the field the check box [Current_Past] is ticked only if the date is in the future. The problem I am having is that I want the check box to update automatically...

I will try to keep this as simple as possible. I have a main form witch lists premises details. I have a subform which is displayed as a list of rooms on the main form. To edit or add information about rooms and users I have a command button opening an "edit subform". The mainform and both...

I got the code below working:- If MsgBox("Do you want to save this information?", vbYesNo) = vbYes Then DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70 DoCmd.Close Else DoCmd.RunCommand acCmdUndo DoCmd.Close End If End Sub The only problem I am...

I tried the code, it still saves the record whether yes or no is chosen! any further help would be greatly appreciated.

thanks I will try your code. I know Access saves automatically but I dont want it to, I want to give the user the option.

I have the following code on a close command button on a form:- MsgBox "Do you want to save this information?", vbYesNo If vbYes Then DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70 DoCmd.Close Else DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveNo...

Its not the passworded form that I am having the problem with. I want the original main form to stay maximized in the background while the user enters the password into a password form (password form opens on click of a command button on the main form.) I hope that makes sense!

I have a main form which maximises on opening. The main form has a command button which opens a password form in 'restore' size. On entering the correct password another form opens. This all works perfectly. The problem I have is that when the password entry form opens the main form...

If I try the Sum(Iif) suggestion I get an error message and strangely the other sum fields in the subform footer, which all worked perfectly, all give error messages too. They are unrelated to the 'purpose' field. It seems very strange. Is the Sum/count/dcount problem because its an option group?

The Count function just returns #Name! I tried that first before getting bogged down with DCount because it seemed such a simple thing to want to do. I basically want to count the number of 'occupied rooms' in a building. For count I entered: =Count([Option1]) Option1 is the name of the...

I have posted something similar to this before so sorry if I am repeating myself. I have an Option Group on a subform containing two options whose results are stored in the table as 1 and 2. I have a Dcount calculation in the footer of the subform counting the 1's and 2's, but I am getting...

Thanks Geoff, can I put recalcualate two fields at once, below is the code i used: Private Sub OptionGroup_AfterUpdate() Me.TotalOccupied.Requery Me.TotalUnoccupied.Requery End Sub I have put the above in the frame afterupdate as you suggested but it doesnt give the correct answers...

I have am using Dcount on a subform, which counts the "1"'s in an underlying table. The "1"'s are created by checkboxes in an option group. The code counts the "1"'s ok, but I am unsure where to put a refresh/requery/recalc command so that the user doesnt have to close form and reopen to get...

Thanks but I solved it - i was getting my punctuation mixed up!

I have an option group which gives the user the choice of whether a building is in use or not. The answers are stored in the table as 1 and 2. The subform, with the option group, has the record source as a query. I have tried to put the count calculation in the query but the subform wont then...

Thanks rich, I tried that but it didnt seem to make a difference. The checkbox is only ticked or not ticked if I select the record in the continuous form.

Thanks Rich for your comment, but I am not trying to waste anyones time, least of all my own. I have tried EVERYTHING that has been suggested in any replies and I thank everyone for their time. I got the checkbox formula to work but only in OnCurrent on the subform. But it doesnt...