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 Chris Miller 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: bosun
  • Order by date
  1. bosun

    Change default value to = last entry

    I apologize Steve, but my name isn't Doug either. My quote comes from Douglass Adams, the author of The Hitchikers Guide to the Galaxy. I will putter with that over the weekend, but it looks simple enough. Thanks again for your help. Bill Lyle I love deadlines. I especially like the...
  2. bosun

    Change default value to = last entry

    Thanks Doug I did check to make sure I was using the name property in the code for each control. That is why I was confused as to why it doesn't work. There are about 35 controls on the form. Could you tell me a bit more about the about the generic function? Thank you again for your help. I...
  3. bosun

    Change default value to = last entry

    I am working on a data entry form where many of the fields remain the same. I am looking to capture the value entered in each field and use that for the default value when I go to a new record. I have the following code: Private Sub Comments_AfterUpdate() 'declares a variable that will be...
  4. bosun

    Need to combine 5 databases

    COPY THE DATA FROM EACH TABLE. THEN USE THE PASTE APPEND FUNCTION I love deadlines. I especially like the wooshing sound they make as they fly by. -Douglas Adams
  5. bosun

    Old Biostar Motherboard Drivers

    I looked at some general USB pinout diagrams and pins 1 and 5 should be +5V I should be able to find it with a volt meter. Thank you zepper for your help. I love deadlines. I especially like the wooshing sound they make as they fly by. -Douglas Adams
  6. bosun

    Old Biostar Motherboard Drivers

    Thank you for your help. I had very incomplete information from the guy I was helping. He needs to know the location of Pin 1 for the usb connector. I have a diagram of the board, but it doesn't locate pin 1. There is no indication visible on the board itself. I love deadlines. I especially...
  7. bosun

    Old Biostar Motherboard Drivers

    I am looking for drivers for a biostar 8500TUC-A does anyone know where I can find them? I love deadlines. I especially like the wooshing sound they make as they fly by. -Douglas Adams
  8. bosun

    Password Expiration in Microsoft Access 97

    I have built a prototype that I will be incorperating into my programs. I have a user table which contains: UserID UserName Password PasswordDate (For a little added security the user table is named MSysUsers. This effectively hides it from the average user.) When a user logs in successfully...
  9. bosun

    Securing objects using VB

    Thanks, most folks I have deal with would not be nosy enough, but that is a great.
  10. bosun

    Securing objects using VB

    My original thought had been to create a login form that would remain hidden once a valid username and password had been entered. I am glad that will work. Thank you for your help.
  11. bosun

    Securing objects using VB

    Thanks for the help. Frankly I was confused by Access's built in security and this seems simpler and far superior.
  12. bosun

    Securing objects using VB

    I am trying to find a way to secure a database in access 97 to a greater extent than the built in security features allow. My basic thought is to make a table with the following fields: [UserName],[Password],[UserLevel] The idea is that the user would enter their username and password into a...
  13. bosun

    Calculating time differences... with a twist

    That would be great. My address is bill.lyle@monro.com Thanks for the help.
  14. bosun

    Distributed DB suddenly says "Disk or Network Error"

    I currently have five access97 applications distributed on a LAN. I have only received that error when a network connection was lost.
  15. bosun

    Calculating time differences... with a twist

    I have to calculate system down time for a helpdesk application that I am designing. The down time will be the number of business hours between when the system went down and when service was restored. I have the following information to start with: DateSysDn TimeSysDn DateSysUp TimeSysUp...
  16. bosun

    Calculating time differences...with a twist

    I have to calculate system down time for a helpdesk application that I am designing. The down time will be the number of business hours between when the system went down and when service was restored. I have the following information to start with: DateSysDn TimeSysDn DateSysUp TimeSysUp...
  17. bosun

    Combining Text Records

    I did a similar thing when building a form letter. My customer table had the following fields: FName, LName, Address, City, State, Zip In query design view for the query on which my letter was based, I entered the following into the Field box: Address: [tblCust]![FName] & " " &...
  18. bosun

    Can I speed up the response an Access Database on a network?

    Another Possible Help... I have run into this problem before. Where forms especially, take a very long time to load. Check to see if your application is saved in a fully compiled state. to do this go to the code screen and in the debug menu look to see if the compile and save option is...
  19. bosun

    Current time in a field

    Create a text Box on your form In the Data Properties for that text box set the default value to: Time() Then go to the event tab and choose: On Got Focus Click Build and choose macro In the macro choose SetValue In the Item field enter the name of the text box In the expression field...
  20. bosun

    Query parameter ?

    Try this in the criteria field >=[Enter Start Date] I have used this setup and it has always worked for me. If that is not it look at how you are calling the query. For instance if you are using a command button to open the query and then to open a form based on the query eliminate the run...

Part and Inventory Search

Back
Top