Recent content by OptimisticYid

Why would I ever want to replace wine with beer :D If you know Al Murray you will know that it is wine and fruit based drinks 'for the ladies'. Many thanks for your quick answer though, worked a treat ;)

Just a quick problem .... I hope. I'm using SQL Server Management Express to administer my SQL database. Basically I have about 1100 products, 400 of which have a postage price of £6.00 which I need to change to £4.95, but the SQL statement I have written below doesn't seem to work. Can anyone...

I have just installed a new invoicing system and would like to add in a development. At present when you go to view an old order you can use one of two combo boxes to find a record, either by order ID or by customer name. My ideal would be to set up one combo box that details all the fields on...

Try F11 once you are at the form stage, alternatively you could just try creating a new database and then importing existing structure and data.

Sorry to bump but I could really do with a solution ....... pwetty pwease ;)

Sorry Gemma don't quite understand where you are coming from. The form works perfectly, I just want to set it so that a related record in the activity log HAS to be created before the main form can be exited.

Certainly, I restructured the subform query to include my products and transactions table. I then added Me.Price = Me.ProductPrice to the after update property of my ProductID field so that when the ProductID is selected the price from the product table (productprice) is dumped into the price...

Have solved it myself, tahnks anyway. As usual I was trying to make things too complicated, cup of coffee and all becomes clear!

I have a main form, lets call it orders and a subform, lets call it order activity ;) How can I force the user to enter in an activity before they exit the main form ....? Thanks in advance

As per my first post ....... "So what I need to do is take the product price dynamically from the product table at the time of the transaction and store it as the price associated with the transaction, just not sure how best to achieve this." So I understand the logic, just not the...

What would I put in the control source for the Price field (text box) in my transaction table? At the moment it is just set to the transaction price as opposed to the product price, guess I need to select the price from the price field in the products table and write it into the price field on...

I have what I figure is a pretty standard format transaction log which is formed in part by three main tables - Order, Product and Transaction. Order can have many transactions, many transactions can have one product. Works well, produces a pretty invoice, feeds off into other tables as required...

Och aye, but i kind of hoped that Mr Gates would put out some software with features that worked properly. How naive am I? :rolleyes:

I have added a test table with a bigint ID field and a varchar data field. When I add the table it tells me that I may not be able to save changes as I am not the database owner or system administrator (bearing in mind we rent a part of a sql server Stateside, the cost of having our own is...

Reckon so, using the same ODBC connection as I did for the import (which worked fine) do i need to change permissions server side? Bear in mind I can only access our part of the whole sql server, which i do through server management studio express.