Recent content by navi95

Right, time to figure this out! Had to put it on the backburner.... Ive got this SQL so far now: PARAMETERS ResStart DateTime, ResEnd DateTime; SELECT tbl_Apartments.Apartment FROM tbl_Apartments WHERE ((([tbl_Apartments].[Apartment]) Not In (SELECT DISTINCT Apartment FROM ( SELECT...

I might checkout the wherecondition another time :) Im happy its working, makes my life that little bit easier now in the database! Thanks :)

Right, after figuring out why the Button wouldnt work, i had to change some of the properties of the subform, I actually went with the Tempvars solution. So the button will create a tempvars called "bknr" and then opens the form using the tempvars as the default value for the booking number...

Right, I have now got the button to at least open the form. I had to change Properties of the subform to allow edits, otherwise the button refused to work. Now I will try the where condition out.

I tried giving it a go...nothing came up. Not even an error asking to debug, which I was expecting since I wasnt sure if I had written the code correctly. I even tried a simple 'docmd.openform "form_edit_booking" ' to see if the button works at all...that also didnt work. Ive checked other...

That looks like exactly what I need! I will have a play later on and let you guys know how I get on...thanks for the quick reply!

Hi all! Im back with another question! Heres the basic outline: I have created a booking application in Access and on my switchboard I have a subform which is based on a query which lists all my current bookings and has the following fields: Booking Nr, Customer ID, Name, Apartment etc...

I finally figured it out, I didnt need the [] when referencing the subform. So my working code is as follows: If Len(Forms!bestellung!Kunden.Form.Name2 & vbNullString) = 0 Then Thanks for all your input guys :)

hmm Ok Ive tried without "value" and Ive also changed it to Name2. No Luck :(

Thats pretty much the same as the sites ive read up so far, I end up with the following code: If Len([Forms.Bestellung.kunden.form.Name.value] & vbNullString) = 0 Then I still think Ive named something wrong in the code as the error message states it find find the field. What am I doing...

Nope not even that, I have the database exporting data when the app is closed so the user needs to the exit button ive coded with VBA to close it. any idea regarding on how I referring to the control on the subform? Im googling around, trying stuff out but nada. Access cant seem to find it, so...

There is no other way to close the form, this database will be used on a PC with just access runtime installed.

How would I apply this same validation check to a field in the subform? Ive tried using code like if len([Forms!bestellung!Kunden.form!Name.value] & vbnullstring = 0 No joy though. So the form itself is called "bestellung" and the subform is called "kunden" Help?

Thanks for all of the replies! I ended up using: If Len([telefonnummer] & vbNullString) = 0 Then I used this on my button whichs takes you to then next step of the form, works like a charm. Thanks!

Hi guys, I need a VBA which would check if one of the fields is empty before proceeding with the rest of the code. Ive tried using something like: if [telefonnummer] = "" then etc etc but no luck. Ive tried setting validation rules on the form itself too, no luck. They dont seem to actually...