Recent content by FrustratedPgmr

I finally figured it out. Function NewToolBar() ' Note that a form's recordset ' is a DAO recordset, in an MDB. Dim db As DAO.Database Dim rst As DAO.Recordset 'Had to add a second recordset with an sql statement Dim rst2 As DAO.Recordset Dim cbr As CommandBar...

I am trying to add 2 combo boxes to a toolbar. I get the combo boxes created but the second combo box just "dings" when I click on it. The comboboxes are 1(PatName) (Findrowinactivecontrol3 function finds the current record based on the name) and 2(PatSSN) (findrowinactivecontrol4...

If you mean by "jumps" it appears to blink when you change data or records then look into the application.echo false if you are working with access 2000+ or the me.painting function for 97??. I use tab controls and was able to stop the annoying blinking when updating or changing the...

Thanks for your quick response. It worked perfectly!!

I need to convert the number field with 2 decimal places to a string in a new field in another table. I must keep the decimal point even if it is ".00". i.e. 10000.00 will still be 10000.00 when it becomes a string. Currently it is converting as 10000. Has anyone else dealt with this...

I had the same problem and I found that using the following on my Exit button worked. Application.quit Application = nothing

I have this happens when I have to do a hard reset. I have found that I have to shutdown and restart to break the lock on the ldb. Once the restart completes I can delete the ldb.

Don't close your form frmpolicyinfo - just make it invisible. "me.visible = false" after the docmd.openform that has the txtpolicynumber field on it. I am assuming that you are opening your txtpolicynumber form from the frmpolicyinfo form with a button click??

Check out stored procedures(MSDE) vs queries or sql(Access).

I am getting the same error 2113 and also -2147352567 - with message not a valid value for this field. I have been going through all my books and it is making me nuts. the field is an 8 digit text field. I checked for null values - lenght. as soon as I hit a key to insert a character - I get...

Yes, The Developer version contains the access runtime engine. When you package the access application for distribution the runtime engine is incorporated. without it users will have to have access installed on their machines. [gorgeous]

If you are using Access2002 and attaching you tables via the form property - try the following first create an unbound text box name it "SearchBox" place the following code in the after update event of the "SearchBox" This works by comparing the value you enter in the...

When you create the MDE version you will not lose your design version - you will have two copies - one that is an MDE (secured code) and one that is your original design with no changes. You can make changes to your original design and create as many MDE's as you want for testing. Just keep in...

Is your server engine started? I have seen this message if my server was stopped. I am using the MSDE Engine that comes with the XP Developer Package. [Gorgeous]

I finally got the syntax correct and it works fine. WHERE (Table.Field ='"&[Forms]![Formname]![Fieldname]&"') This worked running a "docmd.runsql strSql " statement in the forms module for appending records from 2 joined tables into another table. [Reading]