Search results

Is your form based on the Appointments table? If it is not disregard the stuff below ... If it is, when you fill in the fields on the form you are entering data into the table. When you click on the button you are copying that data into the table a second time (copying a first time? - for...

Well, your subform is based on a table (or a query based on a table). You need to place rows in this table. Each row must have the CustomerID and one of the products. One way to do this is to create a query based on the Product table. Put the Product name in the query and place a calculated...

Look at the Cycle property for the subform. It needs to be set to all records. Jeff

Put some code in the Before Update event of the Form to check the required controls and pop up a message if a control is null (i.e. empty) Set Cancel = True (as well) to cancel the update and the user will be returned to the form to fill in the missing data. Jeff

Are you using A97? If so, you might try opening the BE using A2K and selecting the Convert option. Repair the converted database and export as 'Earlier Version' (i.e. A97). This has saved a couple of clients when all seemed lost ... There are professional data recovery services available...

Well, that's poser ... If you open the subform as a form in its own right do the labels show then? Jeff

Well, I'd store the user entries, along with other info (user ID, Entry Date etc.) and make sure there is a unique key as well (you can use an Autonumber). If you do that you can still output the results as you currently do, just don't save them. You need to be able to identify an entry if you...

You really shouldn't store calculated results. In general it's better to store all the amounts used in the calculation (qty, unit cost, tax rates if applicable, and so on) and do the calculation again if a reprint of the invoice is required. It is safer to do it this way as you are less likely...

Hayley The first thing I'd do is to change that variable name (where). It's asking for trouble to use a reserved word as a field/variable name. At the very least make it mWhere or xWhere or what-have-you. Jeff

Maybe (just an outside possibility) they don't fit. Have you tried making the subform control bigger (temporarily) to see if they appear?

One quick and easy method that involves no coding: To make the field that receives the focus change to lemon (say)background ... make the field backstyle transparent and the backcolor lemon (or whatever). I know this looks crazy (transparant AND lemon??) but it works! Jeff

oops! pressed the wrong key - sorry ... to continue: One way ( sounds a bit complicated but isn't really). Make a subform that shows all members. Place this on your form and then move it so it lies over your tab control - but is NOT placed on any of the tab pages. Size as necessary. The...

One way ( sounds a bit complicated but isn't really). Make a subform that shows all members. Place this on your form and then move it so it lies over your tab control - but is NOT placed on any of the tab pages. Size as necessary. The reason for doing this is that the subform will 'lie on...

Try: Dim strDate as string strDate = "1020913" then use DateSerial as follows DateSerial(Mid(strDate, 2, 2), Mid(strDate, 4, 2), Mid(strDate, 6, 2)) e.g. MsgBox "Date is " & DateSerial(Mid(strDate, 2, 2), Mid(strDate, 4, 2), Mid(strDate, 6, 2)) gives 13/09/2002 you could format this...

Or, cutting out some repitition (which might make it a bit easier to follow) ... Public Function LoopRecordset() Dim db As Database, rst As Recordset, intb As Long Set db = DBEngine(0)(0) Set rst = frm.RecordsetClone 'Use a Clone of the Forms Recordset rst.MoveFirst 'Make...

From Help: "The Echo method doesn't suppress the display of modal dialog boxes, such as error messages, or pop-up forms, such as property sheets." Are you using a pop-up form? Jeff

If you were working for your company when you wrote the database and did the writing at work then the company almost certainly 'owns' the database. You might be able to make a deal with your company about selling it - you'll know your situation there. Jeff

Temporarily change the report's recordsource to a query with an appropriate criterion. Jeff

The record will be saved whatever its status - unless there is a problem with validation or duplicate keys or requiered data missing etc. in any fields. It's up to you to check any controls (fields) before you try to save. Jeff

'Snapshot' should be the bottom option in the Save As Type drop down box at the bottom of the Save As dialog box. I believe it should be there by default - although you will have to scroll down the list. Jeff