Search results

sorry to be annoying you but I keep getting an error saying "MyFunction (or whatever I call it)" is not a recognised function name eventhough I have saved the module.

Sorry In SP's in .adp the criteria works slightly differently to the criteria .mdb. For a string value you put in the '' and it automatically puts in the N. eg =N'TEXT' For a numberic value you shouldn't have to put in anything other than the value eg =123 but when i try using Forms as the...

If I change it to this it allows it but then when I run it cant convert the nvarchar to int. = N'[Forms]![frmWorksOrderComplete]![form]![fsubWorderHead]![txtjobid]'

It's a Number (int)

This gives me an error 'Data type error in expression'. I am trying to refer to a control on a subform , I am using Access 2003 .adp

The only reason I am doing it in VBA is because of the last bit (WHERE) you cant refer to a form in a stored procedure (or can you) and the where condition is going to change each time I pick a new record.

I'm still getting the runtime error. A RunSQL action requires an argument consisting of an SQL statement.

What is wrong with this code. It is behind a form in Access 2003 SQL = " SELECT SQLACCESS.tblctwork.job_cpartn AS Partno, SQLACCESS.tblctwork.job_opartn AS CTD, SQLACCESS.tblctwork.job_partdn AS partName , " & _ " SQLACCESS.tblctwork.job_revno AS Rev, SQLACCESS.tblctwork.job_custom...

I should find what I need there thanks. I am also trying option buttons and case statements with the reports laid out in the different positions on the page - seems to work ok

I have a label sheet which may or may not have label in its 4 positions (top left top right bottom left bottom right). I need to be able to select which of these positions I want to print my label on. How can I do that - option group ? can you specify the x y print position each time you print

I have 6 test boxes with the following input mask 99;;0 I am trying to force users to enter either 0, 1 or 2 digits. This works fine for the first box but then all the rest give the invalid entry error message no matter what I enter. Whichever one I enter data in first works and then the rest dont.

Thanks I'll look into it so 'cos that would suite me perfect for some of my other forms too. Will it solve this problem.

No the combo is unbound and this is it's rowsource SELECT DISTINCT TOP 20000 Partno FROM tblctest WHERE (Partno <> ' ') ORDER BY Partno. What is teh advantage of binding the form to a query

I'm using Access 2003 .adp so the recordtype is Updateable recordset. I can update it fine if I dont use the combo to set the record source. The form is bound to a table.

I am using the value selected in a combobox to populate a form and I then need to be able to edit one of the fields but the recordset is not updateable how do I make it updateable.

It wasn't but I moved it up where it should be and that seems to have solved the problem. Thanks

When i am adding a new record and I need to select a value from a combo box I select the value and press enter or tab to move to the next field but this saves the rec and adds anew one at that point. This doesn't happen with all my combos - what decides the action performed when you hit enter.

The problem wasn't with the code the values were being emptied by a requery in the wrong place. To answer your questions - the qty is held in a header record with the prices in a details table. This code is in a module activate from a variety of points.

I am trying to multiplytwo values it works fine sometings but not others.Here is the code MyMatCost = (Forms!frmEstimateComplete.Form!fsubEstDets.Form!fsubMatsEst.Form.txtSubtotal * Forms!frmEstimateComplete.Form!fsubEstDets.Form!fsubOpsEst.Form.Parent!txtQuantity.value)

Seems to work ok with the single quotes