Recent content by Wolff

fair point - must get that appointment with spec savers booked... ;) He could of course attack from the opposite angle - if it is these users then carry out the function, otherwise close the form. Now, where's that smiley of a coat being pulled over the face... :)

I use If NetworkUserName() = "blah" Or NetworkUserName() = "blah1" and it works a treat....

I understand what you are saying, but the table that we are querying only stores the string - as I said, its a very quick very small (300 rows of data which is unlikely to grow) and very simple database. If I get the time i'll get it setup correctly, but its kind of a rush job at the moment...

Sussed it... something you said there made me wonder if the bound column was correct - it was set to 0, changed it to 1 and everything was fixed. I thought column counts started at 0 for drop down boxes? And I am only returning one columns worth of data.... ah well! Must have been the haircut...

No, no Lookup.... its setup exactly the same way as the Day field and Owner field (which work) :confused:

Hi All, I'm creating a small database at work (Access 2000) and want to provide a report function with the option of chooosing multiple criteria. Now, i've done this before on a much larger database, and had absolutely zero problems, but on this database there is one criteria selection which...

Hi All, I think i'm having a bit of a thick week here! I've been asked to create a database which will hold details of servers and the times during the week they need to be operational. I will also need to include the times that they are available for hardware maintenance, software...

Can you not write a query to do the filtering, then send the query results?

If you want to, you can send me a copy of the database (or single form and table) and I can have a play. Its stuff like this that keeps me interested when at work - its fun solving problems!!!

Try it without set, so just reqdoc = "client's tax id number"

Not sure if that would work or not, but then my VBA isn't amazingly good! The way I would do it is: dim reqdoc as string If me.field1 > 5 then set reqdoc = "True" Else set reqdoc = "False" End If And then, yes, reference reqdoc in the html (as if you were referencing a field)...

I would suggest you declare a new variable, then set the variable outside of the html, and then use the variable in the html. Saves any confusion mixing html with IF statements etc! (that, and well, I wouldn't like to try it myself!!)

No problems - just post away if you need more help - if I can't help I am sure there will be people that can!

Yep, you can refence form items, for example, the following line references a field on the form that the e-mail is being sent from : "<b>Impact:</b> <br>" & Me.[Incident Impact] & "<br><br>" The Me.[Incident Impact] is the form.field in this case. There's not really a single tool that I...

If it's already working then you probably don't need to add the reference library. You can check this from within VBA by going to tools, references then just make sure there is a tick beside it. I'm not the greatest with html either, but google was a wonderful tool for that! I've included a...