I am trying to implement a form that will allow a user to search for records that are about to expire (VIA a date field marked "expiration date") through a form that allows them to enter the number of days from the current date to check for records about to expire. For instance, if the user...
I have a set of three text boxes and a combo box. The functionality I need is:
if the combo box is set to a specific value (I.E. "Approved")
Then the form must create next to the set of boxes, another set just like it, which then in turn, must have the same functionality as the last set. So I'm...
I have a form set up that I am attempting to get to act as a menu for several other forms (A data entry form, a data selction form etc...) I have set up command buttons to open each. However when I click them I get this error message:
"The expression On Click you entered as the event property...
I have a form that displays results from a different "search" form. in this form, I would like to have a number for how many results were returned, any ideas?
I have a search form set up with multiple text boxes and a search button, which pulls up another form to display the results. I do this by building a "where" statement and sending it as a parameter to the next form. In order to do this, for each portion of the "where" statement I build I have to...
Ok, I'm trying to work around the whole query thing by using the "where" parameter for docmd.openform
I have a bunch of fields on the criteria form, and in this block I am attempting specify which records to bring up in an already created form, and it seems to work, kinda. It doesn't throw any...
I would like to create a query that allows the ability to search for some number of different parameters of data (Through User Input) but without spamming the user with parameter requests. Is there anyway to design a query so that a user can perhaps choose what criteria to search by?
Ok, How do I get a subform to refresh it's contents? I know its called requery, but how does that work? and is there a way to do it continually, or every so often?
I have an append query that is meant to copy a certain record from one table, and put it on the end of another table, but for some reason it refuses to copy from table to table unless the destination table already has a record with a related field in it. And then if I get it to run, and run the...
Alright, definetly making some progress now, but I'm having troubel tweaking the append query to work the way I want it to. For instance, it won't copy from the source table to the destination table unless there is already a record with the same billet number (the two table's related field) in...
I've got a form that allows you to select a record out of a combo box. from there, I have a button to launch a new form that will pull data from a different table using the record from that combo box as the relation. What I want to do, is then, when the new form loads up, take the record from...
Ok, I've got a command button on a form that opens up a new form populated by data thats related to a control in the old form. It was work a moment ago, and now I'm getting an error that says "Syntax error (missing operator) in query expression "[Billet Number]=" heres my code for the button...
It might be.
I'm trying to set it up thus:
combo box that has a table as it's source: already done
list-box/subform that takes key value from combo box and uses it to populate list-box/subform: not done
Get my problem? I don't know how to tell the list-box, or whatever, what to use as a...
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.