Search results

Thanks Nigel, We've looked at the suggested demo but it's giving us errors when opening - as novices we've no idea what the problem is.

I'm seeking some help in the creation of an appointment booking database for a disability support charity in South Wales. We need a simple and straightforward appointment booking database which our volunteers can use. The ease of use is essential as they have a variety of issues and...

I have been using a parameter query which was looking for contact types (from a lookup) in my main table. I've since changed the contact types to a separate table, which has caused the parameter query to stop working, and no matter what i try I cannot get it going again. What do I need to do?

Hi, I've just added a subform to my contacts database, since when the save command button isn't working. What have I done wrong?

Hi, Probably a basic error on my part, but I'm using the Comman Button wizard to creat Search, New Record, Save & Close buttons on my form - but when I click them I'm getting the message as attached. What's this all about?

Yes, worked great.

Thanks Dennisk, the /USER tip worked a treat!

Hi, I was in the process of setting up a new user on our database, when I think I inadvertantly changed my own permissions. As the owner & creator of the database I am now unable to open it up - am getting th following messag: "You do not have the necessary permissions to use the...

Is there a way to close (or hide) the switchboard when a form is opened from it? At the moment our database switchboard remains open and can be brought to the front of the screen when a form is open. Ideally I'd like it to be locked or hidden once a form is opened on top of it.

I'm afraid I can't get the code to work Agehoops. When I click the close button I get the message "The command or action 'SaveRecord' isn't available now."

Is it possible to assign code for savinge a new record to an exisitng command button? Ideally I want the close command button to also save any changes made, also the new record button (i.e. when entering a list of new records, each click of the "new Record" button will save the last new record...

Easy when you know how! Thanks!

How can I get a "Date Added" field to be automatically populated with today's date when I add a new person to our Contacts' database?

Thanks Dennsik, So will I have to have a copy of the mdw along with the db in order to work on it, once I have changed all the user permissions?

Hi, I've created a duplicate of our database in order to be able to work on the design of it from several locations. At present the database which is being used has been split into FE (on local machines) & BE (on server), with a .mdw file for the workgroup settings. For the duplicate I have...

Up until now the Call History form on our contacts database has worked perfectly. (It is based on the Contacts Management template downloadable from Microsoft). Suddenly, when opening the form it is asking for a Parameter of ContactID - this was the original name of the field when it was...

Can anyone give me a step-by-step guide to creating a subform on my contacts form, so that each contact can be assigned any number or combination of contact types (client, supplier, solicitor etc.). Up to now I have been using a listbox to select only one contact type, and this is now proving...

Okay, this is the Junction Table yes? I've created this now, what's the next stage?

I get that PK is Primary Key, but FK?

We store records of our contacts and generate reports based on what contact type they are assigned to from a list box (they could be client, supplier, volunteer, etc.) However, it's become apparent that our contacts should have multiple types assigned to their records (a client could also be a...