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!

Register Log in
  • Congratulations Rhinorhino 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: THEJOESTER
  • Order by date
  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
  16. THEJOESTER

    Rounding the current time to next hour PLEASE HELP

    Sorry guys, but I am a stupid beginner. Where would I put this code? I don't know where I would put this code. I already tried some places but didn't work. Thanks.
  17. THEJOESTER

    Rounding the current time to next hour PLEASE HELP

    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...
  18. THEJOESTER

    Adding up Yes values PLEASE HELP

    Ok, I have a more complicated situation. I have one table with fields: CustomerID, Train Date, Train Time, First Name, Last Name, Zip Code, Adult Tickets, Children Tickets, Senior Tickets, Payment (list box cash, check, CC), Reservations (yes/no). I need the text box to count up all the...
  19. THEJOESTER

    Adding up Yes values PLEASE HELP

    Hi, is there any way i can add up the yes values in a table and view them in a textbox/label in a form. For example, My table contains the field for reservations. The values are yes/no, but on the same form that I am making the reservations, I need to know how many reservations there are. so I...
  20. THEJOESTER

    Program w/reservations, HOW TO SEARCH NAMES W/RESERVATIONS

    Would I use this in a query?

Part and Inventory Search

Back
Top