Search results

Hello everybody, I have a table called Sponsors which lists the sponsors and the concerts each sponsor has sponsored over the past ten years. The only problem is that everything is on a single table, when it would be much more user friendly to look at if the data was arranged on a Form in a one...

Hello everybody. I have a database with a bunch of company names with their contact names, adresses etc. linked to a subform with details about correspondence made with each company. I was hoping to add some sort of code that searches automatically for a matching record based on what you start...

I have a combo box that works just fine that I wanted to add a little more pazazz to. What I was hoping to do was have a field that is normally hidden pop up (or reveal itself rather) if the user selects 'No' - this would allow the user to record a 'Reason' for the 'No' I understand I will...

I just discovered an interesting bug in the code I was using to find a record matching a control. I get a run time error (#3077) that states that there has been a "syntax error (missing operator) in expression." Here is a copy of the procedure that governs the combo box. Private Sub...

Is it possible to have a three-way cascading combo box? For a database for a small museum, I have a set of two cascading combo boxes, the first for a particular artifact's general category (like communication artifact, or a personal artifact etc) which affects the contents of the subcategory...

Hello. I've been working on an small museum artifact database and the main identifier of each object is the object's accession number. Before, this number was a long integer but it was later found that we needed more than the maximum number of figures that long integer would give. We selected...

I have a field on a form where the date is input. Right now, as a Medium Date field microsoft wants it dd/mm/yyyy and I was wondering how I could change that to mm/dd/yyyy? is there a way to use an input mask for that? it doesn't look like any other of the date choices would help. Thanks

Hello all... I have been working on a small museum Artifact database and am having problems with a form that is supposed to look up records of artifacts which are displayed in a subform. The user enters the donor's name, phone number etc. which is saved in a table, DonorTable. After the...

I have been working on a small museum Artifact database and am having problems with a form that is supposed to look up records which are displayed in a subform. The user eneter the donor's name, phone number etc. which is saved in a table. After the donor's details have been stored, the user...

Just wondering if it is possible to add scroll bars to a memo box that contains a lot of text information. Just curious whether this is possible because the user right now has to scroll down manually to find a certain insert. Thanks for any help you guys can offer. Cheers, Bachfile

I have two cascading combo boxes. They work - you select one Category from the first box and the SubCategory boxes update so you can only select the related subcatories. There is a small problem with this however - the subcategory box appears empty when I select a different record (e.g going...

Hi guys I have a "daily update" form for users to use after they have finished entering data etc. so that they're steps are retraceable. I made so instead of having separate records - I made it so that there was only one record, with all of the info provided being appended to a memo field that...

Hello again! I am doing an "Updates" form which has name, time, date and updates done fields so that updates/changes to the database are recorded on a regular basis. I have removed the navigation bar and instead of having a separate record for each update, I wanted to append or add to a locked...

Do any of you wizards of Access have a clue how I would go about creating a form for adding notes of what was updated to the database every day? I've seen one before where you type in the day's updates in a text box, press a button and it pasted it to another text box that was locked and you...

Just a simple question - how do you get into a form's properties? I keep getting the properties for the form's detail section or form header section, but never the actual form properties where I can add new fields to my form. Thanks, Bachfile

I am constructing a database for a small museum. I've got two main forms - one for entering a donor of an artifact collection's name and one for entering detailed information about each artifact in a collection. The donor form has input for the donor's name, address and phone number and has a...

Hello again, I keep having a problem Enforcing Referential Integrity which allows Cascade Update on two tables. The "One" table is a Category table with fields CategoryID (autonum) and CategoryName (text). The "Many" table is a SubCategory table with fields SubCategoryID (autonum)...

Hi, I have two combo boxes that use similar information for this museum database that I have just started (but its working finally) To catalogue the artifacts for this museum I have many descriptive areas, including the object's category and subcategory. A category would be personal objects...

Hi, I am designing a database for a small museum with the purpose of cataloguing all of the artifacts in the museum using hard-copy records. I've got two main forms to enter the data - one form to enter a donor, their name, address and phone number and another to enter all of the information for...

I'm pretty much a new MS Access user who's started a database for a small museum from scratch for storing artifact records. I have a field on my form for the donor of each artifact. The thing is, many people donate much more than one artifact, which means their name must be typed in the exact...