• WSG-Wog

    WSG-Wog

    @wsg-wog

    Viewing 15 replies - 1 through 15 (of 22 total)
    Author
    Replies
    • Yes, I had the data entry set to “Yes”. Thanks Hans, that’s fixed the problem.

      Really appreciate the speedy responses 🙂

    • I must have hit save after selecting Records->Filter->filter excluding selection. That explains the bit after AND. The current selection was [ID] = 0 (no record) and it put (Not TblTemplates.ID=0) into the filter property. Still getting the same problem tho no matter how I open the form. With or without a filter applied the form shows a filtered recordset of 1 item until I remove filters using the menu.

      Thanks for your assistance Pat

    • addendum to above, when I open the form with no filter, remove filters using the records menu to reveal the whole recordset, switch to design view and view the form properties I find the following line in the filters property:

      ([ID] = 10) AND ((Not TblTemplates.ID=0))

      Where did this come from? I was viewing the record with [ID] = 10 but as to the expression right of the AND, I have no idea…

    • in reply to: Popup when opening form (Access 2002/WinXPSP1) #678497

      Thanks Charlotte. The dlookup seems a much easier way of doing things. A big whoops on the cleanup of recordsets. I usually remember to set the recordsets to nothing but only because I was told that was the correct thing to do, never why. Now I know…

      Once again, thanks for all your help on this.

    • in reply to: Popup when opening form (Access 2002/WinXPSP1) #678486

      Thanks Charlotte, I think your right. I don’t even remember adding that field to the table or why.
      In a text box on the “Costing Tab” I use the function in an expression. The function cycles through the materials table till it finds the right material and then plugs the on cost value of that material into the expression. Can you suggest a better way of doing this?

      Thanks again.

    • in reply to: Popup when opening form (Access 2002/WinXPSP1) #678479

      There is a report designed to print out the form that has 2 functions identical to the ones in the form in its module. I tried changing the names of them and the reference to them but it doesn’t fix the problem. I prefix all Form, Report and module names with Frm, Rpt or Mod so there is no chance of a container object being called “MatOnCost”. I haven’t used any macros at all. I’ve attached a zipped version of the db thats been cut down a bit as Hans suggested.

    • in reply to: Popup when opening form (Access 2002/WinXPSP1) #678468

      I’ve found the conflict but it’s a bit wierd. I compiled the code like Hans and Charlotte suggested and it pointed to the second function “MatOnCost” which is in the forms module. I changed the function name and the references to it to “MatOnCost1” and the problem went away. Suggests there is a control somewhere called “MatOnCost” but I can’t find it. I’ve looked at every text box, label and button but nothing has that name apart from the function. Is there anything else it could be?

      Thanks everybody for your help on this. I really appreciate it.

    • in reply to: Popup when opening form (Access 2002/WinXPSP1) #678424

      Nope. All the forms procedures are of the form “CmdButtonName_click” except for 2 functions which do not have similar names to controls. I checked all modules and code for all forms in the DB just to be thorough. I tried putting a breakpoint in the OnCurrent event procedure but it doesn’t get to the breakpoint before the popup appears. Is this significant?

    • in reply to: Popup when opening form (Access 2002/WinXPSP1) #678390

      Yes, just a few lines to enable or disable a few controls depending on the value of one of the fields in the underlying table to the form:

      Private Sub Form_Current()
      If Me.SandType = “Chemically Bonded” Then
      Me.SandQty.Enabled = True
      Me.SandUOM.Enabled = True
      Me.TxtSandCost.Enabled = True
      Else
      Me.SandQty.Enabled = False
      Me.SandUOM.Enabled = False
      Me.TxtSandCost.Enabled = False
      End If
      End Sub

    • in reply to: adsl router via 2nd NIC #662710

      Thanks Charlie. Sounds like a good solution. I’ll check it out.

      Ryan

    • in reply to: adsl router via 2nd NIC #662372

      Thats right. When the router is connected directly to the switch a regular cable is used. However, when the router is connected directly to the server via a second NIC (First NIC connects server to internal network via switch) a crossover cable has to be used just as if I was connecting two computers together with a single cable and no hub. I checked out the KB articles but they refer to Backoffice Small Business Server 4.x not Small Business Server 2000 and relate to MS Proxy Server, not ISA Server which SBS 2000 uses.
      I had everything working breifly last night with the router connected to the second NIC and the NIC having the same IP address as the router, but soon afterwards the server threw up an error because of the IP Address conflict between the NIC and the router.

    • in reply to: Terminal Services between network clients? #653031

      Thanks Dan. That sounds exactly what I’m looking for.

    • in reply to: Terminal Services between network clients? #650991

      We are running W2K on nearly all of the workstations with W98SE on 1 or 2 of them. Thanks for your responses. I will check out RealVNC and TightVNC.

      Cheers,

      Ryan

    • in reply to: Adobe PDF within form (2002) #599828

      Thanks Hans, I’ll give it a try.

    • in reply to: querydef (Access) #595879

      Rupert is right. You need to pass the date in US format to the query. Try :

      strSQL = “Select * fromqryProductionSales Where tdate >= #” & Format(txtStart, “mm/dd/yyyy”) & “# and tdate <=#" & Format(txtEnd, "mm/dd/yyyy") & "#"

      Ryan

    Viewing 15 replies - 1 through 15 (of 22 total)