Search results for query: *

Hi, Disclaimer:I am novice to Access development. I recently was challenged to making enhancements to a db. I am trying to first get through the first hump of getting the header row bolded. I have gotten far enough of being able to display the sheet after it goes through multi queries that...

Hello, I am trying to export spreadsheets through VBA. I get an ActiveX error. This is the code I have, below. There are no ActiveX references in VBA and Monarch.tlb is referenced. I commented out the previous way of getting and creating the Monarch object to directly find the object with the...

I am trying to compare tables and it is comparing within the table in addition to the NEW and the OLD table. For example, a family is listed in the tables like this: NEW table subsc_num last_name 123456789 hubert 123456789 hubert 123456789 smith OLD table subsc_num last_name 123456789...

Hello, Something strange is going on with a query I have. I have a command button on a form that pulls from a query "RejectPercentTPSummary2". When I run the query through the form (command button) it brings up an error box stating "You cancelled the previous operation." But...

Hello, I have a form which contains fields populated by a query when the form opens. The fields can be modified by a user (change the data in the field or fill in a field). I have been asked if it is possible to track the field changes. For example, if the user changes the date field, stamp a...

Hi, I am stumped on how to set focus on a specific field (txtSent) when there is an error. It does show the message box but does not set focus to the txtSent field. Please help, thanks. Private Sub txtSent_LostFocus() Dim Date1 As Date Dim Date2 As Date Date1 = txtSent.Value Date2 =...

I am having trouble identifying duplicates. When I run the query below. I get duplicates including the original record. How could I modify this to get just the true dups? For example, record 1 has duplicates record 2 and 3. I only want record 2 and 3 to show in this query. Please help. Thanks...

When I try to open the database it brings up my startup form but when I try to view the tables through the database window I get an error message "Operation invalid without a current index" When I try to view others...queries,forms I get this other error message " "isn't an...

I have this query that is pulling incorrect data. For example, My Start Date is 06/24/02 and my End Date is 06/24/02. When I run this, it pulls 06/25/02 also. Is this query wrong? SELECT DISTINCTROW INDIV_TP_SUB.CHILD_TP AS TP, INDIV_TP_SUB.SCRUB_DATE AS [Scrub Date], Count(pend_list.CLAIM_NO)...

Is there a way to include the date parameters in the query output? Here is my query: SELECT DISTINCTROW INDIV_TP_SUB.CHILD_TP AS TP, INDIV_TP_SUB.SCRUB_DATE AS [Scrub Date], rejected_scrubReport.REJ_CODE AS [Reject Code], Count(rejected_scrubReport.MEMBER_NO) AS [Reject Count] FROM...

This is really starting to irritate me.=) I am trying to create a query that pulls specific dates and a specific percentage for the totals. When I try to specify a percentage, for example, I want 6% and above to show only, I get output with % under 6 and a few over 6% but not all the records...

What is the easiest way to close a previous form when opening a new form? I have tried macro and coding and both do not work for me. In the macro I first close the form then open the new form. Why doesn't this work? In coding/modules, this is my code: Private Sub Check16_GotFocus() On...

I have a table that contains duplicate values. I want to count one instance of each. For example, the table pend_list has claim_no field with data: claim_no 2215176239 2215176239 2215176240 2215176241 2215176245 2215176247 2215176247 The count of the claim_no should be 5 but I keep on getting...

I have two tables indiv_tp_sub and pend_summary. The fields on indiv_tp_sub are:scrub_date,child_tp,claim_sub. The fields on pend_summary are:tp_num,total,scrub_date. Scrub_date are the same on both tables. Also, tp_num on pend_summary and child_tp on indiv_tp_sub are the same. The below query...

I think my problem is the way they are linked but am not sure. My query does not combine the same tp and date totals. For example, Scrub_date is 6/24/02 and tp_num is RHA. This date and tp is listed twice with different totals, 300 and 1. I want it to combine these as one. So it would show one...

Hello, I am trying to run a query that pulls specific percentages calculated in the same query. When I try to query anything above 1 percent it does not pull the right data. Below is the query. Also, the appended table is set as text ( I have tried different settings but this one seems to work...

I am trying to subtract the date in one field to get another date in another field. For example, the date in ADJ_DATE field is 20020718, I want the SCRUB_DATE field to be ADJ_DATE-1, 20020717. Why doesn't this query work? SELECT pend_summary.RPT_DATE, pend_summary.ADJ_DATE...

I have tried to create a query that shows the last date entered in the table. My table is indiv_tp_sub. The fields are SCRUB_DATE,CHILD_TP,CLAIM_SUB. The table has data entered in weekly, usually. So the scrub date would show for example, 7/10/02, 7/15/02,7/17/02,7/18/02. Based on this example...

I have three tables: edi_current is table with fields:Date, TP, Batch, Bundle, Beginning,Ending,Accepted, Rejected, EDI_Batch pend_summary is table with fields:RPT_DATE, TP_NUM,Pends, Total trading partners is table with field: tradingPartnerNum My current problem is the sum of the pended...

I am trying to export a table from Monarch to Access. The Date format prior to export is 26-Jun-2002. I need the same format as other tables which is 6/26/2002. How can I do this? Please help. Thanks=) cvaccess