Search results

Hey man, this helped, thanks a lot!

Now that you say it, another strange thing about this checkbox is that I can't uncheck it after I checked it (initially it's unchecked). Could this have anything to do with it?

What do you mean by that? I can change other fields in my form...

This done doesn't work for me either. I still get the error "You entered an expression that has no value" (run-time errror 2427) on this line: If Forms!INPUT_LIGGING!ParkeerCheck.Value = True Then I don't know what's going wrong, but he doesn't seem to know my checkbox. Can anyone give...

Hi all, I'm trying to use an update query, but somehow, it doesn't store anything in my database. This is my code: sql = "UPDATE CONSTRUCTIEF SET ConstructiefScore = " & strGebouwConsScore & " AND ConstructiefCommentaar = '" & strGebouwConsOmschrijving & "' WHERE ConstructiefID = " &...

This works great seth, thanks dude! Freek

Hi guys, If I use an update query in my VBA code (for example, when I click a button), a pop up window is shown to the user. Can you omit showing this pop up window? I don't want to bother my end user with that window. Freek

Lol. I know, it's just for testing purposes :-) Freak

Hi, I try to input data in table 1 with a form that is based on a join from table 1 and table 2. I do a right join, so if there are no records for the join condition in table 1, null values are created. My idea is to change these null values, so 'real' values exist in table 1. Can anybody...

But when you do this, u can't use a simpleform view for your subform, can you? I want to do it like that but don't think it works.. Ciao, Freak

Thanks for the help on this function Christophe. But, with this code Private Sub Text25_Click() Dim rec As Recordset rec = DLookup("algemeenid", "WONING", "woningid=2") End Sub I get the compile error "Invalid use of property". Do you know how to correct it? Thanks. Freek

Hi, I have a problem just executing a select statement. I want the value of a textbox to be determined by a simple select query. I tried to use the Expression Builder but I don't know how to put arguments when using queries in it. For example, you want to select a field 'algemeenid' based on...

Maybe you can make a subform in datasheet view, and make buttons in your (main) form view?

Hi Fab, I think you can just use the Detail view to add buttons or labels and assign actions to it. You can do this by right clicking on them and choosing 'Create Event' or something like that. What programming you need to do the navigation, you can find on the forum here. Use a topic search...