Modules & VBA :: How To Divide / Distribute Books To Boxes

Apr 18, 2015

I have a list that shows how many books we have for each PO No. (Sorted by PO No.) Like below:

LIST 1:

Code:
PO NoTOTAL BOOKS
PO-0001 12
PO-0002 15
PO-0003 26

Now I would like to distribute/divide these different books to boxes and each box gets maximum 10 books. Like below list:

LIST 2:

Code:
BOX NOBOOKSPO NO
0001 BOOK 1~10 PO-0001
0002 BOOK 11~12 PO-0001
0002 BOOK 1~8 PO-0002
0003 BOOK 9~15 PO-0002
0003 BOOK 1~3 PO-0003
0004 BOOK 4~13 PO-0003
0005 BOOK 14~23 PO-0003

Format is not important in the list2, for example in Box 0002 we have book 11~12 means (book 11 of 12 +book 12 of 12) in po-0001

+ book 1 of 15 until book 8 of 15) in po-0002

books have bookno, for example for po-0001 we have 12 different books it means we have bookno (1 of 12) until (12 of 12) for this po no.

How I can produce automatically list 2 from list 1 by query or coding.

View Replies


ADVERTISEMENT

Access Books?!

Dec 14, 2006

Hello all Access gurus and wizards,
Hope this is the right area to post this...

Just wanted your opinion on a good Access book, possibly complete with training CD. I would like to have something that's pretty comprehensive in terms of topics, from basics to 'advanced'.

My background:

I've taken a couple Access online courses myself, so I'm pretty familiar with the very basics of it (creating tables from scratch, importing excel to table, linking text delimited, basic select queries and very beginning of action query like append query, forms, basic switchboard using wizard).

I've used access personally at work, creating some reports myself from scratch (meaning from linking stage to final report).

The only book I have is Using Access 2000 by Roger Jennings (I think it's by Que publishing). After I bought the book I realized it's more of a reference book for the experts, so I need something more 'down to earth' for somebody my level.

I personally would like to learn more about (or at least familiarize myself) with action queries, macros, perhaps just some basics about commands/VBAs (enough to at least know or benefit more from this great forum), linking datawarehouse, etc.

I came across 'step by step Microsoft Access'..I think it was $19.95, which I might purchase, but I would welcome additional comments/suggestions.


P.S. Bob Larson- I'm in Portland too.

View 6 Replies View Related

Access Books

Dec 12, 2007

Hi,

I want to purchase an easy guide to Access 2003, does anyone know of any good books out there that are simple to understand??

Thanks:)

View 2 Replies View Related

Can Anyone Recommend Me Some Good Books?

Dec 6, 2006

I don't want to buy something just because some guy on Amazon says it's so awesome that I have to buy this book!! :P

Anyway here are some things that I am looking at learning:

Access/VBA
SQL
Visual Basic


Any GOOD book recommendations would be great, and much appreciated. Thank you!

View 3 Replies View Related

Books For Access Developer...

Feb 16, 2006

Guys,

I need some good books for Access developers.. I want to what Access really can do.. I know create tables and queries.. How about create stored procedures and triggers using VBA in Access? Or any other more complex tasks in Access. I want to know more about this.

Thanks.

View 1 Replies View Related

Tips Needed: Access Books, Graphs, PDF

Jun 26, 2005

Hello,

I am about to start a project where I must link an Access front-end database to an Oracle backend. I have about a year of Access development behind me now, and now here is the next challenge.

What I have to do is create analyses of data and output the data mainly in the form of diagrams (i.e. graphs or charts). I have seen how this can be done with Automation in Access in a book by Alison Balter (Mastering Access 2000 Development), by controlling the Excel object etc.

Here are my 2 questions:

1. I am considering buying another book on Access now, something that will contain more examples/methods for presenting information as a graph with the help of Excel. Should I stick to buying an Access book, or should I look into getting something that is more Excel programming oriented, i.e. something like an “Excel programmers compendium”? Any recommendations/tips to get me started would be appreciated.

2. The users want the graphs that I produce to be saved as a .PDF automatically at the push of a button in the Access GUI. How is this done? Do I need special software, or can I use something like PDFWriter to automatically convert the Excel graphs into .PDF’s?

Thanks in advance for the tips and have a nice day! :)

J

View 3 Replies View Related

Queries :: Show All Books Not Borrowed By A Reader

Aug 23, 2013

How can I show by query all the books that has not been borrowed by a chosen reader?

My query setup is:

Table 1 readers( name etc.)
Table 2 books (name etc)
Table 3 Table of borrowing dates linked by 1 to many link to tables 1 and 2

View 11 Replies View Related

Distribute DB To Many Servers

Jul 7, 2005

I have developed a db (A2K) which will be distibuted through our companies franchising system to various licensees. These licensees generally operate in a single PC environment but occasionally they will be based on a server network. The single user is fine but I am stumped by the server situation as it impacts on the various links I have set up within the database to files etc that are part of the program but are external such as Excel, Word files. The current links are all set up as C:MainFolderNameFilename. Of course these all stop working when I place it on a server and link the users up via shortcuts. On our own installation I changed the links to the \MyServerMainFolderNameFilename format and everythings fine but due to the number of links this is a fairly lengthy process and I wouldn't want to have to repeat it at every clients installation.

Can any one please advise me if there is a way to set it up so that I could say enter the clients server name in a field. Then insert that field's contents into the pathway details for the links so that they all update automatically.

Your assistance would be greatly appreciated.

View 4 Replies View Related

Best Way To Distribute Application

Jan 3, 2006

Hi, I have a large database containing information that people all over the country want to access. I've designed a main form that contains 3 subforms that queries information from raw data. Now that the database is complete, i'm looking for the best way to distribute it. I've tried to put it on the network drive, but it has been rediculoursly slow. Could somebody tell me what would be the best way to do this? Thanks!

View 1 Replies View Related

Distribute MS Access

Sep 6, 2007

Hi,

I want to distribute an Access database to users, some of whom may not have Access installed on their computers.

The database has been developed using Access 2003 and I was wondering how I can distribute the database as a runtime version to my users.

Any help will be much appreciated.

Thanks,

Harmonic

View 9 Replies View Related

Cannot Distribute Database To Other Computers

May 26, 2006

I created the database on my computer. I added security and split the database to put the tables on the the server. Everything works just fine on my computer. However, when I try to copy the 3 files for the front end of the database to other computers on the network, it won't work.

Perhaps I'm confused as to what files need to be migrated to each additional computer or I don't have the security setup properly.

Right now, I move 3 files. The main database file with the front end. The shortcut file that is created when you add security and the security file that is created when you add security to the database.

I'm stumped.

View 4 Replies View Related

Distribute DB With Access Runtime

Jan 12, 2008

Hi

Does anyone have a good easy sugestion on how to distribute a db with access runtime in a package to users without access 2003?
I have tried setup2go and it makes a fine .exe file.
But I can't make the package with access runtime.

Thanks

Mikael

View 1 Replies View Related

Distribute Row Information To Columns

Jun 18, 2012

I have a Query with many part numbers in column A and their inventory location(s) listed in column B. However, some part numbers are listed 2 or 3 times because the item is located in multiple inventory locations. How can I take these items and put list their inventory locations in multiple columns across one row?

What I have:

ITEM# Quantity INVENTORYLOCATION
A1 5 Warehouse 1
A2 3 Warehouse 1
A2 6 Warehouse 2
A3 2 Warehouse 1

What I want:

ITEM# INVENTORYLOCATION Quantity 1 INVENTORYLOCATION 2 Quantity 2
A1 Warehouse 1 5
A2 Warehouse 1 3 Warehouse 2 6
A3 Warehouse 1 2

View 3 Replies View Related

Database Complete Time To Distribute

Jul 27, 2007

Hello,

I have finally completed my database project. It is a split database. Back End on a network server.

I want to distribute the front end to all users however I want to limit to the best I can what they can do to it. Can someone please advise me on the best way to wrap up and send out my front ends?

All security has been established. I am talking about the availability to see the tables, macros, control bars etc..

Any suggestions would be greatly appreciated.

Fen How

View 1 Replies View Related

Query - Divide

Mar 13, 2006

Just wondering, if this is possible and if so how?

I got query results and would like to divide a figure from the number of results shown..

so if 4 results are shown from the query then i would like to divide 100 by 4, and if 5 results showed then divide it by 5?

View 5 Replies View Related

Divide By Zero Error

Sep 12, 2006

How can I avoid a divide by zero error in an MS Access Query?

View 2 Replies View Related

Divide And Store

Mar 17, 2005

Hi hope someone can help,

What I’m trying to do is work out price per quantity, at the mo I have a database that has products and price so lets take paint for an example.

If I have a 5 litre pot of paint and I’m selling it for £10 I would like a field that tells me the price per litre, so what I’m think I need to do is have a field called ”price” and divide it by a second field called “quantity” and output the sum to a third field called “price per litre” which populates the database.

Sadly I haven’t got a clue how to do this with access and if anyone can help it would be much appreciated.

Thanks

View 1 Replies View Related

Divide By 1,000 Like In Excel

Oct 24, 2006

HiIn Excel, I believe you can format a number and automatically divide it by 1,000 without messing up rounding.For example, 10,000.06 after you apply the formatting becomes 10 as in 10k (for some reason accounting people find this easier to look at/work with). However, if you try to sum the value Excel will actually use the decimal figure rather than the number 10.Is there a similar way in Access?

View 2 Replies View Related

Text Box Divide By Zero

Dec 8, 2006

Hi,

I have a text box which contains a formula. When the text box is divided by zero, it appears #ERROR in the text box. I would like it to be invisible when it divided by zero and to be visible when it has a number.

Any ideas?

Thanks,

Le

View 3 Replies View Related

Access 2007 Package And Distribute Suggestions

Dec 28, 2007

All -

I have just about finished up a Split DB that I plan on deploying in a LAN environment. The goal of course is to turn what looks like an Access Application now into a non-access looking application where the Front End can be distributed and run on any computer within the LAN.

I have several questions that I may need some help on.

How does one go about hiding the Access Shell and/or Ribbon/Nav in 2007?

How would I add a form that allows for a user to navigate to and connect to the back-end without having them check all of the appropiate tables and then browse to the back-end file if they have a different drive letter mapped to the location of the back-end files for example?

Any tips on how to sign the DB so the pesky Trust Center question can be bypassed?

Any other tips on how to simply distribute this for a LAN environment and/or make it look NOT like an Access DB with access to view the Forms, Tables, Queries, etc. This is my first Access DB project, let alone a LAN distributable one.

Thanks!

View 7 Replies View Related

General :: Distribute Field Value Into A Listbox In 2 Or 3 Columns

Sep 25, 2013

i want to display a single field values in list box with query as row source.the query will produce variable number of records or rows. sometime 1, sometimes 3 or 6 my thought is to distribute these records/row into list box column. for example:

if query = 1 then listbox column = 1

if query = 6 then listbox column = 3 (two rows per column).

View 1 Replies View Related

Queries :: Evenly Distribute And Assign Records?

Jul 31, 2013

I have multiple databases (Front-end, Back-end, Import, Reporting) which enables auditors in our company to audit loans.

I use an Import database which imports a random sample of loans (10%) into the Back End database for audit. I import a spreadsheet of loans (let's say 5000 loans) into the Import database, and I have the query return 10% of the loans, which is then imported into our Back-end database for audit (500 loans for audit).

Currently the auditors look at the daily list of loans (the 500 imported loans) and divide the work amongst themselves (5 auditors will audit 100 loans each.) They decide Bob will do 1-100; Joe will do 101-200; Bill will do 201-300; etc.

Is there a way using a query to assign these loans to specific auditors when importing the loans into the BE for audit? I would need to enter how many auditors will be working the loans so the work is divided evenly, and then enter the auditor's initials. (Since the auditors perform different audits, I would like the ability to select or key in auditor initials when importing the loans..

View 6 Replies View Related

Avoiding Divide By Zero Error

Aug 25, 2005

Hi all.

I have three subforms on my main form. They all display salary details from different sources, and each subform has 2 calculated fields in the form footer to show the average salary and the number of records on which the average has been calculated.

I then have a field on the main form to calculate the average of the averages which works OK unless one of the subforms has null or zero in it, in which case it returns no information.

Can anyone suggest a way of bypassing this divide by zero error? The code I'm using to calculate the average of averages is as follows:

Me!Text44 = ((Me![Frm1 subform].Form!text4 * Me![Frm1subform].Form!Text6) + (Me![Frm2 subform].Form!text4 * Me![Frm2 subform].Form!Text6) + (Me![Frm3 subform].Form!Text6 * Me![Frm3 subform].Form!Text8)) / (Me![Frm1 subform].Form!Text6 + Me![Frm2 subform].Form!Text6 + Me![Frm3 subform].Form!Text8)

Thanks for any help you can provide...

View 3 Replies View Related

Queries :: Divide Each Value By Sum Of Column

Aug 9, 2015

I am trying to divide each unique value in a column by the total column; so sales by total sales.

View 4 Replies View Related

Queries :: How To Divide A Field Value By Its Sum

May 26, 2015

I have an alias named [Net Income]

[URL]...

I want to divide it's value by the sum of its values through another alias [%]. How to do it?

%:=[Net Income]/Sum([Net Income]) Not working

getting an error saying:

"You tried to execute a query that does not include the specified expression 'SR_NO' as part of an aggregate function."

View 4 Replies View Related

How To Distribute Updates From Front End Over A Network To Runtime Version

Jan 17, 2013

Is it possible to distribute updates from the frontend to an access runtime version?

View 1 Replies View Related







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