Search results for query: *

I'm designing data entry forms and have a few many to many relationships that I've broken down into one to many relationships with join tables. The type of data entered will be bibliographic data. Example of tables (to name a few) Author_tbl AuthorID (primary key) AuthorName...

I'm trying to create a combo box on a subform. I have a many to many relationship between two tables. I'm creating the main form with one of the tables, and the subform with the join table. Now when I'm creating the combo box, I need to have the ID stored in the join table. Problem is, if I...

I'm sure this is very obvious to most of you. I have a database which will start out as purely data entry - there will not be any data to start with. I want to enforce referential integrity, but in the testing process, the users are trying to enter data, and they keep getting error messages...

I've searched the forum regarding why a query wouldn't return data. So far, I have not been able to solve my problem. I know there's probably an easy solution that I'm overlooking. The problem is when I'm querying tables that have many-to-many relationships, where I've created join tables...

I have a database (concerning bibliographic data) with the following tables: Main Table Title of Document Author1ID Organization1ID Author2ID Organization2ID Author3ID Organization3ID Author4ID Organization4ID Author Table Author1ID Author1 Organization Table Organization1ID Organization1...

I need a sanity check on my database design. The database will store bibliographic information and will be queried (explained below). Here's what I have so far. Main Table ID Source Title Source Type Name of Periodical/Newspaper, etc Author 1 Organization 1 Author 2 Organization 2 Author 3...

Hi. I am trying to use the word mail merge feature to import data from my access database. I have several drop down boxes in my data entry form. When I merge the data into word, the data shows numbers instead of the actual text. Anyone know how to fix this? Much appreciated!

I have a database which contains bibliographic data, including authors, organizations they're affiliated with, title of works, publications, etc. The data entry form is set up with 4 separate author fields with 4 separate corresponding organization fields (e.g. author1, organization1, etc.). I...

Is there a way to set the text box size to over 255 characters? Thanks!

One of my users is getting confused by a data entry form. When he closes the form and exits Access, it saves his entries in the master table(obviously), but when he opens the form again, the data does not show, and he cannot get back to see previous records he entered. Is there a way to have...

I have a database where multiple users will enter data, but it will not be on a shared network. Either I will distribute a master or each user will enter the data into their copy and then I'll have to merge the data at one point. My question - will autonumber work since all data will be merged...

Just doing a sanity check. I have an Access data entry form which needs to be published in bibliographic form in MS Word. I think I found a way to do it using the Merge feature in Word (format: catalog) and inserting the fields I need from my Access table, inserting commas where I need them to...

Hello. I have a field in a form that has many possible entries. What I envision is a field on the main form, and then the user clicks to open a second form which lists all the possible entries. The user needs to be able to select as many of the entries that apply - so they may be selecting as...

Hi all - here's what I need to do, but I'm not sure how to go about it. I have a main data entry form where users enter bibliographic information. I have a word document, already created, that's in bibliography format. Is there a way to link the two so that when users enter new data into...

I created a few listbox tables linked to a main table with the lookup wizard. I have a main data entry form created from the main table, which contains the listbox tables. The problem - the form will not allow the user to move on to the next record until every listbox field is filled out (a...

I have built multiple lookup tables attached to a main table. I want to alphabetize the records in the lookup tables, but since the records are already there and the tables are setup with autonumbers, it won't take my changes. I've sorted the fields alphabetically, but the form won't update...

I'm working with an Access 2000 form. Does anyone know of a way that a user can search a form and see the number of hits (finds) they have? Example: user searches form, gets a dialog box that says "10 hits (finds)", then they view their results. The goal here is to allow the user to...

Hello. I created a "Find" command button that opens the Find and Replace dialog box. I've been working on a way to change the defaults for the Find and Replace Dialog Box. I found an article from Microsoft's support website, but I'm still confused. It says to "start the Find...

I'm working in Access 2000. Is there a way to set the find function (binoculars) to default to the following: LOOK IN: Entire Form MATCH: Any Part of Field Thanks!

Is there any way to make the find function not space sensitive when using a form in Access 2000? E.g.: when I type in "M uriel", it won't find the word "Muriel" in the form because of the space. Thanks - any help is greatly appreciated!!!!