Search results

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

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

NO, this is a question regarding stopping the form from starting a new record.

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

The subform record source is a query, so I think it's going to a new record when the focus is given to it. Is there a way to stop that? Can I tell the subform to not add a new record 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...