Recent content by stu_c

Hello Arnelgp would you have any other recommendations?

Hey I can be made in a report but when I copy from a report into the current word document the layout of the table structure is lost and pastes into a columns rather than the layout on the report which is a little odd :(

Hi all I have a database that I need to be able to create a report in a certain layout, once this has generated I need to be able to copy and paste this into a word document but keeping the layout of the report, Ideally I want a button the user clicks that automatically creates the report >...

Hi all strange one I know I have a form with the following fields CMbStaffName -Picks up from QRYAllAthorisedStaff CmbDepartment CmbArea When the staff name is chosen I want it to input the last entered department and Area for that staff member to be saved so when the same staff member is...

Hello mate, yes I have but I would prefer it not in a subform as I have another subform to add in

Hi all bit of a confusing one TBLProductDetails TBLShippingDetails I have a form Main form: FRMProductDetails - RecordSource: ProductDetails If I have a text box named TXTShippingcode and I want to put the entry into a table that the form isn't a record source for (e.g. ShippingDetails) how do...

Hello mate thanks for the code, that genuinely am confused how that even works!, I cannot see how the boxes finds the data!

Hi all I have a text box I want to show the current record number and total records so it reads "1 of 10" etc, I have got it to work on my main form but cant on my sub form another any suggestions? it seems to recognise the first record as 0, so it reads "0 of 10" when I go to the next record it...

Thank you so much, massive help! bit of an odd one mind, I cannot find the option to remove / hide the top ribbon bar even when I look through the options menu?

is there a way to do this in VBA?

hi all I am looking for a way to the form hide tabs and disable right mouse click on loading a specific form but for the whole database rather than specific forms is this possible to do this via VBA?

sorry, I was just about to upload it, I am at work at present

Thank you for the below, just out of interest if txtVehicleMake was a combo box with two columns how would I get it to copy column 2 into a text box as currently when I try this it only copy's the bound column

solved! Dim Records As DAO.Recordset Set Records = SFrmSubDetails.Form.RecordsetClone If Records.RecordCount > 0 Then Records.MoveFirst While Not Records.EOF Records.Delete Records.MoveNext Wend End If Records.Close End Sub