I have a form based on a query for filtering, setting values, and formatting reasons. When the user double clicks the product ID field, a qty field is enabled for the user to enter a transaction qty. There is a command button on the form that updates the onhand qty in the underlying table...
I cannot get the criteria expression formatted correctly in the following query for a DLookup function. If I hard-code the value I'm searching for, it returns the following results:
Query:
SELECT qryInvenTrans1.[Product ID], qryInvenTrans1.[Product Name], qryInvenTrans1.Onhand...
Excel 2000 - When I type a list of values in the Source box, the validation works fine. When I name a range of cells on another worksheet in the same workbook using the Insert/Name/Define function and then enter =ValName in the Source box of the Data Validation box, it does not seem to validate...
I want to automate the execution of append queries that update data in an Access database from external file sources (either ODBC sources or a network flat file source). I'm not very familiar with writing scripts, but would like some way to schedule Access tasks to execute automatically.
I'm running Access 97. The underlying query executes OK when it is run as a standalone query. The form was working OK until I started adding/modifying code tied to the form's event properties. I have now commented the code or removed the event code but the form still does not display any...
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.