General :: Separate A List Box In Two Categories

Nov 28, 2012

I would like to separate my list box in two categories.Indeed it is composed by 2 types of criteria but arranged in the same List box (I can't create another List box, it's forbidden).how can I proceed?I've thought to insert a dash but it has to appear all the time and I don't know if it's possible to do that.

I've also thought to enter a title IN the list box above each category but it has to appear all the time too..when I click on one item in the List box it becomes highlight.May be code the 2 titles I could add for being always selected (highlight).I don't want to have to select the 2 titles every time!!!

View Replies


ADVERTISEMENT

Tables :: Structuring Categories And Sub Categories

Dec 27, 2012

Suppose I receive boxes and store them in a room. Each box can contain items that are either shaped as cubes or spheres and I have to allow for the addition of more shapes in the future, but only one shape can be in each box. Each box contains a random number of shapes and two boxes may, or may not, contain the same number of shapes as another.Cubes can be either Red or Green, Spheres can be either Blue or Yellow.

I wish to set, and have the ability to change, how many cubes and how many spheres, on a percentage basis, I wish to have (e.g., 60% Cubes and 40% spheres).I also wish to set, and have the ability to change, what percentage of cubes I want to be Red and Green and which percentage of Spheres I wish to be Blue and Yellow (e.g., Cubes -Red 70%, Yellow 30% )

e.g. -- I have several boxes totaling:

Cubes
Red 30
Green 40

Spheres
Blue 10
Yellow 20

My goal is to produce three reports.The first report would provide the Target and Actual number of Cubes and Spheres expressed as a Value and %. The #'s would simply be calculated from my desired % . So, if I wanted to have 60% cubes and I had 100 Shapes, my target # would be 60. If I had 200 Shapes it would be 120. (i.e., The actual number of shapes I have is simply a factor of how many I receive and I have no control over this.)

The First Report would look like this

Target % - Actual % - Target # - Actual #

Cubes 60% 70% 60 70
Spheres 40% 30% 40 30

The second and third reports would be the same format but would break down cubes into red and green and spheres into blue and yellow.I can accomplish the Report that breaks down the shapes but I am running into problems with the next level as I need the total number of shapes and the the total number of only Cubes or Spheres to insert into the expressions.

View 2 Replies View Related

General :: Combo Box To Select Categories In Subform

Oct 24, 2012

I use a combo box to select products and place in my order details sub form .I now realise i need a catogories table . How can i get my combo to look up a categories table then go the products of that table then enter in my orderdetails.

View 1 Replies View Related

General :: Finance Database - Setup Categories Per Transaction

Sep 8, 2013

I'm developing my own personal finance database and the part stumping me on the design is how to setup the categories per transaction. For example a primary category would be "home" and the secondary category would be "furnishings". How do I set this up? I'm getting stuck on how to tie it into the transaction table.

I'm familiar with writing SQL queries, but this is really my first stab at database design.

The relationship diagram is attached. The transaction table and the category tables are to the right of the diagram.

View 10 Replies View Related

General :: Rearrange / Move Custom Categories In Navigation Pane

Oct 15, 2014

I use custom categories in the navigation pane to make finding the right objects easier (duh) but now I have quite a lot of custom categories and they are stuck in the order they were created in.

I would like to rearrange them into some logical order (maybe alphabetical, maybe custom) so i can find the categories quicker.

View 1 Replies View Related

Queries :: Extracting Data From List In Separate Field

Sep 19, 2014

695515*97
531924*11
495853*131
377035*181

Is there a way to extract the 97, 11, 131, 181 numbers from the above list in a separate field?

View 1 Replies View Related

Reports :: Writing VB Code To Loop Through A List Box And Create Separate PDFs

Aug 19, 2015

I have a sales report that I generate each week based on a query, which relies on the input from a combo box on a form. This works great - but I have select each salesperson, one at a time and run their reports separately.

I'd like to have some code that will run through each person on the list, generate their report, create the PDF, and email (or save) the file.From my initial research, it appears I will need to utilize a List Box (vs a combo box), so I can select multiple salespersons for the report.

I've found a few examples of code to use...but a little lost on how to implement. I create a new form with a list box that queries the property table for the list. I then added a button to execute the code, and attempted to add this (with my control and reports names substituted). Getting all sorts of errors -- so not sure I'm on the correct path.

'Posted by ADezii 5.23.2009 on bytes.com
'Modified by Gina Whipp 11.4.2009 to OutputTo Multiple Files
'Tested in Access 2003 with a Combo Box

Dim intCounter As Integer
Dim cboCode As ComboBox
Set cboCode = Me![ YourControl ]
'If Your Data Type is Numeric use this section

[code]...

View 14 Replies View Related

General :: Link Two Separate Clients?

Apr 9, 2013

I'm creating this database for a claims management company. Yesterday I learnt about making a many to one relationship between the claims and clients tables.

Turns out its more complicated than that. Since I'm dealing with claims, a person may add their partner as the second claimant. (usually the case in mortgages)

So where parties A and B are in a relationship:

person A may claim on their own
Person B may claim on their own
Person A may be the primary claimant and add person B
or conversely person B may be the primary claimant, adding person A.

The end goal is to automatically fill in a financial form (making use of a mail merge). So from what I know I think this means:

that grouping them as one contact is not going to work as I need them to be able to do a solo claim, and also I will not be able to easily change around who is the primary or secondary claimant, which will then carry over onto the mail merge.

So I think this means I need them as two separate contacts. However, I don't know how to create a link between them to easily add their partner to a claim.

Would this also mean I need a many to many relationship between clients and cases.

View 4 Replies View Related

General :: How To Secure Data In Separate ACCDB

Jan 27, 2015

I'm building an application in MS Access 2010.

This application must be able to read from a big table in a separate accdb.

This separate accdb contains info that should NOT be available for all my users to copy, as it is valuable competitive information that could be abused by people with bad intentions. So, a linked table solution is not an option.

However, it should be possible to run parameterized queries that do simple look-ups that return only small/relevant portions of the database.

View 6 Replies View Related

General :: Query To Separate Columns In Table

Aug 14, 2014

I have a table tblItemSold

ItemNum Date Sold
1111 Aug-10-2014 25
1111 Aug-9-2014 24
1111 Aug-8-2014 23
2222 Aug-10-2014 11
2222 Aug-9-2014 12
2222 Aug-8-2014 13
3333 Aug-10-2014 5
3333 Aug-8-2014 3

I want to write a query and transform above into

ItemNum Aug-10-2014 Aug-9-2014 Aug-8-2014
1111 25 24 23
2222 11 12 13
3333 5 3

View 3 Replies View Related

General :: Creating Separate User Permissions Without VBA?

Aug 19, 2014

The problem is I need it to be only editable by 1 user, but allowing multiple other users to access it and view the records- just not able to add/edit/delete them.

The other question I had about the Split database would be- Does having a split database mean the data needs to be updated in 2 tables or am I taking Splitting databases too literally?

View 14 Replies View Related

General :: Splitting Quantity Into Separate Rows

Mar 5, 2013

I have a query that holds info for a WORK ORDER FORM. E.G The work order requests 3 staff member.

Is there a way to have a separate table or query split this quantity into three rows so i can assign an employee to each request?

I sometimes get requests for 20-30 staff and dont really want to add lines manually.

View 1 Replies View Related

General :: Possible To Store Forms And Reports In Separate FE

Jul 27, 2013

I have an A2007 database used for time and billing. As time goes on I've had to add more forms and especially more reports. I feel the because of all these "additions" the FE is getting a bit bloated, something like 2.2MB right now.What I want to inquire about is the possibility of moving at least some (if not all) of the forms and reports to another FE and can this be done without having to move tables and/or queries?

The navigation pane is "hidden" from the users so they don't see all the tables, queries, forms and reports but some are smart enough to figure out to "unhide" the navigation pane.Concerning the forms; there are certainly some forms that I do not want other users to open out of curiosity, or for whatever other reasons they might have, so these I would want to move. The same basic reasoning would apply to the reports.

My thinking would be this; move a particular form/report to a separate FE that merely acts as a "bucket" to store the form/report. Clicking on the control in the main FE would open the form/report stored in the other FE using the tables and queries in the main FE.can it be done without having to re-write a bunch of code? I know I can add code so certain controls aren't visible to certain users but I've not found a way to permanently lock and hide the navigation pane.

View 4 Replies View Related

General :: Separate Image Per ID On Table / Form

Sep 24, 2014

I have the need to put a separate image per ID on my table/form or a separate link to an image I can put an image on my form but its does not change when I change my clients its the sam e all the time, I have tried linking to an excel book but for some reason it will only show 10 fields, (and it is linked).

I don't mind creating a standard windows folder with my images in but would need to be able to link to each one from my form.

View 8 Replies View Related

General :: Delimiting - Separate File Into Individual Records

May 24, 2013

I am trying to import several hundred records into Access from a txt file but I can't find a way to separate the file into individual records. A portion of the file is given below:

'C Olive Teece', 'Census, 1940', 'birth: 1919 New York', 'residence: 1940 Ward 4, Canandaigua, Canandaigua City, Ontario, New York', 'spouse: John H Teece', 'parents:', 'children:'
'Edith Teece', 'Census, 1940', 'birth: 1888 England', 'residence: 1940 Smithtown Town, Suffolk, New York', 'spouse:', 'parents:', 'children:'
'St Clair Teece', 'Census, 1940', 'birth: 1867 Pennsylvania', 'residence: 1940 Ward 3, New Castle, New Castle City, Lawrence, Pennsylvania', 'spouse:', 'parents:', 'child: Edward C Teece'

View 14 Replies View Related

General :: Put Combobox / Listbox Values In A Separate Table Or Not?

Jan 29, 2015

Whenever I create a combobox, Access asks me if I want to grab the values from another table, or if I just want to manually input the possible values.

My question is: is one of the two solutions "better" than the other?

Let's imagine I am creating a Form where I can create a new Contact, and in a listbox (with multiple selections allowed) I want to list the possible character traits, so I have

- Funny
- Annoying
- Smart
- Interesting
- Good-looking
- ...

I think that if I need to store in the Contact records these possible traits, I will have to create a Many-to-Many relationship (therefor creating a junction table) between Contact and Traits.

On the other hand, could I do everything without grabbing values from an extra table and directly inputting the values in the listbox? How would these elements be stored in the Contact record if I allow multiple values in one single field?

View 9 Replies View Related

General :: Simple Audit By Posting Whole Record To Separate Table?

Jul 30, 2014

I need a simple audit capability

I have a table (Called Master Active List)

I have an empty duplicate of it called History of Master Active List. (Identical fields, with the addition of a distinct ID (primary key)

I have a form where the master can be changed (Called customer details)

When any change is made I want to post the whole record to the history table

1 - Am I correct I no longer need a form based one,(office 2013) and can do one on the data table itself?

I want to capture everything, can this be done with a wildcard, or do I need to go line by line?

The master table has a ton of fields.

View 3 Replies View Related

General :: Extract Multiple Values From A Cell To A Separate Table?

Aug 18, 2015

I have imported an Excel table with a column which has several values in one cell separated by "". In my case names of institutions afiliated with a patent. Example of the format of a single cell: MASSACHUSETTS INSTITUTE OF TECHNOLOGY (US) RIVE TECHNOLOGY INC (US)

In order to normalize the Access database I would like to extract the institutions to a separate table (institutions) and that the patent is related to both institutions.

I am using Access 2007.

View 2 Replies View Related

General :: 2 Fields From Separate Tables Needed To Create Calculated Field?

Aug 19, 2013

The interface being used is a main form with various tabs and a subform on each of these tabs.

There is one field ('max power density') in my database that is calculated using 'Max Rated Power' and 'Cylinder Capacity' however these are in different tables and subforms. The 'max power density' and 'max rated power' are in table and subform 1 but 'cylinder capacity' is in table and subform 2. Is it possible to keep them in separate tables/subforms and still calculate the field?

View 7 Replies View Related

Categories And Sub-categories

Jan 23, 2005

Hi,

I'm very new to Access, having used it for the first time today :)

I've got a database to write for a media database as a learning example and I've run into my first real problem...

I've got a table for users and I've got to allow users to be able to own one or more media types, e.g. CD, DVD, video, record, etc. Of these types, there are sub-categories for most of them. For example, a DVD may be a horror film, action film or music video, and a CD may be hip-hop, rock or blues, etc.

I thought I could have a reference data table containing a category ID and category value, together with a reference data category table which simply listed the categories. This would work fine if a user could only have one type of media but of course they can have several. So, I thought about having a "composite category" instead which would contain a category, whether it contained a sub-category and a sub-category ID. I'm trying to get my head round this and wondered if this must surely be a fairly common issue to solve. Does anyone know of any pointers or any examples I could do with looking at?

Sorry if I haven't explained it too well :o

View 2 Replies View Related

Categories

Oct 28, 2005

Okay here is my silly little issue, my boss decided to add sub categories, just when I get the database set-up.
Table 1
Category
Category_ID
Category_Name

Table 2
Sub_Category
SUb_Category_Name

Table 3
Contacts
Company
Contact
Adress
Ect Ect

I would like to be able to have each contact grouped by category, then sub category..but I am not sure how to get the relationship to work.

View 2 Replies View Related

Multiple Categories

Aug 9, 2006

Hi guys,

I am implementing a new database (Access 2000) for my company.

It contains contact details of a subscription base.

Four tables are present MEMBER, ORGANISATION, EVENTS and CATEGORY.

My problem is; people attend events, and i want to record this in the database. Each event has an event ID field, and an event description field.

When recording the events which people attend, i could just use the event ID field, but problem is that people can obviously attend more than one event..

Also;

People belong to a certain category

Again i have a category ID field, but people can belong to more than one category.

Any ideas on how to record this info??

View 4 Replies View Related

Newbie - Categories

Jan 3, 2007

Hi,

I am working on a database to list all the inkjet cartridges we sell. Within the printer table, I want to list which category they are on our website. For example, Epson C20 Printer would be in Ink & Toner > Epson > Inkjet > Stylus C & CX Series.

I what some way to enter these in a number of fields, say Cat1, Cat2 etc. I havent a cluw what would be the best way to do this? Has anyone got any ideas? I am thinking about some kind of drill down but wouldnt know where to start on this. Any help would be gratefully received?

Cheers

J

View 3 Replies View Related

Categories And Subcategories

Apr 1, 2005

I'm wondering how to design an Access database with the same type of structure as "Yahoo Shopping!". The Yahoo site allows search for women's clothing or men's clothing or all clothing...please explain how the relationships are structured.

Is it just one category table with queries that display results of a search of multiple categories? How do I structure it in Access queries and forms?

Thank you!

View 5 Replies View Related

One Record Multiple Categories

Jan 20, 2005

Hi

I've built a contacts database which consists of one table containing contacts and services provided and a table with a list of categories, each has a PK autonumber id field. My problem is that individual contacts could fall into multiple categories, could somebody tell me how to do this.

Many Thanks
Anita

View 5 Replies View Related

Ranking / Top 10 Under Multiple Categories

Sep 18, 2007

In a table I have:

- Category (A, B, C)
- Family (A1, A2, A3, B1, B2, etc)
- Item
- Sales

I'm looking for a way to get the top 10 items in each category + family based on sales (ie: top 10 in A-A1, then A-A2, then A-A3, etc). When I try using the top function, it doesn't treat each category + family combination as unique. Any ideas?

View 5 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved