Recent content by akar33

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...