Search results

This version works the way that I need it to. I will see how to implement it into our current db and see if I get stuck or have any questions. Once finish I will post it back for others to use. Thanks again.

sneuberg and plog THANK YOU FOR REPLYING and sorry it took so long to get back. For some reason my automatic emails for replies to this subject never cam through so I was figuring you were just busy and didn't have time to really look at it yet. I will review the suggestions and get back to...

Attached is a very basic sample of the database. There are what I would call "2" sections to the database. 1 section is for the Model information I.E. Make, Model and Year 2nd section is for the Product. Which I have a "CatalogProduct" which is a simplified Part Number that does not have the...

sneuberg, Thanks for the offer I will get something together and post it here shortly.

Hahaha, no worries that is the down fall to forums and discussion boards you cannot see if anyone is in the middle of replying or not.

Hi Plog, Thanks for the reply unfortunately I thought the same thing however there are the anomalies where either the model is not produced for a year or for a year it uses something different and then reverts back to the original part. For the example I gave the anomaly that I is with the...

I am in need of some help. I tried looking for coding that will evaluate a query and show the First and Last Numbers based on the data in a sequential order but was not able to find anything. For example I have created a query with car models and parts that fit those models listed as...

I have already tried something like that but i am unable to get the two inputs (combobox and textbox) to work together or only one at a time. Attached is a sample of what I am trying to work on the

Hi Jdraw thanks for the reply to answer your questions This is populated from a query Only one sales person at a time this feature is to make it easier for the sales person to find thier customer. It is populated from the emplyees table. The current one I am using is like OldSoftBoss's...

I have a listbox that I would like filter using a combo box and a text box. The list box should have everything listed at first and as the user enters something in either box then it should filter For instance: the combo box has sales persons name the text box is used to enter the customers...

I know that is why I am having troubles getting it to work. Thanks for the link I will check it out and see if I can get it to work.

I am trying to create a concetenate query to run another query. My issue is I need the conc to run off of 2 identities to get all the conc fields with the correct type for a CSV export as we have a large number of identities. Like you would see with a car there would be a car model I.E. a...

I am trying to figure out a way to combine the options and attributes of a product into one field for export each having a different amount of options and attributes. For instance I have a product table: ProductPK ProductName Options Table: OptionPK Option Attributes table: AttributePK...

I knew it was something small I was missing. Thanks for your help!!!

I have an Insert into SQL which the records have a autnumber PK (OrderDetailPK) how would I go about skipping the PK to allow the insert into to work properly strSQL = "Insert Into tblOrderDetail Values ('" & vrntNewOrderPK & "','" & !PartNumberFK & "'," & !DiscountedPrice & "," &...

Here is a broken down sample of the DB I am in the process of changing the racers code to be the same as the price code, as before when the original db was setup it was only for racers and we had another built for our products and now we want to track what our racers purchases.

Thank you for the reply!! I am still having troubles it is not pulling up the price after the Product is updated Private Sub ProductID_AfterUpdate() On Error GoTo Err_ProductID_AfterUpdate Dim strFilter As String ' Evaluate filter before it's passed to DLookup function. strFilter =...

I am trying to setup a orders db and it has customers with different price levels when they place the order I want to save the current price for the item in the order details table. I know how to write a string for a single filter but how would I do it to filter both the Product ID and the...

I need a little MVB help. I need to code the following string for a back order module: Dim strNewOrderPK As String, strOrderPK As String strOrderPK = [OrderPK] string (strNewOrderPK) = New Order (OrderPK) (is equal to) New Orders Back OrderPK (BOOrderPK) (that is the same as) Old OrderPK...

I am having problems with an invoicing program I am trying to setup. I currently have an autonumber for the OrderPK which the order details or line items are linked to the order via the PK(primary key)/FK(foreign key). The problem arises When I go to invoice the order. If the order is shipped...