Search results

Can noone help me with this? I only need suggestions on how to do this.. I was hinking about a yes/no field, but then I have to double the code, on the other hand, I can use calculations with larger minimums and maximums, but that takes also a lot of code. Does anyone have a suggestion on how I...

cool, thanks. That sounds much easier then opening the form, retrigering the event and blabla... Thanks fo the tip (btw: maybe a good tip to microsoft, to add vbMsgBoxCenter or something like that ;) )

Think that will work, thanks alot!! If it doesn't work, i will check back sunday (having weekend fri / sat) Tnx! Dennis (Ironis :cool: ) < edit > Oke it works, thanks alot for helping me out on this one :)

I have a little problem with a msgbox. I have predefined the style like this: Style2 = vbYesNoCancel + vbQuestion + vbDefaultButton1 I defined the next code, to give the commands to each button on the msgbox, but it doesn;t work properly. If you enter vbNO, it will trigger the vbCancel...

Ok, tnx it works, Now is there also a command that you can align the text to the center of the MsgBox? Or do I just have to fill in spaces or something like that?

Sorry, 3rd question this hour, but I need the answer ;) I have a few MsgBoxes, and I want the text to be on multiple lines. How can I do that? I know it can be done, but I don't know how. This is the code I have on one of the textboxes: Msg1 = "There are " & spce & " spaces available." &...

I have a planningsystem, which has to plan A-groups full, and after that B groupd. The code calculates if the A-group is full, and will then suggest first other times for reservations, and then if not available it should open a B-group. Now i have two options: 1) Making an 'invisible' checkbox...

FormCode to Module or Class? Hey there, I have a question. I'm working on a planning code, but it seems to get a bit long. Now I want to put the code into modules or classes, to make it more clear to review etc. Can I do this? and if so, how can I do this?

thanx! This might help me on my way HTH Dennis (Ironis :cool: )

Hey there. I don't know if I'm using the right forum now, bu I have some questions about security in Access 2002 (XP) I am building a reservations database, and I also want prepare it to track payments in the future, and when there are email or fax reservations, the system has to be able to...

Well, my code works now. It was the "" in the piece of code for the msgbox. Everything works perfectly now. I removed the whole 'Response' thing, and 'space' works perfectly, but I will rename it, to avoid troubles in the future. I declared all the things you said as variant, and they just work...

So what you mean is that space, enc and swim should be declared as integers? The 'Invalid use of Null' error is being ignored by a simple code: On error goto err >>Calculaton exit sub err: end sub This is how I ignore the invalid use of null. When the calculation is null, the result will be...

Why do yuou want to calculate the age with a constant date.. U coult consider using date functions. Then the age will change on the birthday. Code in After_update. When tabbing to another field, the code will run, and enter the age to the age field. Furthermore on point 2, you made a typo i...

Oke, this doesn't work.. I still get the error when running the code..

Else >>>> Response = MsgBox(Msgs, Styles, Titles, "", "") <<<< If Response = vbCancel Then DoCmd.DoMenuItem acFormBar, acEditMenu, acUndo, , acMenuVer70 MsgBox "Reservation Cancelled", vbOKOnly, "Cancelled", "", "" Else MsgBox Msgss, ""...

Hey I've got a msgbox code error, which I can't figure out.. Can anyone help me? here's the code: Private Sub E9AMLess6() Dim space, enc, swim, enc2 As Integer Dim Response As VbMsgBoxResult Dim Msg, Msgs, Msgss, Title, Titles, Titless, Style, Styles space = 18 -...

Oke, I have used the Dsum function, and it works, but the msgbox doensn't work properly yet. I will find out how to fix that, becouse it is probably a n00by thingy whats wrong with that.. Thanks for all the help you guys! Dennis (Ironis)

k, i will have a look at it. It will be after tomorrow, becouse of a busy cruiseday. I will look into it at tuesday and will let you know. I don't know these functions, so I hope the help-file provides enough info on it. Thanks

Oke, this is the second type I'm typing this, but well, waht the heck :) Oke heres how it should work: People fill in a reservation on the form frmReservation. On the after_update event of the date field, the code should run, and check wether the program isn't already full. This is why i want...

I tried your code, a bit tweaked though, but theres still an error.. Here's the code: Public Sub Planning() DoCmd.SetWarnings False If cmbResProgID = 2 Or 3 Then Dim QryMore6 As QueryDef QryMore6 = DoCmd.OpenQuery(qryCodeSwim9AML) +...