Search results for query: *

Is there a way to filter columns in Pivot table and show up only certain results within each column using VBA? thanks, Dan.

Is there a PivotTable function or solution which returns starting location of each pivottable in the worksheet? Thanks, Dan.

I would like data in Table1 to compile running sum into table2. Is there a running sum query in access? or it has to be done though VBA? Table1: with the following fields Key Commissions Sales Table2: Key RunningSumofCommissions RunningSumofSales Thanks in advance.

I am trying to create report that will show one field from the database. That field is a memo field and its very long, I would like to break it to the next line at specific places, but I can't break it at specific places because Access Reports doesnt understand \n. Here is a sample field from...

I need to pick up the company name from each line. I can't write a regex that will pick up the string "MUNICH AMERICAN (CNA)" or "MUNICH AMERICAN" from each line. Basically, it has to pick up a string from the beginning of the line to "Treaty" part and it should ignore Totals since it also has...

I am trying to query information from the SQL server and when I am running Make Table Query and it creates it on SQL server instead of in Access. Dim myConnection As ADODB.Connection Set myConnection = New ADODB.Connection Dim rstSource As ADODB.Recordset Set rstSource = New...

Can any please help with concatinating several message fields into the 1 row. from Table1 -> Table2 I have wrote the code but it doesnt work properly. Can you please check my logic or suggest your solution. Thank you. Table 1 Policy Message 01 msg1 msg2 msg3 02 msg1 03 msg1 msg2 Table2...

I need to convert textfile to HTML. Example of textfile below: textfile.txt a. Line 1 b. Line 2 HTML Create HTML page with the Name of todays date. And inside color code the lines and remove a. and b. in front of them until EOF. if first char is a. then line should be red. if first char is...

Is it possible to assign a textbox/label inside report that will get a variable assigned to it. Ex. I am trying to run a function that will calculate results and I want to open Report and show that result. Thank you.

Is there a way i can populate ListBox with Values from One field in Table1 and at the same time populate One field from Table2?

CurrentDb.OpenRecordset("SELECT CompanyList.CompanyCode, CompanyList.REINSURER FROM CompanyList Where Reinsurer = '" & cmbReinsurerName & "'") cmbReinsurerName = "Loyd's" and it Kicks me out is there a way to define the variable within sql statement so it would give an error. it works for all...

I have Billing Table and CashFlow Table Each billingID might have several CashFlowID and each CashflowID might be assigned to several BillingIDs. I need to create many-to-many relationship. Do I need to create intermediate table or its possible to create this relationship with 2 tables?

When running a query in Access it brings up this message box "You are about to update 50 records." is it possible to obtain that 50 and assign it to the variable. I am trying to run several queries in function and I want to turn off the warnings and make a report of all queries.

I want to insert a field into the table, but before doing it I want to check if it exists. Is it possible to check if the table contains certain field name?

DateDifference I need to calculate the difference between two dates and find out how old was the person at particular point of time. I need to find the nearest birthday and cut off point is 6 months. Ex: DOB: 01/01/2000 06/01/2004 Difference is 4 years and 6 months, but nearest birthday...

Is there a function in VBA to swap information between 2 columns? I am thinking of Creating a New Column for temporary storage purposes. After the data will be swapped erase it. Do you think its the right way to approach it?

RateTable Sex Age Dur1 Dur2 Dur3 Dur4 M 30 .5 .6 .7 .8 F 31 .3 .4 .5 .4 M 28 .4 .5 .6 .7 ClientTable Name Sex Age Duration John M 28 2 I need to figure out how to obtain Rate for John based on Sex, Age, and Duration, which should = .5 Is...

I wrote the code and it works perfect except it doesn't update the last field in the table. Can you tell me if you see my error. Thank you. Dim LastPolicy As String Dim MAX_KEEP As Double Dim MAX_CEDE As Double Dim SUM As Double Dim MAX_TO_KEEP As Double Dim MAX_TO_CEDE As Double Dim AMOUNT As...

I have a table with Names and Amounts, I need to total those amounts based on the names before moving to next name. Have a running total per name. I tried doing it but all i get is the sum for all the names. Can you give me a tip please. Thanks

Table ID Name IssueDate Amount Kept GivenAway 01 John 2002 2000 02 Bryan 2002 3000 01 John 2001 2000 01 John 2003 3000 Guys, I need help with VBA. I need to fill in Kept and GivenAway fields which are initially...