Search results for query: *

Having difficulty with a query by form project. I have a query which looks at multiple criteria entered into a form's text boxes to create a pick list. Sample query selection criteria is Like [Forms]![TASK QBF]![TVantive] & "*". For some reason I'm not looking at all the records...

Bakeman: I'm trying to get your solution to work, however, I'm getting run time error 2580 That Microsoft Access cannot find Table or Query... Looking at the record source propery in the report it appears that the part of the query to the right of the = is >>> '. <<<. I may have the syntax...

I would like to use an option group to run a query to create a report for a selected individual. I created the option group OK, but all its doing is generating a numeric value depending on the person selected. I need to get the persons name using this value and stuff it into a query to produce...

I have a site profile table with many columns. For data entry I will require 3-4 forms to be able to enter all of the data, with each page displaying the key. I want to have a button on each page to proceeed to the next. This is not a 1 to many situation. What code do I put in the key field...

I want to update various columns in a single table with developers names as the item represented by the row moves through various stages of development. I'm using a combo box dropdown, on a form, to select the individuals name assigned to that phase. I want to use the same name lookup table...

Attempting to use the following code to populate some SQL with the contents of a Textbox. Any tips as to what is wrong wrong would be apprecaited. Set rst = dbs.OpenRecordset(&quot;Select * FROM Contact &quot; _ &amp; &quot;WHERE Contact.Name = &quot; &amp; Me!txtName) I've tried using...

I have used this syntax to obtain receords if the search string is contained in any part of the field Mod: Like &quot;*&quot; & [Mod?] & &quot;*&quot;

I would like to... 1) Enter some criteria in a form. 2) Click on a command button to popup a list of records meeting my criteria 3) Have a message box ask if I want to change the records selected to some value I've entered on the form in an unbound textbox. 4) Update the records or not as...

I would like to... 1) Enter some criteria in a form. 2) Click on a command button to popup a list of records meeting my criteria 3) Have a message box ask if I want to change the records selected to some value I've entered on the form in an unbound textbox. 4) Update the records or not as...

Putting the hidden field on the form sounded great but I'm still having difficulties. To which event should I attach the code AND what would the syntax look like. Thanks.

I would like to put a timestamp (Date/time) into a table column when the record is updated. Putting =Now() for the default value in table design works great to obtain the date a record was added. I've tried all sorts of stuff with forms to accomplish this, but it won't fly. Any ideas.