Hi everybody, The scenario is I have an MS-access database named ps.mdb,containing test table, at location \\test\data <file://test/data>. Also, I have another...
Kapil Not too sure of the syntax, but I think you need to look at the SQL command ALIAS. If you are creating an update query, switcht e QBE layout view to SQL....
Hi, I am supposed to create a database that makes searching 13 tables with a total of 650,000 records quicker. The tables do not all have the same fields or...
Hi people, I am new to this group as well as new to the world of access. Need your help to solve my problem. I send plans to suppliers on a monthly basis. I...
Hi, everyone. I have a little problem, and I certainly hope that anyone can help me out. I have a database called Library, and a three or four tables in it. ...
Anytime you search a table and not a field, the search is going to take a very long time. I agree with you that searching 13 separate tables will take longer,...
Hi, I havn't received any response to the message posted. May be it is a stupid question to the group, but it will be a great help to me. Hence, please do...
In order for you to get help, we need specific questions. Dawn Crosier Application Specialist "Education Lasts a Lifetime" This message was posted to a...
Hello Dawn, Thank you for reply me:) I’m trying to fix an access project. But it is giving me “Error msg” every time I tried to fix or do something in...
Hello, I guess u need to make some quries from the labrary table....then make Frm's out of the quries... take care me:) ivcebos <ivcebos@...> wrote: Hi,...
My DB is a litlle out of control. Too many forms I haven't used, not sure which ones I do. I thought there was an option to see which forms runs which queries ...
I don't know of one in Access but FMS has Totals Access Analyzer which will create reports that show where tables are used etc. ... [Non-text portions of this...
hello I'm currently in school trying to learn access. Not a whole lot of luck with this. Now my trial period of Office 2003 has expired and I don't have the...
Greeting's all. I'm fairly new to Access but love the power of it. I'm cross posting this in hope of getting over a project hurdle. I'm working on a database...
What I did was build a crosstab query of all the students and all the classes and the dates that the classes were attended. It was then very easy to see the...
Try using the campus computer labs. They are sure to have the full version of Office. Also dorms usually have computer labs setup that you can use if you...
Highlight the form then click on View > Object Dependencies. Guy Harley ... From: ms_access@yahoogroups.com [mailto:ms_access@yahoogroups.com] On Behalf Of...
I am developing a database for a company that sells products on ebay at commission rates for clients. When a client is acquired by the company, they are...
There are student versions at student process available through your school. In some cases as much as 50% off. Check with your school's bookstore. Even if...
Ok, I'm stumped. I'm desiging an Access db that shows a cable layout. Problem 1. Cables have two (or more) ends. Plug-a and plug-b with individule wire...
Hi, I have a subform, in which I'd like to put a second subform, but save the data to the same record on the same table. I insert the second subform on the...
instead of copy & paste use office links. Select the required report, click tools Office links analyze with MS excel. Krishnadas ... -- T.Krishnadas Rai ...
Tools/Analyze/ performance will be of help to some extent in access. Krishnadas ... -- T.Krishnadas Rai "RAI's" 101, 3rd C Cross 1st G Main, East of NGEF, ...
... Ok, I think I have Q.1 above whipped. I had to build a Wired_Plug table between Wire and Plug. I guess this was a many to many relationship.. who knew? How...
Hi all, i made a password protection for MS Access project Visual Basic Editor, but for now i forget my password. How can i edit my code again. Tahnks...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
