Hi
Not sure whether this is your problem but I've had similar.
If you reference a dll and you have more then one copy of this dll on your system then the app uses the first it finds in the registry. I had serious problems because moving the dll was not being caught and updated, consequently...
Hi, I think this may be what you are looking for:
In the datasheet form put this code in the Declarations section:
Option Compare Database
Option Explicit
Private WithEvents m_form As Form
In the datasheet form put this code in the close button On_Click Event It supposes that the datasheet...
Hi
A couple of things strike me here.
If I had to navigate using the nav buttons through 72 records I think I might have a sense of humour failure pretty quickly. Why not populate a combo or listbox with the choices from the filter?
Secondly, what is the record locking set to? With 'no...
Hi
Yes you can do it but you have to cheat. For the text box you want to change the color of create 2 (You can figure the other one once you can do this).
Name the text boxes something like txtRed and txtBlue. Make them identical and transparent but with red and blue Forecolor.
Now set the...
Hi
Had a similar problem recently and the best answer to this is to create a report that looks just like your form. Create a query that has a parameter against the key field that looks something like [Forms]![MyForm]![MyControl]
Make the query the datasource of your report and off the button...
Hi
I think Jeff may have missed a vital point. In VB if you use a variable VB treats it as a Variant from square 1 but in VBA there is a vast difference between a string and a variant even after the sheer size allocated. Most VB programmers I've seen use only variants and VB doesn't have a...
Hi
I think you need to rethink the problem. Why not get them to put the data into an Excel file and attach the file to an e-mail? Importing is then no problem. I often use Excel for reports because the user can then send the file to everyone and anyone they need to. It works in reverse too.
What Ann says is good. Your users are joining your user group by default rather than joining for the duration of the session. Is the Admin user required to use a password? Do you have a clever user?
If the default Workgroup is your group there is no need to login if the Admin user doesnt...
Hi Aydan
The best way to remove typos is to prevent the user from entering them! I always make the user select from a list if at all possible, select from an Option Group select from anywhere but don't let them type unless it isn't important.
With thought and careful design almost all user...
Hi
Have you tried to edit the data in the query that is the source of your form, presuming it is a query. Remember that some queries, because they rely on joins and filters, cannot be edited.
If that is not the case then perhaps the properties of your form, allowEdits, AllowAdditions are set...
Bill
Both the methods posted are the way to go but I have added my own way of doing it. I decide which controls are going to be shown under which circumstances then I prefix the name of them with something like "set1_", "set2" etc.
Then I can say:
Dim ctl as Control
For...
Hi this looks a bit complicated but really its easy.
You add one bit of the code to your combo box On Not in List event and put the other in a Module (don't forget Option Explicit at head of module). This will tell the user the item is not in the list and allow them to add it.
Text in the...
In the AfterUpdate event of the control containing the field which is your switch add the following:
Me.AllowEdits = False
This will turn off editing for the current form.
if you want to just turn off that field then you have to move the focus to another control then lock the first control...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.