Search results

How exactly is it getting that value? Is it displayed on the current form, or a different form? Is it the very last record in the referenced table?

The default action of a form is to allow editing of the data. So, unless you've changed the 'Allow Edits' parameter, you should have no problem editing the record. If you have changed the form and disallowed edits, you can add a button that will allow edits. Here's how: 1. Add a button to the...

If you multiply the blank value (which Access stores as 'Null') by the quantity, you get...a null value. This is helpful. Use the 'Nz' function to change the Null value to whatever you want. Usage: Nz([fieldname],"<replacement>") Eg: =Nz(([price]*[qty]),"FOC") Note: <replacement> is...

1. Create the field in the table. 2. Add the field to your form. 3. Convert the field to a 'combo box'. This should bring up the wizard. Cancel it. 4. Set the source of the combobox to Table/Query, and put your SQL in the source box. Though you might get more mileage from using 'SELECT...

SELECT [TAG] & ", " & [Equipment] AS fieldname FROM tablename;

I'm assuming you're getting the values out of a table via a query. In the source query, 'create' your own field with the following: Fieldname: [TAG] & ", " & [Equipment]

Check out the attached database search form. If you look at the source of the comboboxes, you can see that it uses a 'UNION SELECT' to add the 'all' option to the list. You could certainly do a similar thing here.

I'm curious as to why you're even referencing the activeform? Any code you put in the 'OnOpen' event of FormB will run against FormB only.

Normally, you would use the WhereCondition variant of the OpenForm method. Create a new button on your form, and use the wizard to open a form to show specific data. Examine that code and apply it to your listbox. The trouble you will run into is that you can't access the same record from two...

Combine an 'If' statement with a Message Box: Dim strmsg strmsg = "Are you sure you want to add " & username & " to the table?" If MsgBox(strmsg, vbYesNo) = vbYes Then <insert code here> End If

Does the same form access the same information multiple times? IE, is there a subform on the main form that uses info from the same table as the main form?

Filtering shouldn't have any effect on being able to update a record. Either you've accidentally disabled edits on the form, or the source query is configured in such a way that it can't allow for updates.

does the combobox get its info from a table?

I was wrong about that. Set the Control Source of the textbox to =Count(*)

Is the checkbox meant as a, "this department does not exist, so add it" sort of thing? You could do it via code and recordsets. Private Sub Form_BeforeUpdate(Cancel As Integer) Dim db, recordset1 Set db = CurrentDb() Set recordset1 = db.OpenRecordset("depttable") With recordset1 .AddNew...

As an alternative, you could use a proper Reporting tool with crosstab functionality (such as Crystal Reports) to directly access the backend of the Chorus database and create the graphs. Depending on what Chorus uses as a backend, of course.

The total number of records is displayed on the bottom of the form next to the record selectors. Alternatively, you can create a text control, and use VBA code to update it to the record count using the Count funtion: Private Sub Form_Open(Cancel As Integer) Text11 = Count End Sub Oops...

All I can suggest is that you have the spreadsheet filter by month so you end up with agent, month, and amount, and that's it (with the month in the recognized 'date' format). If you do the starting ground work, adding the following months won't be as difficult. Assuming you don't change...

If you can only access the second form from the first form, set the form source query to select only the Site Name of the first form, ie, =Forms!firstform!SiteName

You can set the default value of the PlanID on the subform to the value on the first form. To make sure users can't mess it up, make the second form Modal (on the 'other' tab of the form properties, set Modal to 'Yes'). You can set the second form to only show the records from the first form's...