General :: Order Of Tabbed Documents

Oct 17, 2012

Because of certain design considerations and the amount of data I'm maintaining, I have chosen to use tabbed documents rather than floating windows or subforms.

The hierarchy is supposed to be a person who is categorized as either a client, family member, donor, etc. Further, a client may use one or more services. In the example, our client uses Specialized Home Care. However, the tabs are intuitively out of order: the people tab is left-most, followed by the Specilaized Home Care tab, and lastly the Client tab. It should be People, People:Client, People:Client:Service. If a person uses a lot of our services, there will be separate People:Client:Service tabs and the People:Client tab will scroll off to the right. I'd like Access to order them properly but see no way to do it.when the forms are opened, it's people first followed by the high-level classification (i.e. Client), and the lastly the specific Client:Service tabs. I would expect Access to open and display them left to right, but, as you can see, it doesn't.

View Replies


ADVERTISEMENT

Forms :: Tabbed Documents Icon On Caption Bar

May 25, 2015

Customizing the form with the following code

Code:

Public Declare Function LoadImage Lib "user32" _
Alias "LoadImageA" _
(ByVal hInst As Long, _
ByVal lpsz As String, _
ByVal un1 As Long, _
ByVal n1 As Long, _
ByVal n2 As Long, _
ByVal un2 As Long) _
As Long

[code]...

I can load the little icon on the left on CaptionBar.It works very well on overlapping mode but no on Tabbed documents. How to works with tabbed documents mode?

View 9 Replies View Related

Forms :: Set Form Property To Window In Database Set To Use Tabbed Documents

Oct 16, 2013

I'm using access 2010.

How to set a single form's property to act as it's own "overlapping window" in a database that is set to use tabbed documents. I want most windows to have the tabbed layout but there are a few that I would like to have pop out and be their own windows.

I noticed that the Northwind database did this somehow. if you click on one of the products from the home screen a form pops up in its own window. I tried reverse engineering it, but no luck so far.

View 2 Replies View Related

Freezing Header Of A Form In Overlapping Tabs Instead Of Tabbed Documents

Feb 16, 2015

I have a form (frmMain) which has a header with some basic links and text boxes I would like to keep as a frozen pane on top as the user are scrolling down the detail section of the form. The detail section does include a subform if that makes a difference (frmhome). When going to Options>Current Database> tabbed documents, the form header stays frozen perfectly.

I however would like to use "Overlapping windows" as the form center aligns in the Access window instead of left aligning when using "tabbed". So either :

1) how do I keep the header frozen in "overlapping" or
2) how do I center align the form in "tabbed" view, as right now the form just wants to go as far left as possible in the full Access window.

View 1 Replies View Related

Forms :: Access 2013 - Adding Cross Close Command On Tab In Tabbed Documents Mode

May 25, 2015

I would like to add a cross close command on the tab in tabbed documents mode. Is it possible to accomplish?

View 2 Replies View Related

Forms :: Mixing Forms Overlapping Windows And Tabbed Documents

May 22, 2015

Is there any way to mix together on a db based on tabbed documents some overlapped forms?

View 4 Replies View Related

General :: Button Attaching Documents To Forms

Jul 18, 2012

I'm trying to use this API in my database to be able to attach documents to my forms. [URL] .....

Do I have to put this into its own Module? I'm not familiar with how the code is defining Types and declaring Global variables.

View 5 Replies View Related

General :: Checking Specific File For Documents With Same Name

Jun 4, 2014

I have a button that when pressed it checks a specific file for documents with the same name (example: Test, Test 1, Test 180, ect...)

Code:
Dim StrFile As String
StrFile = Dir("C:UsersJohnDesktopTest*test*")
Do While Len(StrFile) > 0
Debug.Print StrFile
MsgBox StrFile
StrFile = Dir
Loop

The problem with this is if there are 2 files with Test (Test, Test - Copy) It gives me 2 separate message boxes. The first with Test. Then a second message box with the second file, Test - Copy. I want to combine both of the message boxes in to one. So the message box would look like:

Test
Test - Copy

View 1 Replies View Related

General :: Creating Database For Indexing / Organizing PDF Documents

Mar 19, 2013

I would like to Create a database for indexing / organizing PDF documents. My Company currently use a 3rd party accounts program and we raise sales and purchases using numerical numbers ( but we can Jump to a new range of numbers within the program) for example if the purchase order numbers become simliar to the sales order numbers. But this 3rd party software does not let us scan documents into it hence the need for an alternative database.

For the data base I was thinking if only creating a index of the sales order numbers to start with. the first few question I have are.

1.) Should I Use the Autonumber as my first index column or should I replace it with our own sales order numbers in that column.

2.) is there a way to autopopulate the sales order numbers in a table for historical sales numbers.

3.) can you scan directly into Access

How to start planning the design off the database as I know this is almost the most important aspect of a database.

View 2 Replies View Related

General :: Evaluation Form - Scanning Documents To Get Counts

Nov 6, 2013

Once a year we have a conference that has about 400 people attend. These people will participate in several classes, randomly, over a four day period. Each class hands out an evaluation form. This form has six categories and asks you to rate each from 1 to 5. This is done with a grid on the form labeled with 1 2 3 4 5 across the top and the attendees will put a checkmark or X in the appropriate box. This results in approximately 3000 evaluation sheets.

I will take these and manually enter the scores into a database I created in order to tally the results and generate reports. I have been asked to see if this process can be expedited by using a scanner to pull the scores from the sheets.

View 1 Replies View Related

General :: Saving Program To Current User Documents Folder?

Aug 31, 2014

I have an access program and i want it to save a copy into a location... ive got it so it can save however - i want it to save to the current users documents folder (win 7)

What file path would i use?

View 5 Replies View Related

General :: Retrieve Links To Find Some Documents - Adding Message Box?

Dec 21, 2012

I have a report named Link_report which retrieve links to find some documents. I would like to add a Msgbox to say: " No link has been found for this document" when the case link is empty.

View 10 Replies View Related

General :: Open Tabbed Form To A Specific Page?

Jan 21, 2014

Can I open a tabed form to a specific page?

If I'm in the form I can move focus by using

Me.[Page 12].SetFocus

but when opening using that code produces and error Page not available?

View 3 Replies View Related

General :: Tabbed Form - Displaying Filtered Subform

Dec 5, 2013

I've attached a link below:

Basically, its a database for an entertainments agency, I've got a form for 'Artists' which shows the performers on the agencies books. I've tabbed the form so one screen shows the artist details and I want the second screen to show the bookings that the specific artist has.

I've linked to the 'bookings' table on the subform successfully, but I can't figure out how to filter it so it just shows the bookings that the specific artist showed has.

i.e.: I want it so that The Deltatones booking tab ONLY shows the deltatones bookings.

Here's the dropbox link : [URL] .....

View 8 Replies View Related

General :: First In First Out Order Shortage

Mar 25, 2013

I need to design a query in which order shortage is calculated with respect to fifo method for orders .

Attached is the logic

How to create it. and if i need to incorporate more than 10 orders , what is the best method for this ?

View 3 Replies View Related

General :: Using Autonumber As Order Number

Aug 13, 2015

i am going to use the autonumber as an order number but I want " SC2015 in front of it so i end up with " sc20151 , sc20152 but next year i want it to change the year SC201650 .how to put the sc2015 in my report without any input from the user

View 2 Replies View Related

General :: Scrolling Form Order

Jul 11, 2013

I have a table with about 290 record. When I'm in the "Form View" and click the "Next Record" arrow it scrolls by order of Employee instead of the primary key "Record Number".

View 11 Replies View Related

General :: Updating Sort Order Of Records

Nov 10, 2014

I have a table with entries describing a sequence of Tasks (tblTask)

tskID TaskDescription
10 Clean Room
12 Wash Dishes
etc

I have second table called Steps (tblSteps) that is related to tblTask via the field "StepNumber" which is a concatenation of [tskID] & "." & [StepOrder]
So if we look at washing dishes as a task then the steps are as follows:

StepID, StepDescription, StepOrder, StepNumber
202 Put plug in the sink , 1, 12.1
512 Turn on tap, 2, 12.2
205 Put in detergent, 3, 12.3
210 Place dishes in sink, 4, 12.4
435 Turn off tap, 5, 12.5
etc

If I decide delete the third step I get the following:-

StepID, StepDescription, StepOrder, StepNumber
202 Put plug in the sink, 1, 12.1
512 Turn on tap, 2, 12.2
210 Place dishes in sink, 4, 12.4
435 Turn off tap, 5, 12.5

Is there a simple way renumbering the StepOrder entries when one step is totally removed to give me the following?

StepID, StepDescription, StepOrder, StepNumber
202 Put plug in the sink, 1, 12.1
512 Turn on tap, 2, 12.2
210 Place dishes in sink, 3, 12.3
435 Turn off tap, 4, 12.4

View 6 Replies View Related

General :: Order Payment Database - Balance Due

Nov 22, 2012

I am new to Access. I am creating a simple order/payment database.

I have tables for the orders and payments and have a relationship setup.

I created an order form with a subform for the payments.

[URL] .....

View 2 Replies View Related

General :: Get Some Information To Show Up In Chronological Order?

Jul 17, 2015

how to get some information to show up in chronological order.

For example,
It is showing up like this..

Week 1
Week 10
Week 2
Week 20
Week 3
Week 4
and so on

I want it like week 1
week 2
week 3
week 4
week 10
week 20

View 8 Replies View Related

General :: Sort Order For Topmost One-to-many Relationship

Dec 6, 2013

I am currently studying Robert Jennings book entitled Using Microsoft Access 2007 Special Edition. In reading about specifying of the sort order and top value limits established by inner joins (pg 455), the author makes this statement.Access displays query result sets in the order of the index on the primary key field of the table that represents the one side of the top most one-to-many relationship of query tables.An example of a query with Orders, Order Details, and Products tables displays rows in productID (the primary key field in the Products table) sequence. He says that it does so because the Products table has a one-to-many relationship with the Order Details table and indirectly with the Orders table. I do not understand why the Products one-to-many relationship with the Order Details table is ranked as the top most relationship in that the Orders table also has a one-to-many relationship (OrderID is the primary key field) with the Order Details table and an indirect relationship with the Products table. The Order Details table has two primary keys (ProductID and OrderID). My attempts to change the sequence in which the table relationships were formed as well as the location of the tables in the database had no effect on the result.

View 2 Replies View Related

General :: Automated Order Status Field

Feb 25, 2014

Basically working on a Customer Order Database for my carpet shop.

I have a Customer, Job and Order table. The order table contains the line items for each job and each customer can have many jobs.

I have a field in the Order table showing the item order status being either "Instock", "To be Ordered" or "Ordered"

I also have a Job Status field in the Job Table

I would like that Field to be automated depending on the item order status for each item on the job.

At the moment the Job status is a manually selected drop down box of either; 'Ready To Fit', 'Awaiting Stock', 'Items To Order' or 'Job Complete'

For example if all of the items had a item order status of 'Instock' then the Job Status would display as 'Ready To Fit'

If any of the items were 'To Be Ordered' it would display as 'Awaiting Stock'

I dont know how i would solve the situation of some marked as say 'In Stock' some 'Ordered' and some 'To Be Ordered' ????

Also the 'Job Complete' would come from another field in the Job Table marked with a check box...

View 5 Replies View Related

General :: How To Order Values In Multi-Select List Box

Jun 4, 2013

Is there a way to order the values in a multi-select list box:

1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20 appears in the listbox as:

1,10,11,12,13,14,15,16,17,18,19,20,2,3,4,5,6,7,8,9 . Is there a way to have it appear as it does originally?

View 1 Replies View Related

General :: Creating Auto-Sequential Order Number

May 6, 2013

I am trying to create an auto-sequential order number

Example : AB000112 - AB is standard prefix, ''0001'' is the first invoice number, ''12'' is the year 2012.

so the next order number should read AB000212 and the next AB000312

Out of this, I have to issue several debit notes relating to the same order number when the payments are due from customers over a period of time, this will be

001AB000112
002AB000112
003AB000112

Can such numbers be the primary key?

View 4 Replies View Related

General :: Order Database - Discount Table With Percentage For Each Item

Aug 23, 2013

I have been asked to create a database that creates orders, debits stock etc for my company. Now I have been asked to put in some kind of discount table with percentages for each individual item for each individual customer. What would the best way of doing this?

I figured in the Customer Table I would have a code such as 'CustomerADiscount' and 'CustomerBDiscount' etc. and then in my table maybe

Product A - CustomerADiscount - 10%
Product A - CustomerBDiscount - 20%

Product B - CustomerADiscount - 5%
Product B - CustomerBDiscount - 7%

This link these values up within a query? Would this be the best way of doing it?

Is Access able to determine a percentage in "10%" or "5%" or do I need some type of formula for it instead?

View 3 Replies View Related

General :: Use Drop Down Control In Service Order To Select Customer

Mar 1, 2014

I have a client table.
I have a client product table for ski's
Each Client has 1 or more products (skis)

I have a Service Order table and form that I use a drop down control in the Service order to select the customer.In the Service Order Form a I have a continuous Subform for detailed service.

This is where I'm having the problem.In the detail subform I want to select from a drop down box the customers particular ski that I want to service. how to have only that one customers ski's to show up.

View 14 Replies View Related







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