Search results

  1. U

    Urgent!! Calculating totals

    Hi, I have a database assignment for uni, in which i have created a database system for a personal training company. I have been trying to calculate the weekly takings in a report form but have not been able to. For example, in a certain week they may have been 6 sessions conducted, all a...
  2. U

    time and data in access code?

    On my switchboard im trying to display the current date and time, ive retrieved a peice of code but it does seem to work, am i missing something?: 'TO DISPLAY THE CURRENT TIME AND DATE Private Sub Form_Load() txtDayOfWeek = WeekdayName(Weekday(Date), , vbSunday) End Sub Private Sub...
  3. U

    Next button code question...

    Iv got Next and Previous buttons, both of which work. When I get to the start of the record set my error message appears which is great. but when i get to the end of the record set, my error message does not appear. Here is my code, im sure its just a little thing i need to change but I just...
  4. U

    Error code help please

    In my booking system I have buttons that move to the next, previous, first and last record. but wen i click next and when its the end of the record set, it says theres a problem. can you help me write a peice of code for which an error message appears and then loops. my current code is...
  5. U

    Struggling with VBA in access, please help!

    I'm currently designing a database for a "personal training company". I've got code working for things like closing forms, passwords and error messages. Now in my forms, for example the Client Form, I'm trying to use code for the "Next" and "Previous" record button instead of using the wizard...
Top Bottom