Search:

Type: Posts; User: patt; Keyword(s):

Page 1 of 20 1 2 3 4

Search: Search took 0.07 seconds.

  1. Replies
    20
    Views
    266

    What do you mean by the top box in...

    What do you mean by the top box in IE/connections/LAN Settings?
    On my system i choose Network Connections which brings up a page showing Local Area Network with a red cross on it and WiFi which is...
  2. Replies
    20
    Views
    266

    Dear Sudo, on looking back on that i now...

    Dear Sudo, on looking back on that i now unferstand that ESET scanner is not applicable without bring logged onto the internet in Safe mode via ethernet, so just ignore my request for that file.
  3. Replies
    20
    Views
    266

    I cant get that eset utility as i am doing all...

    I cant get that eset utility as i am doing all this on my phone and the phone says i cannot open another window on my phone. I will go and get the ethernet cable. To install the ethernet do i just...
  4. Replies
    20
    Views
    266

    The ISP guys that were here tried an ethernet...

    The ISP guys that were here tried an ethernet cable but not in safe mode.
    When they had gone i tried a system restore and everything was cool for a few days, thenthe problem started again. I did...
  5. Replies
    20
    Views
    266

    I hope this works. I am on my phone doing...

    I hope this works. I am on my phone doing this.Damn it does not allow attachments. I can send it via email though
  6. Replies
    20
    Views
    266

    Windows 10 up to date. Wireless router to my...

    Windows 10 up to date. Wireless router to my phone and laptop.
  7. Replies
    20
    Views
    266

    System stopped internet

    After much mucking around trying to see why it happened i de cided to do a system restore
    to see if it would fix the problem. It fixed it but a few days later it happened again, no more internet...
  8. From what I can see you have pretty well nailed...

    From what I can see you have pretty well nailed it.

    As long as you are happy with it.

    Maybe others have a more elegant solution.
  9. I have included a database rather than try to...

    I have included a database rather than try to explain it all
  10. True what you say. You say: It looks like...

    True what you say.
    You say:
    It looks like somehow I need to list all the started jobs and, for each one, get the operator (i.e., PreviousJobOperator) from the *highest* completed job with the same...
  11. I would create a query "CompletedJobs" of just...

    I would create a query "CompletedJobs" of just completed jobs.
    In your "StartedJobs" query I would introduce a LEFT JOIN for this new query to get the PreviousJobOperator.

    Query StartedJobs:...
  12. Thread: Validation Rule

    by patt
    Replies
    9
    Views
    249

    I meant for you to put that line of code in the...

    I meant for you to put that line of code in the form's BeforeUpdate event
  13. Thread: Validation Rule

    by patt
    Replies
    9
    Views
    249

    Where are you using that code? Get back if you...

    Where are you using that code?
    Get back if you need more help.
  14. Replies
    4
    Views
    181

    Does this do the job? SELECT...

    Does this do the job?
    SELECT qry_Order_List_Count_of_All.[CountOfDB Part ID] AS [Total List Count], qry_Order_List_Count_of_All.[Order ID], nz([CountOfPart Number],0) AS TotalYesCount
    FROM...
  15. Thread: Validation Rule

    by patt
    Replies
    9
    Views
    249

    What code did you try it in the forms...

    What code did you try it in the forms BeforeUpdate event?
    It should look something like this:

    If Meter > LastMeter +672 Then Cancel = True
  16. Replies
    4
    Views
    181

    Please show the queries that this query is based...

    Please show the queries that this query is based upon, it would be good to make the DB available so we can see what you are doing.
  17. Replies
    4
    Views
    415

    Corruption maybe?

    Corruption maybe?
  18. Replies
    24
    Views
    954

    Glad you got it solved.

    Glad you got it solved.
  19. I have made a change as follows: ...

    I have made a change as follows:


    DoCmd.SearchForRecord , "", acFirst, "[id_MainTable] = " & rs!id_MainTable
    ' Me.Filter = "[id_MainTable] = " & rs!id_MainTable
    ' Me.FilterOn = True
    ...
  20. Replies
    24
    Views
    954

    What you will have to do is to write a function...

    What you will have to do is to write a function to separate the fields you want by doing a search for ; (taking into account the end condition where there is no ; ) and write these to a new table...
  21. It would help if you could provide the database...

    It would help if you could provide the database with any sensitive data taken out.

    What I would do in VBA behind a button is to:
    a. use the INSERT INTO command to insert a record based upon the...
  22. Replies
    24
    Views
    954

    Memo field manipulation

    Here is the database, hope this is what you want.
  23. Replies
    24
    Views
    954

    It is (1) that is code behind a button on a form....

    It is (1) that is code behind a button on a form. I would create the table once, and leave it in the Access database.

    The code I provided above needs a line to delete all the rows in that table,...
  24. Replies
    24
    Views
    954

    I would attach this to a button on a form....

    I would attach this to a button on a form.
    Behind the button you would put this code.
    You would have to change the names of the tables to your table names.
    Create a table named tblFound with...
  25. Replies
    24
    Views
    954

    I wouldn't bother with queries trying to solve...

    I wouldn't bother with queries trying to solve this, I would use VBA to build a table (say tblFound) that has 3 fields viz:
    Item
    FrontBack
    Colour
    nb. where FrontBack is a text field that hold...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4