Search results

I would suggest you make sure your list is based on a query referencing a Edit flag. When you open up a form to edit your selected items open the form as a dialogue. When you edit your items update the edit flag on the underlying table. After the open command place a listbox.requery. As you open...

What you can do is put some code in the Detail OnPaint event. This is a way of controlling some aspects of an individual record even when the form Continuous Forms. For example, you could set the background colour or colour of the border.

No, that is not what is happening here. If you look at the test database I have some code against a button that simply assigns a string value to an integer variable. A runtime error if ever I saw one. And, when loaded with the Nav Pane showing it breaks as it should do. When running under...

Great tip, thanks Bob.

Yep, but with 60,000 lines of code it takes a while to get it all in...

Bob, that is the point and the problem. On a deployed system I want to restrict access to the Navigation Pane hence I hide it and disable the Access Key. However, when in this mode the system will not break on un-handled errors. If there is an issue with the system I would prefer to know...

Yeh, makes no difference. Change it to all errors and it is still the same...

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

27k, good effort! Hey, 2 years of graft has gone into my DB. Not saying it is perfect and that there is not code that needs to probably come out, but as Access DB's go I am pretty chuffed with over 50k...

Found this little cracker on the web: - http://allenbrowne.com/vba-CountLines.html Thanks Allen Browne. My DB - 56,428 lines of code! Anyone out there can beat that??

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

OK - I have fixed this. In the end I created a .Net C# DLL. I built with register for Com Interop. I used the following code: - using System; using System.Collections.Generic; using System.Text; namespace CareControlSystems { public class ImageWriter { public string...

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

Yep, you are right there. However, the only reason why the process would kick in should be because the current version is no longer valid. Which means that someone has updated the main database which "should" mean that they have put the updated access front end file in the upgrade location...

Yep, the batch file I call does a copy with a /y switch to force the copy. Filenames are the same. After the copy the batch file then calls: - start "accessdbname" to restart the newly copied file (again in a separate process) for the user. Front end upgraded!

Docmd.Quit using Shell "start batchfilename.bat" spawns a separate process not associated with the MCACCESS.EXE process id. So, I can then quit access, but keep the batch file running. Put a wait of 20 seconds as I have auto-compression built in to my access db and that can take a few seconds...

I solved it! In my code I created a batch file on the fly with a timeout /t command of 20 seconds. I then started the batch file with shell start (which spawns a separate process not connected to access) and then called docmd.quit to shut access down. The batch file starts, counts down 20...