gam3r

Im doing this for a college project and im not very good at visual basic

Im coding some bits in Access database just little validation rules and stuff but why wont this work? I think there is a problem in the first line of code but im not sure how else i can get it to function withthin these parameters.

Here it is:

The error access gives me is
Thank you

This coding is in a form btw with a subform

__________________
biggest NOOB ever :P

DaWei

Possibly you misspelled this? "Benefits" is correct. No guarantee it isn't misspelled everywhere, though.

__________________
Abstraction doesn't make it impossible to write bad code; it makes it possible to write superior code.
Contributor's Corner: Grumpy on C++ Exceptions DaWei on Pointers

gam3r

Thanks for replying, i just checked and i have spelt it that way throughout the system so thats not where the error is.

I think i know what it is but i dont know how to get around it. Booking_Day and Bookings.Booking Session is in a subform and i dont know how to address it in the coding. I dont have the help files installed

__________________
biggest NOOB ever :P

DaWei

Been a while since I did VB. If no one comes along with an answer in a few hours, I'll drop a suggestion from a faulty memory. I just wouldn't want to mislead you.

__________________
Abstraction doesn't make it impossible to write bad code; it makes it possible to write superior code.
Contributor's Corner: Grumpy on C++ Exceptions DaWei on Pointers

gam3r

Thank you, i appreciate your help. I don't mind if you give me a wrong solution, i will try it anyway

__________________
biggest NOOB ever :P

Klipt

I haven't touched VB for years, but how is it you can have variable names with spaces in them? If those are variable names...

gam3r

i know that but this is in access so its slightly different those variables are actually field names..

__________________
biggest NOOB ever :P

lectricpharaoh

Not sure about older versions of VB, but in VB.NET, using spaces in your field names will cause problems. The SQL query strings that are created use spaces as a delimiter, so it will make the database queries choke. Use underscores instead, and see if that helps.

__________________
And once again, Probability proves itself willing to sneak into a back alley and service Drama as would a copper-piece harlot.
- Vaarsuvius, Order of the Stick

gam3r

Ok i shall try underscores but i don't think its the spaces that are causing the problem because i have other bits of code that work fine with the in

Thank you very much for your help mate.

__________________
biggest NOOB ever :P