Search results for query: *

Can you you the add operator like that with dates?

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...

But Does anyone know of a resource on how to add items to a form? Function calls and such?

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?

what is "trim$" and "vbnullstring"?

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...

Thats not quite what I need. I intend to use the query as the source for a form I've already created

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?

already solved it, thanks anyway

Thanks, I suspected it was the from statement

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...

Yep, That was it. No more problem, Thanks a ton.

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...