Recent content by collins_jd

oh my goodness!! that worked!! THANK YOU!!!! I knew the number of records was going to become a problem so now that this issue is fixed im working on how to "archive" old ones so they can still be referenced when needed. Trying to decide the easiest way since i have so many other queries and...

it does sort of read that way but i have not touched these settings. we have been using this for 2 years from 4 different office locations with no issue until 2 weeks ago. At first I thought it was records number issue as we have reached and passed 5000 lines but some of the tables have 8000 and...

here is what mine shows

where do i find that? in access or online in sharepoint?

All of the sudden after working fine for the last 2 years, when we try to finish the order or add another product we get the following error message: "you cannot reference rows created when you are disconnected from the server because this violates the lookup settings defined for this table or...

by design so the accounting dept can pull data by office etc

i wish lol everything is saved on a trusted folder on desktop. the only thing i put in onedrive was the back ups i made each day before i split the database and i had to pull those out of the trusted folder to move to onedrive. ive found several posts in other blogs with people having same...

i have done that. the forms ask for criteria in the query but do not ask for password. currently reading whatever i can find to try and fix. Thanks for trying to help.

@arnelgp ok, can you give me a hint how to go about that. new to access. i will search how to do that but would greatly appreciate a hint lol

@pbaldy correct. the code is visible and functions in accdb. when i save the accdb as accde, the forms no longer ask for passwords. Idk if the code is still in the properties of the form because after it is saved as an accde i am no longer able to open the form in design view to see the property...

About to disperse front end to users. clicking through to make sure everything worked and noticed all the passwords that were added in the form property / events are gone. pic of code attached. I cant add them back in accde file. how do I require pw for those forms? sorry, new to access... i...

@Pat Hartman I entered the code into the form property events before saving as accde..... Event on Open. the tables are product cost table and sf points to VendorXProductT table which pulls vendor info from vendorT and Product cost info from productcostT

Thanks so much! @Pat Hartman and @GPGeorge. You were correct and I was able to fix. I seemingly have only 1 issue now and that is that with the front end I was about to disperse to staff. Certain forms require a password to open but when i convert that front file from accdb to accde, the accde...

Hi All I've finished a good basic functioning ordering etc system. have split the database, created my front end user files, trying to move database to sharepoint and getting the following error (see attachments). the table and values are there.. help would be greatly appreciated

LOL I got a real chuckle from your story and though I have never heard the term before, I do fully understand the "flat-file" term! I know and have loved excel a long time. we have simply have outgrown it and cant do what I need now or to continue to grow. There is also the issue of staff with...