Search results

Oh yes, one other anomalous occurance which might give a clue is that when I try to add a new Contact record from the Contact form, a box pops up asking me to enter a ContactID. ContactID is the primary key and is an autonumber field.

Hi I have written a database for my recruitment company. For certain attributes, on which I need to search (Business Area, Skill, Role), I have created Subforms within the main Contacts and Candidate forms so I can assign a list of such attributes. These are linked to "assignment" tables to...

Hi I've written a database for a recruitment agency. It stores details on candidates, clients, jobs, placements etc. Each candidate record contains a Hyperlink to a Word document contaning their CV. These docs are stored in a simple alphabetical windows directory, thus enabling the user to open...

This might not seem all that helpful but....it's usually a much better idea to design the database in terms of data, it's relationships and the tables you need to hold it - rather than thinking of the forms up front. When you design from the form down you often run into problems. Forms merely...

So you're gonna have separate tables for: Products Suppliers Product Categories Orders Sales Transactions What info will each table hold? Have a think about the relationships between them in terms of One-to-many or Many-to-many - which fields in which tables will need to look up information...

I didn't have a clue how to write my recruitment agency system until I bought "Access 2003 for Dummies". You might want to check it out. I'm no expert as I built mine just using the wizards and query builders etc - no actual programming. But what I found was that you need to make sure you...

Hi I've written an access database which has been working fine for a few weeks. I've have made a few changes to it as and when I realised it required new functionality. As of this morning one of the main forms just won't open. When I try to open it nothing happens. I also cannot delete it. All...