Recent content by ctrl

  1. C

    Database with Web as Frontend

    Hi! We have a project (SAD - Capstone Project) that requires us to make a system for a client. We have to do an Order-and-Delivery System, which will also involve a database with a web frontend. We were only taught of how to make DBs in Access and as far as I remember you can't have a web...
  2. C

    check if there are available slots and then if not prompt user

    Sorry for the double post, but what does this do? aTmp = Split(Combo20, ":") For i = 1 To UBound(aTmp) strTime = strTime & aTmp(i) & IIf(i = 1, ":", "") Next i
  3. C

    Good morning to all

    Hello there! Welcome to the site!
  4. C

    check if there are available slots and then if not prompt user

    opo! :) sorry po late reply. thank you po talaga for trying to help me. Yes, there are no errors now though I still got a bit of a problem. I tested if the code works (well, I placed 2 instead of 100) and when I tried running the form, it did not " "verify" (i.e., no message box or anything).
  5. C

    check if there are available slots and then if not prompt user

    Here's the accdb file of the database i'm trying to work on. i hope this does help you to figure out what's wrong. thank you very much for trying to help me.
  6. C

    check if there are available slots and then if not prompt user

    Thank you again, though I'm still getting an error in if Nz( DCount("*","ReservationTable", "[schedule_date] = #" & Format([Schedule_Date],"mm\/dd\/yyyy") & "# And [Schedule_Time] = #" & strTime & "#")) >= 100 as it appears red. I attached two screenshots to this post. I'm sorry I really...
  7. C

    check if there are available slots and then if not prompt user

    I entered the values. Rowsource for Combo20 is "A: 8:00AM";"B: 5:00 PM" , then control source is set to schedule_time.
  8. C

    check if there are available slots and then if not prompt user

    Hello arnelgp! Thank you for your reply! I'm getting an error. Here's what I placed: Private Sub Command26_Click() if Nz( DCount("*","ReservationTable", "[schedule_date] = #" & Format([Schedule_Date],"mm\/dd\/yyyy") & "# And [Schedule_Time] = #" & Combo20 & "#")) >= 100 /* this part goes red...
  9. C

    New Member and New to Access!

    hello kabayan! masaya ako may Pinoy din pala dito! maraming salamat! I do hope that I'll learn a lot!
  10. C

    check if there are available slots and then if not prompt user

    Hi! I want to know what module / vba code should I do to achieve this effect: I'm making a train reservation database. For this problem, I have three fields: slot_number which is supposed to be an autonumber, schedule_date which houses the date which the users can choose, and then schedule_time...
  11. C

    New Member and New to Access!

    Hello everyone! I just found this forum a few hours ago when I'm looking for tutorials for MS Access. I'm new to Access and coding and stuff, but I'm willing to learn, and hopefully one day share stuff I've learned to others. I'm from the Philippines and nice meeting you all :)
See more
Top Bottom