Darla123
Last Activity: Nov 30 '15, 03:27 PM
Joined: Aug 14 '15
Location:
-
ok, thank you for looking at it! -
...Code:SELECT tblUserPerms.UserPermsUsername, tblUserPerms.UserPermsMall , DetailData.Mall_Id, Malls.Mall_Name_Short , DetailData.Year1, DetailData.Main_Id , MainCategory.Description, DetailData.Sequence , MainCategory.Order, DetailData.Sub_Id , SubCategory.Description, DetailData.Flag1 , DetailData.Priority, DetailData.Committed , DetailData.Forecast, DetailData.Deferred ,
Last edited by zmbd; Nov 25 '15, 06:43 PM. Reason: [z{Please format SQL, Scipts, Tables using the [CODE/] tool :) }]Leave a comment:
-
No, I hope I'm not working thing wrong and I'm sorry if I'm causing confusion. The source of the whole report is a query, reserve is a field in the query that is pulled into the report. We have 10 different shopping centers in our report and each one has a different value for reserve. That's what I want to total.Leave a comment:
-
The Reserve box is in a group called Flag. I've put it there and I also tried it in the footer and still nothing. I'm tearing my hair out on this one.Leave a comment:
-
The name of the field and the text box are both "reserve". I tried naming the text box something else in case that was the issue and =Sum(FieldName) still didn't add properly :(Leave a comment:
-
I've read through all of that and tried the suggestions in the links, but no matter what, it won't add properly. I'm not sure where it's going wrong.Leave a comment:
-
If I do that, when I run the report a box pops up saying "Enter Parameter Value" for txtReserveLeave a comment:
-
Summing text box values?
Good morning everyone!
I have a report that has a text box called "Reserve" whose control source is from a query, so based on a bunch of different things, the value on the text box is different on every page on the report. I am trying to add another text box that adds up all the different values in "Reserve". I've tried using "=Sum([Reserve])", I've tried using running sums in the properties, and all that ever... -
a popup box?
Hello!
I have a combo box on a form that I need to add a pop up box to if the value selected is "Other". I've been looking around and I see how people have a popup form come up, but I just want a box with a message that they can dismiss. Can that be done? -
data validation?
Hi everyone. I have 2 fields on my form. I am looking for some sort of data validation where if field A has a value of 1, then there are 5 possibilities that field B can have. If field A has a value of 2, there are 9 different possibilities that field B can have. Field A and B are bound to a table. What is the best way to accomplish this? Is there some sort of code I can add? -
validation rule and formatting
Hello everyone. I have a field on a form that is bound to a table that can be either "NA" "TBD" or a date. I have a validation rule on the field like this:
IsDate([Field])=True or "NA" or "TBD"
This works great, but the only problem is that I need the date to be formatted as m/d/yyyy (the don't want leading zeros) and the only place I can think of to set the format is in the table... -
Don't I feel silly now!! Thanks again!Leave a comment:
-
One last question, how do I build date formatting into this? Like the date can only be M/DD/YY?Leave a comment:
-
This works great, thank you so much! I am really learning a lot about access from these boards.Leave a comment:
-
Formatting a field
Hello, is there a way to format a field to only allow a date OR the values "IN" and "OUT"? We want people to be able to enter a date or I/O but nothing else. -
OK, I see what I have to do now, thank you again, you are SUPER helpful!Leave a comment:
-
How do I reference them? Because I was trying that and when I went to start typing, it couldn't find them, and when I just manually typed the name in, it ended up erroring out.Leave a comment:
-
I only have On Enter and On Exit as events for my form. It's a subform.Leave a comment:
-
Auto filling a text box on form close not working
Hi Everyone. I have a text box Text1 that needs to be auto filled from text box Text2 on form close. I've tried adding "Me.Text1.V alue = Me.Text2.Value" to the code under form close, but I get an error. Is there another way to do this? Text1 is bound to a table so I can't use a formula as the control to accomplish it (as far as I know, but I'm awful at this stuff). -
Works perfectly. THANK YOU!!!Leave a comment:
No activity results to display
Leave a comment: