Search results

This one is good - has good examples and explainations of normalisation: http://www.blueclaw-db.com/ms_access_examples/

Hi, I'm having problems getting a form to show records that I've just added through ADO. The following code is in a module. What I'm doing is creating a new transmittal record (like a delivery note) and a drawing record. The code to add the records works perfectly - they are there when I look...

Go to File| Get External Data | Link tables then you can navigate to the backend? HTH, RCurtin

The FE of my database has been crashing during the last week and there have been a few other problems. I got errors saying that the BE was an 'unrecognised format'. I remember getting a 'not a valid bookmark' error also. Another odd thing that was happening - when I put breakpoints in my code...

Thank you. I appreciate your time.

I have 2 main user groups - one is document control and the other is managers. There will only ever be 4 or 5 users at most in document control. And yes they do have the necessary permissions to create reports and queries. Originally they didn't as I had given them an mde file but then the...

Thanks for the prompt replies. I will back them up in that case. I found information about this a utility called the access Workbench: http://www.everythingaccess.com/accessworkbench.htm More info here: http://www.vb123.com/workbench/help/backup.htm Apparently you can schedule backups with it...

Hi everyone, Do I need to have a backup system with my database for the backend? The backend is stored on a server that is backed up everyday and tapes are kept for a week. There will be 2 maybe 3 main users writing to the database. Thanks, RCurtin.

Decompiling Front end? Ok I have just decompiled a copy of my front end. It didn't give me any errors. Does this mean there is no corruption? When I had decompiled it, I compacted it using the compact/repair in Access. The original copy was 2,608kb after being compacted. The new one that I...

Hi Rak, Thanks for your reply. That problem did go away when I relinked it. However I am still worried that the front end may be corrupted. (I am pretty sure that the back end is ok as I used the Jet compact utility to compact it and it didn't give any error). How can I find out if there is...

Corruption in Front End Does anyone have any tips? Reverting to a backup of the front end is something I'd really rather avoid because I don't know when the problem started. The database has been crashing in the last week but I didn't realise that it could be that the database was corrupt...

Compacting and repairing database Hi, I've just spent all morning reading about corruption. I'm no closer to finding out about the unreserved error. I did import the tables from the backend into a new database and used the Jet compact utility to compact it. It didn't give any errors. (I...

Hi everyone, I am getting the same error. It happened whenever I checked a checkbox on a form. This was working perfectly before. The checkbox is bound to a field in the underlying query - very simple and there is no VBA code attached. I relinked the database to the tables in the backend and...

Thank you Thanks Rod D, This was the line I used in the condition in the end: [DateReceived]>CDate(Reports![rptDrawingsRegisterByOrderNum]![subRptDrawings]![txtLatestDate]) The only thing was it applied the formatting to all the records - not just the ones that met the condition. Means I got...

Could anyone give me any tips??

I have been trying to fine a solution to this all day. I have a master report called: rptDrawingsRegisterByOrderNum and a subreport called: subRrtDrawings. What I want to do is prompt the user for a date when they open the master report. Then i want to make bold all drawings listed on the...

Sample DB I have just attached a scaled down version of the database if someone could have a look at it..

I tried that and this is the error that I got: Error number: 3022 The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the...

OK I've been going round in circles tyring to solve this problem. I have imported data into a temp table and parsed the records through ADO. That works perfectly. When I open the temp table all the records are there with the necessary changes. However the next step is to append this data to...

Sorted it out! I found the problem - I had a me.requery in the form load event of the subform!