Recent content by egstatus

Awesome. Thank you.

Is there a way to find out if a report uses sub reports? I have a sub report that I modified but I need to know what reports use it. [Without having to open each report in the reports object] I was thinking that there may be a way to iterate through each report and print its children (report...

Thanks you all for the help. I was able to fix my issue with the following query: Me.CustID.RowSource = "SELECT CUSTOMERS.CUSTID, CUSTOMERS.Name, From Customers where inactive=0 or CUSTOMERS.CUSTID=" & Me.CustID The Me.CustID is the ID of for the current record being displayed. Thanks

Hi all, I have an application form that contains many fields from few different tables. One of those fields is a dropdown that list all active customers. I just added ‘Inactive’ field to the customer table today, this table is what is used as the rowsource for that dropdown box. The Dropdown...

Hi Everyone, I have a query that I would like to format in a tabular way. (I'm using MS Access 2010) This is a snapshot of the table's data: This is my access query: SELECT [Income Statement Account Rollup Angelo].[Account Type], [Income Statement Account Rollup Angelo].ID...

Thanks. Problem solved.

Hi Everyone. I have a Yes/No Field for which I store the values as -1/0. I display the field in a combobox and they are displayed as Yes/No. The combo box has a list value with 2 entries, "Yes" and "No" with a Default of 'No'. Entering the information in the combobox work as intended, However if...

Thanks Duane, That does the trick. Never occurred me to go that way. One more question.( I don't know if I should start a new thread for this question). I have a Yes/No Field. I store the values as -1/0. I display the field in a combobox and they are displayed as Yes/No. The combo box has a...

Ho do I prevent users from entering fractions of pennies in currency fields? I am using currency as the field type and I have 2 decimal places as the number of decimal places. However the user can type more that 2 decimals @2.3572 for example. Even though when they leave the field the field...

Hi MajP, I tried on the Paint Event of the Details section of the report as suggested but it does not execute at run time either. The code execute when I'm in design mode and use the 'Report View' option (it executes too many times though). It does not trigger if I use the 'Print Preview'. or...

Hi everyone, I've been reading quite a few posts on this topic and I'm not quite clear if there is an easier solution for this than the ones I've read. So many of these post date back for at least 10 years. I hope ms access has changed since. I have a main report with 5 different sub reports...

I have broken down my one table into 4 different tables and use each of those table for each of the subforms. So far its working as intended but I'm still in a testing state. I thank you all for your suggestions. Ed

Hi Duane, If you had no other option but the one I had explained. How would you tackle it? My thoughts were to create a copy of the current record into temp tables and them point each of the copies to each of the sub forms. Then when I'm done creating/editing the forms update the record of the...

Hi everyone, I have a table that contains approximately 200 fields. I have a main form with 4 sub-forms. Each of the sub-forms access about 50 fields of the table. Each of the sub-forms record source use the same table. I have a toggle button where I change from one sub-form to the others...

Hey MajP/Duane, That is exactly it. I'm referencing fields that are on the parent form, but if the child loads first then it errors out. I can trap the error and if at that point I set the source object of the parent form to whatever should be, the code continues to run however the result is a...