Search results

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

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

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

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

Hi! So I have a form that has an option group on it. This option group auto fills a text box on the form. That textbox is bound to a table. It's all set up and functional, however when navigating from saved record to saved record on the form, the option group radio buttons don't move. The data...

Hello, I have a report that pulls a date from a query, but they'd like an option where if they don't want to enter the date, they can check one of 2 checkboxes. Check box 1 would return "N/A" and checkbox 2 would return "TBD" I'm not sure how to accomplish this? I've never had to do anything...

Hi everyone. I am really at my wits end with this because I am not an access person at all, I just kind of got stuck with this task. I'm hoping someone can help. So we have a field in a report, and currently, there is a text box with a control source of...