Search results

Well, I am - perhaps incorrectly - assuming it should match the idle closetime, so 50000 for 5 mins, 100000 for 10, and so on. the problem is that this doesn't appear to work. I set it to 100000, then set the code to 10 minutes, but the blasted thing refuses to close. However, if I set 50000...

Hmmm...would that not cause problems given that each of the three tables has records which have unique numbers at their primary keys? So the record with primary key number 1 on database A, for example, is not the same as record 1 with primary key number 1 on database B... ...or are you...

Ok, this is only a very general question, but I'm hoping somebody here can give me some general advice. Basically, I have three separate database which I've written for my company. They were all written at different times, hence the fact there are three and not one that does three things. The...

Try my attachment. This is a stripped down version of a database I wrote for my company, so users could keep track of RMAs (Returned Merchandise). Try to add a new RMA and you'll see my coding at work. A user cannot add a new record until the one they are currently adding is saved. They...

Take a look at my download in this thread. Read my post carefully for instructions on how to bypass the security when you want to look at the code, but try out the Search button I have in the database. It allows you to enter full or partial information and have matching records filter into a...

I'm trying to impliment an autokick when idle process to my database, but am running into a problem and am not too sure how to resolve it. Ok, basically I have an autoexec macro on my database which opens the form DetectIdleTime as hidden. This form has its Timer Interval set to 1000 and its...

Must it be checkboxes? I have a database that includes a fairly powerful search facility that gives my users text boxes where they can enter all or part of a particular field (number, text, date, whatever), and then click a command button and have a list populate depending upon every match...

The search function is your friend...

Indeed it does, since I use it in a small database I wrote for work. Assuming you want this to function at the click of a button, use the following code as the OnClick property of the button: Private Sub cmdSend_Click() Beep Select Case MsgBox("Create a Document?" & vbCrLf, vbYesNo +...

It depends on the type of security you want. If you have a database that only a handful of people are only ever going to use at any given time, you could just lock off the aspects of the database itself. Look at the example I've included. This is a database (you will need Office 2003 to run...

Indeed, but bear in mind that not finding the same results as you is far from indicative of not searching. I hunted high and low but was unable to find precisely what I needed; however, your link is very handy, thankyou!

Yes, I saw that in your original resposne and updated it myself. Thanks, MStef; works great now.

Ah, thanks MStef. Got it working perfectly now. Cheers for sticking with this; it's greatly appreciated.

thanks, GHudson, but I really am having trouble tracking this down. I've also encountered a new problem where, with some client's machines (still running Office 2000 and thus possessing the Access Object Library 9.0), I am unable even to manually update them by simply copying the 11.0 file over...

This is something of a shot in the dark, but does anyone know if it is possible to have a database automatically detect the VB references currently installed? The reason I ask is that I have just finished writing a database with some farily advanced fuctions coded into it. Now most of these...

As rborob says, you can use a popup property to make the sub-form smaller than the main form. If however, you want the sub-form to start minimized, there are two methods spring to mind: Method 1: Use a Macro Go into macros and hit 'New'. For the first row, setup an OpenForm command, then...

Hi Darkwater, Sorry for taking so long to come back to you, but I've been dying of man-flu for the past few days and haven't been feeling in the mood for Access programming! Anyway, I've now recovered and taken a look at your requirements. Please see if the little example database I've...

You call it AllowBypassKey. The command button for bDisableBypassKey can go anywhere you like, on any part of any form, no matter where that form is (or you can - as I do on my database - do away with it altogether and just have the module running).

A nice idea, but only works with unbound fields, which may cause lushh a problem; especially when it comes to fields - such as dates - that require strict input masks. Better to manipulate the AllowEdits variable for the whole form, rather than the Locked variable for each field, by using the...

Or you could have a separate form that contains your buttons, which then lead to different sub-forms depending upon the action to be taken. In this manner, you can control what a user can do on each form, rather than trying to let them do all the jobs on the same form by clicking the buttons...