Search results

Thanks, It worked great.

That would work if I only wanted the value of [919000] but that's not it. I have several option buttons and for each one that is selected a predefined value is assigned to a text box [H919000], [H919111] and so on. for each of the option buttons I have a text box [919000Name], [919111Name]...

Hi, I want to create a variable that will = the name of a control then use that variable to get the value of the control. something like this: On the form I have a text box [919000Name] 'Actually many different named text boxes[919100Name],[919110Name]... In the onclick of a button: For Each...

I'm using a Query to generate the report. I want 10 fields to be displayed in the Page header of the report. Could 1 or up to 10 fields per record. The report displayes many records per page.

How can I have the value of a field within a table displayed in the header of a report for each record in the table? Thanks Paul

What if.... Pat, How does this effect the thoughts? The Dwg Table has about 30 predefined DwgNumbers and DwgTitles.(This is to keep a consistent format. Users are only allowed to select from a list) So initially the data in the Dwg table is not assigned to a Project #. But as projects are...

Thanks Pat, I'll think and try with this info

Yes...Yes Pat, Thanks. So what would be in the "Third Table" ? Would this be a situation to duplicate the data? Third Table ProjectNumber ProjectName DwgNumber DwgTitle ???? I think the Many to Many relationship is what is confusing me. Thanks Paul

I've moved back to the design steps so I have a question If I have a table like this DwgNumber (PK) DwgTitle All Possible Drawing Number and Titles are in the table (38 Total) I want to assign Drawing Numbers to Project Numbers. So I set up this table ProjectNumber (PK) ProjectName I can see how...

Ok I give......:) How about a good intro to dabase design? Website or book. I'm rethinking how I set up what I'm trying to accomplish. Thanks Paul

directormac, It all works fine. It's just that I can't figure out how to add records with-in the "For Each" statement. ie. Dim tbc As Control, pge As Page Dim ctl As Control Dim dbs As Database, rst As Recordset Set tbc = Me!TabCtl97 Set pge =...

Drawing table: [Drawing Number] Drawing Title] Projects table: [Project number] [Project Name] [Drawing Number] Linked to above [Drawing Title] I have a form that allows a user to enter a Project Number and Project Name then select (option buttons) each Drawing Number for the project entered...

Is this the place to ask this??? I have a form that allows the user to select several items using option buttons. When a button is clicked a sub runs to fill hidden text boxes with the data to add to the table for each control in a tab within the form. That all works fine. What I want is to add...

never mind I was setting a value before it was a value Me![Projects.Drawing Title].Value = Me![Drawing List.Drawing Title].Value Me![Drawing Number].Value = ctl.Value should be Me![Drawing Number].Value = ctl.Value Me![Projects.Drawing Title].Value = Me![Drawing List.Drawing Title].Value

Here's what I have. as my comments within the script say this script updates [projects.Drawing Title] one control behind. 'on the first control the value of [Projects.Drawing Title]is NULL???? Private Sub Command153_Click() If Not [Text120].Value = "" Then Me![Drawing List.Drawing...

Now I see, Thanks so much paul

If I set up a table for each Project number I'll have a bunch of tables with the same data except the project number. Is this really the way to do it? paul

Hi I’m new to this so be patient with me. I have a db with 40 fields the unique field is the project number and each field after is a task number. I have a form that uses a combobox [ProjectNumber] to select the project # and then based on that selection I need the next combobox [TaskNumber] to...

Well I thought about what I was trying to do and it won't work anyway but I was still curious if it was possible. thanks paul

Is there a way to have a combobox display more than 20 fields? thanks paul