Search results

RE: BeforeUpdate event is not working Good Morning, Can anyone think of why BeforeUpdate event is not working? I have a check box in a subform when clicks it executed BeforeUpdate event but sees the check box is true. Why? I tested with another form the BeforeUpdate event works in check box...

Re: Need help in saving & resetting controls in a subform Hi developers: I really need some help on this problem. Here are the tasks I need to accomplish in a subform -Save previous dispo (check box previously checked) -Set current dispo to true (another check box user selected) -Reset other...

Re: How to fix client/server recordsets out of synch Hi eveyone, I really need some help with this problem. I have subform with bunch of check boxes and previous and next buttons. What I need is when user clicks on a check box the previous selection is saved in a field in the table and the...

Re: unable to move to the next record after editing Hi all, I'm having trouble moving to next record after making a change in the subform. I have eight checkboxes, previous and next buttons in the subform. After reselecting a check box When I click on either previous or next button I get one...

Re:How do you set focus to the last character in a control Thanks all for your help. That's exactly what I need. Thank you!

Re: Slow in opening database Hi Liv Manto, Hi quest4, Thanks for your replies. I tried compact & repair it doesn't seems to make much difference. My tables are manually linked. Liv Manto, I am sure how to mimick the tables as you suggested. Could you explain further? Thanks. I'm using...

Re: How do you set focus to the last character in a control Hello everyone, Is there a way I can set focus to go to the last character typed in a control? When I use set focus to a control such as memo field in visual basic the field is highlighted. I don't want the user may accidentally...

Re: Slow in opening database Good Morning, I have a question on what would cause the database slow in opening up. The database opens to a form, in the form_open event I have code to setting the form up. It seems to be opening slower each time. I am using Access 2000 FE & SQL Server 2000 BE...

Re: combo box will not update Hi everyone, I need some help in combo boxes. I have two combo boxes on a form. The first combo box allow user to select a customer and the second combo box pops all the part numbers for that customer for the user to choose. The problem I am having when the user...

Re: last record not updated. Why? Thanks for your replied. Yes, the requery did updated the table but it also refreshed the form which I don't want. This is what I'm trying to accomplish. In click events of the cmdnext and cmdFinish btns it calls a query and check if a check box is...

Re: Last record does not get updated immediately. Why? Good Morning, I was wondering if someone can me understand this- I have a form(subform)gets its recordsource base on a table through a query in the openform event. The subform displays a record and there are bunch of check boxes w/i this...

Re: reference a nested subform control in the subform Hi, How do you reference to a control in nested subform within the subform? The following code is being run in subform and gives me an error. If Me!RMR_desc_defects_subform.Form!num_defects.Value <> Null Then : end if Error:MS VB The...

re: recordcount syntax for nested subform Hi, I'm trying to find out if there is a record in the nested subform from the subform. MS VB Error: Object variable or with block variable not set. My code: Private Sub cmdNext_Click() On Error GoTo Err_cmdNext_Click dim rec_cnt As Integer Dim rst...

I am having trouble connecting to SQL Server 7.0 tables through Access 2000 .adp file. This is the message I received: "[ATI] [OpenRDA ODBC] RDA error: Resource not available. No error" Can anyone explain this error message? I'm running this application on Windows 2000. Thanks much!

breakpoint problem If it happened to me, I would first Tools --> Utilities -->Compact/ Repair. Then, if that didn't work, I'd import all items into a New, Blank database. I tried compact/repair it didn't work. I created a new database and imported all the objects the breakpoint...

The breakpoint keeps on popping up in Access 2000 application eventhough is not set. It points to different statement every time. I don't want to copy the code and delete the breakpoint statement , save and copy it back. The breakpoint statement occurs in different forms or modules. How...

Good Morning, I have two sub procedures calls form_open event and pass in openargs to the procedure. The openargs are work_ord_lookup and shipped_dates. They are two fields/columns in the same table bound to the same form. Depending on the openargs passed in I need the form to open and filter...

I received "Named argument not found" in the OpenArg:= I can't see why the error occurred. Could you please help me out? Thank you much! Private Sub w_o__history_Click() On Error GoTo Err_w_o_history_Click Dim stDocName As String Dim work_ord_num_lookup As String stDocName =...

I am having trouble to get all my records displayed on a form in form view. It will only displayed the last record. I have set both scroll bars visibily in the property of the form. I'm developing in Access 2000 and SQL Server 7.0. This is my procedure I used: The user selects a record on...

Sorry!The label is defined near the end of the subroutin, I meant to copy the code that might caused the error. You are probably right about work_ord_num dimensioned as a string and use the variable as a numerical value. But the error("Operation is not allowed when the object is closed" )...