Search results

Unfortunately that was only an example and the choice could be limitless. The form is used for data entry and viewing. In data entry mode the fields are sunken and in viewing the fields are flat. All this works quite happily but one field is a look up combo from another table (linked by ID)...

Thanks, that bit I understand That was a simple example, now take it one step forward. Assume that the form is more complex with 20 fields that is used for viewing and data entry. I have the switch between modes working well but the salutation is a combo box necessary for data entry. In...

Sorry, bad post Attached is a very simple database. Form "Names1" (data entry mode), is how it looks with a combo box Form "Names2" (viewing mode) is what happens when I put a text box instead of the combo box. How do I get the salutation field in the "Names2" form to show the actual salutation?

In a small application I am using there are two tables. In the main table there is a relationship with another. The main table stores only the Record ID of the item in the second table but a look up box displays the item name. Standard stuff. On the associated form, if I use a combo box, the...

Thanks for that. I spent hours trying to figure out what was happening and the answer is so simple

I have a form which opens a subform when the user clicks a button. The form is opened using the "DoCmd.OpenForm" method. The subform then displays a field that lists all the records in a database. I want the focus to stay on this form until the user selects one of the records. What is...

In this case the columns total 11cm and the list box 12cm I asked this question on another forum as well and the answer I got was to also resize the columns ie 'Redefine widths columns 2 and 3 Dim lngCW2 As Long Dim lngCW3 As Long lngCW2 = 3.15 * 1440...

Attached is a sample database using Access 2000. Access 97 is the same Form1 has the list box width set at 12cms. 3 Columns Form 2 is an exact duplicate except that the list box is set at about 5cm and the event "on current" changes the width to 12 cms Both list boxes are visually the same...

No. Subseqently I have tried this with a mock up form and it seems to work OK but in my real one it doesn't. Could it have something to do with the filed size in the table it is looking up. I will do some further mock-ups to see if I can duplicate it elsewhere

I have a form with several list boxes. There are occassions when I want to change the width of them. There is no question that the width changes but it places a horizontal scroll bar which I don't want. I have ensured that the total width of the columns is smaller than the width of the list box...

Works perfectly Thanks for your help

I have a form with two list boxes showing data from two different tables. The user double clicks on an item in the first list box which puts the value into a separate text box. They then select one or more items from the second list box which combine the answers in the text box. The resulting...

Thanks, silly of me

I use the following macro to print a single record onto a form. What is the equivalent VBA code? Action: Open Report Action Arguments: [RecipeID]=[Forms]![Recipes]![RecipeID]

Thanks that seems to work If I do the following code Me.TextField = Me.TextField & vbCrLf & "text to be added " Me.TextField.SetFocus Me.TextField.SelStart = 10000 it adds the text at the end of the existing text but on a new line. Because the memo field will never be that long...

Forgive me if this question has already been asked and solved. Just point me to the thread. Basically what I want to do is add a specific piece of text to a text field / memo field (at the point where the cursor is) on the click of a button. I then want the cursor to be active at that point so...