Continuous Form with command buttons
I am having trouble creating these buttons the way I have described. I should be okay once I get the buttons captioned correctly.
Thank you for taking the time to report an issue.
What's wrong... Please write below.
I'm not sure why, but the command button is only enable on the first row of the continuous form and disabled on all other rows. I have another application that functions the same way and there are no issues with it, yet I cannot find any differences in the command buttons. In fact, I copied it from one form to the other.
Is this a common issue? How do I fix it?
This works great, however I need to put some control on the button so entries are not duplicated on multiple button presses.
Here is what I have tried so far:
I have the INVOICE_ENTRY command in the continuous for run the query and disable using this code:
Private Sub INVOICE_ENTRY_Click()
Me.INVOICE_ENTRY.Enabled = False
This works, but since a continuous form it disables all the buttons. can't have that.
I then tried adding another step by having the INVOICE_ENTRY command open an unbound single form, setting default values to the original INVOICE_APPROVER form, and placing a ADD_ENTRY button in the Footer.
I used the same code as above adapted for this new form. This works as well, however when I close the form and click the INVOICE_ENTRY command on the continuous for the ADD_ENTRY command is no longer disabled.
and I know this is a lot of work for something that could just be bound to the original invoice table, however doing it this way is somewhat necessary.
I also have a combobox on my form with the six values inside it being (notice the spaces):
3. Form Left Blank
4. Defaced Form
5. Ilegible Form
6. No Signature
What I require is that when the value in the combo box is chosen then the approriate command button becomes visible (and all the others stay hidden). I.e. If the user chooses the 'Yes' value in the combo box then the 'Yes' command button appears. I need this for all six values in the combobox
The summary form has some combo filters and a command button that opens the second form with only the filtered records. I am using Allens Browns sample of strWhere to do this.
I also have a few sort command buttons that are using the Me.Orderby=[FieldName]
What I can not figure out is how to pass the last sort command from the summary form along with the where condition to the second form.
I originally had a continuous form with a list of client names and phone numbers. I used the alpha macro from the access sample database to filter the list by letter. I am changing that form, basically for aesthetic reasons - bringing its design in line with all of the other forms in the database. Originally I was going to have the actual list of names as a subform and use an unbound main form to contain all of the command buttons for user input. It seems, now that a better method would probably be to use one form and utilize a list box to display the names and numbers. I want to still use command buttons for each letter, but I'm at a loss for what I should use in the onclick event for each of those buttons
Is it possible to insert command buttons to open specific form or tables that have been created without clicking on the table/form itself on left hand side. If so how are the command buttons created
Im having trouble with a form, it seems really simple but I just cant work it out, ill explain a bit about my form and then what im trying to achieve:
my form contains information about a client (address, name, workorders, notes, machines)
Now the name and address appear at the top, then I have a tabbed section below for workorders, notes and machines. Workorders is a subform, notes is a textbox and machines; a command button linking to that machine.
Now the problem im having is, the command buttons are carrying over to other clients (records). However the notes are not (and of course, the subform for workorders). I have spent so long staring at the command buttons properties and other settings and cant find anything.
Is there any way to make my command buttons only appear on certain records (i need different buttons on each record). If it's not, what are my options
There are four unbound combo-boxes in the header that the user can choose from and then I have a command button coded to filter (Me.FilterOn) for those criteria.
The matching records display in the details section of the form (continuous-style).
Is there a command to reset the details section of the form to be blank? Ive tried refresh, requery, repaint, etc. All of these leave the previously queried data. Removing the filter doesnt work because that display all the records. I basically want the form to look exactly the way it did when it was first opened.