Search results

Thanks. I suspected it was requery. However my form consist of a form that contains a liked subform; so then what event should be used: on load on current etc. I want all the form requeried.

Good day All. I am on a form "Claims". I leave to add a record to another form "Instructor". When I return to "Claims" the new record added to "Instructor" does not appear in "Claims". It will appear, however, if the Claims form is closed and reopened. Is there a macro that can allow the...

Thanks. I tried this and it works.

Thanks. That is the case.

Thanks for your response. It does have a time value included

Good day All. I have developed my access program in 2013 ver. but has to use it in a 2007 environment. so obviously some things don't work. This query in vba works fine in 2013 but Although it does not trigger an error message it simple give no results in 2007. Can anyone assist? Thank...

Good Day All. Is there a way for the Navigation Pane to hide when an access file is loaded? In fact I would like the user to see only the login box

Thanks. I did try the site but the problem still persist

Good Morning All, I am trying to install SQL SERVER 14. All seems to be going well. When installation is completed there is notification that: Installation is completed with errors. The errors are : Management Tools - Complete --- Cancelled Management tools - Basic Cancelled The two...

Good Day. I am trying to write a simply query on an attachment field for the return of all records which contains attachments. when I used >o not records are returned and when I use Is Null all records return included those without attachments Can anyone assist?

Good Day all, Can anyone send me a link to information on how to code a vba module that would open a table find a record and edit that record? The code is to be trigerred by an event call from a control on a form. Thanks

Good Day All. I have a mainform "Invoices Payments" and its subform is "Customer Payments" which has a field also called "customer Payments" which has an event AfterUpdate which references code and not a macro. The Mainform has a calculated control called "Balance". The "Customer...

Thanks. I am not that savvy, but I would try to learn the procedure

Thanks. This works.

Good day all. My main form is "Invoices" and its subform is "Customer Payments". "Customer Payments" has a field "Payments". Can anyone guide me how to sum the "payments" field but displaying the results in a calculated field on the main form. I even tried summing on the subform but...

Thanks for the suggestion

Good Day all. I would like to know how to have a report updated automatically if a recorded is changed in on a form while the report is opened. My approach was to place a requery Macro on the form to be activated by a click on the form but that is not working either.

Thanks for the guidance; saved me trying so hard to find the solution. It worked but I used a case statement.

Good Day all, My frame name is "Frame1" with Option buttons "Circle" and "Square"; My code line : Name = me.Frame1 however "Name" get a value of 1 or 2 depending on the selection Can anyone tell me how I can get a return of the String Values instead of the Numeric values.

Question: Can a popup show only I record? Or can it be set to show all records?