Search results

I have a form that uses the following code to handle 2 forms opened in an adp with the same record source. see the following article: http://support.microsoft.com/default.aspx?kbid=304181 Dim rs As ADODB.Recordset Set rs = Me.Recordset.Clone rs.Bookmark = Me.Bookmark DoCmd.RunCommand...

I am using Access 2000 and SQL 2000. I am creating an adp. I have a form (frmMain) with a subform (frm_sbf). On the subform the user can open another form (frm_popup) to update additional information on a particular record. The problem occurs when I close frm_popup and then try to move to...

Rich, thanks for the reply. I had thought about that but didn't want to do that. Do you know why you can't display the 2nd column. The 1st combo box (granted it is not dependent on another value) does what it is suppose to. Stores the 1st column value which is hidden but displays the 2nd column.

I have a continuous subform with 2 combo boxes. The value the user chooses in the 1st combo box determines what will show up in the 2nd combo box. This is working OK. On the current event of the subform and on the after update event on the 1st combo box the 2nd combo box is requeried. The...

I have 2 combo boxes. Combo1 = State and Combo2 = City. The values in Combo2(City) is dependent on what state the user picks in Combo1. The problem is I can't filter the values in combo1 based on the state in an adp. I can do this in an mdb but don't know how to do it in an adp. Thanks!!

Got it. Even though ItemApproved is a bit field in the Access code ItemApproved = True not ItemApproved = 1.

Sorry guess it wasn't clear in my first post that was the code I was using. Here it is again If Environ("home") <> "Username" And ApprovedCheckbox = 1 Then Amount.Locked = True Thanks for the help!!

Based on your response it sounds like the code should work on the current event. However, it doesn't. Any suggestions. Using Access 2000 with a SQL 2000 backend. Thanks

Can you lock a field on a continuous subform based on a value in another field. For example: If Environ("home") <> "Username" And ApprovedCheckbox = 1 Then Amount.Locked = True I have tried putting the code on the current, open, and load events. There is one user who can approve the record...

Wondering if anyone has implemented an audit trail with an adp frontend and a sql backend. Thanks!!

OK, I got the code to work. I will be the first to admit that I may have removed something that needs to be in the code to make it completely correct . . . but it does work. Any suggestions to make the code even better is welcome!!! Module: Public Function SetProperties(strPropName As...

I have found examples of how to lock the db by disabling the shift key in DAO but was wondering if anyone had an example of how to do it in ADO. I like ghudson code using a password box and was hoping someone had done it in ADO. Thanks!!!

The following code allows a user to type in a record in the dropdown box and if the record does not exists it prompts the user to add the record via another form. The problem is the drop down will not requery. It works in DAO but not ADO. The record does get added to the table but the...

As you are experiencing, printing forms can be troublesome. Create a report instead.

Try passing in an OpenArgs For example, if I have a button which opens a form as read only I will put on the On Click event: Private Sub ReviewForm_Click() DoCmd.OpenForm "ReviewForm", , , , , , "ReadOnly" End Sub On the form that opens I will put on the On Load event Private Sub Form_Load()...

First you need to create a 3rd table to store the one-to-many relationship between Orders and Products. For example if OrderID = 1 has 2 orders then the table will show OrderID =1, ProductID = 1, OrderID =1, ProductID = 2. Attach is a quick and dirty sample db showing you the basics.

Thanks, exactly what I was looking for.

I have a form with a memo field. The problem is that if I set a tab stop on that field or set the focus to that field on open or load all of the text is highlighted. Instead of being highlighted, I would like the cursor to be automatically be placed right after the last character.

I was wondering if it is possible to change the size of the window that pops up when you hit Shift + F2 (Zoom). I like the fact that you can have a zoom window pop up without having to create another form, but the window is not as big as I would like. Thanks!!!

Hey Newman, finally found the solution. Here is the link: http://www.experts-exchange.com/Databases/MS_Access/Q_20675009.html I have tested it and it runs great.