I have a large Access 2000 Database which was initially developed as a small multi-user (5 users) system. I had the foresight to ensure all forms were created as unbound ones, using DAO recordsets to populate on demand. The application works trouble-free over linked Access tables (to a MDB...
Hello,
Imagine if you will a simple application with 3 forms.
frmMenu, frmA, frmB
frmMenu has a command button to hide itself and open frmA
me.visible = false
doCmd.openform "frmA"
frmA (a summary screen) has a command button to close itself before calling frmB (has a timer, so I want...
I need to copy a particular record's contents and append it to the end of the table. The copied record will have the same contents except for the new key field (autonum).
The table has over 100 fields, so I used the code below to loop thru each recordset item.
However, I get a runtime error 3219...
Ken,
I only considered the manual (lock field) method because i actually believe the Access locking is inferior! I really need a way to stop a user even BEGINNING to update a record if it's currently being updated by someone else.
As I understand it, the Write-Conflict error message that I will...
I need to consider a record-locking strategy for my multi-user application (Access 2000 front-end, SQL Server 2000 back-end). Many of my forms are bound (eeeek) but in all cases they are bound to underlying queries that have returned (at most) a handful of records.
The default record locking in...
Thanks for your help with this.
Finally, can you tell me the correct way to refer to each control within the selected subform?
My line :
FrmCtl.Locked = YesOrNo
doesn't work. I need my code to cycle thru each text box
on the subform and set various properties.
Thanks for your help.
Based on your sample code, I now have the following code, but it fails at ***
I don't know the code to go thru each control on the subform.
Private Sub LockForm(frm As Form, YesOrNo As Boolean)
Dim FrmCtl As Control
Dim SubFrmCtl As Control
' find all subforms...
Can someone please help me with the code needed to do something like:
foreach subform in form
foreach control in subform
control.enabled = true
control.backcolor = white
next
next
This is part of an idea to make all my forms readonly, with an update button that would run the above...
Most of my forms are bound. Does this mean that I am unable to trap the ODBC errors?
The only unbound forms I use are search forms that create the queries which the forms are based on.
If needed, I could convert to unbound and introduce the db.execute method as you suggest, but I have over 50...
I have just upsized an Access 2000 application to SQL v7 using the upsizing wizard.
On the Server side, I have set check constraints on certain colums (eg discount<40) to validate data entry.
This works fine on my access forms, but the users are getting an unfriendly ODBC call failed error...
I am installing a new PDC and changing the domain name at the same time. If I demote the current PDC is it then free to join the new domain as a plain server?
I am using Access 2000 and need a dialog box to allow users to redirect reports to a specific printer.
I have had a look at using the prtdevnames/prtdevmode property, but I think I'm right in saying that these won't work with my MDE application, as the report has to be opened in design mode to...
I have set up Access Database options so that ENTER takes the user to the next field in the form. This is my preferred default. However, on occasions I need to determine if the user has pressed the ENTER key to exit the text box as opposed to say a TAB or DOWN ARROW.
Can anyone assist me with...
I have a simple table containing transaction codes.
I need to produce a query listing transactions of a certain type eg "XYZ" where NO transaction of another type eg "ABC" exist anywhere else in the same table. I am trying to avoid using a lookup, but just can't work out the...
Problem resolved thanks.
Subform was incorrectly linked to the underlying query of the main form. It should have been based on the "many" table.
I have a simple Form with subform, based on a query.
The navigation buttons (on the main form) reflect the number of records in the SUBFORM. (!)
For example, if the query finds one master record with 2 matching records showing in the subform, then the Nav Buttons show "Record 1 of 2"...
Please help, I have a severe case of brain fade!.
I am trying to create a query based on 2 tables using an inner join, but only selecting the record in the 2nd table with the highest value (Invoice Number).
The following query will give me all Invoices for a customer:
SELECT Cust.CustName...
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.