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!

Recent content by THEJOESTER

  1. THEJOESTER

    Having a textbox with calculations be entered into table

    Is there anyway that i can store a calculated value into the table? What do you mean in your last reply? Thanks.
  2. THEJOESTER

    Having a textbox with calculations be entered into table

    I have a table with the following fields: customerID, First Name, Last Name, Zip code, # of seniors, adults, children, payment (cash, credit card, check) and yes/no fields: paid, reservations. The prices are not in the table. I just want the total price in the table, yes I am trying to store a...
  3. THEJOESTER

    Having a textbox with calculations be entered into table

    Hi I am building a reservations program with ticket sales. I have fields such as "adults", "seniors", children. These are also textboxes on a single form. Right next to these I have a textbox for each of them that shows the result of the textboxes times by the price. Then to add all the prices...
  4. THEJOESTER

    Default Value Problem

    Hey Sorry I didn't think of it, all i did was do a "on lost focus" on the text box and the wrote this code: If txtbox.text = "" Then txtbox.text = 0 End If
  5. THEJOESTER

    Default Value Problem

    Hi, I am creating a form and I need it so when you leave a field, it automatically puts a zero in there. I have tried to do this with properties of the textbox "Default Value is 0" I have also put the default value to 0 in the table but when I leave the textbox blank it's just blank, A zero does...
  6. THEJOESTER

    Rounding the current time to next hour PLEASE HELP

    I have solved the problem, thanks
  7. THEJOESTER

    Rounding date to next hour

    Thanks, Works Great PHV
  8. THEJOESTER

    Rounding date to next hour

    SELECT Sum([Seniors]+[Adults]+[Children]+[Family Special]+[Family Extra]+[Comps]+[Group Special]) AS Expr1 FROM Customers GROUP BY Customers.[Train Date], Customers.[Train Time], Customers.Reservations HAVING (((Customers.[Train Date])=Date()) AND ((Customers.[Train...
  9. THEJOESTER

    Rounding date to next hour

    Sorry Typo* The data type is Date/Time with a medium time as the format: (EX: 5:45). Much Appreciated
  10. THEJOESTER

    Rounding date to next hour

    The data type is Date/Time with a medium time as a "medium format": (EX: 5:45). Much Appreciated
  11. THEJOESTER

    Rounding date to next hour

    Hey I copied the TimeValue(Int((Time+#00:59:59#)*24) & ":00:00") into my query under my "Train Time" field so i would look up all the times for the next hour and this is what i get when i try to run it. "Data Type Mismatch in criteria expression" Any ideas? Please Help. Much Appreciated.
  12. THEJOESTER

    Rounding date to next hour

    Hi, this database that I am making is for a train station that has runs on the hour. What I want is the code to make the current time (Time()) to be rounded to the next hour. Example: the time is 9:04, I need it to be rounded to 10:00. I need this so I can use it in queries so I dont have to...
  13. THEJOESTER

    Rounding the current time to next hour PLEASE HELP

    Hey Baltman, I copied and pasted into the MySQL view of the query and this error comes up "Expected DELETE, INSERT, PROCEDURE, SELECT, OR UPDATE and then it points to nNextHour in this statement: nNextHour=1+MOD(HOUR(DTOT(DATE())+CEILING(SECONDS()/3600)*3600),24)
  14. THEJOESTER

    Rounding the current time to next hour PLEASE HELP

    SELECT Sum([Seniors]+[Adults]+[Children]+[Family Special]+[Family Extra]+[Comps]+[Group Special]) AS Expr1 FROM Customers GROUP BY Customers.[Train Date], Customers.[Train Time], Customers.Reservations HAVING (((Customers.[Train Date])=Date()) AND ((Customers.[Train Time])=Time()) AND...
  15. THEJOESTER

    Rounding the current time to next hour PLEASE HELP

    Please explain to me EXACTLY where I would put it. Thanks

Part and Inventory Search

Back
Top