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 TouchToneTommy 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: *

  • Users: beec
  • Content: Threads
  • Order by date
  1. beec

    Subrecords

    I have an Access XP application with a master table and related records in a subtable. How can I filter wich records in my master table have no subrecords in the subtable. The tables are linked with an ID field in the master table. Thanks, BE
  2. beec

    Error message in conversion to Access 2002

    We just changed over from Access 97 to 2002. When I try to open a database I used in 97, I get the following message : The current user account doesn't have permission to convert or enable database. To convert or enable a database, ensure the following: *You must join the workgroup that...
  3. beec

    Using IF in Excel 97 with VBA

    I'm trying to insert a formula in my Excel 97 worksheet through a VBA script. I want to insert a formula wich contains the IF statement but I get an error message. How can I solve this ? My code is as follows : Range(&quot;E2&quot;).Formula = &quot;=IF(AND(D2<0;D1>=0);1;99)&quot...
  4. beec

    Excel 97 : negative value detection

    I have a range of data in my Excel 97 spreadsheet existing of a column with dates and time and a second column with pressure values. This data has to be analysed on when it passes zero. What I have to do is to count every time the pressure value comes below zero and how long it takes to rise...
  5. beec

    OpenForm with a filter results in no records

    Hello, I use a second form to add extra data to a record. Both records are linked by an ID. Here's my problem : When I want to open the second form, i do it with this code line : DoCmd.OpenForm &quot;frmVerschildrukmeters&quot;, acNormal, &quot;&quot...
  6. beec

    OPC client application with VB 6.0

    I have to write a small program that gets its data from an OPC (OLE for Proces Control) server. Is there anyone who has some experience in this or who can give me an examlpe program or a wireframe. I need to get the data from a Siemens OPC server.
  7. beec

    OPC client application in VB

    I have to write a small program that gets its data from an OPC server. Is there anyone who has some experience in this or who can give me an examlpe program or a wireframe. I need to get the data from a Siemens OPC server.

Part and Inventory Search

Back
Top