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!

Register Log in
  • Congratulations derfloh 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. milcman

    Access 2007 Controls Don't Work in Access 07 Runtime

    Thanks for the quick reply, Bob. That is one of the articles I ran across. I registered the location of the DB as a trusted location and also registered a digital "SelfCert" certificate on the test machine, but still get the error. I have some added code behind the controls in addition to their...
  2. milcman

    Access 2007 Controls Don't Work in Access 07 Runtime

    I have an application written in Access 2007 that works fine on my machine, and worked when I originally installed it on the end-user's machine. At some point the controls on the main form quit working. It gives an error code of 2950. I have researched the problem and what I have found points to...
  3. milcman

    Excel-Display corresponding value from table based on number in list

    I have a list of client names in one column and a random number between 1 & 200 associated with each name. I also have a table of numbers, 1 through 200 with a letter designation for each number, (a,b,c,...aa,ab,...ga). I am trying to figure out how to use a formula to assign a letter(s) to a...
  4. milcman

    How to Compare Variable to Textbox Value

    I am a VB.NET newbie used to VBA. I am trying to figure out how to compare a variable to the value input into a textbox. I tried declaring the variable and setting it's value, and used nested If/Then/Else statements to compare the textbox values to the variable. Even when the proper values are...
  5. milcman

    Dsum causes #Error

    Have another star PHV...your simple aggregate query was exactly what I was looking for! Clint Galliano Halliburton Energy Services BAROID PSL "Done ONCE, Done RIGHT!"
  6. milcman

    transferspreadsheet - bring back defined name ranges in xls.

    I figured it out now...I used the "TransferSpreadsheet Method" but was copying the range of cells from the "Define Name" window and pasting it into the "Range" section of the code. That was the problem because it has the cell references prefixed with a "$". Once I removed them from the code, it...
  7. milcman

    transferspreadsheet - bring back defined name ranges in xls.

    How about posting the solution for others to see? Clint Galliano Halliburton Energy Services BAROID PSL "Done ONCE, Done RIGHT!"
  8. milcman

    Set Multi-field PK in Newly-Made Table

    Thanks, PH! That hooked me up. Have a STAR! Clint Galliano Halliburton Energy Services BAROID PSL "Done ONCE, Done RIGHT!"
  9. milcman

    Set Multi-field PK in Newly-Made Table

    I am pulling data from 2 separate A2k2 databases over our corporate network. Both DB structures are identical (excepting data). I accomplish this by using a make table query to pull data from one DB, then an append query to pull data from the other DB, for each table. I use this data for weekly...
  10. milcman

    Compare Values between Local & Linked tables

    Thanks, LittleSmudge! I didn't use the code you suggested, but thank you for pointing out what I obviously overlooked. The quotes were screwing it up. Have-a-star!!! Clint Galliano Halliburton Energy Services BAROID PSL "Done ONCE, Done RIGHT!"
  11. milcman

    Compare Values between Local & Linked tables

    I am trying to get my front-end DB to compare a value in a linked table from the back-end to a value in a local table from the front-end. Below is a truncated snippet of my code: =========================================================== Dim intLocal As Integer Dim intLatest As Integer...
  12. milcman

    Help with data access pages

    The thread is thread181-800833 Clint Galliano Halliburton Energy Services BAROID PSL "Done ONCE, Done RIGHT!"
  13. milcman

    Help with data access pages

    linuxjr, The data access page sits on a server and does not need access for someone to use it. It is, in essence, a front end to your "back-end" database. I am in the process of trying to figure out DAPs myself and have found so far that they don't like combo boxes or tables without...
  14. milcman

    Query for any "False" item in record

    Cosmo, "OR" is the correct operand. This returns a list of projects where if any component of it is not checked off, it will show up in the list. Clint Galliano Halliburton Energy Services BAROID PSL "Done ONCE, Done RIGHT!"
  15. milcman

    Query for any "False" item in record

    Here is the SQL that I used: SELECT tblWells.atoWellID, tblWells.strWellTechID, tblWells.OperatorName, tblWells.intQuoteNumber, tblWells.strWellName, tblWells.strArea, tblWells.strFieldBlock, tblWells.RigName, tblWells.dtmSpudDate, tblWells.dtmWellEndDate, tblWells.ysnOffsetData...
  16. milcman

    Query for any "False" item in record

    I figured out what I needed to do. It's along the order of +/-18 check box fields. I was doing the query in design view and decided to look at the SQL view. There I saw that I could change the "AND" to "OR" and have it work like I wanted. Thanks!!! Clint Galliano...
  17. milcman

    Query for any "False" item in record

    I have a table that has a bunch of check box fields. I want to be able to query for any records that DO NOT have all check boxes checked. Any suggestions? Clint Galliano Halliburton Energy Services BAROID PSL "Done ONCE, Done RIGHT!"
  18. milcman

    where did "E" drive come from

    Just a thanks to Tahoe2...pointed me in the right direction about a different problem. Removable drive setting up with different drive letter assignments depending on what else is plugged in at the time. It played hell with replication & paths for my split MS Access DB. You gety a star for the...
  19. milcman

    Store Value in Subform

    I figured it out. Instead of having it on the "On Load" event, I triggered it from the "On Dirty" event of the first field. Works fine now. Clint Galliano Halliburton Energy Services BAROID PSL "Done ONCE, Done RIGHT!"
  20. milcman

    Store Value in Subform

    I am using a custom, auto-incrementing value as a record ID,(read - not PK), on a form(frmNewWPAO). I tried using similar code but diferent reference values to do the same for a subform(frmServiceTicket) 2 levels down from the main form. (Form levels: Main=frmWPAO, sub1=frmWPAO_Order, sub2[of...

Part and Inventory Search

Back
Top