Search results for query: *

Greetings, I am trying to reconcile two tables in Access. Each table contains AccountNames, Trade Prices, Amounts, and Reconciled. What I would like to do is be able to identify in both tables if there is a match, multi, single or no match. I have the single done with no problems however, The...

Greetings, I received a file that has a column formatted as general. I first format the column as text. The contents of the cells in this column contain alph numeric and symbols. I need in my code to be able to scan through each row and if a cell in that column begins with = then simulate F2...

Greetings, I have a PP slide with Excel charts in them. When I was using 2003 version of PP I could open PP and click update links and all was well. The charts udpated... Now with 2007 when I click update links my chart in PP blows up to like 2000% in size. I have recreated the charts using 2007...

Greetings, I am importing a spreadsheet into Access. Prior to importing I have to clean up the data a little. There are some formulas that I want copy pastespecial so I can keep the value of the cell. When I run the code I get error PasteSpecial method of Range class failed. Any suggestions...

Greetings, I am trying to do a Dlookup in a query with Like. I import a table that has acct #s like ###-#####-## (field name [F6]) I want to flag accounts that are on my list. So I created a table called range with a field called ID and added in the first ### (the other digits are NA to me) to...

Greetings, I am not sure how to even pose this question. I have a query that does a group by on a date then sums each category. Each day they have. carried over from previous day, New, Complete, Cancelled, Pending for next day. like so Date.....carry .... new .... comp ... can .... pending...

Greetings, I have put together a macro (recorded) that preforms a count in a column. The macro works great if the numbers of rows do not change or the number increases however, if the number of rows shrinks by 1 then it doesn't work. Do you have any suggestions on how I can fix this? Thanks...

Greetings, I am trying to add the bottom 3 cells in column C. Like in C48, i need to know the sum of rows c47,46 and 45. If I use =sum(offset(reference,rows,cols,[height],[width])) it ask for a reference cell. I wont always know what that reference cell is. Should I be using a different...

Greetings, I have some code that would like to tweak and have it perform better. Previously a VLookup has identified which columns to keep. Then I delete all the others with the macro. There are 60 columns in all. Not sure what I can do. Sub Listonly() Dim i As Long, LC As Long Dim hdr As...

Greetings, I am very new to vba in Excel. It's a whole new world. :) I am trying to see how would I code a macro to select>copy all rows and columns in a spreadsheet that have data in them after I have just deleted unnecessary rows and columns? example when I am in cell A1 and I press...

Reference Thread thread705-1453739 Greetings, I am using CK1999's code I keep getting a debug error when executed. The error says there is Syntax error in from clause. The VBA code errors out at line Set rst = dbs.OpenRecordset(strSql) I don't get it. I've checked my tabel name, field name...

Ok, I am not sure how to explain this but I will give it a shot. I have a form "NewRegUpdate" that has 2 unbound text boxes "Lname" and "Fname" and a list box called "txtsearchresults". TxtSearchResults row source is a query using an Assignments table listing the fields displayed in the...

Greetings, My goal is to take and append/updated loan numbers into a dump table that meet certain criteria. The dump table contains headers "Application Date Null", "Underwriting Received Date Null"....and many more. During the validation process I have queries that check for these errors (null...

Greetings, I have a table that has a Suspened Date, Approved Date and a Denied date. Some records can have a date in all 3 fields, some records can have a date in 1 and not the other, some won't have a date in any field and so on... I am trying to get to the minimium date of all 3 fields and if...

Greetings, I am at a loss with this and have tried several times with no success. Using query design in Access I have a field called "New Investor" it could have a value of A or B or C or AB. In another table there if a field called "Previous Investor" This field contains value separated by a ...

Greetings, little problem. Have a list box made from a table of addresses. Throug the process the user will be prompted to double click on an address they want to add to the shipping manafest. I want that address they double clicked on to be copied to a table using an append query. I have the...

Greetings, trying to add this sql statment to VBA. Keep getting Syntax error (missing operator)starting at the IIF part of the statement. Not that familiar with this. Thanks E SSQL = "INSERT INTO DataTrac ( MITLoan, EscrowBal, Srv_Rel_Date, DateRec, GMACLoan, InvestorLoan," & _ "Funded, PandI...

Greetings, wondering if there are any tips or tricks to getting a form to open maximazied after clicking on a command button. I have tried to size the form in design view then save then open form again. doesn't seem to work. In the properties of the form there is only a width property and not a...

Greetings, in new territory here. pasted this sql statement from a working append query to VB tried a couple of different things to make it work still getting a compile error. Appreciate the assistance. SSQL = "INSERT INTO tblEvents ( BillID, BorID, OpenDate, Status, ClosedDate, Reason,"...

Greetings, I have a text box on a form that its value is populated from an IIF statement. That value is not being stored in a table. I am now trying to store that value in the tblRepurchase table. I have added the field to the table called Status. The text box on the form is called txtstatus...