Search results

Include tblInstallSummary and it's fields in the SELECT and FROM parts of the query.

There is no closing parenthesis ")" in your code. If it is a typo in code it's a critical issue. I thought the dot and the bang are used for 2 specific purposes: dot "." is used for objects/statements that come with Access eg. Me!FieldName.SetFocus bang "!" is used with objects you created...

You need to specify the field name in your form. eg: Me!FieldName or Forms!FormName!FieldName so try: =IIf(Me!DaNumber=1,(Me!DaTarget-Me!DaActual1)) BTW I just noticed: DaTar get with a space in it. Is this a typo? Dave

sorry, that's only for negative numbers (-1). It actually sums the numbers.

if you need to count the number of yes (-1) and nos (0), use the abs function. Dave

Just to clarify: Constants (vbQuestion, etc) are relatively new to VBA (last 5 years?). Before that you had to use values (eg. 16, 32, etc). These constants are now specified by VBA. As a result, the names can be used anywhere in your code in place of the actual values. Dave (the old timer)

have a look at the MsgBox Function in Access help. You will require constants such as 16, 32, 48 or 64 to obtain critical, information, etc icons on the message Dave

search help for 'delete queries', create a query then use: docmd.runcmd.openquery "queryname" Dave

how do you know it works well if you cannot see data in the 2nd cbo?

create 3 append queries, one for each table then use Select Case to append the data according to the number you choose. Dave

file extension and hyperlinks g'day, I would use a select case to do that: eg. select case Me!FieldName case "doc" your code finishing with .doc case "jpeg" your code finishing with .jpeg etc Dave

g' day, I want to find a record in form B based on a value selected from a combo box in form A. I have cboSearchInd in frmCompany (which consist of a number of tab controls) based on qryContactNames which include fields ContactFirstName, ContactLastName, CompanyID and ContactID. The cbo...

G'day all, I have a form consisting of 3 tab forms (frmCompany which is the main form, frmContact, and frmSubmissions) based on tblCompany, tblContact and tblSubmissions. Major fields are indexed as follows: tblCompany tblContacts tblSubmissions CompanyID (no dupes)...

thank you both Dave

g'day, I put a button on a form to add records but, before doing so, I want to check if a record with the same id numbers is already in the table. To do so I use the following code: If (DLookup("[CompanyID]", "tblBranchAddress", "CompanyID = " & Me![CompanyID] And _...

Which field was used thanks for both replies, will check them out later. Dave

G'day, I have an unbound form that I want to use for adding records to one of a number of different tables according to the user needs. I do this by hiding/displaying different fields for different data (eg. Type of activity, Contact name). The Save button would have code that saves the data to...

I beg you pardon Paul, your code does work. I mispelled the next check box name. thanks Dave

yes I did Paul, it wouldn't work with the first checkbox otherwise Dave

thanks Paul, it works well for the first check box and nothing happens with the next. Dave