Search results for query: *

How do I setup automatic backups in Access? I setup OnTimer event on the form. The problem is that the form needs to have focus... The code, it copies the current db into new file... Any idea how to get this working when other forms are open? Maybe other solution?

How do I create a tabbed menu like on www.buysellcommunity.com? The menu has two bars: 1) Top bar (just tabs) 2) Second level menu (just links) Th second level bar should change depending what ios clicked on the first top bar I was looking into CSS Adapters, but the problem here is that the...

I am getting this error. How to test for it? I have tried for IsNUll(Value), is error(value) isempty(Value) All returns False! How to check for this error???

The query below is droping many statements, It only shows statements for 6/30/2006, which is the latest statement out of all movies. I want to show the movie and the latest statement for that particular movie. This is the query I have: SELECT A.* FROM [QryReportBase_CalculatedAll Step 4] AS A...

I wrote the union query of queries A and B. When I execute each seperatly it works. When I execute A Union B I get "Division by zero" error. Does not make too much sense. Any idea?

How do I populate (Move Last and Move First) the whole recordset when the form opens?

I have moved all the tables to SQL Server using upsizing wizard. However now users experience big problems, the database hangs. I did some research and I have noticed that: 1) There is a blocking process 2) The blocking process SQL is: "SELECT "dbo"."Contacts"."ContactID" FROM...

I would like to have a way to select multiple Products from the list. How do I make the report to show only records selected in the list box?

How do I automaticly backup database everytime user exits Access application?

I would like to redirect to a custom page when there is application error on the server. Can I do it globally? This is the error: Compilation Error ... Compiler Error message: CVT1106: cannot write to file

How to have database withlinked tables to another the database in the current folder? I want to split my database to two seperate files, so I can update the user with interface changes only, without overwriting his data... Both databases would always exist in the same folder. I do not want to...

I am writing queries with some complex IIF statements. I find it very difficult to edit and read those Expressions in Access Editor. Is there any other/better Editor I can use to edit those statements? Here is a sample: Domestic HV Distribution Expenses Calculated: IIf(IsNull([Total...

I want to send email from Access application when cerain query returns records. I would like to send Access Report as PDF to the receipents. Can I put it on the scheduler? Wonder how other people aproached this issue... Thanks in advance.

Hi, Can somebody recommend good music software which has the following synch feature. 1) I want to Synch all files from Zen Touch mp3 player to my librarry 2) Once I delete file in Zen Touch Mp3 player I want to have it deleted automaticly in the computer librarry 3) Nice To have: Once I...

I have a main form and subform showing all the related records. It is one to many relationship, so i am showing the subform as continous form The problem is that if I want to hide certain fields based on the type of record, it hides field for all records. That is not acceptable, since each...

I have created a tab control within another tab control. However it is always visible, no moatter what page I am on. I want this sub tab control to be visible only on Page number 2... It is like tab within tab, but only on a specific page...

I ahve very long title for Page Caption in the tab. It is truncated. How do I change the size of the tab's caption?

I have created a subform based on SQL Server linked table. It worked fine when it was Access table, but now I can not add anymore records

I want some fields accessible for some users only?

1) User used to get an error message in Access 97, showing the locking information (user). Once it was known they could ask the user to close the application. After upgrading to 2003, this message detail (locking user) is no longer available. Is there any way to enable it? 2) Do you think that...