Search results

  1. H

    How can I get record counts faster?

    I have a bunch of tables that are tied to a table of quotes. On my main quoting form I have tabs for each type of item and I want them to say how many items are related to that quote. So I found myself using a whole bunch of chunks of code that look like the following: Dim rs As...
  2. H

    Problem with recordset loop

    I know this is long but does anyone see the syntax error in this SQL query. INSERT INTO tblCharProduction (SPI, OpNum, Number, Characteristic, SpecCharNum, Spec, GageNumber, Samples, Frequency, Control, Reaction, FAB, MOV, STO, INS, ControlPrevention, ControlDetection, PotentialEffects...
  3. H

    SendObject problem

    I'm trying to use DoCmd.SendObject to send an email alert when a user adds a new record to a certian table. Problem is that when I run my little email subroutine, all I get is an error message that says: "Object doesn't support this property or method" Here's what my code looks like...if...
  4. H

    Syntax error (missing operator) in query expression

    I'm getting the above error message when I try to open a form. The error started occurring when I tried to have two filters to control the form content. One filter is for items checked "Completed" and the other filter is for any information that was included in a Search. The actual...
  5. H

    User-level security using a module

    I already posted this question in the Forms forum, but I thought I might be more likely to get an answer here. I apologize if this violates forum etiquette. I have a module that authenticates users and controls who has full or read-only access to certain forms. My problem is this; things such...
  6. H

    User-level security using a module

    I have a module that authenticates users and controls who has full or read-only access to certain forms. My problem is this; things such as combo boxes and checkboxes that are meant to be used for any user are disabled in read-only mode. I was thinking that I could use the tag property on my...
Back
Top Bottom