[HELP] Adding Book Copies To Book_copy Table

Mar 21, 2008

Ruralguy suggested that i made a new thread - so I'm taking his advice (H)

I've got another problem, well not problem..i want to make it more user-friendly.

Database= 21238 (Look for yourself see what i mean)
(rename to .RAR if it doesn't open)

Basically, when the user adds a book, they can add it easily..
the only problem is, when ..just say i want to add a book, and I have 10 copies of this book, I have to add the book first and the go into the ADD_BOOK_COPY form and then select the book which i want to add more copies of and click add - i repeat this for the total amount of copies that i have.
So if i had 10 copies of 1 book, i add, and then go into a seperate form and then click this button 9 more extra times.
Which, can cause headahces!


So basically, i'm thinking of implementing a new way to do this,
i was thinking about..
When i got to add a book, there's a List/Combo box with 1-20 into
So i can add the book, and then select how many copies, click 'add' and this will add 20 copies of that bookm firstly by adding it to the 'book' table and then adding 20 copies to the book_copy table..


Is there anyone who would like to help with this? :' )

Cheers btw! :)

View Replies


ADVERTISEMENT

Check Book Registry Table Design

May 2, 2005

Hi all, Im updating my current checkbook registry database. Just want to be sure that table look ok to everyone before starting the coding process. This will be a multi user - multi account program. I have attached the relations diagram.
Please give me some suggestions as to what fields i might need to add.

Also check to relations.

Thanks a bunch.

View 4 Replies View Related

Queries :: Cartesian Table - Create Multiple Copies Of A Record To Use For Printing Labels

Aug 5, 2013

I am using a cartesian query to create multiple copies of a record to use for printing labels.

Here's my query that produces the cartesian result:

SELECT tblCount.CountID, tblDeliveryOrders.DeliveryOrderNum, CurrentCY.Deliveryorderlineitemnum, CurrentCY.Quant, CurrentCY.UOM1, tblContainerSizeCodes.SizeCode, tblContainerTypeCodes.TypeCode, CurrentCY.WasteDescription, tblEtidDodaac.EtidDodaac, CurrentCY.ETIDDocNum, CurrentCY.Pounds, tblEPAWasteCodes.[EPAWasteCodes(1B)]

[Code] ....

This works just fine in creating the desired result - EXCEPT I don't get all the records.

When I remove the 'cartesian table', and right join everything, then I get the correct results. If I keep everything as-is and reintroduce the cartesian table, then I get an error about there being an ambiguous outer join.

View 3 Replies View Related

General :: Phone Book - Making Every Single Entry Field On Its Own Table

Oct 17, 2013

I thought that a phone book might be a good thing to begin with...

Should I be making every single entry field on it's own table and then pulling them from there into one form or....?

View 5 Replies View Related

Print 2 Copies

Oct 15, 2007

I have a form in Access with a command button that prints a receipt (which is actually created as a report). Anyway, I want 2 copies of this receipt to print when the print receipt button is clicked. Please take a look at my code and tell me what I would need to be able to accomplish this. Thanks.

rivate Sub PrintRec_Click()
On Error GoTo Err_PrintRec_Click

Dim rstTrans As New ADODB.Recordset
Dim fld As ADODB.Field
Dim strField As String
Dim curCount As Currency

rstTrans.Open "dbo_tbl_Transactions", CurrentProject.Connection, adOpenKeyset, adLockOptimistic

If IsNull(Me.TempTransNumID.value) Then
'this is new record
rstTrans.AddNew
Else
'to stay on the record that was just inserted for editing
rstTrans.Find ("TransNumID=" + Str$(Me.TempTransNumID))
End If

rstTrans!TransDate = Me.TransDate
rstTrans!CustomerName = Me.CustomerName
rstTrans!VehType = Me.VehType
rstTrans!TktType = Me.TktType
rstTrans!Auth_By = Me.AuthBy
rstTrans!Quantity = Me.Quantity
rstTrans!SHtkt1 = Me.SHtkt1
rstTrans!SHtkt2 = Me.SHtkt2
rstTrans!HRtkt1 = Me.HRtkt1
rstTrans!HRtkt2 = Me.HRtkt2
rstTrans!TransPayAmt = Me.TransPayAmt
rstTrans!PaymentType = Me.txtPaymentType
rstTrans!PaymentMethod = Me.cboPaymentMethod
rstTrans!CheckNum = Me.CheckNum
rstTrans!TransReceiptMemo = Me.TransReceiptMemo
rstTrans!TransEntryTime = Now()
rstTrans!TransEntryUserID = appUser

If Me.cboPaymentMethod = "Check" And IsNull(CheckNum) Then 'Check number not entered
MsgBox "You must enter a check no.", vbCritical, "Check Number Verification"
CheckNum.SetFocus
Exit Sub
End If

rstTrans.Update
'this was a new record so update the form value of TransNumID for edit
If IsNull(rstTrans!TransNumID.value) <> True Then
Me.TempTransNumID = rstTrans!TransNumID.value
End If

whereClause = "NewQryShuttleHandiRideReceipt.TransNumID" & " = " & rstTrans!TransNumID

//////here is where I'm printing the receipt
DoCmd.OpenReport "RptShuttle HandiRide Receipt", acViewNormal, , whereClause

rstTrans.Close

Set rstTrans = Nothing
Me.cmdAddRec.Enabled = True

Exit_PrintRec_Click:
MsgBox "Record Successfully Saved! Printing Receipt."
Exit Sub

Err_PrintRec_Click:
MsgBox Err.Description
Resume Exit_PrintRec_Click

End Sub

View 2 Replies View Related

Best Book On VBA

Jun 16, 2007

I want to know which is the best book on VBA out there.. for Access 2003

View 3 Replies View Related

Saving Historical Copies Of DB

Sep 14, 2006

Hiya,

I realise this could well go against almost every DB rule in the book, but figured I would ask it anyway!

I have a database, which pulls all it's data from other databases - some in SQL, some in Oracle, and some from other Access DBs.

It then combines it all, performs dozens of queries on it, and allows me to produce necessary reports on it - all fine.

I have been asked to make it save historical copies of all the data it uses. The reason for this is the Financial Services Authority, who insist that the checks we are doing on this data is all stored, so that if an auditor arrives tomorrow, and asks me to prove the data from 3 months ago was processed correctly, I have to be able to come up with that 3 month old data.

I thought the easiest thing to do would be to use a series of make-table queries to move all the tables data to an external database, which can then be archived.

Does anyone have a way of allowing me to save the entire database, as at NOW - to another database?
I would need to make all the tables LOCAL, rather than linked?

Thanks! (and sorry for the unnecessarily long post!)

View 3 Replies View Related

Multiple Copies Of The Form

Jul 17, 2006

Hi,

I finished a db for a client to help her keep track of the classes she teaches, her students and other related info. The db has several tables and one main form with subforms. I read that it was a good rule of thumb to design the fewest posible forms to make the navigation centrilized and so I did. (I also spent some time on making it look less Access like, more of a stand alone app and wish to preserve it)
Up to this point the client was using Outlook to store all the contact info plus anything else she could jam into various "notes" fields. Now she wishes to have some simillar futures in the db to the ones outlook offered, one of them:
being able to open multiple contacts (records) in new windows. So basically she wants to open many instances of the main form so she can jump between the records without closing the previous one. My question is: what is the nicest (cleanest from the point of db design) way of giving her such functionality? I thought about giving her an option to open the new record (student) in a tab, but I'm not sure how to acomplish that. Another way would be to copy the main form several times and open those as she clicks on "open in new window", but I don't think it's a good solution, becsue: e.g. How many copies do I create? I'd have to go over all the vba in each copy and adjust it so it works properly with the copy, plus all the vba in each subform... :eek:
Any thoughts would be greatly appreciated on how to tackle this. Also what are the consequences of having several instances of the same form open (editing same record by mistake, etc..)

Thank you very much,
Mariusz

View 4 Replies View Related

Best Book For Access 97

Oct 4, 2005

I allready looked at what was recommended in this forum - but I noticed there are only two books listed.

Are both of these books good for beginners or is the Access 97 Bible better? I have seen about a dozen of books and would like to have a few on hand to learn from and to reference as my skills increase.

I truly am after something that can give me a breakdown of the code in Access and what each line really means and the action it produces.

Thanks in advance,
John

View 5 Replies View Related

Access Book

Feb 22, 2007

Hi All,

i'm looking for a really good access book that will help me progress my access knowledge i have an okay knowledge of access and wish to expand my knowledge futher any good books out there that can help i know their is hundreds of books but does any one have first hands experience of a gr8 book they used

Thanks

View 3 Replies View Related

Book Recommendations?

Aug 1, 2007

Hi Everyone,

I was wondering if anyone can recommend a good book for learning more about Access?

I have basic experience with the programme, but am hoping to tackle the old 'questionnaire/survey' issue. A lot of books I can find on amazon seem to be set at such a level that I can already do (multiple tables, simple queries and reports), I need something a little more in depth. Others don't seem to tackle the specific issues I'm going to face (although I could be wrong about that!). Also, as I usually don't bother with computer manuals (I generally pick up and play with new programmes) I don't know which ones are best (e.g. Microsoft own, 'Dummies' etc)?

EDIT: I'm using Access 2002.

Thanks a lot!

Bek

View 8 Replies View Related

Appointment Book

Feb 8, 2008

DOes anyone have any examples that they are willing to post or links about how to build an appointment book in Access? I have tried google but I cant seem to find useful links.

Thanks.

View 12 Replies View Related

Address Book

Oct 12, 2006

I have a form "frmsend mail" whic have fields "To" and "Cc" i want to have a address book in the access itself having same functionality as outlook i.e it should add new email id to the address book, prompt the email id,etc.
How to do tht.
thnxx

View 7 Replies View Related

Address Book

Oct 12, 2006

I have a form "frmsend mail" whic have fields "To" and "Cc" i want to have a address book in the access itself having same functionality as outlook i.e it should add new email id to the address book, prompt the email id,etc.
How to do tht.
thnxx

View 1 Replies View Related

Print 3 Copies Of Invoice With Different Remark

Jul 8, 2007

I want to print 3 copies of a report named Invoice with different remark i.e. Customer Copy, Office Copy, Auditor Copy. I want to print all 3 copies with a single print command.

Can any one help me.
Sample database is in attachmant.

View 7 Replies View Related

Compact Resulting In Copies On The Network

Nov 28, 2007

I tried the search and while I found some things related to my issue, I couldn't really come to a conclusion on my issue.

I have all the databases on the network set to compact on close. This is resulting in a new copy of the compacted database with the generic "db1.mdb" file name every time the db is compacted. It also does not compact the correct one.

So, basically...it is copying the db, compacting it, but not deleting the old one and renaming the new one.

If I copy the database to my hard drive, it compacts, deletes, and renames sucessfully.

The only thing I can think of at this point is there's some issue with the server. But this is happening on multiple servers.

View 14 Replies View Related

Field Data Copies Into Column

Sep 19, 2006

I grabbed a mdb template for customers/workorders from MS. I am trying to modify the "workorder labor" form in design view to have the first field be a manually filled in date, followed by start time, then finish time.

I got the boxes to show up.

The problem is that when I enter a date all the fields in that column are filled with the same information.

I tried variations of using a mask and format. I tried it as a text box from scratch and copying an existing one.

Any suggestions would be greatly appreciated.
Nett

View 1 Replies View Related

General :: Synchronized Copies Of The Same Database

Jun 5, 2014

I have a simple database at the moment which I would like to put onto two laptops. The laptops would be used for entering information when out on a job (no network or email connection).

What I would want to do is have a database on a desktop in the office so when the laptops come back into the office they can update the office database with the information on the laptop database.

View 2 Replies View Related

Good Access Book

Apr 3, 2006

I am looking for a good Access Book. At work, I have "Access for Dummies" and "Access2000 Step by Step". Are either of these good, bad, etc. What would you recommend. I am a begginner, but know some things, so I don't want something for real beginners.

View 2 Replies View Related

Phone Book Problem

Nov 23, 2004

Here is my setup:

In Acess 97 I have a single data base with 5 tables, Attorneys, Employers, Health Care Professionals and two others. All tables have exactly the same fields.

I am trying to create a “phone book” made up of all the records in the data base. The form for this phone book has only a few fields such as fname, lname, phone, address. It also has the autonumber field. The record source for the form is a Union Query. When I open the form it works well. I get lawyers, employers, doctors , etc. all in alphabetical order.


Here is my problem:


I have a command button labeled “View Record.” I want to be able to click on this and have it find the record in its original table and open the form for that table so the record can be modified (on exiting the record I have it requery so the phone book is updated).

I can only get this to work with one table at a time, that is, the table that is named in the event procedure code. So if I am in, say, an Attorney record and tblAttoney is named in the event procedure code, all works well. But if I am in, say, an Employer record I get a blank Attorney form opened.


How can I get it to trace the autonumber to the proper table and open the record . I assume that the autonumbers are unique ACROSS all five tables since they are in the same database.


Any help would be greatly appreciated.

View 1 Replies View Related

Good VBA Book, Any Idea?

May 9, 2007

I really need to learn how to code in VBA for access. Can someone direct me to a good VBA Book?

View 1 Replies View Related

Syncronising Multiple Copies Of An Access Database

Mar 15, 2007

If I want to distribute copies of a database and have one copy as the master and syncronise data; can i use briefcase or is there a better way?:o

View 1 Replies View Related

Copy And Paste Security Permissions From Copies Of A Db

Jul 11, 2007

I have to make a new copy of a db starting with a blank db and importing all the objects into the blank. (Corruptions issues).

When a blank db is made, and the objects imported into it, the security permissions do not copy over. The only way I know how to get the security permissions back is to redo them in the new copy. It's a big db. Lots of time. Ugh.

Is there any way to copy and paste the security permissions from one db to another?

Thanks

View 1 Replies View Related

General :: Printing Multiple Copies Of A Form?

Jun 18, 2015

I have an Access based CRM system that was built for me in 1998. Amazingly it is still pretty effective. However, I would like to make a small adjustment in the programming..

Once we've added the details for an order we press continue and the screen closes and one copy of the acknowledgement of order form. I simply want it to print three copies!

I believe this is the coding part of the command that is effected.

Rem Print Report
DoCmd.OpenReport "Order Acknowledgement"
Rem Close Form
DoCmd.Close acForm, "Booking Entry"

View 2 Replies View Related

Reports :: Printing Multiple Copies Of Each Group

Sep 24, 2013

Our access database keep track of children attending an after-school music programme.

Each week we print registers and give them to the class teachers for them to mark who is coming. The registers are produced as a report, grouped by School then by Class.

We run 3 times a week so each week I need to print off 3 copies of the registers for each class.

Is there a way to print multiple copies of each group in a report? This would save me quite a bit of time each week.

I'm using Access 2013...

View 5 Replies View Related

Print Multiple Copies Of A Report Using Macro

Jan 7, 2015

In Access 2007 is it possible to alter a macro so I can print 2 copies of a report. I have created a simple macro which opens up a report based on a value in a data entry form. I want to automatically print 2 copies of the report. Is this possible....

View 1 Replies View Related







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