| Thread | Last Post | Replies |
|
| "Index or primary key cannot contain a Null value" error message | 09 Nov 2006 13:21 GMT | 7 |
I am very new to & unfamiliar with Access. I am working with an already existing database at my office. Yesterday, my coworker exported a table into Excel to fix data in one column. When she imported the table back to Access, we now get the error
|
| Is there any way to read excel data from other excel sheet | 09 Nov 2006 12:57 GMT | 1 |
I am very new for excel and trying to read some excel data from a particular sheet of an excel-file. Could anyone help me for this. Thanks in advance,
|
| MOD and QUOTIENT Functions | 09 Nov 2006 06:45 GMT | 4 |
I want to use MOD( ) and QUOTIENT ( ) functions in a query in Access 2002. But these are not available (although these are available in Excel 2002). Any suggestions what to do?
|
| Student Government | 09 Nov 2006 05:36 GMT | 1 |
I'm new to Access but I'm sure it will be much more efficient than all these binders and random files laying around the office. I don't even know where to start! Can anybody help me with the following:
|
| Need top value for each group | 08 Nov 2006 22:45 GMT | 5 |
I have two linked tables with a one-to-many relationship. TABLE1 Model Number (primary key) type
|
| Need advice on setting up tables and relationships | 08 Nov 2006 20:56 GMT | 3 |
I am a new user and not a programer or anything of the like. I have taken a user course on Access. What I want to be able to do is have a contact database for our company. I work for two accountants that are partners. I figure on one database per partner and one for joint clients ...
|
| has SP2 been fixed so it wont delete games | 08 Nov 2006 19:54 GMT | 1 |
had to reinstill OS to get SP 2 out . It pulls lots of games out and some are indorsed by MS. ive tryed to get answers about this starting on day one one SP 2 being ready of the pub. if this has been fixed then i well down load sp2.
|
| goto record on form | 08 Nov 2006 19:09 GMT | 2 |
I have a text box for searh criteria on a form and a button to bring up records showing on another form. Every thing works great except, all the other records lock out. (Default where no records match brings them all up as well.) I've been trying to use a goto Cmd, but can't ...
|
| Input of expressions | 08 Nov 2006 17:32 GMT | 1 |
I've got myself confused about expressions and code. First, where do expressions get inputted, specifically. I don't think I'm putting them in the right place because nothing different happens after I input them. Also, what is the difference between the expression builder and ...
|
| Is it possible to populate a record on different tables automatica | 08 Nov 2006 17:22 GMT | 1 |
I designed 7 tables, this tables collect different information about same individual ( Medical information) every individual has a unique value ,MRN, I put this MRN on all tables in order to relate these tables with this field. I will create a single long form containing all ...
|
| "Lock" images together? and then to background? | 08 Nov 2006 16:59 GMT | 5 |
I forget what it's called in another db app I use so I must just try to describe it. When I put two images together to create 1 merged image, I can lock those images together so that they act as one. Then I can take various elements and lock them to the background so that the user ...
|
| No more than two letters in a textbox ? | 08 Nov 2006 15:20 GMT | 2 |
I can't seem to find anywhere in the propperties of a textbox, where it is possible to set the max number of letters a user can write. I only want a user to input max two letters in a textbox. Where can this be done ?
|
| automatically enter information | 08 Nov 2006 14:43 GMT | 4 |
I have 3 different tables that make up 3 different forms. What I want to be able to do is enter information into these 3 different forms and have the information automatically enter into the 4th form. I have to have a report for each form and a final one with all the information ...
|
| create a primary key in an existing table | 08 Nov 2006 04:29 GMT | 3 |
I encountered problem when i tried to create a primary key in an existing table which does not have one yet. There are too many records in it and it's hard to find out which one is 'duplicated'. I'm not sure whether, if there is any duplicate records in the table.
|
| Query question | 08 Nov 2006 04:21 GMT | 2 |
Just a question about queries, I have made a query up where it list all the number from a certain field. But i want the query only to show the 5 highest numbers. I have set the field to descend but how do I get it to only show the first 5 numbers
|