Search results

Hi there people I was just wondering if the sort could be removed from groups. Secondly i have a size field by which i want to sort out a report - and i want it to display small, medium, large and then extra large - how should i go about doing it?? Bert.

Thanks Guys Thanks guys, Help Really appreciated Bert.

Hi there people, I am facing a really trick situation - that has me baffled. I am creating a database for a Home Textile Firm and the problems i am facing are : 1. The products have very different attributes e.g. A Flat Sheet will have Width, Length, Drop, Hem A Sham will have Width...

Fee Management Ok Here Goes: I want to track student information - Name, Father's Name, Address, Class etc. Then the fee paid history also needs to be tracked for each month - The student can be promoted to a higher class or repeat the same class in either case the student will start paying...

Fee Management Sorry Dreamboat for not being more specific - Actually i have been asked to design a database for a school - The requirement is for the fee (entering fee information - Tracking defaulters etc.). Best Regards, Bert.

Hi there people, I am trying to design a school fee management database, i was wondering if any of you gurus have done anything similar. The main problem i am having is the class (do i maintain a separate table or what?). Any help would be appreciated Bert.

Need Suggestions I am designing an inventory control / Order information system for a home textile factory - i have run into a problem that i hope someone will assist me with. the data flow is somewhat like this: Fabric is received from the mill | Stored in the fabric store | fabric is...

Networked Db Problems Thanks for your replies, Yes i have opened the recordeset as dynamic - the actual problem is in the validation - see the example below: two frontends open on 2 computers. now the form validation goes like this: Button Click (CMDSAVE) Requery recordset ' to get the...

Hi there people, I am working on a database that will be running on a network - Anyway i have split the db - Everything i running just fine, so we decided to test the validation on the forms - (By the way i am using ADO). If there is an interval between the users making an entry into the same...

Hi there Pat, Thanks for your reply and the links - i have finally sorted out y problem thanks to the links provided. What i have one is created two tables one products and one sub products- then when i want to know how many sub products will be required to complete a product - i just build a...

Hi there people, i am having trouble with the design of my products table - my actual situation might be confusing - so i will use the following analogy of a Resturant to describe my problem: Ok here goes: A Fast Foo resturant Sells individual products - like Fries, Burgers, drinks etc...

Coplicated Relationships Thanks for your suggestion, Will rethink the design. Thanks again, Bert

Hi there people, I am designing a database for a Home Textile Exporting firm, and i am stuck. My problem is that when a buyer places an order he/she can order one or more than one product - which means a one to many relationship between the PO table and the Products table - This is fine. Now i...

Hi there People, I need some suggestions, I am working on a database for the company i work for - it is a home textile exporting firm - everything is just fine up to this point - the problem i am having now is that they way i have designed the database is like this: DATA FLOW: Order placed...

Hi there people, I have this querry based on two tables that have a one to many relationship - sometimes the many side will have values and at other times it won't - when i run the query i only get results of the records that have corresponding records in the many - any suggestions??? Bert.

I recently thought it would be good if i had users and passwords set for the database - i am using Access 2000 - so i go ahead and try it out - it works fine, but now i want to remove it and restore it back - since i am asked to enter the password for every database file i open on my system...

Hi there people, I have recently joined a company that is using Foxpro 2.6 to store their info. I have suggested to them to switch over to access 2000, but they are convinced that there isn't much more to access than there is in Foxpro - i know that Access is better in many aspects but don't...

Hi there people, I have a field (Decimal Data type) which will consume 12 bytes of space - this field will be left blank at times - i am worried as to if the null fields will also be taking up as much space as the ones filled in??. Bert.

Input Mask How about trying: 99"/"99"/"99 Bert

Hi there People, I was just wondering if there is a way a record is saved or written to the table only when a save button is pressed rather than having it saved when the user types???. Bert.