Search results

Thank you so much CJ, I trying to become more familiar with what the code is saying to do, so i appreciate the exposure, works great!

I am tying to create a cmd btn called "Report" that when clicked opens a form [quick report] in dialog window. I have that done easy enough. But what I want is if that form [quick report] is open, and you click the same button "Report" for it to then close the form. Is this possible? I am...

Geotch, I think by trial and error i found i needed to use On Current, seems to be working like I want it to but i i see that results in errors elsewhere i will upload the db. thanks for the reply.

Hello, I am somewhat newer to Access so I am trying to accomplish this without VBA code. I have a form [expense from] that has (3) tabbed controls on it. I want when i click on the second tab [Enter Receipt] for the page to GoToRecord - New. I cant seem to find the right place to put this...

i don't know how to change the criteria of my query to look at the navigation form instead of the original version when i created the form.

I know it ask for a parameter when i transfer the form to a subform on a navigation form. I am looking for somewhere i can learn how to adjust the path the query uses when i embed a form into a navigation form, i have not learned that process yet.

Hello, I am somewhat still new to Access, so i am trying to learn how to make my queries run when they are in a navigation subform. I was wondering if anyone had a good link teaching this, i am having a hard time finding something on line that explains this process well? I keep getting...

Hi I have two list box that control 5 subforms. i have a Run button that works in sorting the subforms according to the listbox. I have a rest button that i want to clear the selections of the listbox and then requery the subforms as if the criteria were null - or return all records. i have the...

Thanks so much Pat, perfect!

I did have the totals showing, so when i removed them, i can now edit the query however, the rest of the query still filters except the reconcile does not show only the false. thanks

hello, I know that i can edit contents in a single table query and it will update the data in the underlying table, but how do i gain the ability to change data in a query when 3 tables are involved? - i am a beginner so i need to try and do this without code. thanks for any tips

Spikepl, i was failing to put the reconcile column in the design table twice, i think that i have a workable solution, not the cleanest but it doing the process now. Thanks to everyone for the help!

I think i did this correctly...

Spikepl, I am a beginner so most of the SQL code was based off what i did in the design view. i have made the adjustments you suggested the query is pulling out the check boxes now, only issue is the small gray parameter box is coming up now with prompting i enter a value for the reconcile...

Please run the Receipt reconcile form for 5/1 to 7/1. what i need is for the query in the form to only show the false records, once i reconcile a record i do not want it to show up any more. thanks

I cannot upload this due to company security. However, more simply stated, i want a query to pull only the fields not checkboxed in a table. In the design query criteria field i have tried, =0,=false,=off,=no, then all without the =, no combination seems to work.

ok, i have a table with many fields, one being [reconcile] i check that box as true in the table. then i have a reconcile form that i use to filter the date, division etc of a query. however, i only want the query or subform query to show the criteria in the reconcile for AND only the check...

I have table.[reconciled] tat allows for a check box. i want to enter in the criteria filed in query design that i only want to see the unchecked or false entries. i have tried writing the criteria multiple ways and i cannot get it to filter out on my sub form query. Any ideas. i will past the...

Select AAexpense.[amount] From AAexpense Left Join AAFuelman ON AAExpense.[Amount] = AAFuelman.[posted amount] Where AAexpense.[amount]<>AAfuelman.[posted amount] Union ALL SELECT AAFuelman.[Transaction date] From AAFuelman Inner Join AAExpense ON AAFuelman.[transaction date]=aaExpense.[date]...

When i write this SQL it returns the same number of records as what is in the Fuelman table and only shows one column named Transaction date but has driver names in it?!? so it has not pulled out the matching records from the expense leaving the unmatched