Search results

That is it!! Works perfectly Thank you

Thanks for the reply but I am also trying to get it to open to the specific product that was selected which is where I am stuck. Getting it to open the correct form and then go to the the record selected.

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

Attached sample db

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

I don’t suppose I could get information on how you have it setup.

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

That is what I also try to do but since the original db was setup without autonumbers as the primary key they had the primary key set on the customers PO number which recently became a problem when different customers have the same PO number. So now I am trying to rebuild the program correctly...

Ok I have been working on this and my current problem is when it goes to upload the temp table information into the orders table I need to have the db create a new autonumber for the OrderPK (primary key is setup as an autonumber) but because if the insert function it is trying to insert a null...

Thanks!!! for the bit of information I would have never thought of it that way. Setting up the db the way you suggested will also alleviate some problems I have with data entry. Some individuals enter a specific model name differently then the actual model name made by the manufacturer.

Attached is db that I have added the update and append queries that will update the PK's and then Append the data to the Catalog table

Actually I think I finally have it somewhat figured out with the use of an update query I set it up to where all the related fields are linked Model Table Excel Table Model = Model Type = Type Manufacturer = Manufacturer And run the query to update a new field in the...

I wish it was that easy but as the db shows same models can have different types but take the same products. So the data has to be shown as: Model Manufacturer Type taking the PK from that comidination in the models table to link to the products.

Thanks for the quick replies!! I have tried doing an append query etc. but I start to have problems with trying to get the data to look at all the variables. I have attached a new db which has a table called Excel. You will see how the excel data is structured. From that table I need...

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

Added a sample DB

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 have been narrowing down my problem. What I need to do is clear the OrderPK number on the tblTempOrder table after it has been loaded into the table before it is then uploaded to the tblIndentOrder. My current code looks like this: Private Sub cmdInvoice_Click() If IsNull([InvoiceNo])...