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 strongm 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: sysadmin07
  • Content: Threads
  • Order by date
  1. sysadmin07

    MS Access VBA

    Hi, Within Access, I have some data in a table that I'd like to use to selectively populate another table. Per the example table below, I'd like to dump all data into another table, although where the State is equal to California, I'd like to only populate the values where LName is equal to...
  2. sysadmin07

    Converting for Internet View

    Hi, I'd like to make my Access forms viewable online, in which there is a lot of VBA code behind them. Ideally, there would be a converter to transition them to whatever language necessary. Regardless, what are your opinions and recommendations? Thanks.
  3. sysadmin07

    Hiding a sub-area for non-users

    Hi, I have a sub-area in SharePoint, in which the members of it have been appropriately defined. Although non-members can't access it, they can still see that the link to the sub-area exists. Is there any way that I can hide the link for non-members? Thanks.
  4. sysadmin07

    "Invalid Data" Error When Editing Records

    Hi, I have a CF page that allows me to edit records in a MS Access database (the primary key in the database is autonumber-based). If I try to edit one row of the database from my CF page, everything works fine. However, if more than one row needs edited and is displayed on my CF page, upon...
  5. sysadmin07

    mysql.err File

    Hi, Our nightly backups are approaching capacity and I've noticed that the mysql.err file is rather large. Can this be excluded from the backups? Would it have an effect on recovery, if a disaster occurred and the mySQL databases needed recovered from backup? Thanks.
  6. sysadmin07

    Dynamic Number of Tables

    Hi, I'm pulling data from an Access database, in which I'd like to display in tables on a CF page. The problem I'm having is that I need to generate the necessary amount of tables, based upon number of occurrences. I have a few instances where, for example, the Access table row named "test"...
  7. sysadmin07

    Deleting Records from an Access Database

    Hi, I'm trying to delete multiple rows from an Access database. I'm having trouble figuring out how to call entries that are differentiated by -1, -2, -3, etc. (outlined below under the "Name" heading). How would I go about deleting the John-1, John-2, and John-3 rows? FYI, this is a rather...
  8. sysadmin07

    Multiple Entries in Access Db

    Hello, I have a CF page with textboxes that populate an Access database. In two of the textboxes, I have a user enter their city and zip. In some cases, a city will cover more than one zip and I'd like to give them the capability to account for this. For example, if "Los Angeles" is entered...
  9. sysadmin07

    Using Variable Data to Compile Hyperlink

    Hi, I have two textboxes on a ColdFusion page for users to enter information into that's being written to an Access DB. If a given URL is www.tek-tips.com and the user enters "test1" and "test2" into the textboxes, how can I use that data to make the URL: www.tek-tips.com/test1,test2 This...
  10. sysadmin07

    Textbox Entry - Set as Two Variables

    Hi, I'm trying to send a user-entered field from a textbox into two ColdFusion variables. For example, if I have <input name="test"> and I want it to also equal "test2", how would I go about setting them equal? Thanks.
  11. sysadmin07

    Passing Text Box Info to Variable

    Hi, I'm currently working on a website consisting of three frames. The first frame contains a textbox and a submit button. When the user enters a zip code and hits "submit," search results are shown on the second frame (this is working okay and I don't need help with that, just an FYI). What...

Part and Inventory Search

Back
Top