Search results

I would have a combo box that shows all current client numbers (this would stop the user entering non existant client numbers) Select the Client number In the after update of the combo box or the on click of a button (I would use a button)you can run your query (don't forget to type...

If you create a query Queries from the design window then New you can select the find unmatched query wizard follow the wizards instructions and you should get what you want

Create a query that selects all the information needed for the report In the division column of the query in the criteria section type [Please Enter Your Division] now change the reports data source to be the query that you just created Now when you run the report it will prompt you for the...

Try placing an Exit Sub after Cancel = true

You could create another report with et details you require and then add this report to theoriginal report (as a sub report)

Make sure that the expression is in the report page footer

RE:RE:How to identify a charector Glad to be of help

Try rthis in your query SELECT InStr([Yourfield],",")-1 AS pos, Trim(Left([Yourfield],[pos])) AS firstname, Len([Yourfield]) AS namlen, Trim(Right([Yourfield],[namlen]-[pos]-1)) AS surname FROM yourtable;

RE:error, cant trace, how to fix it? I converted the select code to run from a query (as Below) it now works you had some fields specified incorrectly (Bb ,Ff, Hh, Jj) once they were corrected it runs ok Hope this points you in the right direction SELECT COUNT(*) AS [Counter]...

Create a query that selects the student name from your table In the criteria section of the column (relating to the student name) type forms![yourformname]![yourstudentfieldname] on your form in the after update event of the studentnamefield type Dim nodata as string nodata =...

If you login to your database (shift in)using the username and password of the one you want to change then select from the menu tools , security, user and group accounts then select the tab change log on password Enter old password then the new password twice and roberts your mothers brother

Yep it was the horse drawn version an optional extra was a pooper scooper

Try something like this Dim strStoreSQL As String strStoreSQL = ("SELECT * from PartsInventory WHERE PartsInventory.CO_PART_NO = " & [fldPartNumber].Value Set daoRst = daoDbs.OpenRecordset(strStoreSQL)

If you have a table that has a column that contains the values that you need to appear in a combo box then create a query that selects the column with the required data create a combo box with the wizard and specify the query you have just created as the source

replace the code you have attached (in the jpg) to =Dlookup("[Title]","[qryturnearntitle]")

Go to the properties of the form and on the other tab set modal to yes

If the variable is a field on the form right click on the field select properties, set format to fixed and decimal places to 1

The variable that you are using to hold the final calculation in its properties you can set the number of decimal places

You have to set up user security on your database Tools , security, user level security wizard when wizards first form appears click next then next then make sure all boxes are selected then click next select Full and new data users click next then click next enter a username and password,add...

I would dim your variables as double The Text110 field open its properties and on the format tab you can set the number of decimal places also set format to fixed