Search results

I have a form with 8 pages. I'd like to set it so I can tab tru all the field on the first pages and than to the first field of the second page and so on. I tried to set the cycle in the properties to current pages and current record, but it only tabs through the field of the page that is visible.

I would appreciate suggestions in handling the following. My db allows the user to enter charges for specific services. The charges for these services change periodically (usually annually). So I have to be able to change the charges when appropriate (e.g. January 1), but the charges for the...

In a table (tblProcedures) bound to form (frmProcedures) I have a field called Archive (Yes / No property). The form shows a list of procedures. Clicking on a procedure shows it’s specifics in a couple of textboxes. I would like to set a command button that when clicked would set the property...

I would like to stay away from using the ActiveX Calendar control in my applications. Does anyone have a calendar form that can be opened with a button on the main form and than populates a texbox on the main form after clicking on a date on the calendar form. I did found a sample somwhere but...

I found this post at another site and kinda am intrigued myself. Does anyone have a suggestion or a resource to go to ? "I donot have the Microsoft Access 2000 developers addition, however, in the "Microsoft Office 2000 Visual Basic Programmers Guide" Page 41 reads, :If you have Microsoft...

I found this post at another site and kinda am intrigued myself. Does anyone have a suggestion or a resource to go to ? "I donot have the Microsoft Access 2000 developers addition, however, in the "Microsoft Office 2000 Visual Basic Programmers Guide" Page 41 reads, :If you have Microsoft...

I have a delete button on a form 9developed with the wizard) to delete a record. I have put in a message with the code showing like this Private Sub Command74_Click() On Error GoTo Err_Command74_Click If MsgBox("Delete record?", vbYesNo, "Delete") = vbNo Then Else...

Need help with the code on the on click event of a command button on formA to stop formB from opening if the listbox on formB is empty

Rich just posted a solution for related to an incorrect entry of a date. It works when using the tab key to get out of the box. I need to go a step further yet and set a code that the same message shows up when any other action is taken (e.g. close the form or click on another object)

I’m trying to set a code to an event procedure of a textbox (Date/Time) that will alert the user when the date entered is greater than today and return the focus to the textbox for correction. Here’s what I used. It pops up the message box, but does not set the focus back to the textbox. Here’s...

I have a form that has a list box and several textboxes. Clicking on a person will display his/her info in the textboxes. When I open the form though it displays the info of the first record. I like it to open with a new record. If I set the DataEntry property to Yes, it won't allow me to click...

I am using the following code to set a label to invisible if the textbox is empty. It works great for each textbox / label on the report, but the problem is that I have to set it for each one. If Me.Textbox = “ “ or IsNull (Me.Textbox) Then Me.Label.Visible = False Else Me.Label.Visible = True...

I usually do not post the same problem at multiple sites, but I am desperate for help. I am looking for the code that will set all labels in the section of one report to not visible when the corresponding fields are empty. The report is bound to a query populated by a form. Each form receives...

I have a report with multiple fields (textboxes and corresponding labels). They are all lined up horizontally one under the other. The form is bound to a table populated through a form. Not all fields will be populated on that form for each record. I would like to set a procedure on the OnOpen...