Search results

The db is an Access 2000 db. We can upgrade it to 2003 but not everyone is on 2007 yet. So this would not help at this time. I have not used Access 2007 but we are switching to it in the near future. Does the Mouse Wheel not have the same functionality in Access 2007? Do you have to...

The db is Access 2000. It works in Access 2000 and 2003. But if the same db is opened in 2007 it does not work??? Here is the problem. There is an Access 2000 db that has a main form and sub-form. The sub-form is in 'Single Form' view and they are linked together. Normally after you...

Awesome. Again I am embarassed by not realizing I could do something so simple. Thank you again,

If the PK is multiple fields how do I jump to that? The standard (wizard) code is: ' Find the record that matches the control. Dim rs As Object Set rs = Me.Recordset.Clone rs.FindFirst "[Job_No] = '" & Me![cbo_Job_Number] & "'" If Not rs.EOF Then Me.Bookmark = rs.Bookmark...

P.S. I have tried Me.Refresh and Me.Refresh followed by Me.Repaint.

I have a form who's source table has 4000 records. These records are updated via DoCmd.OpenQuery rather than through the field directly. Because of this the form does not reflect the changes. I want to refresh/requery the fields and stay on the same record. How to a Requery/Refresh without...

I was really afraid you were going to say something like that. bummer... Not the answer I was hoping for, hehe Thank you,

Sorry, The check boxes are unbound. And the form is based on a table. But the table is not updatable either.

There inlies my problem. When I use Me.Dirty = True I get: The data in the form cannot be updated directly. Without data the is updatable I cannot set Me.Dirty, and without that I do not get the 'BeforeUpdate' event.

I tried that. the code Private Sub Form_BeforeUpdate(Cancel As Integer) never executes. I think it is because the check boxes are unbound so the form does not update. I think. Why else could I check a check box and not call 'BeforeUpdate'???

I have unbound check boxes on a form. When someone checks any of these boxes I want to prevent them from going to the next (or previous, or anyother) record without a user prompt. ---- Basically, the form is based on a table. The check boxes are based on another can CANNOT be updated...

Here is an idea, is there a way to, using datasheet view to bind the contol (txt_Emp_Rate) to [Emp_Rate] then I can't change it which I realize. But somehow capture the data entered????? And preform an update query? I would really, really like to stay away from a subform that has a single...

If I understand you correctly and the spread sheet is already open the process should read: 1. Open Excel 2. Preform whatever user functions are required 3. user selects from a combo box. 4. user clicks a button 5. clicking button runs some code which runs a macro to export a query to excel...

You could use the above with the Emp_No being the primary key in both tables. Note that the qry_Emp_Info is actually a PT query. I really appreciate it.

I'll pay around, I have never done that so I'm not sure. I'm not sure how it would identify which excel you wanted. What if you had more than one open. Even if you don't you have to be ready for the possibility.

The idea is to have a spreadsheet (like) view so the user can go down the list and enter the numbers. I like(d) the idea about a continuous form, this is closest to a datasheet view which is what I really want. However (and there's almost always one of those) I can't get it to work. If I have...

I have a local table: tbl_Emp_Rate Fields: Emp_No Emp_Rate I have a Pass-Through query: qry_Emp_Info Fields: Emp_No Emp_Name I would like to build a query -> subform -> form that will allow a user to find the employees name or number and update the rate. Sounds simple but... The pass-through...

You could open (create) your own workbook and let access control that. Set xlApp = CreateObject("Excel.Application") Use this to open a new workbook Set xlWorkBook = xlApp.Workbooks.Add or use this to open an existing one Set xlWorkBook =...

I owe you again. Actually I have never used the 'Format' command. Thanks again, If you're ever in So Fla I owe you a beer/soda.

I have a Word doc (template) that I populate from an Access Form I use With Wrd.ActiveDocument.Bookmarks .Item("Name").Range.Text = Me.txt_Name.Value .Item("Address_1").Range.Text = Me.txt_Address_1.Value .Item("Rate").Range.Text = Me.txt_Rate.Value End With...