Search results

Sorry Tony. Try this one.

Tony, I've attached a db which illustrates what I'm trying to achieve. Thanks, Dave

I have a popup form (FRM1) which contains a list of names. When I access FRM1 from another form (FRM2) I double click on the list box and the selected name is returned to a field/control on FRM2. That bit is easy as I just use "[Forms]![FRM2]![Control name]=[Listbox]" on the popup form. I...

Thanks for the help guys. The IsFormOpen function works a treat. Rich, I had already tried the OnActivate option but it wouldn't work. Not sure what I was doing wrong as I had it setup as you suggested. Focus went straight to the first control button but the form didn't requery? Cheers, Dave

I have two forms (FRM1 & FRM2) with list boxes. When either list box is double clicked they open a third form(FRM3). When I close FRM3, I want to requery FRM1 or FRM2 depending on which is open. However, the requery request for the form which is closed throws up an error. I've tried using...

Just a quick note to thank everyone who helped out with this one. Yet again this site and you guys have proved invaluable. I haven't been able to implement the various suggestions as yet due to other issues cropping up at work but I'll let you know how I get on as soon as I get a chance to work...

Hi Autoeng, This is what I had as of yesterday evening. Private Sub Form_Open(Cancel As Integer) Dim UsrLocal As Object Dim Wk As Workspace Dim Usr As String Usr = CurrentUser Set Wk = DBEngine.Workspaces(0) Set UsrLocal = Wk.Users(Usr) 'If IsNull(UsrLocal.password) Then If...

Missed your last question Autoeng.....I decided to pack it in for the day (I'm a few hours ahead of you). I'm using Access '97 on W2K

Thanks Autoeng. I'll try option 2 in the morning. Despite my best efforts I can't get option 1 to work. I was heading in the right direction before your reply but I just kept getting a 'runtime error (3251) - object doesn't support this action' when I try to run "If Usr.Password = "" then"...

Thanks Wayne. That Autoeng link is actually a response to an original question I had on passwords sometime ago. He may also be able to answer this one. Dave

All users are authenticating to a central mdw file at present, each using a unique user id. This allows me to connect the 'Current user' to an employee. Until now, they have been able to enter with a blank password field. However, it's now becoming more important that users can't access using...

Sorry Wayne, I should have mentioned that I'm using a workgroup mdw file to authenticate users. I haven't needed users to have a password until now so I want to build in a check when they logon to force them to password protect their user id. Thanks, Dave

Does anyone have a script which will check the user's password and if blank will open a 'New Password entry form'? I have enough info to build the password entry form but I'm stuck when it comes to checking their current password for a null entry. Thanks Dave

Thanks Fuzzy

I have a 4 digit number field which I want to preceed with the current year to form a unique reference. When I combine, for example, 2003 with 0123 I'm getting 2003123. The zero has been dropped . Anyone know how I can avoid the zero being dropped? sofar... DIM Numfield as string...

Anyone?????........if I'm not making sense please let me know.

Hi folks, I need your help again..... I'm building a db which will record 'Errors'. These errors need to have unique id's. I have two tables and a query. Table A (TBL - Fund errors) records the log date, error reference & error number. Table B (TBL - Maxerr) records the max error number per...

Thanks Matt, that did the job. Always the simple solutions that are hard to see.

Forgot to mention re. the above, [Startdate] and [Finishdate] are both unbound fields on the same form as the list box......you probably already guessed that.

Sorry guys...I need your help again. I have a list box containing several hundred records. The second column (column(1) assuming columns start at 0) contains a log date. I want the user to be able to filter the list box for a specified log date range without having to open a different form...