Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. SQUASHJUNKIE

    Query invoice and price matrix

    I am trying to query two tables in MySQL 4.1, one which has invoice information, the other which has price history info. In a sample scenario the invoice table has CUSTOMER, INV_NO, ITEM, INV_DATE, and the price table has CUSTOMER, ITEM, START_DATE, END_DATE, PRICE. The price table does not...
  2. SQUASHJUNKIE

    Report Title in Report manager Subscription

    yep...already tried that...didn't work. Tried using @[parametername] and the full name i.e. @parameter![parametername].value without any success. :(
  3. SQUASHJUNKIE

    Report Title in Report manager Subscription

    Hi, Is there a way of passing a default parameter value into the subject title on a report subscription? Currently there are std global variables i.e. @ReportName was executed at @ExecutionTime, but what other variables can be passed here to make it more relevant to the recipient? Thx
  4. SQUASHJUNKIE

    Connection problems

    OK, sorry I forgot to be more specific. Network has 5 w/s all win xp sp2 pro. Internal Network range 192.168.0.1 -> 192.168.0.100 Wireless Access Point fixed ip @ 192.168.0.100 (dhcp switched off) DC is Win 2003 Enterprise, DHCP, DNS and Active Dir switched on, 2 NICs, also acting as proxy...
  5. SQUASHJUNKIE

    Connection problems

    I have a small network setup with a win 2003 as a DC, and it also acts as a proxy server. The clients on the network after a certain time get disconnected from the network resources, no access to shared drives, although access through the proxy is ok. Once the client is disconnected I have...
  6. SQUASHJUNKIE

    DATA Selection Help

    Hi bruce2402 Thx for the input, I changed the property to cbodocno.text and placed the breakpoint in. Fixed It!!! just as a bonus question though :), if the combo box is looking up an invno which is not unique in the query that I am accessing, and I want the combo box to return a value which...
  7. SQUASHJUNKIE

    DATA Selection Help

    Hi, I'm a bit of a beginer to VB.net and have struggled throught the last couple of days to produce a simple form. However I want the form to show data based on a selection from a combo box, but I keep getting an error. I beleive the problem to be in my sql statement, but at the moment I cant...
  8. SQUASHJUNKIE

    Link and Index Table

    Hi, I'm having a couple of problems attaching a table via an ODBC link....I'm using the following code ______________ Function AttachTable() As Variant On Error GoTo AttachTable_Err Dim db As Database Dim tdef As TableDef Dim strConnect As String Dim tIdx As Index 'index for table Set db =...

Part and Inventory Search

Back
Top