I have a form that when a new record is added works fine. However when an existing record is edited the whole program folds, (the usaul microsoft message about sending error details occurs then program shuts down.) I have tired Compact and Repair but to no avail. The form was working well until...
I have a button that when clicked on the form allows the user to type a surname and searc the database. however at present the full surname must be typed correctly. I would like for it to be able to search with only part of the surname being entered. How could I change the following code to...
I have a form with all fields enabled option set to No. The user must be allowed to click a delete button to delete a record but cannot edit or add records. Is it possible to prevent the fields from greying out in this situation. I have tried by enabling the fields and instead setting the forms...
I have tried to find the solution to this on the Internet but cannot find anything to help. I have a date field showing on a form. When a users enters a date I want another field to automatically display the day, i.e Mon, Tues etc. Is this possible?
I am struggling to get my head around error trapping. I stuck this bit of code in the Forms VBA to get error codes but get nothing returned. The form is called Prisoner_Details. Can anyone help
Public Sub Form_Error(DataErr As Integer, Resonse As Integer)
MsgBox DataErr
End Sub
I am a complete novice at VBA. I have a command button on a form, (PrisonersBySurname), that has the following code attached which opens a new form, (Prisoner_Details). would like to add code that closes the original form when the new form opens. Any ideas?
Private Sub...
Firstly is it possible to open 2 forms by clicking one button on another form. Secondly is it possible to open the 2 forms so they do not maximise and instead sit side by side to be viewed at the same time. I use a macro on the OnLoad event of the parent from to maximise it when it opens.
I have a field in a table that contains postal codes in the uk in the form ab39 9. I would like to be able to trim the space from the record so it reads ab393. The space is not always the fourth character though. Any ideas?
Well missingling over and over we hear the piece of advice “Don’t make assumptions!”
What a grossly over-simplistic piece of trite. We all make assumptions every second of every day. If we had to test every single assumption, we would be rendered hopeless. Is that really your boss, or is it an...
I have a form of clients details. Each client has a Client Number. When I open the form it is designed to open blank in all fields. However if I type in an existing Client Number the rest of his details do not automatically fill the fields. I assumed they would do. Can anyone explain why? The...
I have a Form that uses a BeforeUpdate event to offer the user the chance to undo changes before saving. The code below works however I do not wish the form to clear its contents once the user clicks yes as I would like the user to have the ability to then go onto add data into the subform...
Can someone explain to me as I seem to be the missing link. I open a form which is linked to 1 table. The primary field is named Spin. My form opens blank which suits me. However I thought if I entered the spin vlaue for an existing record the rest of the fileds would automatically fill out on...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.