Search results

Ah yes, i was putting it in the page footer, thats why it wasnt working. It now works. Thank you soooo much sean!! I really appreciate it mate!!!!

oh dude I just moved the text box from "Page footer" to "Detail" and it worked! but, the total was then showed after each session and i just want it to show once. Do you know how to create a new heading thing like "Detail" to put it under??

Just tried that Sean but in the text box appeared #Error Any ideas?

Well in the report, the fields to be shown are: SessionID, Session date, WorkoutiD, Workout_type, Workout_cost Total (added in report) I tried things like sum=workout_cost, but i have little experience...

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

mate, thank you so much!! iv been bustin my ass tryin to get that to work! u tha man!!

txtDateTime is a text box in the form yes, txtDayOfWeek is not, however the bloke I got the off didnt have DayOfWeek either, and on his form the date was working and clock was working even with the seconds ticking. I havnt set a timer interval, i dont know what that is. I dont have to put this...

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

cheers mate, appreciate it :)

im talking about my error message, which is: MsgBox "Please click Previous to view previous records.", vbExclamation, "End of Record Set" I want that message to appear when I try and click Next on the last record. any ideas mate?

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

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

Cheers mate :)

oh thank you so much mate. which "else" code are you refereing to tho? code you post it here please. Thank you so much!

yeah steve that was quite complicated lol. if found this peice of code which now works: DoCmd.RunCommand acCmdRecordsGoToNext BUT when it gets to the end of the record set, it shows as a code error. what code can I add for my error message to appear when the end of records is reached

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