Search results

Thanks Brad!! Still problem If I do that then I cant add a new record, I tried it by doing a query with the table products and the query AverageCost it works fine just to show records but I cant add records. Any susgestions? DaniBoy I hope you still there!! I cant sleep trying this!!!

Did I explain my self ok? Let me try to explain this better, I have a form Products with the fields pProductID, pName, and an unbound field. The unbound field I need it to be likned to a query just like when you link the Total from a sub-form to the main form that goes like this...

Hello, I have a query that gets the average cost of a product from all invoices, noe I have a form created from the table Products, in this form I have an "unbound" field where I want the value of the average cost from the query to be display. How do I link the value on the query to the...

No way !!! Sorry I kept doing that but I never added new records!!! :eek: Thanks DaniBoy I realy need a break!!!!:(

Hello, I have a subform that is in Continues Form View. Is it posible to make it so I can see more than just 3 records at once. I mean that I could see 10 records without scrolling down. Thanks DaniBoy

Thanks Fizzio Well you are right!! am going to change it back to Autonumber, the problem I have is that am not that good at coding so I struggle to do some codes. I actualy got a code from the forum on how to use the "Not on list" event so that when the user type PrimaryKey and its not on the...

Hello, I have copy this code and modified it from the Northwind database. Its a code that looks up the value of the UnitPrice field from the Products Table and puts this value on the UnitPrice field on the Orders Subform. All I chnaged was the field name and the table name but I get this...

I though the same thing!! I though that too, but then I tried to duplicate the same senerio and it does not work. If you go to the Orders from on northwind and go to the details you are able to somehow pull the unit price automaticly, How? i have no idea since its suppose to be the unitprice...

Ok, am looking at the Order Form, that is made from three queries, Order Qry, Order Details Extended Qry ane Order Subtotal. Now this queries are made from the two tables Orders and Orders Detail and Products. On the Order Detail Table I see that we have a field name UnitPrice and on the Product...

Now its working!!! Well guys I have no idea what is going on here!!! I just redid the hole thing, from the button to the code and now its working!!! OOOHHHHHHHH !!!! It kills me!!! jeje, but am happy that it works!! It was my goal for the weekend!!! Thanks DaniBoy

Hello I dont know what seems to be going on today!!! I am getting realy frustrated!!! Well here it is!!!: I have a button to send an email and the codes goes like this Private Sub Command75_Click() On Error GoTo Err_Command75_Click Dim stdocname As String stdocname = "Workorder...

Tell me about it!!! jejeje Yes, the field is text 360 degrees!!! I tried exporting the table as a query and it worked fine, so I guess am gonna do it that way, but it is wierd that is happening like that!!! Thank for all your help DaniBoy

Tried that Thanks Hello I tried that but it does not fixes my problem, it actualy gives me the date and thats not right. I am tranfering a data field that is a text field. For example: the text field has a value of "2002-03" I should get the same "text" value on the spreadsheet right? Well is...

Hello guys/gals, Am back with a question agian!!:(, well I am exporting a table to Excel, I do it the easy way by going to file export ect. Once the table is exported and I go check the spreadsheet, all my fields are good except one text field. This text field I have is a combobox on the...

Hello Guys, I am trying to make a lable change its caption on a Report depending on a check box, If the checkbox"REFUND" is Checked I want a label to have a caption of REFUND and if is Not Checked I want the Caption to be "CORRECTION FORM". Simple right? Well this is what I did on the OnPage...

Thank you for th info Thanks for the information!!

Where did you get them from? Just wondering where did you get the runtime files from, I would like to learn more about making the application run with out having office installed. Thanks DaniBoy

Thank you guys!!! I dont know how I missed that, anyway its friday!!!:) I will try it out Thanks DaniBoy

Hello I am trying to make my file to be imported from an exel spreadsheet automaticly from a push of a botton. I have read on the forum and I have part of it done, but I dont understand the error I get, it says to specify a name argument. Well I looked in a couple of posts and I can see the...

Pat is right, Always!!! jeje To make it easy do the following: One table named: Customers Another Table Named: Order Details Another Table named: Products you will now create a many to many relationship, from customers to order detail and from products to order details. now on th order...