Search results

I have yes, It puts the cursor in that box but does not put the scroll bar back to the top of each from

Hi all I have a form with sub forms etc, across the bottom I have buttons that allows the users to scroll through the different records, one of the buttons allows users to crate a new record, it is possible that when this is clicked it takes the user back to the top of all forms?

I tried that is didn't seem to work

how do I lock a field after 24hrs so it cannot be changed? I am using modules If [Forms]![FRM_TBLALL_FullCustomerDetails]![Form]![DateEntered] < Now - 1 / 24 but doesn't seem to work?

Hi all I have a button that when clicked i want it to put YES or no in a combo box that then unhides other fields, I have managed to get it to work manually when selecting the yes or no dropdown but doesn't seem to work when I get VBA to select it via a button seems like although its showing the...

thank you!

Hi all I have an Acess form that is filled out and when a button is clicked populates into a word document is there a way to make this process automated so it automatically prints and closes the word document (without saving) Public Function FUNC_CreateEnvelope() 'FIND WORD FILE Dim oWd...

Hi all I have a field where the users types the area for example LONDON is there a way to auto populate this into another field showing the first 3 letters already in place?

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?