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 :(
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 >...
strange one I know I have a form with the following fields
CMbStaffName -Picks up from QRYAllAthorisedStaff
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...
bit of a confusing one
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...
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 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
Dim Records As DAO.Recordset
Set Records = SFrmSubDetails.Form.RecordsetClone
If Records.RecordCount > 0 Then
While Not Records.EOF
I have the below, when "BtnDeleteAllRecords" is clicked from the main from I want to delete all records in the subform named "SFrmSubDetails", I tried doing a loop with the below code but no success, I have never done loops below so probably completely wrong, wasn't sure what I need to...
thank you for the below works perfectly!, just as a bit of an upgrade how easy would it be to add a row number in next to each entry, for example, I was looking at having an unbound field on each row using the =1 in control and using RunningSum Property but I do not have that...
I have a tabular form, when I click a button I need it to copy all the information on that record into two separate text boxes as shown below, any suggestions on how to do this?, I am having real issues trying to get the tabular data copied into a word document so I am hoping by doing...
sorry for the late reply, been rather manic
problem is there are records in 3 different tables, I have managed to get the information from the main form and the sub forms but my issue is that
Hello Doc Man
thank you for the below, I genuinely think this has gone past my knowledge of access...