Search results

oAccess.OpenCurrentDatabase("C:/File/Path/To/My/Database.accdb"); Wait, doesn't this code return the existing instance? Does it create a new Access instance? Then i need to look up a different method :D It never occured to me, because i am only running a background process, that does not depend...

In my experience flicker does not occur when using timer events. But it may occur if you refresh data, requery your form or set the focus. And of cause if you do these things in a timer event :D Especially the requery is mostly the culprit. You can easily fix that by using Form.Recordset.Requery...

Obviously. Sorry, that was my bad. I adjusted the code to replace the MouseMove Event instead. But be carefull, OnMouseMove does fire quite a lot :D

An example would be the following: First create a VBA Function: Public Sub ClickedSeat(SeatName As String) 'Your code here End Sub In your Forms Open Method do the following: For Each ctl In Me.Form.Controls 'This will loop through all buttons. Carefull, this will replace ALL BUTTON...

To help you, i would suggest you provide us with more info about your problem. Best would be an example database. But i do think it would be best to create a new issue for that. I had similar problems in the past, and flickering can have various reasons. So if you provide us with enough...

The simplest way to do this is to first remove the old record if exists: cursor.execute('DELETE * FROM tbl_test WHERE fld_PK = ' + ID) And then run your INSERT INTO Statement cursor.execute(' INSERT INTO tbl_test (fld_PK, fld_value1, fld_value2) VALUES (?,?,?)'),(ID, name, address))

As i am also quite interested in the topic, here is a usefull link that can definitely be of use. https://docs.microsoft.com/en-us/previous-versions/office/troubleshoot/office-developer/automate-access-using-visual-c The simplest solution that comes into my mind, if you want to communicatefrom...

This is exactly what i was looking for! Thank you very much arnel! Great vba as always! o_O:love:

Hello everyone, i am working on a quite general system that should be used in any form. I have a popup form that can be opened on a lot of forms. This Popup form is a list where you can select values from. When opening the form, the "target control" is saved as a public variable. This is the...

I am sorry, but it seems like this option is not there! Do one need to meet a specific requirement for that?

Sadly i can not find that option. Do you mind sharing a screenshot on where to find it?

Alright, guess i will go with that :)

I think you misunderstood my intentions. What i wanted to do is reset the row source to it's default value. So i change the Row Source SQL String, to show different data using VBA. How do i revert back to it's default value/state? How do i revert back to the row source that is set when i opened...

Hello everyone, i have a combobox in an access form. The rowsource is set to a table in my database. Now whenever the user does a specific action i change the row source using VBA to display different values. Whenever i close the form and reopen it again, the rowsource is set back to it's...

I am also not a fan of the built in Navigation forms but they do their job pretty good for simple tasks. The prompt comes from changing the form (for example the color property) and then closing it. What you can do to avoid that is, you can change your Textboxes using Conditional Formatting...

Edit: This does not seem to be your problem, but the link is still usefull, so i will keep it in here :) I tested it in one of my forms. When you call the DoCmd.CloseForm Method with the Save Property to no, the prompt should not appear. DoCmd.Close acForm, "Order Review", acSaveNo There are...

The Password Login from Isladogs is really good! So i would first go for that. It is quite hard to prevent users from accessing certain forms and tables in access. If someone with malicous intent and knowledge tries to access data that is not supposed to be for him, then he most certainly can...

Never mind this thread is necrobumped, i missed that sry ^^ it is more than 8 years old

Hey Mohsin :) I am having trouble answering that question. First, you did not provide any information about the machine. Type, Manufacturer etc... Without that one can not look up the machine specifications and their API. Simply "connecting" to a machine is not a difficult task, but the machine...

Now you are :) congrats! 😋 but keep in mind I don’t know why that is. It is just an assumption