Ah-Hah!!
I had everything in Add Mode. Thanks a lot, it works now...
FaurKris
Last Activity: Apr 6 '11, 06:33 PM
Joined: Jun 18 '10
Location:
-
I'm not sure how to change that... All the forms open in Form View.
Shall I post the code for the button clicks?Leave a comment:
-
I understand that. And as stated, the forms all open just fine. However, the forms which need to show live data (not just a printed report so-to-speak) do not show anything at all when loaded FROM the switchboard. Outside the switchboard, everything works wonderfully.Leave a comment:
-
Why are my records not displaying in the Switchboard
I've got some Forms and Filters that are opened via a Switchboard when selected. They all work just fine when I open them individually (outside of the Switchboard). The Forms which only have links to reports, open their respective Reports and display the data without issue.
BUT the Forms and Filters which display live data (and allow for the adding/deleting of records) from the Queries show NO data at all WHEN BEING OPENED FROM... -
Form. At the bottom, Completed.
Although the form, in this state, has all the information removed, you can still scroll thru. There are already some check marks... Filling in the Completed box with the percentage of Sent AND signed is the goal. So when I begin, most of the customers are checked with a SENT. The Completed percentage will be 0%. As the SIGNED copies come back and I check that box, the percentage will rise.
...Leave a comment:
-
Within my form:
I right click the text box for the field "Completed" .
Enter into Properties.
Click Data.
Click the 3 little dots next to Control Source.
Delete the word "Completed" that is in the dialog box and paste your code - compeltely.
Then I click OK.
If I click off the Control Source slection, a dialog pops up saying "The expression you entered has invalid syntax....Leave a comment:
-
posting to a report
I made a form using a bunch of Combo boxes.
Each Combo box takes fromt the same query/table.
Each combo box also takes from the same column (I am choosing from particular customers).
I am using this same idea for multiple combos of the same column to select a few other options like "Time" and "Day".
Everything is working how I want it to.
My lack of understanding... -
Sorry. I used teh exact code you posted.
I also tried Googling and making small changes and such. I even verified the names of the columns. There is Sent, Signed and Completed. So to get a percent completed, I need to sum and divide Signed by Sent.Code:Completed: Sum(IIf([Signed],1,0))/(Sum(IIf([Sent],1,0))+IIf(Sum(IIf([Sent],1,0))=0,1,0))
I feel like a 4th grader! Haha! Too bad I cant just use Excel...Leave a comment:
-
This is what comes up when I enter the code directly into the Query. Vendor Data is my Table......Leave a comment:
-
I appreciate all your help!
I am still getting an operand type error regardless of what I do....
I'm unsure exactly how to procede! I've probably got something else wrong somewhere...
Thanks again!...Leave a comment:
-
This is what I tried first, "=Blahblahb la "
I am now only getting an operand error. I'm missing a parenthesis somewhere? I'm trying to understand exactly what the formula is doing so I can figure it out.... lol....Code:Completed: Sum(IIf([Signed],1,0))/(Sum(IIf([Sent],1,0))+IIf(Sum(IIf([Sent],1,0))=0,1,0)))
Leave a comment:
-
Didn't know it would reduce the picture by so much.......Leave a comment:
-
Attached screen shot. Maybe this will help too?...Leave a comment:
-
Cool! You understand what I need to do...
When I paste the code (after right clicking the text box/Properties/Data/Control Source/pasting the code in the empty box and clicking ok) I get an error saying "The expression you entered has a function containing the wrong number of arguments."
I should say that I deleted the "ReturnedNotice s" text that was already in the control source dialog box before...Leave a comment:
-
I'm very Green when it comes to Access.....
Maybe if I try to explain it differently???
I am querying customers information on a form. The form simply shows their contact information and allows me to add/edit the information. Then of course I can plot a report!
Well, I want to add to my form - a reference for me.
What I want to add are two check boxes and a text box which will display...Leave a comment:
-
How to Sum and Divide two columns in a query
I found that there is something like Sum([col 1]), and I get that....
I have two columns that are populated via check boxes on the form called 'Sent' and 'Signed'. Once checked, the value in the table is a -1.
I need to divide the total sums to get a percentage of signed vs. not signed.
In Access, what would be the formula I enter in the query field (named %Completed) I made to display the answer? I... -
Okay, thanks.
The easiest thing for me to do is the idea of the list box. I added it for SUP, and it did update all the other text boxes like you said it would. I made the form Continuous as well. When I scroll in the second list box, the forst does not change. But after I make my second selection, the first set of text boxes change.....
Is there a command or selection I need to keep each SUP box (and respective...Leave a comment:
-
Yeah, I figured that forms are geared toward displaying just one record..... But there has to be a way to use a single form for multiple records....? Even multiples of the same...
SUP1 and SUP5 was just an example to say that I want to use "SUP" from the field list to display name 1 and name 5 from my column "SUP" in the table. And then of course, their respective row information...
I am looking...Leave a comment:
-
I dont think you missed the mark, perhaps I can explain better. I'm not sure how to post a screen shot, that would be easiest! Also, I have a new post that may be clearer....
I have loads of names. Each name has information that goes along with it (in the same row). I have a form with selected items from the field list for a single name. Those items are called SUP, FIS, etc.
The form allows me to edit or add....Leave a comment:
-
I need to use the same item - But how?
Okay, I have a form and it reads the following from a query:
SUP, FIS, DAY, TIME.
On the report, I need to print out multiples of these categories. For example,
SUP, FIS, DAY, TIME
SUP, FIS, DAY, TIME
etc.
I dont want to just create new tables or queries, since the form also allows me to edit or add information to the table for each category.
I could have as many as...
No activity results to display
Leave a comment: