I have a form with some code that allows the user to hit a command button that deletes the current record. Access routinely asks the user to confirm that they...

Hi, I am using Access 2003. When I open another instance of Access via Automation, it will ALWAYS become visible after executing the OpenCurrentDatabase...

i have a find button on a form and it works, but when a record is not found, it moves to the first record. how do i keep it on the current record? here is my...

I would like to create a query that groups my data by month, qtr or whatever time frame I choose and average my other fields in the query. For example I have...

My company employs a SQL back end with an Access 2003 front end. Recently, two computers on our network have been having their Access crash multiple (up to 10)...

****

Hi, I would like to see if it's possible to make "Insert Comments" in Access 97 as in Excel? Thanks, KIT LAU

Using Access 2K which as tables in ms sql 2K that it links to. in the code I have this: Set rstDeliveryHeader = New ADODB.recordSet rstDeliveryHeader.Open...

How can I check if a string only contains numbers and no other symbols? Richard

I have a access db that was created and working fine with access 2002. I opened the database with access 2003 it seemed to work fine with no errors and closed...

Hi, Can anyone help resolce a databse issue I have. When I open it I get the error message Microsoft Jet database engine stopped. Im really need this...

Is there any way in Access to reverse the .mde file back to an .mdb. I accidently deleted the .mdb file and need to make changes to the database. Please...

We have an old app that is in based on Access 97. We need to replace the server ASAP. Will Access 97 run on Server 2003? Thanks.

I have an expression which includes the number "365" allowing me to get a daily value for an annual figure. The only problem is if it's a leap year the result...

I think ADO.Net creates the wrong date/time on your computer. Please check your computer date/time. -- HTH Van T. Dinh MVP (Access)

i am using access 97. I have a form where i enter data, after i am done entering data i want to be able to hit a command button and that button fires a query...

Ok I know there has been much discussion about dealing with time, but I am having a time trying to get something to work. We have a schedule table that lists...

We have developed several powerpoint presentations and are having cross platform issues. As files are ported between IBM's and Mac's slides lose all their...

I frequently import text data (formatted the same way each time) .. this data is then appended to one of my tables. Each time I import I have to define the...

I've adapted a template database to record data for my project. Another office (same company) would like to try it out. When I copy the database and just...