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.

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

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

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

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.

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.

Hi there people, I am working on this database for a fabric export company - The inward table is somewhat like this: Design Color Construction Type Qty --------------------------------------------------------------------- Ashville Red 30x30/76x68...

Hi there, I am designing an Inventory Database using Access 2000 - Now there is a field (Text) that will be used to specify the location - it can be numeric and alpha numeric - e.g 1A/01 2/09 Area1/08 4/09 Now i want to sort these records alphabetically - e.g Area1/08 1A/01 2/09 4/09 but...

Hi there fellow programmers. I am designing an inventory database (First for me). What i need to do is track input and output and finally the staock in hand. Now i have come up with multiple ways of doing this - (Designing the structure). The first being: Just one table to hold both the...

Hi There People, This is my first post on this forum. I have been working on a project (Using Access 2000) for a Textile exporting company - Ething works fine except for one kind of Report that i am having problems with - The report will show the Stock in hand.It is simple up till this point...