Search results

I have a form with a combo box and a text box. The combo box uses a query with 6 fields the 6th one is currency. The text box's control source is the combo box's column(5). When a selection is made in the combo box the text box does not display currency. ie text box should be $1.10 and is 1.1 Is...

Here’s some back ground just in case. I have a volunteer table with lots of info. I’m only using the FName, Lname, Email and DateTime fields. What I’m doing is making a method to track each volunteer. I have a form for the volunteer to enter his first and last name (FName & Lname) and to store...

I'm using Access 2002 and when I try to scroll up or down it selects the row and then scrolls 1 row. Is this a bug? thanks Paul

I have 6 tables that have 1 to many relationships. I would like to have all 6 tables on 1 form for data entry. When I use the “Form wizard” and select the tables it wants to group the last 3 tables in 1 subform and it won’t let me add records to the last 2 tables. Same thing happens when I...

Hi, I need the text in the field to allow both lower and upper case but when the user enters "i" (only 1) it changes to "I" , "ii" works just fine. How can I stop this?? I guess I could write an event code like: Dim LowerCase, UpperCase UpperCase = Me![FieldName] LowerCase = LCase(UpperCase)...

tblFAR FarNumID (PK) FarNumber FarTitle tblFarParagraph FarParaID (PK) FarNumID (fk from tblFAR) FarParaTitle FarParaText tblAC ACNumID (PK) ACNumber ACTitle tblACParagraph ACParaID (PK) ACNumID (fk from tblAC) ACParaTitle ACParaText 1.Each FAR contains Many FarParagraph 1 to Many...

I’m having trouble defining Relationships I’m thinking I need a “Junction” Table and I have tried looking at the Orders.mdb but it hasn’t helped (I’m sure I’m just missing something) I just don’t see how it works. If at all possible please don’t just give the info try to help me understand so I...

I have a form with a subform the subform displays the records as they are entered from the main form. Why when I click on the subform is there a new record added from the data in the main form? Is there a way to tell the subform not to add a record oncurrent or onfocus. Paul

I have a form with a subform that simply displays each record added from the input of the main form. What happens is when I scroll the subform to see the last record entered it adds a new record with the info from the main form. I just need the subform to display the records. No editting from...

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...

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

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...

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...

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...

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...

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