Search results

so the shared spreadsheet is what the company runs it business from at the moment. what i am doing is migrating from that to an access database when you have multiple people editing a spreadsheet at the same time the user initials are displayed as a overlay with a colourful highlight of the...

I am migrating users from a very large shared multi-user-access spreadsheet to an access database and they have started using the application i have created for beta testing. One of the issues/requests is to have functionality that occurs with shared spreadsheets where each person accessing it...

@MajP wow, ok that sounds perfect

@MajP looking, thank you

@Gasman thanks i'll take a look

@Minty i have a reset sort button on the page so thats where i'll put the defaults, and i think you've pretty much answered what i thought which is its not possible to capture the event and override it

@Minty thank you, that would at least set the default sorted view but i'm trying to append the RecordID sort bit to any time the user resorts the data themselves. again tbh i'm not sure what i am asking is possible so happy if someone says "nope not possible" but just trying to capture when a...

Hi I have a continuous form that is by default sorted by a date field of a record. If a user enters a 10 new records which have the same date the records are sorted in a random order, which i assume is as expected, so as an example: As you can see the last field is the record ID (which is...

went a different route which solved all the issues above so i have resolved the issues. i am going to mark this solved because it has been and thank all for the inputs and assistance. if anyone wants to know what i did in the end i can explain but it might be a bit too long to explain

awesome thank you, its the acDialog part that pauses things thats good to know i'll look into the naming of the forms etc thanks for the recommendation

hey @June7 thanks for the update. The popup form is called as follows: Private Sub btnAddConsignment_Click() DoCmd.OpenForm "form-Consignment", , , , acFormAdd End Sub this creates a new record but doesn't actually add the record to the table till the user hits Save or Save/Exit on the...

Hi All I have a continuous form that shows records from a table. There is a button which opens a popup form for data entry. Once the user completes their data entry there is a button to Save/Exit and this requeries the continuous form so the new record is visible, but i would like to move the...

@Pat Hartman thank you for your response and input it is appreciated

@arnelgp that is very interesting thank you. i've tested it out and its pretty much exactly what i want to do, it might even mean me re-looking at the ways in which i'm passing data around etc because right now the arguments to open form are quite limiting but if i create the new form the way...

@LanaR i will still take a look at the course though as i am sure there is tons of useful stuff on it and if it is discounted i will certainly put it to my boss as something that i would benefit from and see if they will fund it

as an update: DoCmd.Close acForm, "form-Delivery" DoCmd.OpenForm "form-Delivery", , , , acFormAdd, , argumentsString works and achieves what i want the flagging of returns is just indicating which of the associated product records linked to the delivery will be used in the new...

i think i am probably not explaining things well enough so i will add, i do not need to retain focus on a specific record as i am creating new ones and passing details of things i need to know as arguments to the form open call as i don't need to know anything about the record i'm clicking the...

may take a while have 1000s of records of test data across 26 tables and all of it has been imported from a live spreadsheet so trying to anonymise it might be tricky, i will try though honestly i am pretty good with doing the stuff if people explain it, i have had the database reviewed by...

the deliveries are built up of 2 tables: Delivery information - static data that covers all products Product information - 1 or many products delivered to a client When a client rejects product we can deliver it to a second client (usually a market) so we create entirely new sets of static and...

@LanaR thanks for the response, and whilst you might have described the solution i'm not entirely sure what you mean. at the moment i can create NEW deliveries and all that works fine, just need to understand if i should close the form before the "openform" VBA line to get the process to work...