Search results

thanks. i have 2003 and it was designed on 2003. am i at a dead end?

Hi guys I think i already know the answer to this but thought i would check I have placed a database in a shared folder on a server for other users to use. Is there a way for them to use the database without having MS Access installed on each machine (they have MS Office but not Access)...

Thanks JR. tried the code below but now the command button doesnt do anything! Private Sub Command69_Click() Dim mOutlookApp As Outlook.Application Dim mNameSpace As Outlook.NameSpace Dim olApp As Outlook.Application On Error Resume Next Set olApp = GetObject(, "Outlook.Application") If...

thanks again trevor im not overly concerned about the maxmise thing just curious. with regards to opening a new appointment i cant seem to get this to work where ever i try it in the code... it opens the calendar but not a new appointment window... Private Sub Command69_Click() Dim...

sorry trevor, i edited my post when i got it working before you replied... firstly it still opens a new version of outlook - not the existing one (all users have their outlook open and minimised all day). im not sure if this can be helped? secondly - is there a further step to open a new...

thanks trevor, that works great to open the calendar. a couple of things - firslty it still opens a new version of outlook - not the existing one (all users have their outlook open and minimised all day). im not sure if this can be helped? secondly - is there a further step to open a new...

Hi guys I have seen various threads about setting an outlook reminder based on an appt table and then a form. All i want to do is have a command button which opens outlook and opens a new appointment in the calendar for the user to enter the reminder information themselves. Is this possible...

Thanks matey worked great! I changed it slightly so it worked with an error message if the button was pressed without a valid email or was null: Private Sub Command67_Click() Dim strPath As String If Len(Me.PurchaserContact2 & "") > 0 Then strPath = Me.PurchaserContact2 Else MsgBox "No...

thanks. that solves the problem of if its not a valid email but i still get the use of not null error...?

Hi guys probably pretty straight forward but cant seem to get it going... i have a command button to click to send an email to the email address in a field. it works great unless the user has not entered anything into the textbox. and im getting an error if the text box has normal text in it...

thanks guys and thanks bob - i have taken that on board and removed the yes/no from the table so as not to store these results...

sorry, realised you meant explicitly call the 'sub'. I know this involves writing 'call' somewhere but im not sure where? please advise. also do i need to put the code in the forms oncurrent event?

thanks for your reply linq. to be brutally honest i dont understand this bit :o could you explain? thanks again

thanks. ive added a breakpoint so it stops the code at that point. i still cant see a problem as it all looks ok. any other suggestions or pointers?

Hi guys feeling a bit stupid today as i cant figure this out and its pretty simple. i want my checkbox (Exchanged) to be ticked if a date field (ExchangeDate) has had a date put into it. otherwise remain false/empty. ive tried an if function on the after update event of the field...

thanks guys - that code works great for the time being can anyone point me in the right direction for some code for dlookup or recordset to check against and how this works with passwords?

hi guys i have a database that has a checkbox if the stock is in stock. once this item is sold the box is unchecked. for security reasons i wantit to request a password when the checkbox is unchecked so that only tha managers can remove stock from the database. ive had a little search around...

Everything else works behind the error box (and if I press debug, close) so couldnt i just add "on error resume next"?

it seems to work apart from this error - couldnt i add "on error resume next"?

any ideas?