Search results

Hi all, I'm trying to work out a query in design view, I'm using the IIF statement and was wodering if there's a way to use an else type function? This is what I have working: IIF([field1]=Y And [field2] Between 1 And 5,"Level1,"Decline") This is where I'm trying to get to: IIF([field1]=Y...

hi, I'm not getting anywhere with this... is the only thing I can do is to manually input the value that is automatically calculated?

ummmm.... Maybe technically this isn't what I should be doing? Could you offer any advice then on how I can achieve my requirements? E.g. I want to be able to find out if someone is eligable for a free gift offer, before this is confirmed, details would be calculated: 1. How long have they...

Hi all, Not sure if I've done the right thing but I'm part way there... Ok, what I'm trying to achieve is this: To have a form with various text fields, some are for input but a few would be calculating what values are entered into the forst text boxes, but this data should also be stored in...

It doesn't look like I'm ever going to get the help required...So, how much will it cost me to get this sorted?

Hi sportsguy, I don't seem to be getting this right... I copied your code as suggested and this is what I noticed. When I run the Macro that runs both queries one after the other, I get a popup box prompting me for a parameter value for MasterTable.ID Can we make it so this doesn't prompt...

thanks sportsguy, I'll get on to that in the morning and let you know how it goes :)

I'm probably missing the point here also ;) but in the first post you said What I would ideally liek to show is the customer name once with the invoices listed underneath or to the side.... and for this, doesn't going into properties of the customer name and setting hide duplicates to 'yes'...

Forgot the databse...

Hi all, I've been trying to get a query to work for the last few weeks now but not having much luck...Someone in another forum posted the below SQL but they wasn't able to offer any advice with it and I couldn't get it working in the format it was in. Database Info: 1 MasterTable - Holds all...

Thanks but I checked that first and as there was so much code I didn't / don't know whats what. Maybe I'm getting above myself with this due to it's complexity? But hey if you don't try you don't get... Where can I check this out? Thanks guys

Hi all, I just downloaded an alarm clock db from the sample db's section but before I could post this message the post had gone? I was hoping for someone could explain a little about how, when opening the database, only the form is left on screen? I never knew this was possible and it could...

thanks for your help, could you give me a little more to go on? How can I get the total into the query in the first place when the total isn't stored?

Hi all, Not sure if this is possible or if it is I will be able to get my head around it but here goes. I have a form that has three text box fields each of these are number fields in the table the first 2 are to collect a value and the third adds the values from the first 2 and outputs the...

Thanks for your suggestion, it would work easier I think but due to design restrictions it needs to remain as a combo. :confused:

Hi all, Would you be able to help with a problem I have setting up validation rules on combo boxes? I want to set up the form so that if an option is selected from a combo box the user will have to fill out another field or if a different option is selected from the same combo box they will...

Hi, I have a form that captures data inputted into a text field and a couple of drop down menus. This runs a query and outputs the results to a form. What I am trying to achieve is to monitor what is inputted into the search form. When I hit search a macro is run which opens a form that runs...

Hi, I have created my database, and due to seacurity issues I have created two databases and linked the tables. On the Q & A fields I have set them to Memo, in the table view on both databases I can see all the text that is entered into the field but when I look in form view on one of the...

I have a form that contains a couple of combo boxes and a three text boxes. The combo boxes pull their data from two different fields within one table but they are unbound. This is the Row Source for one of them - SELECT [FAQs_table].[Department] FROM FAQs_table GROUP BY...

That worked a treat! Thanks a lot