Search results
-
Copy to Clipboard?
Also...when I try to replace Set rst = db.OpenRecordset("tblSubReport") with Set rst = db.OpenRecordset("SELECT * FROM tblSubReport WHERE rst!SubReportID = [Forms]![frmReport].[ReportID]);", dbOpenDynaset) I get an error: "Too few parameters. Expected X" When I give it one parameter...- theKruser
- Post #7
- Forum: Modules & VBA
-
Copy to Clipboard?
OK...I am about to see if my comupter can fly. I can get the records to display correctly in the debug window using the following code: Dim db as DAO.Database Dim rst as DAO.Recordset Set db = CurrentDb Set rst = db.OpenRecordset("tblSubReport") Do Until rst.EOF If (rst!ReportID =...- theKruser
- Post #6
- Forum: Modules & VBA
-
Too few parameters, Expected 1
Thanks for the reply! Question: would the code/precess be different in a split db? I have tried the info from the link you included, but still can't get it to work. Thanks again for your help!- theKruser
- Post #8
- Forum: Modules & VBA
-
Copy to Clipboard?
Thanks for the reply! Question: can you please provide an example of how one would create the record set in VBA and then loop through it? Suppose the following: tblReport ReportID (PK) ReportName ReportTimestamp InfoBox1 InfoBox2 etc... tblSubReport SubReportID (PK) ReportID (FK)...- theKruser
- Post #5
- Forum: Modules & VBA
-
Copy to Clipboard?
I got it partially figured out. I have an unbound text bow that I fill from a query through vba. I then use the acCmdCopy method adn paste into a .txt file. Noe the issue becomes using vba to grab the info from subsets of records off of the main record (second table) in which there may be...- theKruser
- Post #3
- Forum: Modules & VBA
-
Too few parameters, Expected 1
I am having a similar issue with the following code: Dim dbsManager As DAO.Database Dim rstInfo As DAO.Recordset Set dbsmanager = CurrentDb Set rstInfo = dbsManager.OpenRecordset("qryInfo", dbOpenDynaset) I am getting the "Too few parameters. Expected 1." error as well. I have checked...- theKruser
- Post #6
- Forum: Modules & VBA
-
Copy to Clipboard?
I would like to be able to create a button on a form that will call a query/report and copy the results in plain text to the clipboard. I am assuming the best way would be to create a hidden text box on the form and assign it's value with VBA, then use the acCmdCopy method. However, I am not...- theKruser
- Thread
- Replies: 16
- Forum: Modules & VBA
-
Import more than 255 characters from Excel?
Has anyone figured out how to import more than 255 charters from a Excel cell into Access 2007? Any help would be greatly appreciated. Thank you in advance. -
Dymanic labels on forms: Possible?
Is it possible to change form labels to display info that depends on the selection of a combo box? For example, suppose: tblFormData -FormDataID (PK) -FormLabelsID (FK) -Text1 -Text2 -Text3 -Text4 tblFormLabels -FormLabelsID (PK) -LabelForTxtText1 -LabelForTxtText2 -LabelForTxtText3... -
Eliminate line break (carriage return) in report export
Addendum to the above: I might actually need a report after all. I have to be able to include static code before and after the code the query generates. -
Eliminate line break (carriage return) in report export
Bob- Thank you very much for your reply. I hadn't thought about the max character limit in Notepad. However, when exported to a .doc from Access, it shows the carriage return there as well. I wrapped in <html> and <body> tags and it did display properly, but if you look at the source from... -
Eliminate line break (carriage return) in report export
I would lov to do that, but I do not know how. Any way you could explain or post a link would help me figure it out? Thank you for your reply!! -
Eliminate line break (carriage return) in report export
I have also noticed, that in some instances, when exporting to .txt it just stops. Meaning, in the report and/or query, there is more code/text at the end of a long line of code/text than there is in the exported text. It is like the exporter just says, "Ok...too many characters in this line... -
Eliminate line break (carriage return) in report export
Yes, it is there. First <td> line. There is a carriage return between Badge" and class= -
Eliminate line break (carriage return) in report export
rptAlphabetical. Right click and export as .txt. The first td row has a line break in it. I may have found a way around the problem, but I still would like to understand why it is happening. If you have a moment to explain, I would appreciate it. My work around amounted to changing the... -
Custom error message problem
@MStef Thank you very much for your work on this. It will go a long way in my custom error messages in the future. You are a lifesaver. @ghudson After @MStef added the code, I am not sure that I even need those lines anymore. @ghudson and @MStef If the code I had entered previously is no... -
Eliminate line break (carriage return) in report export
@vbaInet Thank you very much for your reply. I am not very good with VBA. I assume these to be something I would have coded into the report. If they are not, I have no idea where to go to find them. -
Custom error message problem
I am trying to create a custom error message. I am getting a very odd response. On error, I get an Access-generated Runtime error '3022'. If I hit End then try to close the form, I get my custom error message. The first text box on the form is for Employee ID. After update, it should be... -
Eliminate line break (carriage return) in report export
I have a database which I am building to output html code to a .txt file for uploading to a site. The problem I face is, I cannot figure out how to force a line of text to export as continuous. As it sits, longer lines of code are forced a line break (carriage return) upon export. As for... -
Combo box in tbl...good idea or horrible?
Thank you. I will do just that. I truly appreciate your help.