Search results

Trasfering a large query to Excel will it create new sheets if it reaches Excel 2003's limitation? DoCmd.TransferSpreadsheet acExport, , QueryName, PathNameFileName, True

why do I get the new record (blank row) at the bottom of a query? Hopefully I can explain this well. When you run a query the last row should just contain the last result. In my case when I run it the last row contains the asteric and a blank row to add. This causes the Invalid use of Null error...

Not sure how to do this. SQL or VBA or what. Basically when I import an excel sheet into a table it looks like this: [F1] (first column) Fund: 4329 AccountNumber 13224233 Fund: 3343 AccountNumber 23939393 Fund: 2299 AccountNumber 23939321 Fund: 4329 AccountNumber 39328393 I want this: [F1]...

Not sure what to do. Right now from the import I only have one field in my table (field1). It contains account number followed by 5,6, or 7 rows for the address. I would like to have it On the same row multiple fields It looks like this.. 123456789-00 123 main st Boston, ma 02216...

I can only run it once and it works fine. Then i have to close the database and open it again. If i run it once close the excel sheet then clear the values on my form and run it again it doesn't work. Private Sub ReconReport() Dim dbs As DAO.Database Dim rstGetExportData As Recordset...

Ok, I have 3 Account fields: ACCT, PHAC and TACT and I'm trying to just create one single formula field called ACCOUNT. if all 3 are null or len() < 1 then display "N/A" else I want it to display the actual account.

currently have a string that looks like this: 00000000038683132 I need 386831.32 Thanks,

if isnull({AccountReps.DealerNumber})= true then {AccountInfo.TrustDealerNumber} else {AccountReps.DealerNumber} This is what i currently have. I also want to add that if both {AccountReps.DealerNumber} and {AccountInfo.TrustDealerNumber} are null then use {AccountInfo.AccountNumber} any...

basically i'm having an issue where I can only get 256 characters to export into excel with the code below. I'm under the impression that ADO will fix this. How can I switch it? Dim dbs As DAO.Database Dim reportarray As Variant Dim rstGetExportData As Recordset Dim rs As...

I know how to do this from my computer but it would obviously have to be on the whole time and not locked or anything right? I'm trying to figure out a way to have a report emailed to our support email group daily. If I put the database on a shared drive it wouldn't work either right. I'm...

I've tried a bunch of different things on here, but nothing is working for me. Right now I'm using DatePart("WW", Date(),0) to get the week number. How can I get the date range to show on my report. This is week 29. So it should show today (which is a sunday) 7/13/2008 - 7/19/2008 thanks, QR

I have 2 tables and one table only contains 3 fields: AccountNumber, FieldID and then Fieldvalue. I put this table in a subreport. I want to grab first, lastname and Middlename from this subreport. fieldid 4=firstname, 5=lastname and 6=middlename and place it on the main report. so on the main...

I have a table and there is a field called memo and it starts with Control Number: 3478884803. the first 3 digits are the dealer number so I changed the format to be Mid 18,3. i also have a table called Dealers and it has dealerNumber and DealerName I want to add dealer names into my...

Right now I have this and it works fine: if isdate({?TradeDate})=true then datevalue({FundTransactionLines.TradeDate}) >= DateValue({?TradeDate}) and {FundTransactionLines.FundTransactionSource} = 10 and {FundTransactionTypes.TransactionTypeName} <> "Transfer Purchase" and...

Can someone help me with this error. I know it has something to do with my memo fields but whats a work around?! I'm not sure if its special characters or length or what. 'custom Excel Reporting Dim dbs As DAO.Database Dim rstGetExportData As Recordset Dim objXL As Object Dim...

Hi all, I have 2 list boxes on my form. List7 and List9. List7 gets populated with a query. I want to have two arrow buttons that will move items from List7 to List9 and then from list9 to List7 if needed. Also I need it so if list7 has an item selected and then I click on list9 and select an...

easiest and preferably cheapest. Or just cheapest (free maybe) way of converting my Access reports into crystal

in my main productionsupport table I have a field called category with 7 categorys you can choose and a field called TimeinHrs with the time spent on each category. what i want is a summary report for the year that shows all 12 months up top then on the left the category and then time spent...

I have to option to view/edit a table on my form. HOw can i get that window in front of the form window. right now you have to exit the form in order to edit it. Thanks, QR Private Sub EditButton_Click() Dim TableName As String 'err check if combobox is empty If...

Not sure if this is possible? I have a column called Issues and another column I want to call ShortIssues and I basically want ShortIssues to be Left(Issues,50) so that its just 50 characters long of column Issues. any ideas. Thanks,