Search results

If you are only wanting it to ask for a password on database opening: In Access 2000 you can click the tools menu, then security> set database password. It will prompt for a password when the database is opened. This method only checks the password I don't believe it checks for user id. Eric

Finally Got it! If you say it should've worked the other way, I believe you, most likely something I did wrong. None the less, I got it to work here's how if anyone's interested. Private Sub PONumber_AfterUpdate() Dim myTest As Integer myTest = Me.RecordsetClone.RecordCount If myTest <= 0 Then...

Can't quite get it I put that code in and it does work except in the case when a new AFENumber is being entered where there are no related record to get a dmax on. In this case the DMAX () + 1 returns a null. I tried this but it gives me the Invalid use of null (error 94). When I debug it...

One last thing - I hope Hey Pat I thank you for your help! I've learned a lot just from your replies. I understand; however, I've got a long way to go. I was trying it with the leading quote, but I was putting before the quotation instead of after. Needless to say it didn't quite work and I'm...

Private Sub PO_Number_AfterUpdate() Me.Variance_Number = DMax("Variance_Number", "QryVarianceLogForm", "AFENumber = " & Me.Parent.AFENumber & "'") + 1 End Sub IT gives me another error: Run-time error '3075': Syntax error (missing operator) in query expression 'AFENumber = 3R139A.1". It also...

What I've got so far First, Thanks for that tidbit on dmax. I put this in the on click event of a button just for tests I also tried the after update event of the variancenumber box. Private Sub Command125_Click(Cancel As Integer) Me.VarianceNumber = DMax("VarianceNumber"...

Some ideas but can't get them to work I've searched the forum and microsoft for somethings that may work. Forum definitely got close but I can't get it to work...

I'm wanting to know if it's possible to set the value in a control on a form equal to the record number that it is on. I have a Master form and then a subform on it setup as a columnar form. You know how the records on the subform are number per each record on the master form, like master form...

The database I have is more complex than what I have here but for the sake of saving typing I've tried to make it easy. I've been on this the past couple of days and really haven't been able to get anywhere. I've searched the forum for something and found something similar, but it was an...

Thanks Thanks Jon that helps a bunch.

I'm wanting to set up a macro or something else automatic to import an existing database table into the database I'm working on. In the macro I'm using the Transfer Database action. I'm wanting to automatically import a table from an external database. However, I want the user to only select...