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

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?

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

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

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

Hi There, In my report there are 7 grouping there are names they need to be in the details section, my problem is that detail information is appearing 4 times in the report, I just want to dipaly it once. Is there anyway I can control it by using counters. If anybody has any suggestion that...

Hi there, Like we use Chr(13) for next line, what was for tab? Does anybody remember? Thanks Annie

Hello, I have following groupings in my report Report Header Page Header Grp Header 1 (Last name) Grp Header 2 (First name) Grp Header 3 (ID) Grp Header 4 (Date) Grp Header 5 (Basic info about ID) Grp header 6 (More info about ID) I am trying to print duplex (double sided) so that the NEW "ID"...

Hello, Just wanted to thank all of you who had helped me so far, it is a great place. Here is my question I am trying to convert dates which are like 9/1/2005 to 09/01/2005 zero fill. Thanks Annie

Hello, I am trying to make the following if and else statement work as follows. Actual value (field name TEST) is String. Actual Value (TEST) Converted Value abc 11 xyz 12 bab 23 13 ERROR else...

Hi there, This issue of mine really getting complicated. My data set looks like this ID, AlternateID, first_name, last_name, birth_date 1,5,Tina,Roy, 05-15-01 2,5,Reena,Roy, 05-20-02 3,5,Mona,Roy, 05-25-02 4,6,Rose, Lippa, 06-02-04 5,6, Megan, Lippa, 07-04-03 The report is grouped by ID...