Search results

Thanks for the suggestion. My post is accurate and it is a 1 not a zero. I should have mentioned that the bound column is 1, which is CountyID the width of which is set to zero so all that shows in the list is County. The reason that "All Counties" is in the box when the form loads is that...

Thanks for the response. It's late here so I'll have a look at your blog tomorrow. I should have included one more thing, which is that the bount column of the combobox is 1, which is CountyID, Counties is 2. The width of County ID is zero so only County is displayed in the list. The reason...

Hi I'm an Access hobbyist so my skills are pretty rudimentary, especially in SQL (I've started working on that). I found this code on a website and it serves my purpose perfectly. It took me a couple of days to figure out what's going on, but I now get how the Query works. I just can't figure...

Any Idea why my query doesn't work?

So you're saying I can have the two comboboxes in the header and use their values to set a filter on afterupdate?

Hi. Seems that this should be easy, but I have spent the last two days, trying every imaginable method and have encountered nothing but weird problems. This is a To Do list database, I'll simplify the data for clarity. There are tasks (what you have to do) and two levels to categorize them...

arnelgp Thanks very much. It turned out that it was GroupLevel2, so the syntax is Me.Section.(acGroupLevel2Footer).BackColor = BColor You Sir, are a warrior. I've seen you here for years. Thanks Again

O.K. I figured out the header. It's: Me.Section(acHeader).BackColor =

Sorry, somehow missed the line Me.GroupHeader0.BackColor = BColor If I use that I get the same error

HI -- Tried that and initially got a compile error, on the "Me.PageHeaderSection.BackColor = BColor" line Method or Data Member Not Found I commented out that line, leaving only "Me.Detail.BackColor = BColor" and did not get an error but the color of the detail did not...

Sorry but I'm not sure what you mean by "store the same text strings (names etc) over and over in a database. How am I doing that as opposed to ""Recording the key field" Thanks

This should be simple but I can't seem to figure out how to do it. I want to set the colors of a report to a Public Variable BColor. I'm using the On Load Event and can get it to work with the report detail but the Header and Group Footer are eluding me. This is what the design view of the...

Thanks again.

Thanks for that.

So, just to be clear. The value in the bound column property will end up in the control source property?

O.K I did not realize that bound column was 1 based. In fact, I wasn't even sure what bound column was. I changed it to 2 and it does work. Thanks so much. Any idea why this is happening. I am 100% sure that I chose the correct field in the wizard, and redid the combo box several times...

HI This sort of relates to a question I just posted named "Wrong Data From Combo Box ," but I think it better to post separately. I'm wondering how I can see which field of a table the chosen value from the combobox list will be placed in. Thanks

Hi I have a combo box, that I set up with the wizard, that is entering the wrong value into the designated field of the destination table. The combo box is on a form--frmAccountsInputEdit--used to enter a new bank account into a table named tblAccounts containing two fields: [accountsBank]...

theDBguy Thanks for that. I think that will work but I am anticipating one problem, which is getting the value of the control in a variable. I've run into this before and as I recall it works something like: You open a continuous form and the first record is the current record. When you...

I'll have to go over and see how to attach the database. Problem is that everything is pretty rough and it will require some explaining to understand. I think I have found the problem though. Instead of putting the condition in the DoCommand.OpenForm statement I think I should be putting it...