Recent content by burrcm

Odd things can be left out if the printer is in draft/economy mode. Just a thought. Chris B

You could even change the text to indicate that an entry had occurred, either by displaying the actual value of the entry or by changing the text to "Completed" or whatever - =IIf ( IsNull (text1) , "No Entry yet", "Completed") or =IIf ( IsNull (text1) , "No Entry yet", [text1]). Chris B

OK. Another thought which might work. Create an unbound text box to use as the label with the control source set to ="some text". Place it directly over the text box where data entry is to occur. Use it's on click event to set it invisible and to move the focus to the entry text box. Set the...

Hide the label and put the text you want to see in the default value. Be aware though that the default value willl be entered in the database if it is not replaced, unless the field is numeric, in which case you will get an error on save (which in this case may be a good thing). Chris B

Sort the table by the County column to get all the Yorkshires together, but it really doesn't matter as you will do this in queries and reports as needed. Chris B

The criteria field is the update to line. Chris B

Create a query containing First Name and Last Name, make it an update query and put my first name code in the criteria field of first name and the other below last name. Save and run the query and it will populate the columns in the table. Chris B

Since there is only one actual form, anything added to on click will always have the same effect regardless of which menu page you are on. I think building your own menu forms rather than using switchboard will solve it for you. Chris B

All items are added via switchboard manager, not in the switchboard design view. Tools - Database Utilities - Switchboard Manager. CB

Yep. Open switchboard manager, click Page 2, Click edit. Now add items. These will appear on page 2. Chris B

Not sure I quite understand, but from the beginning - open switchboard manager. The first page is automatic - Main Switchboard (Default). To create page 2 click New and type a name, say Page 2. Now edit page 1 - click on Main Switchboard, click edit. Click New. You will see three lines. On the...

Max 8 items on any page without major rework, just add another page and reference that from the previous page or wherever you like. You can also add a Back button to move up a level. If 8 to a page doesn't do it for you, don't use a switchboard at all, do it on a custom form with buttons. A bit...

Add the first name and last name fields to your table. Query the table, set the query to update then add the following as the first and last name update criteria. First Name: Left([Name],InStr([Name]," ")-1) Last Name: Right([Name],Len([Name])-InStrRev([Name]," ")) Chris B

You can set the second form to hide the first form when it opens (On Open event), then close the first form when it is closed (On Close event). This avoids the user closing the first form inappropriately. Chris B

Each switchboard page is created on the first page of the switchboard manager. To access a subsequent page from the first page, you edit the first page and add a go to switchboard command. Chris B