Search results

Basically the code is this... Private Sub add_treatment_button_Click() On Error GoTo Err_add_treatment_button_Click Dim stDocName As String Dim stLinkCriteria As String Dim stCustomerID stCustomerID = Me![Customer_ID] stDocName = "add_ColourCard_info"...

Matt, Yes, basically. Prev form is the prvious form from which the customer id is taken from, then passed to.

Robert & Pat, Thanks for your help on this. Basically I did understand Robert's advice, but it still didn't work. I therefore thought i would rethread as people tend to pick up new threads and leave the ones that have been answered. I had spend hours and hours and by the time i had posted the...

I have 2 tables Table 1: Manufacturers on this I have ManufID and ManufacturerName fields Table 2: Products on this i have ManufacturerID ( Related 1-many, only include records where both match ) which relates to Manufacturers.MaunifID and ProductName, ProductID, Product Description. What I am...

Thanks for the help...it still doesn't work, it just comes up with blank !!???

I have a form which is attached to 2 tables, manufacturers & products. Products has a ManufacturerID field ( relates to Manufacturers.ManufID ) and also has things like product name etc etc. Manufacturers has ManufID and ManufacturerName What i want to do is to have a combo box that gives a...

Thanks you for your help Alan.

Problem solved....forget setting variables and pulling into unbound box. Set the default value as the [Forms]![prev form]![customer id]. Then set the control source as customerid...it inserts it automatically

Hi, Building a client database ( A97 ) When i select a client form opens in datasheet which provides a summary of customer treatments that have occured. I can then click on a date and it will give me specific details of that treatment. What i want to be able to do is to add a treatment from the...

Got it !!! It was jumping to the error message before executing 'if...then' statements, this not processing them and supplying the wrong error message... Thanks for all who helped though... FYI the code is.... Private Sub TreatmentDate_DblClick(Cancel As Integer)...

No, the error is coming straight from Access not from the MsgBox. Putting the variable at the end of the message to view it for error checking. I have removed it but still get the same problem. I think it may be the error trapping in 'On Error GoTo Err_TreatmentDate_DblClick' which jumps it...

Hi, following on from my last post, I have partly solved the problem.....now i get 'invalid use of Null' basically if a TreatmentID exists then it opens the form. If it doesn't exist then i want it to show an error message. It works if a TreatmentID does exist, but comes up with 'invalid use of...

forgot to say - they way i woked this out ( I'm new too - day 2 of Access ) is that i put a command button on my form and set it up to open a new form when pressed ( through the wizard ) Then I grabbed the code, placed it in the double-click field i actually wanted to open the new form (...

This works for me.... Private Sub TreatmentDate_DblClick(Cancel As Integer) On Error GoTo Err_TreatmentDate_DblClick Dim stDocName As String Dim stLinkCriteria As String stDocName =...

Thanks for your help Drew BUT unfortunately none of this works. Is there any way i can list variables whilst running so i can see the value of TreatmentID ??

Hi, I am trying to error trap. When someone gets presented with data on a client, they can click a date on the record and it opens a detailed form presenting them with all the data relevant to the date they clicked. The PROBLEM is that if there is no data ( past history of the client ) i want to...

Hi, I am trying to error trap. When someone gets presented with data on a client, they can click a date on the record and it opens a detailed form presenting them with all the data relevant to the date they clicked. The PROBLEM is that if there is no data ( past history of the client ) i want to...

WOW ! Thanks you so much for your help. Very appreciated

Thanks for your help. Unfortunately i am lost on the VB code and havn't got a clue. I understand the principle though, so it was very helpful. Thanks again.

Thanks for your prompt reply. If you set the enabled to no, then all the info becomes greyed out. That's why i just wanted to lock it to prevent editing, then perform a 'magic' unlock command, similar to how you describe. Do you know how this would be done ???