Search results

Good thought Well, it's a good thought and good to know... but when I first open the form I have not actually changed the properties of the form yet. It's just the default form properties. I added a requery on my form current event just to be sure and it made no difference. Thanks

Hi All, I having a problem that is causing much grief because I can't understand what is happening. I don't get the logic here. I have a form with a subform. The subform is displayed in datasheet view. I want to make the entire form (inc subform) read-only unless a user clicks a button. To...

Works Now Thanks Tim, I used your suggestion, it is much simpler. However, it still did not work. I found another error (in the Dlookup) and got it working so I am just posting the code that worked in case anyone has a similar issue some time. Private Sub Form_Activate() Dim IssueIDx As...

Hi, I was hoping someone could explain why the following code does not work. Hopefully it is enough to go on. I would like a form, on opening, to run some code if there is an OpenArg value. In the code below me.MyIssueID is the OpenArg. I am trying to populate an unbound control with table...

Thanks Thanks mailman, your are certainly right about the naming convention. This is my first DB and I sure wich I'd started it right. Now it will take some work to standardize it. Thanks to you too Wayne. Arch

i Wayne, No, I've never got errors. Just the the bizarro query problem. I saved it as 2000 file format. I could save it differently if you think that will help (I'm running 2002). I could also email directly the whole DB. Thanks for the effort. Let me know if you get it going. Thanks /Joel

Hi Wayne, Yeah, I pasted it in. I am attaching part of my Db (whole thing was too big) so you can take a look. The form in question is frmNewIssue. There is not a huge amount of data in the tables so for testing you can use these values: Product: Horizon Rad Station Category: General Issue...

Hi All, This seems like a really simple thing and that's why I am pulling my hair out because I cannot get it to work. I have a simple form with 4 comboboxes, 3 of them are cascading. All 4 boxes are bound to the same table - no join. And in fact, these are the only 4 fields in the table...

Thanks Thanks very much. It was what you said! Arch

Hi All, I'm having a problem getting my multiple criteria query to work and was hoping someone could shed some light. I have a form with three unbound search fields (Product, Category and Issue Name) and an unbound combobox (Issue ID) that would contain all matching records, based on what's...

Does not work either Thanks for the reply Scott, Actually that's exactly what I thought too. I did something similar to what you suggested already (I just referenced the form directly as opposed to setting up a variable) - see below. When I did this it worked but when I went to the tblIssue...

Hi All, After reading many threads in this most valuable forum, I tried to set up a combobox in my form to automatically add a value that a user puts. It's not quite working. I have my LimitToList property set to Yes and have added the code below to the NotInList event. However, when I try...

Reset object properties fixed this Thanks Pat... they were both fine and I guess I'm chalking this up to Access weirdness. In case anyone comes across a similar issue and hence this thread this is what I did to resolve the issue. - I imported the applicable objects into a brand new test...

This is really driving me nuts! I have a cascading combobox (2 combos). The first one works fine... let's me choose values from a table in my DB. The second combobox values will depend on what is entered in the first one. I have a query with 3 fields: MyCategoryID - Bound Column CategoryName...

Bummer Thanks jfgambit Thats what I thought. Bummer though. It's a lot of work to create them esp if you want the record count included. I find that with subforms, the navigation buttons can be confusing for users in their default location. Perhaps in the next version of Access :-)

Hi All, Does anyone know if it is possible to change the default location of the navigation buttons on a form? Thanks! Arch

Hello All, I'm having a small yet highly irritating problems and am hoping someone can help :-) I have a form with a subform. When I tab from the main form to the subform the display shifts so that I can no longer see the main form, only the subform. There are workarounds... I can enable...

Variable not updated at all Hi, Thanks for your response Bob. Although this did not resolve my problem, I'm sure that it will work once I've figured this out. Here is the problem now. In troubleshooting it seems that the issue is that my variable 'OwnerCaption' is not being updated at all...

Hello All, I have a caption on my form that is attached to an option button. I have the form coded so that this caption has it's value depend on a field on the same form. I actually got it to work but if I change the value of the control field that the caption depends on, I would like the...

I'll check out threads on cascading combos Thanks Pat, My form is not continuous - but I will check out previous posts about cascading combos for some hints. BTW - My DB logic does in fact seem backwards but it's really not. It makes perfect sense when you know the full story. Thanks for...