Search results

I see your thinking now, thanks for help. I still don't understnad why it doesn't pick it up with =null when it does equal null, and that you have to use the isnull. Anyway it doesn't really matter, it works, Thank you

Sorry it does I used a + instead of an &. Thats the Java slipping in there.

That doesn't work either.

How come if it equals null should you have do this. I've never come across anything like this before.

Can someone tell me why this doen't work If Me.Action_Taken.Value = Null Then MsgBox "The 'Action Taken' must be given", vbOKOnly GoTo Exit_cmdClose_Reset_Click End If I've put a break in at the if statment to check that it does equal null and it does but it still skips over it. WHY?

That worked like a treat, just needed to drop the [] around the controls reference in the code you posted. Thank you very much

In the following code how would I make the A1 control reference increase when the i increases i.e when i=2 reference A2, i=3 reference A3. For i = 1 To 33 Forms![Engineer Full Report].[A1].ForeColor = RGB(255, 128, 0) Forms![Engineer Full Report].[A1].FontBold = True Next Any help...

I've tried that already but it wont save because it's not open according to access.

Hi, I've written this subroutine that modifies 2 conditional formats when the 'Finish' button is clicked to the critrea entered in the form 'Control Panel'. This works perfectly but when the form that the conditional formats are applied to is closed and reopened the conditional formats are...

Could somebody please tell me how to set the size that my form will appear when loaded, because it's really annoying me trying to get them to appear at the size I want.

Is there a piece of code I can use to stop a form maximizing on load, so it stays the orignal designed size?

How can I convert a UK Date to a US date in code because for some unknown reason all date literals in a where clause, regardless of where you come from must be in US format. Any help would be much appreicated?

I've written this piece of code to requery a subform but can't get it to work when executed I get the following error :- There is no field 'Forms![Switchboard]![Status not passed to supervisor subform]' in the current record. DoCmd.Requery "Forms![Switchboard]![Status not passed to supervisor...

Worked like a dream. Cheers :D

Hi, I have a combo box which is populated by a table with the fields ID, First Name and Surname. What I want to do is display the first name and surname concatenated and hide the ID column, but populate the field with the ID number. Is this possible?

That still doesn't acheive my objective. I got a more indepth report that opens when you double click a record I just wanted a front screen that gave you a quick overview so you could see which record you needed to look at.

Yeah thats exactly what I want You can't use a subform in a continuous form I've tried Access tells you to change your form type, try it. If you try and use a list box to display the values they don't update for each record so every listbox contains the same values. I've tried both methods.

The thing is I'm using a continous form to list all the engineers there audit score to date, number of audits had and I want there last 5 audit scores listed too. And you can't use a subform or list box on a continuous form to display these. I can retrieve a single value with a domain function...

I have made a top value query that pulls the the 5 latest audit scores a certain engineer has acheived, but now I want them to populate 5 textboxs on a continous form where the engineer in the query equals that of engineer on the form. I can pull values using the domain functions such as...

You can't use a subform on a continous form though and for the purpose of this exercise I need a continous form. As I need to show all the results on one page.