Recent content by chiefvj

Thank you very much for your prompt response. I will give it a try.

Why can't Microsoft upgrade Access without completely changing the look. In Access 2003 I can easily disable the shift key and hid the tool bar.. etc . How can i do that in Access 2007?

Does anyone have any idea how to code in VB... a link a to a IP Address?? thx.

Apprv is yes/no.. The answer I should get running that query is 4. The constant "compforOffday" minus 1 chvSelector that is a "comp for off day"..My query results in 0 records countered.

I am trying to get this query placed in a control running on a report to execute correctly. .. =[CompForOffday]-Abs(Sum([chvSelector]="Comp for Off Day") & abs(sum(apprv)) CompforOffday = 5. This is how the table looks.. chvSelector Apprv...

I have a access 2003 application that automatically sends an email message notifiying a client when a request has been approved. I found a thread on how to do that in one of your forums ..so thanks a bunch. However, Outlook pops up a message stating that a program is trying to send an...

Thanks for your help.

Is it possible to customize a VB for Microsoft Accees message box. For example change the back ground, change the fore ground color etc. ?? thx

thanks i will give it a shot

When a user launches an Access database for the first time a security warning pops up...I have to go to Tools>Macros and set the security warning level to low. Can I use VB code to turn off that warning? thx

Everytime you open an Access database( a backend with the tables for example) a Record-Locking Information file is created. That file is deleted when the database is closed.....True? Here is the problem...if the backend database is in a folder with limited permission ie. can delete records but...

Thanks for the response...I finally got it to work with this coding.... Private Sub dfld35_Click(cancel As Integer) On Error GoTo Err_Command144_Click If dfld35_Cnt = 0 Then dfld35_Cnt = 1 Call Check_DDDate(dfld35) Me!dfld35.BackColor = vbRed ' this call loads Else...

Here is the code fot the click and double click events.. ************************************* Private Sub dfld1_Click() On Error GoTo Err_Command144_Click Call Check_DDDate(dfld1) '**** this calls a function that opens a PopUp form.. "dfld1" is a date that is passed to the function. the...

thx for the early response. I gave your code a try...but I'm still havin problems...

Here is the situation...When I click on a control in one form... another form opens and a record is loaded in a table. Now... I would like to double click on the same control and delete the previous record that was loaded. The problem I'm having is that I never get to the double click event...