Search results for query: *

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

Hi Everyone, Is there a way I can control how forms/sub-forms load? It seems like the order is not the same every time the application runs and for my application the order is important. I have an MainForm(GrandParent) that have 5 Sub-forms(Parents). Each of the Sub-forms(Parents) within the...

Thanks very much. Great suggestion. It worked. Ed

Hi all, I have a MainForm [Main Page]. This main form has a SubForm [SubformA]. SubformA has 7 subforms [Sections A-G]. I am trying to determine when each of those 3rd level subform(the childs) have focus. I have tried both lines below on the Form Current Event of the Child(section) subforms...

Hi All, I have an access form that I want to change the back color of the field I am in. I'm doing this in the got focus event and lost focus event. Unfortunately due to some requirements I need to display multiple record in the form at once. Private Sub StateCode_GotFocus()...

Hi every one, I have the following query that I created using the query designer in access, I would like to use in in my VBA code: UPDATE 2JMEDTEST SET [2JMEDTEST].BATCH = Trim([BATES]) & "_" & Trim([Invoice Number]) & "_" & Trim([Invoice Date]); I can't get the query to work in vba, I tried...