Search results

I would appreciate any help with this. I have a form which is used as an event log and check list. The form only needs to be edited as a once-off each day then an OnClose event macro saves the changes to a table via an Append query to record the information for that day. What I want to...

Re: How to go from Intermediate to Advanced An advanced user is someone who has not just done a single day course by a commercial "training company" and issues an "Advanced Access Programmer" certificate to everyone in the class including those who finish the day still trying to work out how...

Ok. This is what I came up with as a macro to do the job. It works, and importantly allows the option for any user who exits the database before the backup is done to opt out. (This is not a true backup of the database but simply appends a "snap shot" of the clients table to a "Daily Stats...

Ok, I'm still thinking. What I am considering is including an IF expression at the beginning of the "backup" macro to check to see if there are any records in the target table with today's date. If not, proceed to run the append query, if so, go to the next action. Does that make sense? If...

Yes you are right. I ran the macro and got the error message. I am happy that I got the error because it confirms that the PK is preventing duplicates. What I want now is to be able to run the macro and only have an error for issues that are not related to the PK conflict. What I want is for...

Actually Galaxiom I would have thought that the standard update query I have now would suffice, as the new dual-field PK will fix any issues with duplicates, so only new records will be inserted anyway. That simply leaves the scheduling issue and actually writing the Macro to run the update...

Thanks Calaxiom 1. Yes that seems obvious but I didn't know if there was any problem with adding a field to the PK in an existing table. I will try that today. 2. My only issue with this is whether the database can open with no users logged in. If it can then no problems, I can schedule it...

Thanks for everyone's advice. What I think I have worked out that I need to do is: 1. Add another field to the primary key on the backup table. This is because the source table has ClientID as the primary key, but the amend table has many records for every ClientID. So, I need to know...

arnelgp, my problem is not the backup of the database as such. The database is backed up on our servers automatically. I use a macro to run an apend query. This query simply apends one table to another existing table as a backup. The first table's data changes every day and throughout the day...

Ok Ranman256, I believe you but I have no idea what you just said :confused:. In English: I set up a separate database - ok, got that. In that database I have a single form on which I place a single text box - in that box I set the default time. - I guess that's the time I want the backup...

I know this question has probably been asked a thousand times, so if you have a good link to point me to that will be great. I have a macro that runs on close to remind the user to perform a backup. The backup is a simple append query that saves a table recording the day's client service...

Thanks The Doc Man, that seems to be the issue. It must be an Exclusive Open issue which prevents editing the records on linking from the intermediate form. I have now deleted the intermediate form and just generated a form based on the filtered list in one step, and this seems to work ok...

I must be going insane. I have a console form with links to various forms etc. I have a control button that opens a query. From this button the query opens in edit mode. Records can be edited. All good. The query can also be opened in edit mode directly from the object list. But if I...

Yes you are right, I didn't realise that.

That did the trick arnelgp! Thank you. Interesting how in design mode the SQL doesn't compose correctly some times. I am still learning the finer points of SQL so this is a good lesson for me. Cheers, Steve.

Unfortunately that didn't work. In it's most basic form this is what I want: SELECT tblDailyStatsBackup.ClientID, tblDailyStatsBackup.MavisID, Count(tblDailyStatsBackup.CallDate) AS CountOfCallDate FROM tblDailyStatsBackup GROUP BY tblDailyStatsBackup.ClientID...

I have a frustrating problem. I have a table of clients (ClientID) and dates they are called (CallDate). The table is an Update table populated from daily backups. So I have a list of every client and every date that each has received a call. I want to generate a report that summarises how...

Yes of course! DLast( worked fine. I knew that I knew the answer but sometimes I forget that I know :o. Thanks pbaldy!

I must be having a brain fade, but I just can't work out how to incorporate an unbound text box that I can edit to appear on a report. The report's source query is a parameter query. I want to be able to have a general message box on the report to convey monthly messages to recipients. I...

I tried the VBA but couldn't get it to work, so I found a work-around. I just made a new form with a hidden ClientID field behind a subform taking up the entire form area, and simply nominated the parent and child ID's as per normal, and hey presto! It works. Thanks a heap anyway MarkK. I am...