Search results

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...

I don't know any reason that it wouldn't. Make sure you add in the Microsoft Outlook reference library within VBA tho!

I'm perhaps not using the best code for this function, but it does what I need it to do! I use a mix of VBA and HTML - the example below is shortened, but will give you a start point if you decide to use it! This is using Access 2000 with Outlook 2003. Dim msgtxt As String Dim Summary As...

I'm afraid I have absolutely no knowledge of Access 2007 :( I take the it the wizard is turned on and you're following through all of that? Other than that, hopefully someone else will be along soon to point you through the rest of it!! Good luck with it - I know its easy in 2000, so can't...

Absolutely - what version of access are you using? I use 2000...!! (we're a bit behind the times here!). Check that the subform is set to allow edits. It works as standard in 2000, but not sure about later versions! If you have the subform set as a datasheet too, that might help.

Need to check, but about to go into a meeting... Set up a one to many relationship between the tables, and then when designing your form, use the wizard to put the subform in, and set your own relationship there - eg table1.ID = table2.ID (or it might be form1.id, but you get the idea!)...