Search results

In a quick test: Private Sub Text0_GotFocus() Me!Text0.Text = Me!Text2 - Me!Text4 End Sub worked fine. Jeff

Yes. But you'll have to 'roll your own' as far as letting users edit/delete and stuff. It can be very flexible but is not suitable if you are trying to keep out hackers or ensure a good level of security. On the other hand, in an ordinary office environment where users are not 'techies', it...

It looks as if you're trying to ensure the record is saved before printing (which is a very good thing to do ...) If so, you are being unnecessarily complicated: If Me.Dirty = True then Me.Dirty = False will save the record if it has been edited. HTH Jeff

Try the Office97 Value Pack (On the CD). "Not all file types are installed by default. To add other file types ... Additional file types are ... this is a note at the bottom of the 'Save As/Export', To An External File or Database dialog box. HTH Jeff

You can make a 'Snapshot' of the Report(s) and send the snapshot files as attachments to an email. The recipient will need a copy of the 'Snapshot Viewer' (free download) but it's all quite straightforward. The download is named snpvw90.exe It's about 1.7mb. I use it quite a lot. My clients...

The link will be the same as for the original Main/Sub setup - except that you'll have given the 'new' main form a different name.

This all looks too complicated for me. I use a technique I developed many years ago (before multi select thingys). Put a yes/no field (called Selected, maybe) in your table and on the form (as a check box). Run an update query to set all selected to no when the form loads. When using the...

INT(44/5)*5+5 = 45 INT(47/5)*5+5 = 50 so far so good - but INT(45/5)*5 + 5 = 50 so you need to check Int(n/5). If n/5 and Int(n/5) are the same then n is a multiple of 5 and you don't want to round ... eg If Int(n/5) <> n/5 then use INT(n/5)*5 + 5 end if

If you are using A97 there is a free download (wzmapi80.exe) that allows you to link to Outlook's address book.

a couple of points: Firstly, putting the code on the On Current event of the form ensures that the control is made visible (or not) as you move from one record to another - it will not reveal/hide the control if the combo is altered. You need the After Update event of the combo for this...

Me.Filter = "[Surname] = """ & Me!txtSearch & """" Me.FilterOn = True works on my machine (A97). Are you quite certain that the form is not set to Data Entry? and that Allow Filters is set to Yes? Can't think of anything else (assuming you are entering a valid search criterion in txtSearch)

Do you have the database split with tables in one file (the Back End) and everything else (the Front End) in another file with the tables linked to it - a copy of which is placed on both users' machines? If not you need to split your database. If you have a split database I suggest you check...

Why not use Me.Requery or Me.Refresh instead of all the individual requerying you're doing?

There is only one thing I can suggest ... Me.Filter = "[product_name] = """ & Me.Txtsearch & """" change to Me.Filter = "[product_name] = """ & Me!Txtsearch & """" i.e. change the dot in Me.Txtsearch to a bang (!) Untested theory!

You can certainly get code to run on a new record only ... use the On Current event and test for NewRecord If Me.NewRecord then etc.

Because (I think) you are setting the focus correctly - but the tab keydown event still has to be processed. This moves the focus on to the next control, which is the one following the control you put the focus upon. To stop this put a line in your code: KeyCode = 0 which will 'kill' the tab...

You can't size a checkbox - but you can put a label or unbound control on the form and use its OnClick property to play with the value of the (hidden) checkbox. The label, of course, can be of any size and contain any character you want ...

You want =Nz([Text70])+Nz([Text72])+Nz([Text74])+Nz([Text75])+Nz([Text76] ) I left out the zeros Nz([Text70],0) because that's the default behaviour. HTH

No, you don't have to pay any yearly fee. Maybe he was talking about some kind of support contract (which is, of course, entirely optional).

Put this code in the Before Update event procedure for the text box that holds the EmployeeID (I'm assuming a name of EmployeeID for the table field holding the ID numbers) Dim rs as Recordset Set rs = CurrentDb.OpenRecordset("NameofTableHoldingEmployeeIDs",dbOpenDynaset) ***note: Set etc...