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...
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.
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...
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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.