Search results

  1. S

    Hello All, I am having a DLookup problem with a Main Form | SubForm

    Problem with a DLookUp. I am currently working in MS Access 2007 and I attached the following code to a unbound text box which is located on a tab control =DLookUp("[ProdSpecAdr]","t_Suppliers","[pk_SUP_id] =" & [Forms]![f_DE_CPN]![fk_SUP_id]) Everything was working great till I placed this...
  2. S

    Is there a limit to the number of fields to a table??

    My boss has a table with tons of fields on it, he designed it this way because it was easier to add data to one place, but now the table keeps crashing, does ms 2k have a limit to the number of fields in a table?? Thanks in advance.
  3. S

    Now I've gone and Done it HELP!!! Compile Error:

    Compile Error: Variable not defined yesterday I went out to the MS site to install the coding to disable the wheel function on the mouse. After padding myself on the back, cus it worked, I called it a day and went home. Today I came in to run a report and to my suprise I'm getting the compile...
  4. S

    Need help with enabling a sub form

    I have a main form which allows users to set a search for records in a subform (embedded in Main form) how do I allow them to make changes within the subform based on their result?
  5. S

    Gwad I've had it On open default list box to Yes or -1

    What is my problem, I can't get this to work, I have list box that I want set on yes and when I do this in the on open forms I get all kinds of problems?? can anyone send me in the right direction??
  6. S

    Deselect chk boxes

    I have a button when you click it, it runs a append query to change all true check boxes back to false my problem is after it runs the append query the user see a long error message, then to see the check boxes change .....you have to go back and click the button again.....not very pretty here...
  7. S

    Reset check boxes

    I have a form with several records, the user is given the option to check a box if he want to send a email, what I need to happen when the form loses focus or is closed, how do I re-set all check boxes = -1 back to 0?? Thanks in advance.
  8. S

    button Collects Emailaddresses then open a form to create a report

    I have a button that collects all the email addresses that have a check mark next to them. What I want to happen next is trigger a form to open, so I can select from a list of options (this is already built) which in turns runs a report which ultimately gets attached to my above email...
  9. S

    Combo Box null value

    not sure if a combo box can contain a null value I have two combo boxes I want to make sure the user fills in box one before going to box two here what I got so far: Private Sub ResetTxtBoxes() If cmbBox1 = Null Then Me!cmbBox2.Enabled = False Else Me!cmbBox2.Enabled = True...
  10. S

    Compile error

    Compile error: "User-defined type not defined" I split my database (Access2k) and then went into the front end to test my forms, now I'm getting the compile error, the form has a multi list select box (which I got from this wonderful site) and then you press a button to preview a report, when I...
  11. S

    I Ran accross a great example of selecting muti records and sending emails

    I Ran across a great example of selecting (chkbox) multi records and then click a button to send email and the email address were auto filled. Stupid ME didn't make a copy of it and now I'm going crazy looking for it... anyways it was a beautiful thing, does anyone know what I'm talking about...
  12. S

    Drag and Drop works great but how do I open a reports based on what I selected?

    Drag and Drop works great but how do I open a reports based on what I selected? I have two list boxes the first is "items not selected" and the second is "Items selected" now I want to create a button that open a report showing the result from "Items selected"?? Hope someone can help I've been...
  13. S

    Calculating......Error when opening a sub form

    I'm working in Access 2000, and everything was running great till yesterday....on my forms I have a simple count record calculation. i.e. =" The Number of Customers for this Educational facility = " & " (" & Count(*) & "" & ")" every time I'd open a form it would tell me how many records I had...
  14. S

    Would like to click on a button that opens MS Outlook with/User email add.

    I want to be able to select a record that has a email address and open MS Outlook with the email address auto filled into the To: box. All of the examples that I review have files attached, does anyone know of examples that opens MS outlook without attaching files?? Thanks in advance.
Back
Top Bottom