Search results

I did. i believe this error as something to do with OLE objects or length of the memo field. I don't think its the length so much though.

I know it was sloppy but, I used option explicit and defined everything still get the error. its at this line: objActiveWkb.ActiveSheet.Cells(2, 1).CopyFromRecordset rstGetExportData

CopyFromRecordSet Object Range failed is my actual error message.

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

I get it. This is great. Thank you!!

i should of mentioned that. yes there is date in (shortdate). So I would be using DateReported, Category, TimeInHrs fields still a little confused by using functions to pull 84 times and then totals

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

Yah, maybe I should explain the original issue. I have a listbox that im trying to populate via query and I'm doing it in VBA because i don't know how to write a query using form textboxes. My Issue field is a Memo so i'm assuming (cause I tried) that It doesn't work and will not populate in...

No troll, sorry.. how do I make it so when items get added to a table its automatic? So that when the Issues cell is filled it automatically populates the ShortIssue column with Left(Issues,50). I tried putting that in the default value section but no luck. Thanks,

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,

Thanks for your help. I figured it out with this little hack job.. Dim dbs As DAO.Database Dim rstGetExportData As Recordset Dim objXL As Object Dim objCreateWkb As Object Dim objActiveWkb As Object Dim fld As Field Set dbs = CurrentDb Set objXL =...

actually i fixed that. but now im getting a operation is not supported by this type of object at the 2nd line: for each fld objActiveWkb.Worksheets("Test").Range("A1").Select For Each fld In rstGetExportData

Runtime error 438 object doesn't support this property or method @ this line objActiveWkb.Range("A1").Select its not because you missed the K in the original either. I fixed that.

using the code below but it doesn't export field names. any ideas how to add them. Thanks Dim dbs As DAO.Database Dim rstGetRecordSet As Recordset Dim objXL As Object Dim objCreateWkb As Object Dim objActiveWkb As Object Set dbs = CurrentDb Set objXL = CreateObject("Excel.Application") Set...

I have a form with 3 txt boxes. Also a table with the 3 fields.. Number of updates, Number of Errors and Number Correct. I want it so number correct is the calculation of Number of updates minus number of errors on my form. I know in the control source I can put =[Text1]-[Text2] and that...

might be. I got it to work fine now. I think the best thing to do is to create a 2003 version first then use 2007 so that its constantly a 2003 version. Instead of build something in 2007 and then try to convert when done. Thanks for your help.

just got home from work and it says embedded here. picture: image1.gif picture Type: embedded I don't get it. Shouldn't it stay on the form at all times. must be cause I converted it to 03 file format? No idea, but I would like graphics on my forms without having linked or separate files.