Search results

Try the DatePart function to extract the month,day,year then concatenate them into a string.

You could update any field in any table in your database via an action query (specifically an update query). You usually create one of these action queries via the query design grid. Another way is by a Docmd.RunSql statement where you specify in your vb script the required sql statement to...

Try this: =Val([Expr1])+Val([Expr2]) ..... etc. Should work.

It appears that you are placing your total in the page footer. Try putting you textbox with the formula in it in the report footer; it should work there.

Your project definitely can be handled by Access. To be able to complete it successfully, you'll have to have some understanding of VBA in order to program for example, the events that will take place when a user selects one of your option buttons or check boxes. You'll need to read up on...

Graphics will definitely disappear when you export a report to Word. You could try editing the report in Word and insert the graphics in the specific spot that you want.

Your problem sounds interesting. If you email me a short version of your db, I would like to look into your problem.

You can extract portions of a string using the "left" and "right" function. For explanation and example of these two functions, look in the Help section of your Access menu bar.

One way to do this is to create a table where you have two fields populated with values as follows: -------- F1 F2 Record1 Yes -1 Record2 No 0 Use this table as the record source of your combobox. Field1(F1) should be the visible...

If you select "Yes" in "Auto Expand" of the combo box, it should take you to the section where it matches the first character typed in. Your position in the combo box will change as you type more characters as it will try match the characters typed in.

In a nut shell, this is what you need to do: Create a new form. Choose a record source for your new form Insert a "Tab Control" on the form. Create text boxes on the tab control Choose control source for each text box. This should point you in the right direction and a good start. Let me know...

You mentioned that you have built a table called "TblReceipts". I presume that you have at least two fields in this table as: - PolicyID - Amount I am sure that you are aware that you need a form so the user can enter data into your receipts table. One possible way is to update your balance...

Try putting this code in the after update of your combo box. It should close the current report on the screen without any further action on your part. After that, clicking your "Go" button should bring up the new report. DoCmd.Close acReport, "YourReportName"

I take it that "E" means executed. If so, then your query will only select those that have been executed and nothing else. If you want to show everything including the ones that have not been executed, then you have to take out your condition in the WHERE clause.

If your combo box has two columns (Name and ID), usually ID comes first before the name. In this case, you would refer to your ID as Me.Combo.Column(0) and to the Name as Me.Combo.Column(1). Combo field columns start with a base of "0", not "1". Not sure if this is your problem, but without...

Check what column you have bound in your combo box. Usually, the first column (primary key), by default gets bound when you create a combo box. Try binding the column that contains the data you want.

Set the "Limit To List" property of your combo box to "No". This will allow you to type in the box anything you want including something not in the record source of the combo box. The value that you entered in the combo box can then become the "criteria" of the query you want to run which in...

Try the IsNull function.

AND ((IsBetween([startDate],[endDate],[tblBooksAndContracts].[tblSystems].[dtmSystemWorkComplete],[dtmMailIDCards],[tblGroupInformation].[dtmDateMembershipReceived]))=Yes)); It appears to be coming from the above. See your WHERE clause.

Try defining the recordsource of your subform using Dmax, e.g.: Me.RecordSource = "SELECT * FROM tableName WHERE PrimaryID = DMax("[PrimaryID]","tableName")". In theory this should only display only the last entry in your table which has the highest value in the PrimaryID field. You may have...