Search results

I want to change a column from a combo box in VBA Code. Is there a quick way of doing this or have I got to remove the row and add it back again? I can access a column from a row that is selected via: - List0.Column(1, List0.ListIndex).Value However, this is readonly...

Help! I have some serious odd behavior on a couple of PC's. I have DB that uses Access 2010 runtime. The DB uses modal / pop-up forms. This system is installed on about 300 PC's running a range of OS - Windows 7, 8.1 and 10. On two computers so far we have a strange issue. When a form is...

Hi Does anyone know if there is a way of making sure that the underlying base Access Window is maximised? I have the short cut set to start maximised, but some users are being clever and changing the window size. The problem is that many of the operations within access (such as Form Centre)...

What is the late binding option for DoCmd.RunCommand acCmdSpelling? I have a Access Runtime system which is being moved to machines with Office 2010, Office 2013, Office 2007 etc The system currently has a reference to Microsoft Office 14.0 Object Libary which means that when installed on a...

I have a large database. I want to identify which objects take up the most space. Does anyone know of a way of identifying a list of each object with their relative size? I can do this in sql server, but no in Access?

I have a large Access 2010 DB. Although I have a lot of error trapping in the database, there are some areas that do not yet have it. I am working on this. I have a weird issue that when I run the database with AllowByPassKey set to false with the Navigation Pane hidden, if the database comes...

I have a Access 2010 database running in runtime. What options do I have for spell check? I can bind to a 2010 Word spell check (if it is installed), but could I do a late bind to utilise any other office spell check? Has anyone tried to use a .net spell checker dll and get access to call out...

I have been working on a pretty big Access Database for a while now and it is coming to an end in terms of dev. I wanted to get some stats on how many lines of code the database has. I wrote a simple procedure to do this: - Private Sub Command0_Click() Dim mrd As Module Dim NumLines As Long...

Hi Guys, this is an interesting one. So I have a programme that uses Access 2010 runtime. It is deployed with some .net dll's etc so I wanted a super slick, professional single click install. I have gone for the Access Runtime silent install using the config file method. I am using a .Net...

Hi have a weird one here. I have an Access 2010 database. I wanted to provide some functionality that was better suited to write in .Net. So, I went and wrote a very simple DLL. I compiled this object and deployed onto the target machine. In access I can see the DLL and I am able to...

Hi I have a pretty technical problem. I have some images stored in a SQL Table which is linked into Access. These images have to be stored in the database as I also reference them on other platforms (Android, Web etc). In my Access programme I need to display a continuous form / report...

How can I overwrite the existing Access database with another Access database without the need for the end user to get involved in the process. I want the code to copy a new mdb file over the database I am using (!) and then automatically start the new mdb file...:banghead:

Hi Guys I have a form that is opened as a popup and modal. From this form the user can also open other forms, again which are popup and modal. The first form as a timer event which fires after 5 minutes. It loaded a status screen on this form when the timer event fires. I only want the...

Got a right tricky one here. I have a global function which I have hooked onto the onClick event of controls. Currently I am using commandButtons as my control of choice. In my function I can then reference Forms.ActiveControl which is no problem. However, for lots of reasons I really need...

Well.....?

I am not sure if this is the right place for this post, but I wanted to share some cool code that I use a lot in my Access apps. Almost every app I write the users need some form of on screen report. Normally they want loads of them and cranking out a way of displaying the queries so that I...

Looking for a bit of short cut code if anyone has it. I have to do some tricky automatic form building stuff. I need to duplicate a number of controls on a form. They are all acCommandButton types, but they have different images, sizes etc. Anyway, my thought process was if I have a...

I have an issue, I think I have a work around, but I am struggling... Firstly, I have a SQL 2012 database which has a table holding some images. These images have to be stored in the database (as we are using them in Android devices as well as Access) and so I cannot use paths to the images...

Hi Not sure if anyone can shed any light on why I have this problem. I have a function that creates a form dynamically to enable the end use to edit the table (or query) contents. For example, if I have a table called Activities. By calling this function it will create a form with the fields...