Search results

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 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 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 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 & "," &...

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...

I am trying to set up a form in which I am able to dbl click on a product in a list box and it will take me to that product in a form associated to its product line. This is what I have so far: Dim stFrmName As String Dim rs As Object Set rs = stFrmName.Recordset.Clone rs.FindFirst...

I am trying to make a sub form open a specific form based on criteria of the sub form right now I have: Private Sub Form_DblClick(Cancel As Integer) Dim rs As Object DoCmd.OpenForm "frmCatalog" Set rs = Forms!frmCatalog.Recordset.Clone rs.FindFirst "ProductPK = " & Me.ProductPK...

We currently use Excel to make a sales report that we are able to compare sales from this year to last year and year to date information. The problem is all the data is entered by hand. I was hoping that I would be able to make a db that I can upload all the sales information and then run the...

I am trying to create a form that will allow me to upload data from Excel. The data that is in the excel spread sheet needs to go into a table the is linked to other tables. The excel spread sheet has the data as such - Product Name - Model - Manufacturer - Type The database tables are...

I am having a hard time in figuring how to attack a certian problem. I am trying to make a form in which we can upload data into a datasheet form from an excel spread sheet via cut and paste. My problem is with how the database and data is structured in order to let me cut and paste: Tables...

I have been working on a javascript application for my class that I am taking online and I am completely stumped the book we are using doesnt have the best formate in helping teach how javascript works (probably becasue trying to put tomuch into a small book) My Problem is when the user...

How would I go about deleting one field OrderPK after it is Updated to tblTempOrder? If blnBackOrder Then DoCmd.SetWarnings False DoCmd.RunSQL "Delete * From tblTempOrder" 'Clear temp order table DoCmd.RunSQL "Insert Into tblTempOrder Select * From tblIndentOrder Where...

I am updating a db and have made some changes to it and I am unable to figureour how to make the backorder module work correctly My tables are as such: Order table: OrderPK (AutoNumber) CustomerOrderNumber (Text) CustomerID etc. Order Details Table: DetailPK (AutoNumber) OrderFK (Number)...

In my db I have a cascade combo which on another form works fine between a productline and category, but on this for it wont let me do the same thing with Vendor and Manufacturer. I get an error after I select the Vendor when it is supposed to set the criteria for the Manufacturer. I have...

I am stumped on how to move the data from an old data base to my new one for this example it is the Copy, because the PK will change when added. I have 2 tbls that one is the tblBikeModelIDs in which it takes form 2 other tables for year and make. Then I have tblModelIDKits which it is the...

I am stumped right now I have a prices table that as prices increase / change we can change it and see previouse changes etc. Then there is the products table I am having a hard time figuring out how to set up a orders detail qry I have a max date qry to show the most current price for...

I have a save function setup and would really like to keep the built in close button as you would have on any other program. Just to make the program easy to use. This is what I have setup on the before update and on close events. What I would like when someone selects the close button that...