Recent content by pas123

Thanks, the Val(...) worked.

Yes I know....I have just tried to make the texbox display 1.00 in any way and it won't. All it will display is 1

yes and I tried seting it to standard with 2 decimal places.

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

Listbox wasn't wide enough........

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

Pat, Here's the data structure: AC20-11, 1, Chapter 1 Title, a, Section a Title, i, Paragraph i text, 1, SubParagraph 1 Text, A, SubSubParagraph A Text I have tables setup like this: tblAC (PK)ACID ACNum ACTilte tblChapter (PK)ChaptID (FK)ACID Chapter ChapterTilte tblSection (PK)SectID...

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

I found that if I change the autocorrect by removing the i to I entry it is fixed. But I wonder if I would have to change this on all computers or if it would change just by running the database? Thanks again

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

Thanks, FARs and ACs are like books... Chapter "125", Title "Aircraft standards", paragraph "a", and Text "actual text for paragraph". I think you may have set the path for me. I think I got cought in the fields and forgot the tables.... I'll let you know.

Wait, as I've seen in other posts that would not be the thing to do.

Perhaps I should just include the FarNumber and FarParaTitle in the ACParagraph table. And include the ACNumber and ACParaTitle in the FarParagraph table....