Search results

Hi all, usual apology in case this has been done before (I'm sure it has!). I have a recordset (the table is called tblJobTitle) and I want to loop through all the records and create a windows folder (MkDir) in my P directory with the name of the field/control [JobTitle]. This is what I...

Thanks Gasman, looks better. All I need now is some feedback on the original code query. Roll on home time. Got my hat and coat on already.

Thanks Minty but what an effort. Don't recall it being this tricky last time I posted. Maybe wrong end of day ! Don't suppose you have an answer to my code query do you ? ta.

Hi all Please can you advise on following. When I add a new linked invoice to a customer record for the first time it only works if I use - Recordset.AddNew If there are already linked records then this works fine - DoCmd.RunCommand acCmdRecordsGoToNew BUT If I use Recordset.AddNew the primary...

Hi all Please can you advise on following. Hi all Please can you advise on following. When I add a new linked invoice to a customer record for the first time it only works if I use - Recordset.AddNew If there are already linked records then this works fine - DoCmd.RunCommand acCmdRecordsGoToNew...

Hi all Please can you advise on following. When I add a new linked invoice to a customer record for the first time it only works if I use - Recordset.AddNew If there are already linked records then this works fine - DoCmd.RunCommand acCmdRecordsGoToNew BUT If I use Recordset.AddNew the primary...

Hi all Please can you advise on following. When I add a new linked invoice to a customer record for the first time it only works if I use - Recordset.AddNew If there are already linked records then this works fine - DoCmd.RunCommand acCmdRecordsGoToNew BUT If I use Recordset.AddNew the primary...

Trying again with code Private Sub Form_Current() If Me.subfrmInvoiceNew.Form.RecordsetClone.RecordCount = 0 Then Me.subfrmInvoiceNew.Form.Recordset.AddNew Forms![frmInvoiceNew]![subfrmInvoiceNew].Form![RaisedBy] = Forms![frmpassword].Form![EmployeeName] Else...

I thought I set this out neater than this honest

Hi all Please can you advise on following. When I add a new linked invoice to a customer record for the first time it only works if I use - Recordset.AddNew If there are already linked records then this works fine - DoCmd.RunCommand acCmdRecordsGoToNew BUT If I use Recordset.AddNew the...

Hi Mark Thanks for feedback. Not sure this does the job partly because I don't understand the .BOF reference. If you can throw any more light on it or have any other ideas would be good. Thanks anyway.

Hi all I have a main form and a sub form. The sub form is continuous. I want to add a button in the main form that sets focus on the sub form, goes to the last record in the sub form but shows the last 'x' number of records (can get about 20 in the main form space allocated to the sub form...

Minty - superstar. Was I seriously doing it the long way round or what! Couldn't see wood for trees. Worked fine and much tidier looking. Thanks, much appreciated.

Hi all Got myself a bit stuck and possibly not starting in the right place to begin with ! Using Access 16 I want to use code to automate a copy and paste process. Copy from 2 controls/fields/Text Boxes on 1 form (frmEmail [Details] and [Body]) and paste into a single control in...

Thanks for tip. I might have done this hard way but various pointers suggested that I create a separate table for the next sequential number to avoid multiple users creating 2 records at once and causing corruption. When my new record wizard runs it opens the separate table for the next...

I have tested and it only brings up the error message if the field (RPRRef) is blank or user tries to change it. The field is a sequential number (not autonumber) that I don't want changed once created. I have a new record wizard which pre populates this field but I was struggling to lock it...

Thanks Minty I ended up with following which seemed to do the trick. Private Sub RPRRef_LostFocus() If IsNull(Me.RPRRef) Or Me.RPRRef < Me.RPRRef.OldValue Then MsgBox "The job reference number cannot be left blank or lower than the last number in the sequence." & vbCrLf & _...

Hi all May just be wrong end of day but can you help with this one please. I'm trying to make sure that an end user can not enter a value which is either Null or less than the existing value. This code brings up a message box if null or less than 19500 but rather than specify a number, i.e...

Thanks, response to query already received. So far so good, much appreciated.

Thanks Bob. I was close but couldn't get the right bits in the right place. This worked a treat. Very much appreciated and thanks for quick response.