I have been using this newsgroup for many years, and on each ocation I have always been received with a warm reception and you guys have always provided me...

I would like to change the value on a combo box I am using: Form_fmain!fmainp.pstatus.Value = "Design/Rev" The "Deisgn/Rev" is one of the choices. What I am...

Hi, I need to round time to the nearest 0, 15, 30 or 45 Minutes. Example: START SHIFT (ROUND UP) 8:10 AM to 8:15 AM 8:15 AM to 8:15 AM 8:16 AM to 8:30...

Hi, I am trying to run a macro, I am using the right code db.Execute "Macro1" ??? Thank you all Dim db As Database, rs As Recordset, r As Long Dim cncpath...

I would like to transfer the following Excel sub (it works, already test it) to MS Access. Could you please help me? Thanks to All Bre-x Sub...

Is there a way on MS Access 2002 count files? Example C:\mastercam\apples.mc9 C:\mastercam\apples.mcx C:\mastercam\oranges.mc9 C:\mastercam\bananas.mcx I...

Is there a way to change: GEORGE BUSH to George Bush ?? Thank you all Bre-x

Hi How do I know if a function has been susscessfully executed? Sub doit() Responce = myfunction("my msg") if Responce = "OK" then msgbox("OK") end...

Hi, I have this function : Public Function open_app() Call Shell("msaccess.exe ""M:\INV\Inv_JEFF.mdb""", 1) DoCmd.Quit End Function I would like to pass a...

using VBA how do you close? Thank you all Bre-x

I have this function to download data from a Pervasive SQL into MS Access Public Function get_hrs(WOPRE As Double, WOSUF As Double) Dim sql As String sql =...

Hi, I am exporting data to MS Excel ID, WOPRE, WOSUF, WOOPER 1, 5230, 23, 10 2, 5230, 23, 20 3, 5230, 23, 30 4, 5230, 30, 10 5, 5230, 30, 20

Suddenly I cannt compact/repair any of my dbs I get the following error: MS Access can't delete path\mydb.mdb after compacting it. The compacted database...

On a Datasheet Form, can you "Conditional Format" and entiry record? (make the row "Yellow" per example) Thank you all Bre-x

Hi, Is there a way to find out what field has been edited on a particula record? I have been ask to create a db and to record on a log table what record has...

I want to make a selection from a combo box and the selected value must update the necessary text field on the form. The Tradewind example (FORMS - Orders)...

I am labeled as "work" rather than my name. How do I change my label or the "from" label?

What i am needing is for a field to be automaticly filled in when i make a selection in another field. Ex: i have a drop down box that i choose a company from,...

I need to make one field required on my form only if the user checks the box as complete. I would like to have something pop up and ask for the RO# that they...

I have a form where the persons name and birthday and the spouse name and birthday and anniversary are entered. I want to be able to run a report and print...