Search results

Its tough alright! As you've probably seen, it retrieves the network username through the module without a problem, it concatenates perfectly but it's just that last part where it attempts to write to the textbox, and only ever on the form where records are created, that it plays up. I'll...

Apologies. I've attached (if the filters in work allow me to) the database below. You need to use the User Level Security Wizard to create an additional user and group. Then log on, open "frmCollateralPur" and edit the 'Description' textbox before logging on as a second user and opening...

But all fields are textboxes. And the exact same code works on the other form...

Hi folks, I have 2 forms on a table. Record locking is set to 'edited record'. User 2 goes onto Form 2 and edits record. User 1 goes onto Form 1 and presses 'save' for whatever reason. The save button attempts to set a field (say field1) to some value but gives a run time error 13 'type...

Thanks for the reply Jack Problem is, for all sorts of reasons it's not practical for Form 2 to be a Subform of Form 1. Also the nature and number of tables makes it an even greater mess. Just to complicate things, I'm using the fantastic MouseTrap code. Can some of you experts please try...

Hi folks, I've been playing around VB for days now and I've gotten nowhere on this issue. Hopefully someone can help me: On hitting a save button on Form 1, I need a Form 2 to open + check if the current ID number exists on it. If not then create a new record (only the ID number) in this...

Huge thanks guys for your really quick replies. The .setfocus method works like a dream so I'll definitely use this instead of the other methods I tried out. Interestingly, it wouldn't work without temporarily setting the form to non-Modal as you suggested Rich so thanks again to you both.

Hi all, I hope some of you can give me some inspiration here. I have an Autoexec macro that opens Form1 and Form 2 at the same time. Both forms maximise and Form2 is the one that shows on screen, with Form1 behind it. Both forms are modal. What I need is a command button on Form2 that will...

The code youre using above will only give the network name which, from what I can gather, youre not really interested in. The method I use (rightly or wrongly) is to open a form called frmlogusers which is based on a table called tbllogusers and stamp the user and date/time on it like this...

Thanks Doc Man, I think I'll try holding onto my job so I'll give hacking a miss. Might test out this Timer business on only a few PCs at first because I'm having enough trouble with unreliable hardware as it is.

Worked a treat, huge thanks

Mouse trap question Ghudson This mouse trap is excellent but I THINK I found one loophole. If you change the first name and press save and then change the second name and use the mouse wheel to scroll to another record, it does this without showing the warning. Is this a known problem or just...

Hows it going all? Just a quick question for you experts out there. While the excellent sample database at RogersAccessLibrary will allow me to kick a user off my database in X amount of minutes/hours, has anyone ever needed to kick a user off immediately, and therefore render the OnTimer...

Matt, I went and logged this as an issue with Microsoft and this is the reply I got from one of their support people. I did revoke one users access and things improved significantly. ************************************************** In your case you have indicated that when you open your...

I'm not totally with you JSDART but try setting the Allow Additions back to YES and set the Navigation Buttons to NO. This will then force your user to use your command button although you'll need to guard against the mouse wheel and Edit Menu methods as well to make it anyway secure.

Thanks a lot everyone, I'm going to start testing some of these colours right now.

Hi all, In an attempt to get rid of the boring grey background that seems standard with Access forms, I've been running my first ever database for 12 months with an orange(!) background and blue text. However, it does look a bit over the top and unprofessional so I'm wondering what you fellow...

Thanks ghudson I'll do as you suggested. Getting the computer names will be straightforward as they follow a simple naming convention. The reason I'm asking the question is because some users have a habit of logging onto the database from sub-standard PCs which when (and not if) they crash...

Hi all, Has anyone ever found a way (or a reason) to lock the 'Name' part of the Access 2000 logon box using a command line or batch file? I want to prevent users from logging onto the database from different machines. Thanks for reading this

So it's not just me!! At least once a day every day for the past 2 weeks my Access 2000 database has been crashing and exactly like you, my exit routine log is showing that the users are doing nothing wrong. A compact and repair job runs every night on it. OK my DB isnt split between BE and...