Search results

Ok i tried the code and replaced the ID field with my invoiceid. when i fire the command buttonn it refreshes but it does not prompt or convert the form to pdf or prompt outlook. Thanks

Hi, I have a little problem i am using the microsoft converter to pdf in my forms. I have made a command buttong that converts and inserts it as an email attachment. The problem is when i view the attachment it contains all the records. Is there a Me statement that i need to put into it so that...

I don't know if this should be posted in tables,querry,form or records, so i want to apologize ahead of time.:o I have 2 tables, "tblProducts" & "tblInventory" that have a relationship of one to many using the ItemID. What I need accomplish is to get a grand total of the value of all...

Thanks for all the help. This worked out. Thank you as well for the working example. When i broke it apart and looked at the event procedure that also helped, especially the on change event. I want to say thank you, thank you, thank you. James More Questions will come.

OK, I didn't see the second page of the post, :eek:, I thought i was forgotten about. You have answered some pertitnent questions. This afternoon i will look at it, but i may have a question or two, but it looks like this has resolved the issue. I haven't though put it into mydatabase I...

Ok i change the combo box so that it retrieves the price as well. Then i take the price from the combo box. This is the code. =cboItemSearch.Column(2). Now the price shows up, i can't change the data. Is there some settings that one is aware of that would allow a person to overwright the data...

Table Name were data is stored :tblProducts Fields in the "tblProducts" - "ItemID" and "ListPrice" which i changed in the code. The form that I am using to put the data in is "frmProductsInvoiced" but i see you use the Me! and the field that is being used in this form is called "StandardCost"...

OK I got an #Name? error so it is much closer, I think. Thanks so much for you help. James

I am trying to understand the dlookup statement. :(:(:( The "frmProductsInvoiced" has 4 fields the first one is a cbo box named "cboItemSearch" the Control Source for this cbo box is ItemID. It takes the list from the "tblProducts" and uses the "ProductCode" field for us. The second field is...

should there be a me statement?

Nope, get error.

=DLookUp("[tblProducts]","[StandardPrice]","[ItemID]='" & Forms!frmProductsInvoiced.[ItemID] & "'") I get an Error on this code James

Thank you for your help. I have the setup of the tables as to what you have mentioned. I will break it down a little bit more. I have a "tblProducts" table which contains fields such as "ProductCode" , "StandardCost", "ListPrice" (which is were the customers price is located) and other...

Make sure your control source has nothing in it. That can make you edit the data.

I have a question pertaining to tables and forms. I have an invoice form that has a number of subforms and the data is flowing very good. The problem i have is with an invoicedetails table subform that has a standard price field. I also have a table "products" that has a standard price field as...

I am trying to make a navigational form with tabs that contain information on a particular record. My first tab in the form is called "products" and my second tab is "inventory". The problem that i am getting is that when I change my record in my products tab and i goto my second tab "Inventory"...