Search results

It worked fine for me also without the select object in my testing. If something has grabbed the focus, the MoveSiz may be trying to apply it to the incorrect object. I fidn this to be the most common cuase for teh MoveSize to not work as desired. I prefer to be as explicit as possible with my...

It could be you need to select the form before the MozeSize Try this tested code. Option Compare Database Option Explicit Private Sub Form_Load() ' make sure the correct object is selected DoCmd.SelectObject acForm, Me.Name DoCmd.MoveSize 1, 10, 100, 1000 End Sub ***...

If you have not resolved your issue, it could be related to the 11/12/2019 Office update. I had several users where Insert and Update queries stopped working See the link below to see if your version of Acces is on the list of versions imp0acted and how to install the fix. See Access...

I prefer to handle this with a simple select query to get the data stored in a table. I like o use a table to store the text as MajP recommended. I use a form to maintain the Rich Text data. You can use Access's built-in support for the Rich Text editing. I prefer to use a subform to display...

Unfortunately for swat (the original poster), the databases are user-generated and not split. They are also on a network share. The best practices for preventing corruption are available for swat. User-generated, single user (not split) databases stored on a network share is a huge challenge...

I have experienced renaming a database helping for many years, starting with Access 2000. It has something to do with the VBA code source and the VBA that is compiled on demand getting out of sync. Leading to an inconsistent state. Or strange things start happening. Do your database with the...

If you do not have the source database (accdb) that was used to compile the accde then it will have to be recreated. I agree with @Minty that if you try to create it yourself and need help, that the great community here will be able to help you do it.

You may also find these examples helpful Report Dialog Examples

Wishing you all the best with your project.

Before you purchase a license, I recommend you download and install it. You can use it for 30 days in trial mode to see if you like it. It is fully functional during the trial. If you want to continue using it after 30-days, then purchase a license. Or first try the code in the link theDBguy...

I do Google Calendar interfacing from my apps, including Access.. I first tried interfacing with with Google Calendar writing only VBA code. Not easy and takes a lot of time to learn. I found and ActiveX control from ChilKat Software (Click Here) that made it really simple. Had it working in...

WARNING: Using teamviewer as describe is NOT Free. It does require a paid license for commercial use. It really works best for remote tech support. Not the best for working for long periods of time or data entry. FYI: LogMeIn and GoToMyPC both handle remote printing. They are both much...

I would suggest checking out this example for the Sample Databases forum. Display Picture Without Storing the File in the Database

This site also has a forum call Code Repository found here: https://www.access-programmers.co.uk/forums/forumdisplay.php?f=63

This may help: http://www.outlookcode.com/threads.aspx?forumid=2&messageid=29996

As Pat pointed out, Word automation does work. I have done it but it used lots of code. Using an RTF control takes only a few lines of code to get the job done. ' 1 load the RTF control Me.RTFCOntrol = MyRTFdata ' 2- ectract just teh text MyString = Me.RTFCOntrol.Text The Internet...

Anther option: Which RTF control are you using to format eh RTF data? All the RTF controls I have worked with have a .Text (or similar) property that returns just the text without any of the formatting.

Something to think about ... While this is still true for the JET/ACE ( mdb/accdb) database formats, this is no longer true for all SQL and NoSQL database Servers. They are getting very efficient as storing files. Note: If you are using the free version of some SQL Servers there is a size...

You're welcome. Glad we could assist.

I build a dashboard using lots of bound sub forms and/or sub reports on an unbound form. This might be helpful: Using Dashboard Graphics in Access Also, check out: Dashboard Builder for Microsoft Access