Recent content by rafal444

Thanks, I have the backup procedure, it is the scheduler I need to get working with the code...

How do I create a copy of mdb every one hour? Will it work when db is open. I also do not want to overwrite the old files. Just keep daily backups for 7 days, and keep all weekly backup for a year...

Do you have more details regarding the scheduler? What exactly I need to setup? Right now it just backups from inside of MS Access, OnTimer method of the form...

Yes, two files

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?

Can anybody help?

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

Value is a calculated field on the report. =NullToZero([my query field])

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 am moving stuff to VBa code, how can I reference other query fields in VBA code? Here is an example: Domestic HV Distribution Expenses Calculated: IIf(IsNull([Total Distribution Expenses]),IIf(IsNull([Domestic Distribution Expenses]),Nulltozero([Domestic HV Distribution Expenses]),([Domestic...

Here is the query: SELECT ID, Film, Name, MovieRelDate, StatementDate, [Domestic Theatrical Distribution Expenses Calculated], [Domestic HV Distribution Expenses Calculated], [Domestic Other Distribution Expenses Calculated], [Domestic Distribution Expenses Calculated], [Domestic Distribution...

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 wonder, maybe I need to populate the whole recordset. I have noticed taht when I move to the last record, the SQL causing the problem dissapers from Processes window in Enterprise Manager