Search results

Hi all, Hoping you might be able to help as I've hit a stumbling block. I have created a query on my DB and a user has reported that they are no longer able to select unselect all and then select a particular field. Picture here shows what the user wants. instead they are presented with...

Great - What is the best way of using the update Query. Below is a snippet of my numbering ID _OldID Internal Ref 1 9 TEN2018-001 2 10 TEN2018-002 3 11 TEN2018-003 4 12 TEN2018-004 5 13 TEN2018-005 6 14 TEN2018-006 7 15 TEN2018-007 8 16 TEN2018-008 9 17...

Sorry, i thought it might be the case. I have been speaking with my colleague and we can get away with not having the ID number visible when creating a new record, plus we have another form that we use to update records and that form opens on the last record created, courtesy of Colin from AWF...

I would be unable to see the next sequential number that the DB provides which is used as our identifier. I.e. When I dirty the form it shows me the ID i then use this to label our files so it would be like TEN2020-476 etc. As we have multiple Status's for our Tenders the numbers on view may...

Bummer! Im clutching at straws, but what if I create another table just for autonumber or would that not work?

Thanks, Concerning the PK reference - i am assuming there is no way i can get the form to show ID number when I dirty the form?

@theDBguy - Thanks for the advice, its greatly appreciated. Currently In one of our DB's we only have 500 Records and the BE tables are on a network drive and are linked to the Users FE, however this has becoming a nuisance with users having to connect through VPNs. @NauticalGent - Again thanks...

Thanks for the advice. Umm this might be an issue in my current setup then as we use the PK as an identifier for the record, i.e updates, comments etc. If it does not show us chronologically the next number it could start to throw out our records. The way i setup it up at the moment would be...

Hi all, I have been testing Access BE tables into a Sharepoint List and reached a stumbling block. (Hopefully this is still supported by MS) I've managed to get the data uploaded into SharePoint using the export function in access but now I have lost the ID number in a particular form for...

@cheekybuddha, I echo the comments from isla, thank you @isladogs, Yep, i can confirm it all works as previously but now with the added spell checker function.. (That will stop complaints from my colleague :rolleyes:)

Fixed it.. Sorry I am really new to under VBA code..

Further to my last post it has also stopped the "cancel" button working in the "new comment entry"

OK, so I did that part and the spell checker runs, however it has messed something up. When I used to open the form to make a new comment it would always open with the ID number that I had on a previous form, picture below: The code previously always had that ID number filled in? What did I...

Hi There No not yet as not sure where I should put in within my code?

My form looks like this. It looks to me like a text box in a form? The table field for this is a "Long Text" field.

Hello all, I am attempting to add a spell checker code which was taken from the forum to my existing VBA form that was completed for me but I am a little stuck. Below is the code that was written for me. What I added is a different color. Is there a way that when I click the save comment it...

Hi all, I'm struggling to find the best way of not using ColumnHistory. I'd like to keep the view layout that it provides but be able to sort the comments into a chronological order. Can you point me in the right direction? @isladogs I read through your document but alot of it appeared to...

Yes I have had a brief read of your article, need to study it alot more in depth though. Im assuming there is no way of sorting the history box to show in date order. I need to find some information in the forum that will give me the same ability as columnhistory but in a way i can sort it...

Hi. Yes the comments are stored in a network located BE.. (AG) does see my comments on their machine. She sees it in the same order as I do. on my machine.

Yes its all very strange.. Prior to your message I had taken a copy of my colleagues FE and replaced my version, updated a record (Put a comment in) and again behaves differently. So i am SG and my Colleague is AG Now its putting the latest comment underneath.. This is the randomness of...