Search results

Thanks, Paul. As always, you are a wealth of knowledge.

I have two forms, the first of which I'll refer to as my "main" form. The main form has 6 text boxes bound to Table1. There is a one-to-many relationship between the records of Table1 and the Dates table. After filling out the first 2 text boxes of the main form, I want to open up a second...

I would like the label for a text box to read "B&W or Color" for a database of photographs. Access will not accept the ampersand. Since this is just a label, I thought I could get away with using this symbol. Is there a way to get the label to accept the ampersand?

Thanks for your suggestions, Galaxiom.

Given the runtime issue and the imperfect option of creating a fixed number of invisible unbound text boxes, it looks like I'll have to input the data using bound text boxes and simply have a sub-form for the entries to the 2nd table. Usually I prefer to make unbound entries first, review them...

Agreed that there would be a second table involved. But what if you want to enter data through the use of unbound text boxes - using a single form and a "SAVE" button which would be clicked after reviewing all the entries ? If you choose to go the unbound route in entering data for both the...

Hi, jmsjazz. I have the same problem. I'd like to be able to insert x number of unbound text boxes onto a form, after the user indicates the number of text boxes required. I'm certainly not an expert at this, but I do know that creating a number of text boxes beforehand and making them...

I want to set a default value for the date (for both the single date text box and the subform) because the dates relate to historical records from the 1950's and 1960's. If I don't set an initial default, then Date Picker opens up on the current month. The time spent backtracking to the 50's...

On my main form, I have a subform to input multiple dates, using date picker. I also have a text box on the main form to input single dates, again using Date Picker. On entering both the single date text box and the subform, I don't want the (default) date to be visible. I only want the...

I'm using a form to populate a table called tblPhotoAlbums. Fields are: PKid Photographer (id from another table) Volume Date On the form, I'm using Date Picker, but I hate having to backtrack several years (even decades). I'd like the Date Picker to default to a particular year and month -...

Thank you missinglinq. That was just what I needed.

It's similar, but not quite the same. For example, let's say that my first table contains the following: Group ABC 6 Group XYZ 10 Then in my form, I want the 2nd combo box to show a listing of numbers from 1 to 6, if the user chooses Group ABC in the first combo box, but a...

I have a simple db with 2 tables. First table has 3 fields: GroupID, GroupName, GroupNumber I want to populate the second table using a form. On that form are two combo boxes. Users can select a GroupName when they click on the first combo box. No problems there. But for the second combo...

Thanks for the additional responses. For the time being, I've used the "GoTo" option. It seems to work fine. Here is the file I've been working on. Its purpose is to save names in a table. The user keys the name into a form's text box and then the VBA code asks the user to indicate what...

I will give that a try. Thank you, Paul.

I am using an Inputbox in a Function. The user is supposed to enter a number between zero and some other (positive) number. I want to check to ensure that the response falls within this range. If the user keys in a number outside the range, I want to show a message, but I do NOT want to...

It looks good to me. I'll give it a try, Bob. As usual, you manage to get to the end result several times faster than I could have. Many thanks.

I don't think I'll breach the 255 limit. This is the coding that I was trying so far: ================================================ 'Define a variable to hold the number of elements in the array Dim i As Integer i = UBound(sNames) + 1 'State the number of items in the array in a MsgBox...

I'd like to use Msgbox to list the elements of an array, with each element listed below the previous one until all the elements appear within the MsgBox. I imagine I would need to use Chr(13). Is it possible to use some sort of Do Loop within the coding for a MsgBox? PS #1. The number of...

My use of the Split function and arrays came about because I wanted to have a form with one unbound textbox to input names. However, the table has a first name field and a last name field (Fname and Lname, respectively). The Split function works perfectly when the user inputs only 2 names...