Search results

Thank you everyone! I needed that info on the global variable from MarkK and I did make a macro and called it from the vba that The Doc Man suggested. Everything is working fine now. Thank you, so much!

I am using Access 2016. I used the Query Wizard to create an append query that works correctly. I saved the query with the name pendingAdd_qry. In an Event Procedure on one of my forms, I want to run that query, pendingAdd_qry. My code gets an error on the Execute statement and I just can't...

Thank you, so much!That helped me see clearly. Everything is working fine. I appreciate your help.

I am using MS Access 2016 I have a database that includes 2 tables: blank_tbl blankID blankYear (number) blankDistrict (number - join on districtID) blankInfo1 blankInfo2 blankInfo3 blankFinanceamt blankTrusteeamt blankClose (yes/no) district_tbl districtID districtName districtDioceseNumber...

Fixed! Fixed! Fixed! I had to add Me.Refresh at the top of the button code. The requery still wasn't working when I was creating a new main record and inserting new subform records. Please let me know if you see a problem in my code for looping and inserting. Thanks.

Sorry. I just fixed my requery syntax to Me.subfrm_Allocation.Form.Requery. It appears to requery now. I'll do some more testing. Hope it's fixed. Thanks

I'm using access 2007. I have a mainform and a subform linked properly. I have a button on my mainform that will insert records to the underlying table of my subform when clicked. The records are inserted into the table correctly, but they won't display in the subform until I move off the...

Yes. That works. Thank you so much.

I can't build it in there. It doesn't do the joins right at all. It builds the SQL with "and". That's why I posted in the forum. I'll keep looking.

The auxiliary_tbl contains information about auxilary groups in our organization. Each group has officers: a chairperson, secretary, and treasurer. I want to make a query that lists all the info in the auxiliary table along with the name of the chairperson, secretary, and treasurer. The...

I am using Access 2007. I have a table called auxiliary_tbl. It contains 3 foreign keys (chair, secretary, treasurer) to a table called individual_tbl. I want to make a query on the auxiliary_tbl that includes the corresponding names of the 3 foreign keys in the individual_tbl. Right now I...

I deleted the description fields and added them back in with the text box contol wizard (?) and it seems to be working fine. Thanks for your help.

I saved the database in 2000-2003 format. It seems as if the field called description on the subforms is effecting the calculated totals on the main form (which seems illogical because the calculated values are correct). If I enter a numeric value in the description field (Auxiliary...

I did have an onload event. I removed the event (deleted the rows in the event, then erased the "Embedded Macro" from the onload event. Now, i am able to add numerical values to the description field and it works ok. But as soon as I add a non-numeric value - I get the error. I can...

I've attached my database. The form titled frmEOV displays the correct totals on the main form. If you add data in the description fields on the records listed on either "donation" subform you get an error in the totals on the main form. Sometimes I get the error as I'm tryping. Sometimes...

I'm sorry I wasn't clear. Description is a separate field that does not have any calculations on it. I'll check it to make sure it doesn't have the same name as one of the calculated fields or the amount fields. But I'm pretty sure it has a unique name. I'll send the database.

The control source for the total field in the footer of the subforms is = SUM(Nz([field name])) The control source for the total fields on the main form is = subformname.Form!controlnameofthesubformfootertotal I can make a zipped copy of the db if that will help

I'm using Access 2007 i have a mainform that has 2 page controls. Each page has a subform with a calculated sum of an amount field in the footer. I wrapped each subform calculation in an Nz. All total fields are formatted as currency. the totals display correctly on the main form...

Thanks for your help. I needed to use the On Delete event to save the transaction ID. Everything is working now. Thank you again.

the sql string runs if I hard code a numerical value ( = 32) I don't know how to save the ID of the original transaction for use later in the after delete confirm I don't know how to reference the saved ID in the delete transaction.