Search results

Sorted Thanks KenHigg and DocMan... spot on :) Actually, it was hard to spot as there were no missing references. In fact, the user could do everything in the DB except one thing (auto email send via Lotus Notes). There was a reference to DAO3.6 Object Library and looking at my PC (and...

We have a shared DB on the network (slipt front/back ends). Everyone can use the DB seamlessly except one user, who receives the following error when they try and close a form (which has some code). Error 2447: There is an invalid use of the .(dot) or ! operator or invalid parenthesis You may...

I use a piece of code I found here and have modified it so if a user selects a certain option from a combox on a form, it will send the email to a specific group of people. I have some code on the 'onClick' property behind the 'Close' button on my form: Private Sub Close_Click() On Error GoTo...

Sorted Figured it out :)

I have searched and can't find any posts related to this: I have a form where the user can click a button and it sends an email to a Lotus Notes user. The recipient and body of the text is pre-defined. What I would like to happen is, when the user creates the record, an email of the contents...

That did it! Thanks Mailman. (syntax gets me every time)

Having a bad hair day with a filter. Currently, I have a filter that shows all records with yesterdays date: Me.tblChanges.Form.Filter = "((OpenedDate=date()-1))" This works fine... but now the user would like to see all records between yesterday and the previous 14 days (ugh!). Any...

Excellent! Thanks all for the assistance.

Thanks for the reply. I want to avoid using security... it's a really basic app. The reason we want to capture the ID is because we want to track who is raising records (so we can spank them when they get it all wrong).

*Access97* Had a look but can't seem to find anything related. My DB is split on a network. I have a form with a textbox called WHO. The ControlSource of WHO is =UCase(USER()) (USER is a module) - basically, this captures the user's ID from their NT logon session and displays it on the form...

It works! Thanks to both of you :)

*Access97* I have a form with a textbox called [ImplementationDate]. The user is free to enter a date into the textbox. What I am trying to achieve (unsuccessfully) is a way where the user cannot enter a date unless it is at least 14 days greater than todays date. I have tried...

I want to be able to change a forms RecordsetType property to 'snapshot' to prevent edits. The macro or VB to do this is run from a button on a different form. I have tried this with the a macro but no joy. Trying now with VB. It looks like the form must be open to change the property so I am...

Pat/Colin - when I'm all growed up, I wanna be just like you :) Cheers

I have a textbox 'Duration' whose control source is =DateDiff("n",[DurationFrom],[DurationTo])/60 All data is stored in a table. This sort of works if the times entered in DurationFrom and DurationTo are nice and round (like 10:00 11:30 which would return 1.5hours) I get problems when times...

OldSoftBoss Excellent :) That did the trick. So what is the difference between acCmdSave and acCmdSaveRecord?

Access97: I have a form with a date field. After the date is entered I run a DoCmd.RunCommand acCmdSave and then a requery. The form does not close but stays open for the user to perform another action. My problem is this: When I test the .MDB (no split - just a straight .MDB), no errors...

Hi DJN This works a treat :) I removed the msgbox from the module as this would require the user to click 'ok', which sort of defeats my purpose. Now, they just get ejected. Thanks a heap.

Hi The-Doc-Man I see now. Looks pretty straight forward. I'll give it a crack. Thanks to you both.

Hi Mile-O-Phile I think I know what you mean. What I was after was a way to eject people once they are in the app. We have an automated backup of the backend and it hasn't been working because users are leaving the app open when they go home.