Search results for query: *

I am trying to open 1. create a macro that will open EXCEL workbook 2. count the number of columns, if it is less than 5 it will fails, gives error message 3. Counts to see, if it has more than 12 lines (records), if less it fails, gives error message. Thanks Annie

It seems kind of strange, when I used to bring in the subforms it used to trigger a wizard that would let me link parent form and child relationship, but for some reason I don't get that wizard any more. Any ideas....

How can we make sure only person is entering data at a given time, we tried setting up passwords but as long as other users has it they aslo can get in. Help please.

I have data entry screen which has data fields from different tables, I am very limited with my access so please help Table 1 Name ID Tag Table 2 City State Zip the form needs to have data form both the tables in the same screen. Name, ID, Tag, City, State and Zip but the field list lets me...

I have one main form from where user makes the initial selection, upon selection (clicking a button to open another form), when the user closes the second form the initial form looses it's size, I want to stay maximized, How can I acheive, I tried onLoad (Maximize macro) then I tried Onload...

Thanks looks like second option is a better option, should I add this code to the main forms BeforeInsert()

Is there any way a group of users can be blocked from modifying few fields NOT the entire records just few fileds. Let me know. Annie

I have used tab control to distribute the data fields for each records for e.g in each pane there are 20 data fields, I have over 4 panes like that all the data elements belong to each record. There is one data field in each pane that is required field if the user does not complete it then the...

Will it effect the performance that one of the table has 152 fields in a database, which will be used by 2 - 3 users for data entry and rest for read only.

How do you give data entry choices to some users (NO DESIGN CHANGES TO FORMS) and read only to others. Please help.

What is the maximum size of access database, given there are two/three users?

Well, if the word is converted to .txt file then how to parse the "data entry" part, so that I can populate one of the tables.

Hi, Can Ms-Word forms can be imported in the database? If yes, is there any link I can look to get how to parse the data. Thanks

Thank you so much, it worked !!!

Hi There, I asked this question before but now I made some changes but still was not able to resolve the issue. Name (Main report) (sub report) Contact names Contact phone numbers Each name has more than one contact and each contact has more tha one phone number. I am trying to keep all the...

Hi there, I have Crystal 9.0, it has 3 groupings, Name Contact Name Contact phone Number The number of Contact name varies and at the end of each set their is a line. As there is no way of knowing how many contact names are there, what heppens is for one set if the information is more than...

Yes I tried that and it worked, I am testing the other part of the question. Thanks for your help Annie

DB1 links to one table, which is hidden(SQL Server), a query is created out of that table. DB2 runs that query,creates a local static table, and the static table is only updated when the command button is selected. Annie

Hi There, I was wondering if some one can help me with this I have two Access databases 1. One Accaess database links to two tables by ODBC connection, that table cannot be seen when I select table menu in Access nor I am required to type the password for ODBC connection, How can I get to it as...

It is my fault I did not explain in details, every student has STDID and FAMILID So in the family table every sibling including the student who has STDID is part of it. So the desired outcome for a certain student would be all the siblings NOT the student itself. Annie