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

    TreeView click

    Here's basically what I'm trying to do. I have a treeview that I have filled. The treeview is located on a form with another subform when I click on the 1st node I want the record on the subform to reflect this. Sort of like a relationship you would see with a one to many. Any ideas would be...
  2. ryan1

    Copy File

    Help Needed! Here's what i'm trying to do. I want to run a procedure that will copy an access database from a location(some where on the network) to the users desktop.
  3. ryan1

    Retrieving Data from Another Table

    I'm trying to right a function to pull data from stand alone tables. This is what i've got so far but it doen't seem to work. I'm trying to pull from a text field. P.S. For specific reasons i cannot link to these tables. ''''''''''''''''''''''' These are set on another form Set gdbs =...
  4. ryan1

    Open 97 Database from a 2000 Database

    I'm trying to open an Access 97 database from a 2000 database and not having a lot of luck any help would be great.
  5. ryan1

    Copy database

    How do i transfer the whole database from one location to another using VBA. The copyed version would be a back Up.
  6. ryan1

    On Exit

    Is there a function that will run on Exit of the entire database (for example autoexec macro on startup).
  7. ryan1

    Menu Bars

    I've in the past set my menu and toolbars up in all sorts of ways. I currebtly working on a very busy database and was looking for some input on what the best approach to using menu bars was. In the forms i want no menubars and in the reports i only want the specific one i've specified(always...
  8. ryan1

    Assign Recordsource of Tree View

    I'm trying to figure out how to set the recordsource of a Active X tree view control. I'm experenced in Access but i'v never user Active X controls (except the calendar). Any help would be awesome.
  9. ryan1

    Log Users Off

    Question. Is there a way to automatically log all users off a database?
  10. ryan1

    calendar Now() date

    I'm using the ActiveX Calendar form which works great except one problem, when i open it for the first time in the morning in never has today's date selected it's always the last day i used it.
  11. ryan1

    Inactive database

    I'm trying to figure out how to monitor the database if a user has not clicked on anything or had any keystrokes in 60 minutes close database. Any help would be great....
  12. ryan1

    Date Diff

    I have a many query that records dates. I'm trying to find the difference in days between a date to the next date which are in decending order(there are 20 or so dates). Any Suggestions?
  13. ryan1

    Change Data Type

    Does anybody know how to change the Data Type of a field in a table using VBA. Any help would be great.
  14. ryan1

    Capture Key Strokes

    Does anybody know how to capture key strokes and set them equal to a string.
  15. ryan1

    Count Records

    I could use a little help getting a mod going. I have a table that in imported from another database, the table has many duplicate records excluding one field so for example i have 5 records that have 52121 as the number key and each field has a different hours in the hours field. What i'm...
  16. ryan1

    Print Help!

    How do i get the Default Print Dialog box to appear so the user and select desired printer before printing.
  17. ryan1

    Insert Into Statement Help!

    Here's what i'm trying to do. I am selecting items from a stand alone table and trying to update another table that has a many relationship with another table. I know how to write a Insert Into Statement but how do i included a primary key from the one table into the insert statment. If this is...
  18. ryan1

    Create AutoNumber

    I'm trying to create a 4 digit, auto count from a number field in a table. I know how to find the max number and add one. But i do not know how to create a 4 digit number. Need help
  19. ryan1

    Julin Dates

    Does anybody know how to change a date to a Julin Date??I Need Some Help
  20. ryan1

    Update errors

    I need some assistants. I am updating a table from unbound text boxes on a form. The problem is sometimes the textboxes are left blank(Null) therefore creating a validation violation error. Any Ideas?

Part and Inventory Search

Back
Top