Search results

  1. V

    unique value in combo box

    I don't want the field to be unique, I just want the combo box to show only one instance of each existing value in the selection list. Several Parcels will have the same Appraiser.
  2. V

    unique value in combo box

    I need a data entry combo box that pulls it's selections from the existing data (Appraiser) in the table and also allows the entry of a new name if necessary. I can't get it to work. I added DISTINCT to the select statement, but it makes the distinction on the Key field (Parcel #) instead of my...
  3. V

    subform total

    I'm getting #Error on a subform total, and can't figure out the problem. I've checked everything listed in the Help topic, and it all seems OK. The field I'm totalling is a calculated field in the subform's query. If the record is marked as "Void" I don't want the amount included in the total...
  4. V

    sorting subform

    I have a table with a Parcel # field which is set up as a text field because some numbers have a letter after them. (10A) In order for these to sort numerically in my form I created a field in my query using the Val Function. This makes it sort right in the query (1 is before 10). However, when...
  5. V

    removing sort order

    I have a report that I originally set up with a particular sort order. I have since redesigned it to use with several different filters and sorts. I removed the sort from the underlying query, which looks fine when I look at it directly in datasheet view. It's unsorted. I set the report's Order...
  6. V

    exclude certain entries in a total

    Is there any way to exclude certain entries in a total? I need to be able to show the dollar amount that was voided in some records, but not include them in the total. I thought I could make a field which would indicate a Void, but don't know how I'd use it in a Total calculation.
  7. V

    formatting selected record

    Is there a way to hilite the record that has focus in a continuous form? I know how to do individual controls, but can't figure how to do it for an entire record.
  8. V

    Data type mismatch

    I have a form which opens fine, but I can't change the data in some fields. When I change the recordset type to Dynaset(inconsistent updates), I get a datatype mismatch error. What do I need to check to fix this? There are several different tables and other queries making up the form, would one...
  9. V

    combo box error

    I've been trying to make a combo box, and keep getting this error when I try to use it: Runtime error 438, object doesn't support this property or method. I used the combo box wizard, got the data from the same field I'm storing it to. I have list boxes on the form that work fine, what's wrong?
  10. V

    Lowercase to Uppercase

    If you just need it displayed as uppercase in a form or report, put a > in the format property of the field. If you need the data actually changed to uppercase, I don't know.
  11. V

    Crosstab Column totals

    How can I get Column totals in a Crosstab Report?
  12. V

    filter not finding all records

    I have a popup dialog box that I use to enter a new record. I now have two records which have the same job number. When I go to my detail form and search by form for that job number, it only finds one of the records. I checked the table, and both records show up there, but the query my detail...
  13. V

    overtype in SQL

    I feel like such a dummy! Yes, it was the insert key on my keyboard. That's one I never use, and I didn't have a clue what I might have done to cause it. Thanks!
  14. V

    working with subform

    Did you ever get this fixed? Try changing the Data Entry of the form to Yes.
  15. V

    overtype in SQL

    All of a sudden, when I try to insert characters in an existing SQL statement or field property, it's overtyping the existing text instead of inserting. Have I accidentally changed a setting somewhere?
  16. V

    syntax error

    Thanks a lot, that fixed it!
  17. V

    hiding a control

    I have a combo box on a main form, which I'm using when I need to filter on the attached subform. It works, but it looks confusing in between searches. Is there a way to make the combo box diappear unless one of the filter buttons is clicked?
  18. V

    syntax error

    http://odyssey.apana.org.au/~abrowne/ser-28.html I'm trying to use the code from the above web site to filter a subform. I keep getting compile/syntax errror on the portion at the bottom: MsgBox Err.Number & ": " & Err.Description, vbInformation, & _ Me.Module.Name &...
  19. V

    Filtering Subform

    I found this question while searching on another forum, and since it states my problem exactly, I'll just copy it: Has anyone come up with a GENERIC way of providing filtering of subforms? For example, in the Northwind database, the Orders form has an Orders detail subform. If you want to...
  20. V

    Record last updated field

    I'm getting the compile error "Method or data member not found" with the "txtDateModified" part of the code highlighted. DateModified is the name of my field, so what am I doing wrong?
Back
Top Bottom