Search results for query: *

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.

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...

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

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...

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...

Please...I would like to use VBA to link to a Database on a network computer using the IP address or its URL. thank in advance.

I have a Access application with front end( forms, queries, reports) on 4 desktops and the back end (tables)on a network server. The problem, one user accessing the tables and the application loads and excute searches very fast. More than one user accessing the tables at the same time and the...

T have a timer event that closes a database application whenever there is no user activity on a form for over 20 mins. However, if one of many VB message boxes are waiting for a prompt from a user, the timer event to close the appication is never executed... Any ideas on how to close the msgbox...

How do you code a Batch file to run from within Microsoft Access?

Does anyone know why whenever you run any kind of Query Access will automatically add kB to the size of a database. 1. I have create a new database and imported the Queries, Forms and Reports and I have the same problem. 2. I have created new queries linked to the same tables and the problem...

Private Sub combo_sport_KeyPress(KeyAscii As Integer) Dim TheKey As String TheKey = KeyAscii If TheKey = "324" Then ' if the user hits the space bar ' check for the ascii code 324 MsgBox ("We are in a space " & combo_sport) Else MsgBox ("keyascii= " & KeyAscii & vbYesNo) End...

I'm not refering to a null. I want to trap ie. a space that a user accidentally enters into a field. thx in advance.

Can anyone help with a thread to how I can check to see if a file exists. I have a back-end database and sometimes the server crashes. I need to check to see if my application can link to the tables and send a custom message notifying the user that the application cannot link to the tables. thx...

Can someone point me to a thread that has code which will find a string anywhere in a field. For example, if I had a field with "AAAAAAAAAAAAAAAAAA jack aaaaaaaaaaaaaa", would Access or VB be able to find the "jack" in this field? thx for any help

I took over a Lotus database that was created using Lotus Approach. I was able to convert the tables to Access 2007. However, the tables have no key fields. How do I create a key field without generating an error message saying duplicate fields will be created? thanks for any help.

any threads available on what and how to use the various event procedures?

I have 2 gig of RAM... using geforrce fx 5500 pci video card. Running Windows xp media Center. Machine is 3 weeks old and I have loaded Premeire 2.0 numerous times and it causes the computer to crash. Any ideas. I have taken it to The GEEK SQUAD and they cant get it to run.....