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 IamaSherpa 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. BCarruth

    Help with inputting time values and proper formatting

    Thanks for the help, I will try them both tomorrow! Bob
  2. BCarruth

    Help with converting time values

    Thanks for the answer that solved my problem Bob
  3. BCarruth

    Help with converting time values

    I have a calculated time value and would like to see it in decimal values for example: Time value is 5:27 I would like to see the decimal value of 5.45 (I got these values using Excel formulas, but I can't get it to work in Access)
  4. BCarruth

    Help with inputting time values and proper formatting

    I have to input alot of time data into a spreadsheet and I am wondering if there is a way to just be able to put in the numbers and have it format to time for example: I put in 1330 and it converts automatically to 1:30 PM?
  5. BCarruth

    How to limit data in combo box?

    I have 2 controls on a form, one is a text box called "teams", the other is a combo box called "channels". I want to be able to limit the data in the channels control to the team in the team control. The tables involved are Teams with fields teamname Channel with fields channel and teamname...
  6. BCarruth

    Help getting data from internet

    I am trying to pull down info from stock pages into my access database. One way I was told to do this is by pulling the data using SQL. Does anyone know if this is the right road to go down and if so is there anyone who could point me in the right way of getting started ( a tutorial maybe?)...
  7. BCarruth

    Help with calculating birthday's

    Is there a way to create a query that will show everyone who has a birthday either today or in a week?
  8. BCarruth

    Looking for a clock control

    Thanks that worked great. Perhaps you know if there is a way to create a control similar to the ActiveX Date Time Picker control. I want the user to be able to click the drop down box and be able to select a time. I would like a clock like appearance to it if possible (similar to the calendar...
  9. BCarruth

    Looking for a clock control

    Please that would be a great help to me!!!!!!!!! Thanks for the help Bob
  10. BCarruth

    DateTimePicker error message

    Every time I open my form that has the DateTimePicker control on it I get the following error message: Can't set value to Null when checkbox property=FALSE Is there a way around this error without having to set the property to TRUE and checking the box every time you change the date? Thanks Bob
  11. BCarruth

    Looking for a clock control

    Is there an active x control similar to Date Time Picker that simulates a clock?
  12. BCarruth

    Help with Public (Global) variables

    I am trying to create a modified version of Access's User Level Security. My scenario is as follows: I have an opening password screen in which the user will select from a dropdown box their UserID, I have 1 hidden fields on the form that will contain their user level. What I need is to place...
  13. BCarruth

    Code to tab out of a subform???

    Thank you very much!! The code worked perfectly. Bob
  14. BCarruth

    Code to tab out of a subform???

    Is there any way to code a way out of a subform rather than use the control/tab keys (or is it alt/tab keys?)? Thanks Bob
  15. BCarruth

    Help with Undo command

    I am trying to undo changes to a subform's record (not delete the record just undo the changes). I have a button on the mainform called Undo my code behind it is as follows: Private Sub UndoButton_Click() Me.Undo Me.sfmOrderDetailsSTATUSCONTROL.Form.Undo End Sub...
  16. BCarruth

    Opening Word document from Access

    I would like to be able open up a word document using a particular template. I don't know how to specify which template to use. Thanks Bob
  17. BCarruth

    Help with Importing an AutoCad file into database

    I need help in trying to figure out a way to import an Autocad .dwg file into my database, cut and paste some data onto it then print it out. If anyone has any ideas let me know Thanks. Bob
  18. BCarruth

    Security Problem

    Trying to find information on how to set up security on a database so that users can only access the data they are responsible for in the tables. I know the user level security prevents acessing forms, reports, etc. but I have people that I want them to only see their records when they log onto...
  19. BCarruth

    Closing many forms at once

    Is there a way to close 3-4 forms at once. Say that many were open and I wanted to get back to my main menu from the 4th form is there a way to code it so the other 3 forms also close? Thanks Bob

Part and Inventory Search

Back
Top