Search results

Hi, I am trying to get an iff statement to work with a dlookup. So the criteria which are held in a static table can be adjusted by the user without having to amend the query. Unfortunately it does not work and produces the TRUE result only and ignores the FALSE criteria. IIf([CountOfname] &...

Hello, I have had a search through the forums but cannot find anything that is relevant to my issue. Hope someone can help. I have a table with scores and then grades tbl_scoregrade Score,Grade -999,10 133,9 239,8 342,7 449,6 570,5 709,4 785,3 862,2 917,1 I want to reference a field called...

Worked a treat, thanks.

Hello, I have searched through the forum, but cannot find a suitable answer to my question, so here I am. I wonder if you could help me? I have a list of Customers each of which has a Customer ID then I have a list of accounts which may have more than one customer ID. For this senerio I...

Worked a treat thanks.

Hello, I have a combo box on a form which lists some names generated from a table. I would like the selected name to be inputted into the 'critera' of another query called 'qryPBCustLevel' and for that query to be run. I have tried to code this, but it is crashing at the point it trys to add...

But how would I be able to get in then?

Hello, I have a db that I want to password, so that anyone pressing either F11 or holding shift down at the start, will be prompted with a password. .....But, I want the user to be able to see the start-up form and associated forms without having to enter a password. Is this something that is...

Thanks, but.... The query is completly seperate, sorry, I should not have included it. I tried using a form to input the data, but its doesn't work. See code below. Private Sub btnMEP_Click() Dim DateFrom As Date, DateTo As Date If MsgBox("Please note: this process can take up to 5 minutes...

Hello All, I am trying automate some report printing. I have around 20 reports most of which require a from date and a two date. If I use the code below, it asks for the from a two date on each report print, but the dates are always the same. Is there a way of take a two date and a from...

Worked like a dream Thanks for that.

Hello, I am trying to get a text box to populate my users full name. I have a table with a list of users network names and real names. The table looks like this: fldRACF ' Network Name' fldUserName ' Real Name What I would like to do is perform a lookup on the table and output the real...

Thanks Worked like dream.

I have the following code, which is used to validate users and forward them to a sample form. I have a table with user IDs in and the code compares the users ID with IDs in table and either lets them go forward or kicks them out. N.B. It also calls an audit process, but this is fully working...