Recent content by stu_c

  1. S

    Copy Report Layout to Word

    Hello Arnelgp would you have any other recommendations?
  2. S

    Copy Report Layout to Word

    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 :(
  3. S

    Copy Report Layout to Word

    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 >...
  4. S

    ComboBox value to update another combo box

    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...
  5. S

    Add record to a different table than RecordSource

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

    Add record to a different table than RecordSource

    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...
  7. S

    current / total number of records in Txtbox

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

    current / total number of records in Txtbox

    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...
  9. S

    Disable Tabs and Right Click

    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?
  10. S

    Disable Tabs and Right Click

    is there a way to do this in VBA?
  11. S

    Disable Tabs and Right Click

    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?
  12. S

    Copy Tabular Data into one Textbox

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

    Copy Tabular Data into one Textbox

    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
  14. S

    Delete all records form Subform with Main Page Button

    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
Top Bottom