Search results

Hi Thanks for that it works fine, just trying to sort out my other problem. Whats the best way to make a calculated field?

ARHHHH! Just tested it again and I have noticed that it changes the colour for the every record not just the one I want! (So if Item 1 has 12 and the qty should be green if I move through the fields they will all be green instead of the colour that correspond with the qty) I have it set on "on...

OK I have wrote a code that works! However it is very long If Me.QTY <= 10 And Me.DofQ = "EA" Then Me.QTY.ForeColor = 255 End If If Me.QTY > 10 And Me.DofQ = "EA" Then Me.QTY.ForeColor = 33023 End If If Me.QTY > 20 And Me.DofQ = "EA" Then Me.QTY.ForeColor = 32768 End If If Me.QTY < 2 And...

Just gone up to 4 so will need to have a think about the code as I also want 3 colours (a red, amber, green system)

Hi I only have 3 at the min so I will try that but it may increase so I will keep trying the code, I have some ideas Thanks for your reply

Hello On my Database I have used Conditional Formattion to change the colour of the qty to highlight when the qty is getting low however its not as good as I would hope as there are different type of definition of quantity (D of Q) e.g. Each (single items such as a screw) and Roll (such as cord...

Thanks for replying. Hopefully shouldnt be to difficult (which normally means it will be LOL). I will have a look when I get home tonight. Thanks

OK I've managed to set it up however When I select to view the report the report is made up of all the fields but (so there wil be lots of letters) however I just want the one that I am viewing at the time Any sugesstions?

Thanks I will have a look. Thought that you could do it but wasnt sure where to start Thanks for your quick replys

Hi I am just wondering if there is any way that you can use access to input information into a letter i.e. you could just click a command button and it would print a standard leter with the details from an address on access e.g. name etc Thanks

The best way is to add a text box then use a comand button (find form) linked to that text box then select find particular field in form Now when you type in the information it should bring up that form and if not it will give you a blank form to fill in

Thanks Obvious now that I look at it LOL Thanks for your reply

Have sorted it It was "macro1" instead of (macro1)

yeah have had a look but cant find any thing. Maybe its just me. Will keep looking

Hi I am wanting help so that I can write a code so that when I select an item from a list box a macro will run the code taht I wrote is If Me.Stockist = "other" Then DoCmd.RunMacro (macro1) End If But it comes up with This action or method requires a macro name argument Any ideas?

Thanks I have just done it

How do I do that? All that I have is Visible- Yes or No.

Hi In my db I have a list box which works fine however I am wondering if there is any way that I can have a text box that is invisible unless "other" is selected in the list box thanks

I have the same type of thing in my DataBase and it works fine in the After Update event.

Hi I have a table with a list of sizes in. The fields are min height, max height, min chest, max chest, and size. I am wanting to somehow make a way of imputting a height and a chest size and getting the corresponding size, so it will need to search greater than the min and smaller than the max...