Video Items Order Question

Dec 8, 2005

Hi

First let me tell you about my system, these are some of my tables


tblMovie
MovieID,MovieTitle,MovieDate,MovieDescription,Movi eActors,CategoryID,MovieLength,MovieStatus,RatingID,MovieR entCount,MoviePoster

tblItem
ItemID,MovieID,FormatID,ItemCondition

tblSuppliers
SupplierID,SupplierName,SupplierCity,SupplierAddre ssSupplierPhone,SupplierMobile

tblPurchase
PurchaseID,SupplierID,PurchaseDate,PurchaseTimePurchaseCost

tblPurchaseDetails
PurchaseID,ItemID,Quantity,CostPerItem


my question is how can i make an order and then update the item table with the new copies that i ordered

View Replies


ADVERTISEMENT

Count Items In Order

Dec 27, 2007

I'm building an order entry database. It has two tables (amongst others) called tblOrders and tblOrderDetails, related together on the OrderID field. For every order, there is one record in tblOrder, and as many records in tblOrderDetails as there are individual lines in the order (so, if, for example, the order is for 10 pencils and 2 pens, then tblOrderDetails has 2 records).

Each entry in tblOrderDetails has a Status field, which indcates whether or not the items have are in manufacture, shipped, delivered, etc).

I need a way to get Access to show me only "Open" orders (i.e. ones in which not every item has been shipped). Can I set up a query to determine how many lines each order consists of, and then is there a way to get access to check if all of these are "Shipped"?

Many thanks in advance for any pointers,

Gary

View 1 Replies View Related

Preserve Order Of Items In Table Without ID Or Primary Key?

Nov 10, 2012

This is a CSV file that comes through an Access specification. I need to be able to copy the items from the table to other tables but somehow apply a unique and sequential ID to the rows first, this is essential to the job. The text import spec applies a unique ID but save the spec, and call it using VBA, it doesn't do that.

Also, there seems to be a bug where using a macro to run the text import specification, (and this is after an update from Microsoft), that it doesn't recognize the specs anymore... after I deleted several of them.

View 8 Replies View Related

Track Order In Which User Selects Items From A List

May 11, 2012

I am trying to find out if there is a way to track the order in which items are selected from a list. I am a dabbler and any keyword searches that I can think of don't bring up what I am looking. So, here is what I am trying to do:

I have a table of symptoms with 3 fields (ID, Category, and Symptom).I have a combo box that will allows the user to pick a category (using select Distinct on category field). I then have a list box populated with all the symptoms that have a category of whatever the user selected. The problem I am having is that I need to somehow track the order in which the user selects symptoms and then save that order for future reference and to be printed on a report. The order is important because the most severe symptom needs to be listed first.

View 7 Replies View Related

Forms :: Bound Form - Items Not Appearing In Alphabetical Order

Aug 2, 2013

I have a report that generates 100 items in alphabetical order. All of the items are also displayed in a table. I have a bound form attached to the that table, and when the items appear they are not in alphabetical order. Therefore, it is a hassle typing in the data when the form will not appear in order, because instead of going in order I am flipping through pages. What is causing this to happen? And what can I do to fix this?

View 2 Replies View Related

Inserting A Video

Feb 26, 2007

Hi
I really need to insert a movie in my database. I have tried inserting a Windows Media Player object in a form, but I dont know how to link it to a movie on my computer. Please help me with this. By the way I'm using DAO, if that helps at all.

Please help me as soon as possible, I'm in a hurry
Thanks in advance

View 4 Replies View Related

Play A Video In A Form

Mar 2, 2005

i have a series of short Avi films( they can be converted to another format is better suggestion) that are basically a tutorial films on how to use my database...

what i want is a form to have a list of these files so the user can choose which one to play the file within Access as a tutorial section...

Can this be done, if so anyone fancy helping me with this one please.


Cheers

Andy

View 1 Replies View Related

Add Input Mask To Video Field

Oct 14, 2015

I am trying to add an input mask to my video Field, so that it is always enter correctly. V-1-2015, what I have so >"V-"099-0000, but it is showing spaces if nothing is inputted for the 99 fields, if I add in !>"V-"099-0000 it then removes those spaces since those are optional characters, but then the V is no longer capitalized. How can I correctly have an input mask that keeps the V always capitalized and have mandatory fields and optional fields without spaces. I want it to come out as V-1-2015, or V-11-2015 or V-111-2015.

View 11 Replies View Related

Adding Video In Startup Page?

Jul 2, 2014

adding a video in my startup page its like a introduction video.....how to add a video in access.

View 1 Replies View Related

Modules & VBA :: Video Capture Using ActiveX Controls

Jan 10, 2014

Using Activex controls for capturing video from a webcam or similar. Just looking for a snapshot that I could then forward via email from access.

Ive seen commercial licenses for an activex control. The form Im imagining would have a window showing the live video with a snapshot button where we could store the image as a jpg for example and then generate an email forwarding on the image. It seems possible!

View 1 Replies View Related

General :: How To Manage Items In Set And Individual Items

Jul 31, 2013

I just want to know how to manage items in set and individual item. Suppose my product list are

individual items = A,B,C,D,E,F,G,H,I,J,K
and 5 pc set = A,B,C,D,F
and 3 pc set = G,H,K

How should I design the table. Previously I designed the table for individual items and whenever orders for set is placed user had to enter individual items with quantity.

E.g. order is for 5 pc set = 3000

A=3000
B=3000
C=3000
D=3000
F=3000

Now I need to just say 5 pc set and it should be automatically populated. And also if order have combination of individual and set items.

View 3 Replies View Related

Allow More Than Order In ORDER Form

Apr 4, 2013

I have a problem when I want to create an "ORDER" form, that will allow user to enter more than one order.

I have no clue how to do it.

View 14 Replies View Related

Adding Items...

Apr 7, 2006

I've made a button on my form which adds a booking ID into the listbox, but it doesn't seem to work. This is my code:

Private Sub Command18_Click()
Dim BoI As String

MsgBox "Booking successfully added!", vbInformation, "Booking"

If Month(Me.Date_1) = 1 Then
ListJ.AddItem Me.BoI
ElseIf Month(Me.Date_1) = 2 Then
ListF.AddItem Me.BoI
End If
End Sub

If someone could tell me the problem, I'd appreciate it. Thank you. :)

View 5 Replies View Related

Switchboard Items..need More Than 8

Aug 17, 2005

How can I increase the number of items on a Switchboard?

When I change the code, "conNumButtons = 8" to 20, an errors says only 8 items are allowed on a switchboard page.

When I select debug, the VB opens and the following line is highlighted yellow: "Me("Option" & intOption).Visible = False"

Do I need to change this line, or delete? to accommodate more items on a switchboard page, or am I stuck with only 8 items?

Thanks.

View 4 Replies View Related

Adding Items...

Mar 10, 2006

MsgBox "Booking successfully added!", vbInformation
'Depending on which month is booked, will determine which listbox is goes in on frmMain
If Month(Me.Date_1) = 1 Then
Forms!frmCurrentBookings!ListJ.AddItem = Me.BoI 'Add to ListJ on
frmCurrentBookings
ElseIf Month(Me.Date_1) = 2 Then
Forms!frmCurrentBookings!ListF.AddItem = Me.BoI 'Add to ListF on frmCurrentBookings
End If

End Sub

So basically... I have a date field in the form 'frmAddBooking'... if the month of the date is 1 (January), then the conntents of the date field is added to a listbox in a different form (frmCurrentBookings)... but this doesn't work...

If somebody could help me I'd appreciate it greatly.

View 2 Replies View Related

Tables > 255 Items?

Mar 6, 2006

I've been running into this problem in Access. I have records which have more than 255 fields. The easiest solution would have been to get a table with more than 255 fields, but I can't do this, so I've had to split up the tables. The next easiest solution would be if there is a way to link the tables--I have a data field "IntAccNum" identified as the primary key in each table--so that when a new row is formed in one, it is formed in the others. This wouldn't waste space, since any row in the first table would necessarily need a corresponding row in other tables. Is there a way to do this?

If not...

The problem I run into is when I populate a row in the demographic table and then try to fill a corresponding row in another table. I use a command button to for a macro to "OpenForm", and then try to "SetValue" of the appropriate field in the second table. This adds a new row in the second table. This does let me populate the correct row of the second table the first time I try for each row. However, after this initial population, when I switch back and forth between the first and second table, I get an error in access since obviously I can't keep adding a primary key with the same value in the second table.

Do I need to do some sort of query to see if that row exists in the second table already. Or is there some simple solution to what must be a very common situation that I am overlooking?

View 4 Replies View Related

Odd One - Menu Items Have Disappeared...

Jun 7, 2005

Up until recently, when I selected multiple objects in design view (on a form) and right-clicked the mouse, I had several options in the 'Size' sub-menu (including 'Size to Widest / Tallest / Narrowest / Shortest').

Then I tried to be clever(!) and create a new custom toolbar which had just these options on it, as I use them frequently. This was all very well until now, when I can't find the custom toolbar I created, and the options have disappeared from the Size submenu aswell!

Has anyone got any ideas on how I can get them back??

(I have tried going into Customize to drag them back, but they're not there either! :( )

:confused:

View 1 Replies View Related

Switchboard (Disable Items)

Jul 18, 2005

Hi Folks,

I have created a switchboard that has 8 more sub switchboards. They have got items from 1 to 8. My database is setup with users and their authorised access levels. Admin has level 1, Manager level 2, Users Level3. Now what i want is that when admin logs in all the items in the switchboard must be available, but when a Manager with leve 2 or a user with level 3 logs in to the database then certain items on a specific Switchboard must be diabled For example lets say Sub Switchboard No 3 and its item number 4 (SwitchboardID = 3 and Item Number 4) should be disabled. I tried searching it on the Forum but no use. All i request you is to help me in this issue.


Warm Regards


Darno

View 2 Replies View Related

Count Overdue Items?

Mar 29, 2006

I have a database for booking items in and out and would like the database to automatically count the number of items that are overdue.

I have a COMPLETED field which is a check box, when ticked completes the booking, if it is not ticked then the booking is incomplete.

I also have the "Date Returned" which is the date the customer is supposed to return the items.

So using these two fields how can I count the number of overdue items?

if COMPLETED=false and Date Returned<Date() +1

that's basically the logical expression I think would work, but I don't know the code/method to implement this into my database :x please help!

View 2 Replies View Related

Pasting Multiple Items.

Mar 6, 2008

I am trying to learn to use MS access 2007 and have a query about copying and pasting.

Is it possible to paste the same line of text into multiple lines or do I have to arrow down and paste into each individual box?? I can highlight any number of boxes in the same column but when I click paste it only pastes into the first highlighted box.

Any help would be really appreciated.

Thanks

View 2 Replies View Related

Form Items Missing

Mar 27, 2008

Hi,

why do ALL form items disappear if certain records are not there? my mainform is fed by a people Qry and the people have payments however, if you delete the payments, all of the items on the mainform disappear. if i go into the table and manually add a payment, everything re-appears.
the mainform is exclusive to "peopleQry" and there are 2 subforms which show different data at different times. when the form loads, these subforms have a sourceobject set to "" so it couldnt be them. the mainform doesnt display any payment information unless asked and then, it is shown on a different form. this is a bit of a problem now.

can it be prevented?

regs,

NS

View 4 Replies View Related

Multiple Items To A Claim

Dec 13, 2004

I have to redo the company I work for’s insurance program and they want it done in access. I’ve hit a big snag though. Not only are my Access skills very rusty. But also I have a very complicated task here! :)

I would need a customer table an insurer table and an adjuster table. These tables would link to a Claim table. In the claim table I need to make it show the items that the person is going to get with there insurance money by getting details from a table with all of the information for the items.

But how do I make it so you can add more then one item to the claim?

Some people may have 1 item to replace some people may have 20 items.

Hopefully someone understands what I mean here

Thanks Heaps
Ashley Colman

View 6 Replies View Related

Multiple Items In The Same Field

May 4, 2005

I am trying to enter multiple parts into the same field and using commas to separate them. Is there a way to create multiple records with the same information, but change the part numbers in them according to comma's?

Would look like this.

Primary Key Location Part number
789 bin89756 89756,87564,78965,12565,45896

I want it to do this in the end.

Primary
Key Location Part number
789 bin89756 89756
790 bin89756 87564
791 bin89756 78965
792 bin89756 12565
793 bin89756 45896

View 2 Replies View Related

Items In Stock Problem

Sep 30, 2005

I have a query which is based on a tbl which has data on chemicals in storage. The query is based on two tbls as follows;
Main tbl
ProducdID
ChemicalName


Second tbl
Batch number
TransactionID
Transaction date
Purchased check box
Used check box,
expirydate
ProducdID

When a chemical is purchased a tick goes in the Purchased check box with the other relavant data. When a chemical is used a tick goes in the Used box along with other relevant data in the other fields. In essence each chemical will have only two records 1. a purchased record and 2.eventually a Used record.

I want the query to report on all chemical records which are still in stock. So it's not as simple as adding a True or False to either check boxes. Showing records which have ticks in the Purchased CB ,or not showing records with ticks in the Used CB, will still show a Chemical which has been Purchased but may have been used at a later date and is no longer in stock.

Any suggestions? I hope I haven't confused anyone with my problem?

View 3 Replies View Related

Counting True Items

May 4, 2006

Can anyone help?
I have a table with the following:
Booked with a y/n field
Person Name with a text field
So...
Yes(True) Jim
Yes(True) Jim
No(False) Jim

What I need is to be able to show a query that shows if the checkbox is ticked (True) and the Name is Jim total up how many true items there are. So from the above I can see that Jim has 2 true items. I would then like this shown in a text box is this possible?
Also, it is not always going to be a person called Jim so... (From above)
Yes(True) Jim
Yes(True) Jim
No(False) Jim
Yes(True) Jack

So how would this go on a query in a sub form? So Name Jim would show 2 and Jack would show 1? At the moment is is grouping the name and I dont want that.
Any ideas
Cheers

View 4 Replies View Related

Count The Distinct Items

Jun 3, 2007

Hello all,
I am new to this forum. I have this problem where I need to sort the 4 books in the tables below according to the highest quantity of book sold.In this scenario,
Book C would be 1st in the table with a total quantity of 8.
How do I write a query in access to perform such operation. I have to use DISTINCT to get each book and also count the quantity(e.g. Book C:5+8).
But it seems that I can't use Count and distinct together in Access.

Title SalesNo Quantity
BookA22
BookB 31
BookC 45
BookC 53
BookD 6 1

Hope u all can help!

View 4 Replies View Related







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