Mark All Products From Subform

Dec 2, 2005

I have a form orders with a subform orderdetails where we can order more than one product. When the order is finished you save it with a save button where it will also automathically mark the products ordered as not available.
Now, this code works, the problem is that it only marks one product. how do you make it mark all the products that where ordered (in orderdetails - the subform)? :


DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
'set values here!
'loop?
Dim stAvai As String
Dim strSetProd As String

stAvai = "= " & Me.OrderDSubform.Form!ProductIdctrl.Value & " "
strSetProd = "UPDATE Products " & _
"SET Products.[Avail]= True " & _
"WHERE Products.[ProductId]" & stAvai & " ;"
DoEvents
DoCmd.RunSQL strSetProd

View Replies


ADVERTISEMENT

Tab Control To Mark Page

Dec 29, 2005

Hi folks,
I've searched through the forums and found a little on tab controls, but haven't been able to figure out what I am trying to do.

I have a form with mutliple tabs, each of which contains a subform related to the form on the first tab.

When I am scrolling through the records, I might select the fourth or fifth tab to view that subform, and then, when I scroll to the next record (using the nav bar) I want to stay on that tab... but so far, my form always defaults back to the first tab.

Any suggestions on how I can keep the form open on the tab that has the focus would be a great help. Thanking all readers in advance....

Don

View 5 Replies View Related

Modules & VBA :: Hash Mark In Searching

May 22, 2014

I've got a bit of a problem with # mark when I want to search a number containing "#". The number is as follows: 33.#5hy4-1234When I insert a part of this number to a textbox eg. #5hy to search records containg it, it gives me no results (despite there are such in a database) I know that it is to do with this # mark. I have an sql query: (...) where sachnummer like '*" & variable & "*'

View 3 Replies View Related

Forms :: How To Add Quotation Mark On The End Of Textbox Value

Jan 27, 2014

I am trying to add a quotation mark on the end of my textbox value using this code : =[BuildResolution] & " " "

It will not work because it thinks I am adding a string. Is there any way to do this? The value displayed in the textbox would look like 0.01" ....

View 3 Replies View Related

Using A Question Mark As A Character Not A Wildcard In SQL Query

Jan 25, 2005

Hi,

In SQL in MS Access a '?' '*' '%' are all used as a wildcards.

I need to be able to retrieve all messsages which contain a '?' within the message.
i.e. If a message contains the following characters : why?

I want to retrieve the message as a '?' is part of the message.

When I write the code :

SELECT User.User, Message.Message
FROM Message INNER JOIN [User] ON Message.[Message ID]=User.[Message ID]
WHERE Message Like '*?*';

Access takes the '?' as a wildcard and retrieves all the messages in the database. Is it possible to get round this and use '?' as a specific character.. not a wildcard?

Please help

View 4 Replies View Related

Add Quotation Mark In The Format Property Of Textbox?

Jun 15, 2014

I am attempting to manipulate the Format Property of a Textbox. As an example, entering in &" lbs" causes your text to end with " lbs".... only I am trying to add a " mark, for example saying something is 6" away...

How do you tell the format property to add this?

View 5 Replies View Related

General :: Click On Image In Form And Leave A Mark

Jan 30, 2013

I have a form with an image embedded in it. I want to be able to click on the image and leave a "dot" or "mark" where i have clicked, allowing me to click in multiple places on the image and leave multiple "dots"

I am assuming i need to crate a new shape each time i click, how is this done?

View 3 Replies View Related

Forms :: Textbox With Exclamation Mark If Value Is Negative Or Actual Number If Positive

Nov 5, 2014

Is it possible to format a textbox such that a negative value doesn't show numerically but in some other form (like a cross or exclamation mark from the Wingdings font, for example?)

I have a couple of textboxes which take their values from a function. The function is designed to return a long integer value which should always be greater than or equal to zero (the function counts the number of outstanding e-mails in a given Outlook folder, hence it should always be zero or higher)

However, as part of my error handling, if the function can't connect to the Outlook folder for whatever reason (for example, if the user does not have the appropriate permissions, or they do not have it mapped etc.), then it returns -1 (so I have some sort of value to identify a fail)

So currently, if such an error occurs, my textbox(es) will show -1 (and I can use conditional formatting to highlight this)

But it would be nice if it showed an "X" or "!" instead, and only showed the numerical value for 0 or positive. Is this possible?

View 14 Replies View Related

Top 5 Products Per Customer

Jan 22, 2008

Hi There,
I have created this query and i want to return the top 5 suppliers per LOB. It is returning something but it is not the top 5. I want to limit only to return the top 5. Pls. help and thanks. See attached file.

View 5 Replies View Related

Help: Attaching Several Products To One Customer

Aug 17, 2007

Hi, I'm not even sure how to describe my problem in the proper terms in order to look it up in any faq or tutorial.

I have one table, customers. Their name, number, etc.
Another table, products: Name, id, department, etc.
And the final table being orders. Customer bought product when, etc.

However, I'm only able to attach one product to each customer per order. I need to be able to attach any number of products, and I don't know how to go about doing that.

Also, when I create a form for entering all the data to these tables, the information doesn't stick. I create a form using the order table, enter the order and customer information, and have the products as a subform. The information will stick for each table, but they won't connect to each other.
If that makes any sense...

Any pointers would be great thanks, I don't even know where to start.

View 5 Replies View Related

Date Query For When Products Are Available

Apr 19, 2006

I am trying to automate a process where we have 1000's units available on a date eg 01/01/06 - 05/01/06 this is produced in a reprot via a prehistoric system we use.
The report shows the start date and the duration the unit is in use. per each order
I then use excel to populate when the unit is in use. With all of 2006 date's along the top and use an if statement to populate when the unit is in use. Then i sum all like for like units together.
Is there an easy way of doing this in access?

where i am failing is populating when an individual unit is available with out using excel. excell is on the vege of falling over now due to the volume so am desperate for alternatives

View 1 Replies View Related

Grouping Products In A Report - Please Help

Dec 8, 2007

Hi everyone, I am having a lot of trouble doing something that is probably very simple.

My scenario is customers order products, lots of products, now i need to know the quantities of these products for all my customers. It doesnt have to be by customer name, all i need is the product and the Quantities.

I can produce a Report that contains what i need in it but i would like to summarise it.

My report now has the PRODUCT and the QUANTITY for each product that was entered in the order, Problem is the Same product comes up all the time in the report.

For example Product= Tray Lasagne Quantity = 1
Product= Tray Lasagne Quantity = 2
etc...

And it has a continues list in the report, i would like to group the products so that it shows like this on the report:

Product=Tray Lasagne Quanity= 1, 2 etc

Is this possible? Thanks.

View 13 Replies View Related

How To Set Codes Linked To Products

Mar 28, 2012

I am using Access 2010. I have 4 columns in my file. They are "Code", "Item", "Qty", and "Amount" . I have 5 products with my own codes. It means the codes are set by me. For example, 00001 for ruler, 00101 for book, 00201 for pencil, 00301 for rubber, 00401 for pen. My wish is to link the code and product together. It means that when I sell a pen, I must type the code for pen (in the "code column") and I must type pen in "Item Column", so I think it really takes long to do this because I will really make a mistake because the code and item are not linked at all. What I mean is that when I fill or know the code, I will get the product automatically in the "Item Column" or vice versa.

Now I have set the code 00401 for pen.

So when I need to fill the information. I wish to fill the code in the "Code Column" and then the word pen is automatically shown in the "Item Column". In this case, I will be able to get right code linked to its product.

View 1 Replies View Related

Publish Products From Access On Website

May 28, 2006

I would love to publish my product catalog from my access database on a website. it should be a browsable catalog with search field on article number range, product group, product type and should be able to display product pictures.Within my access database i have a link to the product picture stored by filename. I'm looking for an easy solution to do this, i'm using mysql as database on my hosting provider.I can do the export to mysql myself (interfacing between access and mysql) but am looking for some hot software to display the catalog easily without programming the front website myself. I already have oscommerce installed but don't want a webshop and don't know how to disactivate all the features within oscommerce to only retain the article browsing.Thanks if you have a hint

View 3 Replies View Related

SQL Query That Share Products Among Storehouses

May 29, 2005

Aloha,

it's my first time here and the reason is because i have a problem with a query.
I have a database of a storehouse. Each storehouse can be in one city. Storehouses have 5 products A, B, C, D, and E. A storehouse may have more, less or equal quantities of a product than it needs. I want to write an SQL query that shares the quantities of a product among storehouses. I tried to write but it was to difficult than i thought, so i ask your help. I attach the database for your convinience. :)

View 12 Replies View Related

Modules & VBA :: Searching Products With Images

May 15, 2014

I have attached a sample database that is for searching products with images. The search works ok, but cant get the product image on form-- FRM_Carns

View 1 Replies View Related

Queries :: Find Data Only For 3 Products

Apr 16, 2015

I have been trying to get this to work for days and I cant get it to work correctly. I have a query that I need to search only for the records that have 12,22 and 24 so in the fields criteria I have been trying

Total: Where
Criteria: In (12,22,24)

and it works BUT it only works for the first record it finds then it seems to skip and continue to search for all records after that.

View 3 Replies View Related

Queries :: Available Prices At Certain Date For All Products

Dec 6, 2013

As you know, the prices are, unfortunately, dynamic "objects".

So, I have a table for products:
tblProducts
ID_Product - Autonumber (PK)
ProductName

and a table for prices
tblProductsPrices
ID_ProductPrice - Autonumber (PK)
ID_Product - Number (FK on tblProducts
Price - Double
PriceDate - Date/Time

The problem: I have a certain date. I need to know the available prices at that date for all products.

I have a solution; but, for each product, I apply an external function that use two aggregate functions: DMax and Dlookup.

For my small tables, this isn't a problem but I like to know if it is a better way.

View 10 Replies View Related

Find Unique Products To Specific Build ID's

Dec 14, 2006

I have a table with 5 fields:

Build ID Process Product Product_De Operation_

What I am trying to accomplish is as follows:

Each Product can be in the table mulitiple times depending on how many Build ID's it has. So if Product 123456 has Build ID's G004, E818, N005, F813, D024, C879 it will show up one time each for each Build ID. What I want to query is unique Products that are for Build ID's D024 & C879 only and not for G004, E818, N005, & F813.

How can I accomplish this with a query. I am sure I am making this harder than it is but I sure need help.

View 1 Replies View Related

Limiting Products Shown To Specific Customer

Nov 21, 2005

Hi,

I'm experimenting with the database attached (Access 2003) and on the Order Deatails subform I would like to be able to view only the products for the related CustomerID!

Any pointers on how to do this - very much appreciated :D !

Thanks,

Mary

(PS Some non-essential db components have been deleted in order to decrease size for upload)

View 4 Replies View Related

Queries :: Finding Only The Clients That Has Only 4 Types Of Products?

Sep 14, 2014

find only some clients that has only 4 types of products, but no other type of products.

Just to put it in a much easier way to understand. If I have to find only the client that did buy only 1 or more from the 4 products. Fridge, tv, dvd player, mobile phone. But I'm not interested in the clients that also did buy for example, laptop, pc, video cameras, etc. So if the client has only one of the 4 products, I want to list them all, did they buy another type of product too, then not.

How could I create a query that will show me only those clients?

View 4 Replies View Related

Queries :: Material Checked Out And Returned Products

Apr 8, 2013

Finally got my DB straight so I am not using calculated fields however can't figure out the best way to handle the Combo Box so I do not show closed records ( Item checked out and item returned).

Please see the attached table of materials checked out and materials returned. How to setup a query so that if an item has been returned and matches the item checked out, Both the original check-in and the matching return records are filtered and not displayed in the Combo Box.

Also, I am a little worried about partial returns as when an employee only returns half the amount.

View 14 Replies View Related

Queries :: Make DSum For Products Coming In And Out?

Nov 9, 2014

I am trying to make a dsum for products coming in and coming out. find the example below

Products In
Apple 10
Mango 5

Products out
Apple 5

Now I want to show statement for sum as follows

Product. In. Out. Net in hand
Apple. 10. 5. 5
Mango. 5. 0. 5

But it is showing only

Product. In. Out. Net in hand
Apple. 10. 5. 5

what I understand is dsum cannot find the out field for mango as there is no field found for mango

View 14 Replies View Related

Product Pricing DB Looking To Show Similar Products

Mar 7, 2013

We have created a database (electrical contractor) of all our customers, invoices, work orders, etc. and been using since 2000. I have created 'not billed' reports and queries for specific types of jobs. Next step for me has been to create a db for our products we purchase from vendors. they can be the same product from different vendors, or same type of product from same vendor but different manufacturer.

We use this to order inventory, check contract prices once we receive invoices from vendor, and provide estimates to our customers so, there are many people looking to search different pieces. I have a good product base entered, and have been looking through sample templates to try to find a way to bring up similar items when you find 'widget1 from vendor1' i would like to click or show somehow 'related items' window?

View 2 Replies View Related

Making Transactions With Multiple Products (Diagram Inside)

Mar 21, 2008

Hey people, hows it going? Quick question

I am creating an EPOS system for a bookstore and I have a many to many relationship between the transactions table (tbl_transactions) and the products table (tbl_products) using a link table (tbl_linktblproductstransac). The below diagram shows what i mean below:

http://img512.imageshack.us/img512/3246/relationnshipswd9.jpg

I made it many to many because 1 transaction can have many products on it and 1 product can be on many transactions.

Now what I need to know is how will i make records with more than one product on one transaction (in the table itself or in a transaction form). I would really appreciate if someone could help. Thanks :) and have a good Easter

View 2 Replies View Related

General :: Auto Create Orders And Products Every Week

Apr 14, 2013

I have an Access database that contains Orders and its delivery status with the sub table Products that have relative records of the order, I want to Auto Create the New Order with the Same Products (sub tables that have foreign key of Order Id) on the order due date, how to do that so whenever the order is due, it will be auto created with the same specs which i will change manually!

View 1 Replies View Related







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