Search results

  1. M

    Automate an export of data to Access tables.

    Hi, Would it be possible for me to build an interface for a customer to use for importing data. So that they customer could choose from a drop down list, or input into a text box where they want to export from, and where they would like the export to be imported?
  2. M

    Regarding Mail Merge and Report Building

    Hello: I don't program in Access very often. I am using Access 2003, and have a client that wants me to create a Mail Merge application using queries against some access databases. Is this something that can be done in Access? Also, they have some reports that they would like for me to build...
  3. M

    order by when you have joined tables

    Oops-- that is what you did.. sorry. Are you sure that you have the name of the table right?
  4. M

    Simple Form Validation

    No, I really would like to use the existing format. Is there anyway to catch the click of the default form buttons ? or to prevent the form from being submitted (so that when I catch the form_beforeUpdate, i can say don't submit the form if they aren't validateable...
  5. M

    Simple Form Validation

    Okay, how can I catch this with VB? I have code in the Form_BeforeUpdate() but that is not preventing the user from submitting with wrong data in field. [Number of Bedrooms].SetFocus If (CInt([Number of Bedrooms].Text) < 1) Then MsgBox ("You need to enter 1 or more bedrooms") End If...
  6. M

    Simple Form Validation

    When user submits record on form, by pushing the arrow to move forward to new form, or back to previous ones, I would like to ensure that they have met a specific criteria in some fields. How can I catch this without using VB Access? I can use VB Access, but would like to know how "normal"...
  7. M

    order by when you have joined tables

    SELECT d.PDetailsID, d.po_id, d.po_uniqid, d.job_id, d.p_qnty, d.p_desc, d.p_unitp, d.p_units, d.p_extend, d.p_qos, d.p_grec, d.p_done, d.cocreq, d.est_id, d.line, d.class, d.selected, d.itemid, d.category, d.GroupID, d.p_qosextended, d.late, d.lastsavedby, d.matid, d.customer...
  8. M

    Basic Form Information

    I have forms in a database that I am looking at. How can I tell which table the forms are connected to? Easiest thing, I know. Help much appreciated. -Mike
Back
Top Bottom