Search results for query: *

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

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

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

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

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

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

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

I am trying to get counts from a table for the current month and whether the Bates are T or M's. The field Bates contains a "T" or "M" on the 6th position. I want to get counts for both T(Trade) and M(Magazine) in that position and the total of both. This is what my query looks like right now...

Hi all, I need help with the following query. I have a view [V_GEN_EMPLEADOS_CON_SALARIO_ZERO] that return all the employees with salary being equal to zero. [There are 4 different companies within the corporation, so the view return records from each of those companies.] This is the view...

Hi, I have a problem with the following query. It is returning the same average for each record. What I'm trying to do is to calculate the average by each positions within the company. Here is my code: SELECT B.CORR_PUESTO, B.NOMBRE_PUESTO, AVG(A.MONTO_NETO) AS AVERAGE_MONTO_NETO FROM...

How do I make the following query to list the result in one row per company instead of 12(number of months) as I'm getting. I'm trying to calculate the sum of salaries paid by company by month. I have 4 companies in my table. In my query below I have specified just for company whose ID is 1 to...

Hi all, I'm trying to create an email address field by using the first letter of a Full_Name, then the Last Name from the Full Name, then add the '@' + CompanyName + '.com'. Here is data I get back after running the query: CORR_EMPRESA NOMBRE_EMPRESA CORR_EMPLEADO NOMBRE EMPLEADO EMAIL...

Hi everyone, I have the following query UPDATE PAYTEST SET PAYTEST.ImageName = "C:\Client\AppName\Images\" & [imagename] & " *.TIF"; This query works fine from access query designer. Now I want to use in vb.net and I can't seem to get it to work. [highlight #EF2929]newPath contains the new...

Hi, I have this query in access: UPDATE PAYROLL SET PayRollToDate = CDate( Format$([PayRollToDate], "MM/DD/") & "2012" ) WHERE Year([PayRollToDate]) = 2010; It runs fime from the query object. Now I want to use it in VBA, I have about 75 tables And I want to use code to do the update. All it...

Hi Averyone, I get an excel file from a vendor and it has an Address Column that it looks as follows: Address 50 MIDLAND AVENUE HICKSVILLE, NY 11801-1510 DEPT 20-8025 PO BOX 5998 CAROL STREAM IL 60197 241 W 26TH ST NEW YORK NY 10001 75 REMITTANCE DR #3011 CHICAGO IL 60675-3011 There is a...

Hi all. I am using access 2003. I have a master table that I update daily with detail records we get from different clients. I am having a problem storing the user name that has the database open to the field: Added_By I have a function in a module that retrives the window user name. However...