Search results

Could you explain how this code works? varproductid has not been defined

Also as I want this to always happen, instead of adding that to the code on the form is there anyway of doing it in the table design?

Thanks for that Gemma, that is what I was looking for :) I am able to change the design if you think that will help. So you suggest I add a field something like Version_Number as an AutoNumber Primary Key? I presume I still need the suggested code to find the next value?

Hi guys, a confusing thread title I know, I am struggling to define the question that is why I am struggling to find the answer. Here goes: I have got a table with the following composite primary key fields: Product_ID Product_Version I want the Product_Version to increment by 1 everytime I...

Could you have a look at that code again JR and see if it is correct. Something is causing an error and I cannot find what it is.

Exactly what I was looking for. OpenArgs is something I need to start getting my head around. Cheers JR

I have got a form and depending on what form triggered it to open I want it to take on that primary key. In the default value of a control on the form that is opened at the moment I have got: =[Forms]![frmJobs]![JobNo] I need the same to happen but from a different form, so instead of...

You put it in the field. i.e. you could calculate a line total in an invoice by adding Qty and item_price to a query then in a calculated field =[Qty]*[item_price] This creates a new column in your query output.

Thanks Bob, that is exactly what I was looking for. I knew there would be a better way than to simply store the address in the table in an unnormalised form.

As with the Purchase Order example I have just given. I do not want to put the delivery address details in the PO table for the sake of 1% of orders. Any ideas how to get around this? Linking to a PO_Delivery table to store the address etc?

I agree with all points made. I think I will note this as a shortcoming of the database and move on. I do not want to bloat the database just for the odd client address change (which will happen). This system is not for accounting purposes so maybe it will be picked up by the accountancy system...

Hi all, I have the following table in my database: INVOICE (InvoiceNo, ClientNo, InvoiceDate, CustOrderNo, CustRef) I obviously have an INVOICE_LINE table that goes with it. When I update the CLIENT table and then reproduce an Invoice it will take on the new address. I want to store the...

It may be easier to set a default to the field i.e. set it as 0 then you can count the 0s? As the previous post said you cannot use IsNull with DCount as DCount will always return a number

You will need to setup a Query to perform that calculation. Create a Query with all the data in you require from the tables, then you can perform the calculation as a calculated field in the query

http://www.google.co.uk/#hl=en&source=hp&q=send+access+form+via+email&aq=0m&aqi=g-m1&aql=&oq=access+form+via+&gs_rfai=&fp=67d5d5d61e9a0270

Cheers for the input guys. That is exactly what I was thinking, I was just checking that no one would argue that it is a wasted table.

I have a database and recently the company have changed their telephone number. The address on all the printed reports was manually entered into a label. I am undertaking the task of changing this so that the address can be edited without me. Should I store this address information in a...

I have just read my question and see why you are confused, I did not explain very well appologies. Instead of using "Back up Database" from the menu, I want to code a button to launch it :)

All I am trying to do is launch the built in Back up Database utility from a command button instead of clicking the Office Icon, Manage, Back up Database.

Hi ghudson, I'm not sure how that is going to help me, could you explain further please? I presume I needed an API or something, similar to the following to call the function maybe? http://www.mvps.org/access/api/api0001.htm