Search results

Original post here. Just wondering if anyone here has had any recent DAO VBA issues in Access 2016/2019 where the same code works just fine in 2007. This issue seems to have sprouted around June 10th, but I can't seem to find any Windows 10/Office 2016/2019 Click-To-Run updates correlating...

Hello everyone, Is there any way to decipher between outputting a report and opening a report in VBA? I have code within a report's On Close event that I only want run when the report is opened in Print Preview. I've tried using the following... Reports(rptname).CurrentView OR...

Hello everyone, It's been a while! Can anyone please point me in the direction on how I can create a form in VBA and add an OnClose event to it? I've been searching the interwebs high and low for an answer to this. Creating the form in VBA is no trouble (I've got a fairly complex one going...

Hello, I`m currently trying to accomplish the following (forum link to save duplicate posting): http://stackoverflow.com/questions/38075289/access-2007-subdatasheet-form-to-visual-studio-2015-vb-windows-form-app Anyone on these forums know how I would go about doing this? Any help at all...

Hello, Is it possible to make a button/text box appear within a form column when the form's in Datasheet View? This isn't a life-or-death situation and "no" is more than an acceptable answer. Just curious if it is even possible with VBA and why it is/isn't?

I've asked this a while ago on Stack Exchange. Haven't gotten much for replies since, so I was wondering if anyone here could pass on any insight as to how this might be accomplished! Don't worry about replying to my question on Stack Exchange. If I get an answer, I'll post the answer on Stack...

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

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

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

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

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

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

Good morning everyone, Thanks (many thanks) to John Big Booty's post below, I was able to create a very user-friendly pop-up search form: http://www.access-programmers.co.uk/forums/showthread.php?t=188663 I would like to take it a step further... Now, I would like to grab the selected record...

Good afternoon (for those in the Atlantic Time Zone), This is more of a curiosity, so if it's not possible it's not the end of the world... I was wondering how I could do a multiple value InputBox in VBA, if this is even possible... This is so I can prompt the end user to enter a range (with...

Good morning everyone! I've got an issue pertaining to inner joins within an update query. This query will not run now (giving the expected "must use an updateable query" error) due to two fields involved in one of the inner joins are now both memo fields. Is there any way (and I assume there...

I current have an Access 2007 database which one of our end users utilize faithfully. When he initiates a search in this Access 2007 database on a Windows XP Professional station, it returns the results almost instantaneously. However... this same search started in the same database on a Windows...

Anybody else looking forward to this epic MMO? I can't be the only one excited for release day (or early access if you pre-ordered)! :D. Let me know what you think!

Hello, me again :rolleyes: Hoping this one isn't too tricky, just need to know how in VB I can refresh all my linked ODBC tables within my "Main Menu" form's OnOpen event. Any assistance is always welcome! :)

Good Friday afternoon everyone, Is it possible, within an OnOpen even of a specific report, to set the printer selection and page setup (size, margins, etc.) to certain things? If so, how would I go about accomplishing this? I would like to do this for specific users within our domain (this I...

I'm currently tweaking a report with three sub-reports; adding/changing a few fields and other simple tasks. One request has been given to make the sub-report's report header to appear in the main report's page header for the duration (multiple pages) of each sub-report. Is this even possible...