Search results

To determine the names of text boxes on the page, you need to read the HTML for the page. I've found that the Inspect Element feature of google's new Chrome browser is very good for this task. You can right click anywhere on the web page and chose Inspect Element to open a nice editor with the...

Inserted DoCmd.RunCommand acCmdSaveRecord at top of SUB... Same Error, just took longer. I don't get it. The underlying query doesn't rely on any information contained on the main form. To validate the integrity of my "strSQL" I ran it independently and it generated the expected results. I...

this was my other unsuccessful approach: ''If chkIgnoreDNC Then '' ''With Forms![mainform].[subform] '' .Form.Filter = "" '' .Form.FilterOn = False '' .Requery ''End With '' '' ''Else '' ''With Forms![mainform].[subform] '' .Form.Filter = "nz([DNCUntil])<=Date()" ''...

Tried your restructure, same thing. Actually I reversed it to reflect that if chkbox = -1 I do no want a filter applied. I think your example is the same as mine since I set the condition a the top that only gets changed if the chkbox=-1 thanks for the cycles on it...

No, I was just trying to eliminate the WHERE clause from the SQL string. the same error occurs whether the SQL has been modified in the SUB or not from it's original form, that is if the chk box was checked or not. So, if the WHERE clause is in there or not, I get the same error. I use the...

Just found through the immediate window that ?forms![mainform].chkignorednc -1 when the box is checked. so, "-1" = true? That's odd to me. Tried that too in the If statement, same error. I'm stumped. Need fresh air.

Just tried it in AfterUpdate, same error. I guess I'm too much of a newbie too understand your "tried the -1 thing"

Thanks for the response... IF chkIgnoreDNC = TRUE results in same error.

I'm attempting to have an unbound Subform updated based on the click of a Checkbox on my main form. In an attempt to achieve this I've done the following in the chkBox's Before Update Event: Private Sub chkIgnoreDNC_BeforeUpdate(Cancel As Integer) Dim strSQL As String, strWhere As String...

Awesome! Thanks for that. Using the acConstants in the Select Case I was able to follow along better than the MS page's example. I guess I'm still not clear exactly though. I see that it works, but I'm trying to understand the why and how of it. In this code, Private Function fRowSource( _...

DCrake: Thanks for that. So, you can add to the rowsource with the additem method each time through your loop for each row... In my original version I thought I'd hit a constraint because I'd read that the rowsource can only be a string up to 255 characters when you have rowsource type set...

I too was somewhat perplexed by that code. One thing I found was that my VBA / Access2007 environment does not support rowsource type 5 (array) as referred to in that post. That appears to be a feature within VB? I have yet to find a way to populate the listbox in an Access form with an array...

I'm struggling to find a way to fill a Listbox on an Access Form with the contents of an Array that I'd build in a VBA routine. Through searches, I've gotten as far as building a long string and assigning it to the rowsource for the Listbox. Not pretty IMO for my final solution. I made a...

Update: I found another post referring to a "quirk" with A2007 where you have to compile the VBA project immediately before crating the ACCDE. So, I did that, and it compiled successfully with no errors. I then recreated another ACCDE file. This time upon opening the ACCDE file and trying to...

EDIT: I was wrong, I must've still been in the ACCDB file when I thought it was working earlier. It's still not working for me. I've removed any extraneous reference in the VBA Project. Everything works fine in the ACCDB file. Every time I re-save the ACCDE file and open it, I cannot...

I'm stumped. I saved my ACCDB file as an ACCDE for another version of my app. Previous versions of ACCDE work fine. This time, anything that requires VBA does not work. It's like VBA modules are not there. When in the ACCDB version of the file, everything works fine. In the ACCDE...

OK, thanks. I do not have VB6 installed on this machine. Perhaps thats the source of the message. With regards to the task at hand, hte Demo DB referred to doesn't really show updating the values directly in the flexgrid, it merely produces a from when you click in the cell of the flexgrid...

I've read several posts on these boards regarding the desire to change data in the matrix view that a crosstab query provides, and the dillemas associated with this task. I discovered this link... http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=429&KW=listbox&PID=425#425 with an...

I've read several posts on these boards regarding the desire to change data in the matrix view that a crosstab query provides, and the dillemas associated with this task. I discovered this link... http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=429&KW=listbox&PID=425#425 with an...

Thanks for everyone's input. Given my Excel Userform background where the concept of Bound controls doesn't really exist, my tendency when first approaching Access forms was to program any sort of calculated field in a VBA function. I appreciate the simplicity of creating a calculated field in...