Search results

I checked MS Knowledge Base and found this example. MyTotal: CLng(DCount("OrderID", "Orders", "[EmployeeID] = " & EmployeeID")) A couple of things stand out not the least of which is that the field counted, "OrderID" is different from the criteria field. Note also that they are converting the...

Try counting another field that is sure to have data in it. I think I had some difficulty once when the field counted was also the criteria field. Surely there is a patient name field. DCount("[ptName]"...?

Need criteria. Try adding a criteria to the DCount function to specify that you are counting Ids equal to the current record Id in rst. If [lngPtId] is a string: If DCount("[lngPtId]", "tblTmpDispLab", "[lngPtId] = '" & rst![lngPtId] & "'") > 1 Then... If [lngPtId] is a long integer the...

Was this conversion we just finished a 1 time deal? It makes a differrence. A form with some text boxes will do the trick either way. Oh what a dummy(me). I was using the .name and somehow deleted it trying to find a format scheme that would work. I learned how to create a date/time data...

Progress! And now I need help. I made a form with a cmd button and put the following code behind the button. I can't get the time part of the date/time field to work. Almost there. HELP (and thanks in advance for Geoff and me). Private Sub Command0_Click() Dim dbs As Database, rst1 As...

Geoff, I looked at both tables. Tbl2 looks like it does what you want. Help me understand your problem. Is the data in tbl2 just hand entered samples and you want to move records from tbl1 to tbl2? Is it a data entry format or form for tbl2? Whatever the specific problem is, its solvable.

OK first go back to Excel and copy and paste the "To this" including the column labels to sheet2. In access use "Get External Data", "Import". Select sheet2 to import. Access will create the table and populate it with the data from the "To This" columns (sheet2).

I looked at the Excel spreadsheet you attached. Do you want an Access table to duplicate the columns labled "To This"?

Make Access do the work. Create a stored query on the payments table with the id and date criteria referencing their controls on the customer form. (=forms!customerForm!txtID). You can use the query as record source for your pmt form. If that's not desirable, view the query in "SQL View" and...

Human Engineering An additional thought. Are you sure your form requests information in the order, form, and jargon PILOTS are used to? To be successful, an application must "speak" the user's language not the developer's. Soliciting their input for the layout and language of forms will do...

Mile, thanks for the logic and insight. Tables it is!

Mile, are you thinking cboUnitType selects "Length","Weight","Liquid" and cboUOM_purchase and cboUOM_use would then offer the units - and drive the units cbos from a table?

I have a table, tblSupplies, with a UnitOfMeasure field for both purchase units and use units. ie purchased by the lb but used by the oz. Units of measure could be weight, length, or liquid depending on the particular supply item. In any case the options for each type of measure are fixed...

Look at the help topics on bookmark property. You'll find what you want to do there or here by searching "bookmark".

Look in Help From Access VB Help. Sub OptionalArgs(strState As String, Optional strCountry As String)

Regarding "...past records having "* data *" in their string have code "DM" in JobFunction field?", if this is a correction or update to existing data, why not use a stored update query to make the change. Granted, for large tables it may take a while to run; but, for a one time pass it still...

I take it you can call this function from the NotInList event from different cbos with different data sources and that your use of "related table" refers to the calling cbo's data source. Not a bad idea - unless - you want it to perform operations unique to a particular table and/or particular...

You do have them. :) All humans have "special glasses" that make the mistakes of others much easier to spot than our own - in every aspect of life. :)

Dbl Oops Check every record. Right? With rst .MoveLast .MoveFirst Do While Not .EOF If .Fields("dblSupQty") = 0 Then .Delete End If .MoveNext Loop End With

Help help Open the form in design view. Look at the form properties - events. Click the 3 dots to the right of OnCurrent to open visual basic. "Help" on that screen is what you want. Start with "Getting started". :)