Search results

  1. J

    AC2007: Can I duplicate this Excel filtering in my query?

    Using a 'Group By' on the query is a good way to remove duplicate data as long as any other fields are the same.
  2. J

    INSERT INTO W/conditional target?

    I think you need an Update query. http://office.microsoft.com/en-001/access-help/update-data-by-using-a-query-HA010076527.aspx
  3. J

    Question Iif & And Function

    When you say 'one of these measurements are out of spec' what do you mean? At the moment your formula states that if all the fields are >= 45 then the result is 'FAIL' but if one or more of your fields is < 45 then it will be set to 'PASS'. What do you want to happen?
  4. J

    Select entry from combo box if yes/no box checked

    What is Trimmed? Is it a string, if so it needs to have quotes as follows: Me![FL Lesion] = "Trimmed"
  5. J

    Select entry from combo box if yes/no box checked

    Will it always be the same value? If so do this: Private Sub FL_Trim_AfterUpdate() If Me![FL Trim] = True Then Me![FL Lesion].Enabled = True Me![FL Treatment].Enabled = True Me![FL Lesion] = 1 End If End Sub NOTE: You need to change the 1 to the required value.
  6. J

    Ms access VB query?

    I would either create a table/form and save the required info there or save them as database properties.
  7. J

    date=last monday

    Try >Date - Weekday(Date(), vbMonday) + 1
  8. J

    Form compressing on open

    Try changing the settings so you can amend the size of it when it's open and then set the size as required, save the form and close. Then in design view remove the setting so the user can't resize it. Failing that you could set the size using VBA when the form opens.
  9. J

    Question Back-end of db thinks user is still logged on

    Make sure that MSACCESS.EXE isn't still running in the user's Processes (on the Task Manager). Failing that try shutting the computers down that you believe are to blame. If the locking file is still there then someone has it open.
  10. J

    Linking Sub Forms

    To start with ou need a common field that the 2 forms can link on. Then you need to add the details of the 'linking' fields to the subofrms Data properties as follows: Open the properties for the subform. Click on the Data tab. Enter the linking field for the main form in the 'Link Master...
  11. J

    Change path on existing reports

    Depends how it was setup. The path could be hard-written in the code, stored as a database property or stored in a table so you need to identify which and amend accordingly.
  12. J

    defining relationships and RI in an existing DB

    There is only one reason for not having relationships in a database (that require relationships) and that's bad design. This sounds like a big job but you're going about it the right way and I think you've highlighted the main potential issue and that's orphaned records. I don't think you'll...
  13. J

    Form Doesn't Open on All Systems

    Is this a shared Front end i.e. both computers are accessing the exact same file? Can you provide some detail on how the form works when it is being opened i.e. do you click a button and is it opened by code or is it a macro etc...
  14. J

    Form Doesn't Open on All Systems

    Sorry, do you say that the form is actually opening on both but it is minimised on one? Are you using different version of Access/Office?
  15. J

    Set Textbox Default Equal to Another Textbox

    Ooops! Here ya go: Me!CalcFieldName = Null NB: You will need to replace 'CalcFieldName ' with the real field name of the calculated field and put the line of code on the AfterUpdate of each of the other fields.
  16. J

    Set Textbox Default Equal to Another Textbox

    Because you want the value as a default this means it will only happen when the form is first opened. You could get round this by removing the value in the calculated field on the afterupdate on the Value fields as follows:
  17. J

    The Microsoft Jet database engine cannot open the file ''. It is already opened exclu

    Excel can't be used in a multi-user environment. To get round this issue try creating a table from the data in the Excel file and using that in your query instead.
  18. J

    comparing calculated values in a Subform

    I've downloaded the db and had a quick look and I believe it is a timing issue becuase when I step through the code it works. This means your code is fine - though somewhat convoluted - but I don't have time to investigate further at this point. Below is simplified version of what you're...
  19. J

    comparing calculated values in a Subform

    It's possibly a timeing issue - you could try running a recalc first as follows: Private Sub Form_current() Dim QTYA As Integer Dim QTYB As Integer Dim TF As Boolean Me!RFP_subform.Form.Recalc QTYA = Me!RFP_subform.Form![QTYRECTOTAL] QTYB = Me!RFP_subform.Form![QTYORDERED] ***If IsNull(QTYA)...
  20. J

    comparing calculated values in a Subform

    Not sure if you tried this but what I meant was look at the values in Break mode - this means selecting the desired part of code and using QuickWatch to see the values. So when the code breaks at the line below, highlight Me!RFP_subform.Form!QTYORDERED and then press SHIFT + F9 to see the...
Back
Top Bottom