Search results

I get the same error, I should be putting this in the conditional formatting screen right, with Expression is: I found if I remove the first =, it gets rid of the error but it still doesn't work. I still get the 1 and 2's in my report.

I've been trying different IIF's but not like your example. I just gave yours a try, but got the following error message The expression you entered contains invalid santax you may have entered a comma without a proceeding value or identifier.

Hi, I have a field on my report, that has either a value of 1 or 2. What I would like to do is, if the value is 1 hide the field, but if the value is 2 I would like it to display 'required' instead of 2. Is there a way to do that with conditional formatting?

found it, I removed this 'If Me.RecordSelectors = False Then DoCmd.MoveSize 0, 0, 8200, 5350 Else DoCmd.MoveSize 0, 0, 8500, 5350 End If

OK, I'm giving this a try, and it's working fine for alternating the colors, but I've noticed it changes the size of my form to a default size when viewed, and it also moves my form to the upper left. Where in the code, can I make it not do that? I don't see anything. I wanted to use this...

I'm sure this is in the forum somewhere, but the search isn't working so I can't find it. I have a Continuous form, and would like the have the row colors alternate to make it easier to read. I found this searching google http://www.lebans.com/alternatecolordetailsection.htm Is this the best...

What would I put in the conditional field screen? Would I select the field that I want to be enabled/disabled and then put something in the expression field?

Hi, I have my main form, with a continuous sub form. On the sub form, I have a dropdown. What I'm trying to do is, if they select a certain value from the dropdown, another field in this form becomes enabled. I tried this on the afterupdate of my combo, and it works but it enables the field...

I'm wondering.. Am I making this more difficult then it needs to be? When I first started designing this, I thought that the provider and clinic needed to be tied together in somesort of relationship. but really as I think about it more, the clinic is more tied to the 'issue' then anything...

I'm having a hard time trying to think of how to do this. I want for each new record in the db, I want the user to be able to select a provider (the rider number is unique to each provider). So I'm going to have a search, or dropdown that allows them to see if that rider number is already...

Thanks, I'm still a little unclear how this junction table works, or what it's suppose to do really. I've never needed to do a M:M before. What I had been planning on doing when I get to building my forms. Is have a main form, that used a subform for the provider. The user would push a...

OK, got word back and yes, there is the possibility of a provider being part of multiple clinics Thank You for brining that to my attention, I just hadn't thought of that :( OK, I created a new table called provider_clinic I added the primary keys from my provider and clinc tables to this...

I think you might be too, and I'm waiting a response back about it. Glad I haven't had a chance to work on this much since I first started this post. :eek:

It was my understanding that it would be many providers to 1 clinic. But now that you mentioned it, I'm going to double check with the owners and verify that this is the case. I don't want to assume that when there could be a possiblity of a provider belonging to multiple. thanks for...

lol wouldn't be a bad idea. Thanks for your help, I think this sounds like a good, and simple solution that allows me to keep things normalized

I need help visualizing how this would work. The only clinic information there is, is the name of the clinic. So the clinic table would have clinic_ID Clinic_name provider table provider_ID Provider_Name rider_number and the third table would have? providerclinic_ID provider_ID...

Ah OK, I've never used the not in list event before so never thought something like that. Doing a search on google is brining up some info on it. Looks like it might work. The only thing I worry about with it, say they go to type in a clinic name which is in the table, but they spell it...

Hi, Just was asked to create a new db Basically it's going to track provider/member information Here is where I'm running into a issue. I have a provider table, it has the name, rider#, and I need to list the 'clinic' the provider belongs too. I orignially thought since many providers can...

Great! that worked perfectly. I was hoping something like this could be done, just didn't know what to search for on the forum. I thought I tried alias too, but didn't see anything. Thanks Again

Just want to make sure I understand what you said correctly, what I have is a lookup table that holds the values I need for the combo box. Then in my form, each combo box uses this table to display it's values. Each combo box is bound to a field in my main table. When an item is selected...