Search results

Hello, Is it possible to fire the On Current event for the subform of a datasheet main form when you expand a record's subdatasheet view (clicking the + sign) regardless of what record your cursor is in? Right now, you have to select the desired record fire in order to fire the subdatasheet...

Checking through my forum posts and, if anyone wants to know how to do this, just create a dummy group based on an expression (=0) and remove the page header/footer. Once this is done, just set your new dummy group's "Repeat Section" property to "Yes" and presto! The dummy group header will be...

Thanks for the suggestion, pbaldy! Just like you, I was hoping someone would have a simple yet ingenious solution for this (which, there usually is in the programming world!). That's also the end-goal solution I was hoping to end up with but, with different width fonts/characters, there is no...

It's been close to a month since I posted this, just wondering if anyone know of anyway I can accomplish this? Or is this an impossible idea, even with VBA.

Thanks for the tidbit, pbaldy! Do you know how I would set the concatenation so the string of dots go the end of the control with "Can Grow" enabled? Is there a way within VBA to determine what length of dots would be needed to go from the end of the string to the right end of the control...

Good day/night everyone, For clarification, this is what I would like to accomplish. I have a report control (with "Can Grow" enabled) where I would like to add a dotted line from the end of the contained report string to the right end of the report control. Meaning, something (roughly) like...

Thanks Minty! That's basically what's happening, once I remove and readd the ODBC tables, it works fine again. I've been revisiting these forums as of late and cleaning up any open threads I posted via marking as solved, which I will do to this thread.

Just visiting/cleaning up my forum posts right now... Going to mark this thread as solved because I eventually restructured the stored procedure, it is now dumping data into a virtual temp table (in server RAM, not a physical temp table within SQL database) plus looking at another to simply...

Awesome! Thanks for your help! Here's the end result :) Dim s1 As Integer Dim s2 As Integer Dim s3 As Integer Dim s4 As Integer Dim LongestS As Integer s1 = Len(rs.Fields(0)) LongestS = s1 s2 = Len(rs.Fields(1) & " : " & rs.Fields(2) & " : " & rs.Fields(3) & " : " & rs.Fields(4)) If s2 >...

Thanks CJ! So, taking this logic and then building upon it, could I get the length of each string and left justify each to the longest one? Kinda like so? Dim s1 As String Dim s2 As String Dim s3 As String Dim s4 As String Dim LongestS As String s1 = Len(rs.Fields(0).Value) s2 =...

Thanks for all the quick replies everyone! All your suggestions will definitely help! spikepl, could you provide an example using .Htmlbody within an Outlook object? I've used the Outlook object in another instance where I needed to attach multiple reports in PDF form to one email, but never...

Hello everyone! I have the following string of text that I currently push out to the body of an Outlook email (using the DoCmd.SendObject function with an Access report): sMsgBody = "Please find attached the specified Final Costing Report for WO# " & WO & vbCr & vbCr sMsgBody = sMsgBody &...

pbaldy, sorry about the misinterpretation. I tried copying the SQL from my pass through query, pasting it in SSMS and running it but it still showed the correction result-set data. Minty, I tried using that date format setting in VB then running it, grabbing the SQL again from the pass through...

The pass through query is being set directly to a report. I've even changed my VB to the following, still no success thus far: Dim db As Database Dim Q As QueryDef Set db = CurrentDb() Set Q = db.QueryDefs("Employee Evaluation") Dim sd As String Dim ed As String...

Thanks for the reply guys! pbaldy, even the pass through query result-set was different than compared to the SQL one. Turns out it was just how I was declaring the sd and ed variables in VB. CJ, thanks for pointing the variant declaration out! That was a bad habit I picked up somewhere on the...

Hello everyone, I haven't posted in a while, but this scenario is quite strange... Does anyone know what would cause a SQL stored procedure to behave differently when called in Access 2007 via VB than within SSMS (SQL Server 2008 R2)? This is what I have in Access: Dim db As Database...

The original setup now appears to be working on other workstations except mine... yet we're configured the same way (ODBC connections, action queries, front end databases).

Good morning, I'm currently having an issue where I cannot run action queries on a table where there's open recordset connections within form(s) (I'm using SQL Server 2008 R2 with linked ODBC tables) to the same table. If I manually run a make table query, close the forms and run the action...

Figured out what it was! The Wii U Pro Controller and PS3 Controller USB Cables (I was using the Wii U one) are the same type... but the Wii U cable ONLY transfers power, not data (hence why it wouldn't sync with the console). Once I got a USB Cable of the same type (think the one I found was...

Good morning folks, I've recently purchased a used 80 GB PS3 (Piano Black) and noticed, after some research, how easy it was to upgrade the hard drive in these systems (seeing that it only needs a bare 2.5" hard drive). Luckily, I had a 500 GB kicking around and was able to swap them with no...