Recent content by Darla123

Here is a screenshot of what I'm trying to do, I hope this helps, I'm awful at explaining!

Hello. I have a form that has a table as a data source, the table has 5 fields, Field1, Field2, Field3, Field4, and Field5 Field1 is always visible in the form, but I would like to add an "add" button below it to add the next text box for Field2 for the rest of the fields, and also have a...

I changed it to OR, and now my report is all messed up, it's duplicating records, I'll try messing with it a little more to see what's going on. Thank you!

I'm not sure what you mean by putting it on different lines?

Hi everyone. So I have a report that's tied to a query. I have 3 fields on this report. These fields are all in a row If the value of all three fields is a "0", I don't want it to show up on the report. I see how to filter these out in the query, I'm putting ">0" on each of the fields in the...

Hello, I have a form that has 2 date fields on it, Date1 and Date2. These 2 fields are on the same row of the report and are tied to each other (just for internal purposes, not in the DB itself). The control is a query. Normally the fields are listed in ascending order by Date2. Sometimes there...

It comes from the underlying query.

Well, the "reserve" text box is in a section we have called "flag1 footer". I've tried it there. The total box needs to be in the report footer, but I can't get it to sum correctly no matter what section I put it in.

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

Hello everyone! I have a form that has 2 combo boxes on it. MainCategory and SubCategory. Ideally the user selects the main category, and then the sub category, and it all goes into a report nicely. However, I am running into an issue where at times the users are going back in and changing the...

And now that this is working perfectly, they've decided that they want to change it to m/d/yy, like it strips the zeroes off of the month or day if they are entered. Can that be done?

I never could have gotten this on my own, and it works great. Thank you!

Hi Everyone, I have a text box that is bound to a table. There can either be a date or NA or TBD in this textbox. I have achieved this by using a validation rule: IsDate([textbox])=True Or "NA" Or "TBD" However they are requesting that the date format be in m/dd/yy format. I tried entering...

PERFECT!!! Thank you!!

I think that might not work out because they aren't required to have an option for that textbox, sometimes they have to enter data manually.