Search results

Is it because there's no 'Else'? Either way taking out the 'End if' should work

Apologies for asking this question but I'm working on my first ever module here. I've got a large chunk of code that I've copied and pasted onto 16 other forms. Obviously it would be much neater to have it once in a module but I'm having problems. Here's a sample of where I'm at...

Works like a dream Rob. Thanks again

Thanks Rob. Am I right in thinking you're using Access 97 because Access 2000 doesnt seem to be recognising the first 2 lines?

Hi all, Can someone pleeeeease give me some help here? I have a table tblLogUsers with 3 fields - UserName, LogonDate and LogoffDate. I need to do some sort of Docmd.GoToRecord on this tables form (frmLogUsers) so that the current user, which is got from a module, is looked up on it and...

But what happens if you want to disable all menus and toolbars on all forms and reports but still have a custom toolbar unhide itself when a report is activated and then hide again when the form is closed?! In other words, I don't want this toolbar to be seen unless a report is active. Is...

You're a top man, works like a dream. I'm going to try out custom-menus as suggested in some previous posts on this site and hopefully that will sort out my last issue. Thanks again for your help Vassago. Andrew

Vassago, you're code was still too complicated for me but many thanks for some other ideas I pinched from it. So here's where I'm at. OK its not pretty but it seems to be working well enough so far. Open the database and then open 'frmHomepage', wait a few seconds and then click the 'CLOSE THE...

Thanks Vassago. Yes I'm using the DB on a network and I've set up the standard Access user-level security. I was thinking of using the CurrentUser and CurrentDate methods which seems to be half working. Pointers in the right direction would be much appreciated because my knowledge of VBA isnt...

I know something similar to this has been posted loads of times before but I I can't find an answer that would be suitable for my DB. Basically I would like to have a table called tblLogUsers, which has 3 fields called 'User', 'DateLogon'' and 'DateLogoff', to be populated when a user logs on...

How about this? Private Sub Form_Current() Me.tabEstimates = 1 End Sub

Youre right, XP doesnt allow you to revert to old versions of documents. Might be worth going through some of the temp folders as this has gotten me out of serious trouble a few times on a Windows 95 machine. The document wont always have the same name as the one you called it so do a search on...

Think Chewy means SHIFT!!

Happened me a few months ago as well and the same official Microsoft fix sorted it out.

Noor, Microsoft explain record locking on Access Help as follows: "When you edit a record, Microsoft Access can automatically prevent other users from changing the record before you have finished editing it. Giving one user exclusive access to a record is called locking. There are three...

Steve Give this a try. On the 'Built-in Menus' category in the customise box, drag the Window menu onto your custom menu bar. Then just drag back all the options you don't want your users to have back into the customise box and this will leave the list of active windows. Let me know how you...

Steve, To go to the last record, try this Private Sub Form_Load() DoCmd.GoToRecord acDataForm, "YOUR_FORM_NAME", acLast End Sub

Pat, I've put your code on the Form_Current() event of the form (one of the 17 main I mention above) but am getting this message: "The expresion you entered has an invalid reference to the Parent property" Where am I going wrong this time?

If you double-click the blank fields in Excel, the #Num disappears in Access. Another Microsoft 'hidden feature'?

I've seen this before when running my database with security. If you log on a read-only user and the table has no records, all the controls on the form will be invisible. Long shot but...