Search results

Coy the BE when not in used and create the tabel and copy it back. I am not quite clear Coy the BE Arnel... can you elaborate again? Frank

Arnel, my database was split, bkend is in the server now. Can I just add the tblLocalVariable in my FE.accdb?

Thanks Arnel for your explanation, you help my brain work at my age of 66, I will try.

Arnel, When I unzipped the file, it looks like below and when I open the mdb with MS Access2016, as in the 2nd picture it says it is already updated, while I can not open it.

Hello, this is my front end, file path in server: \\ABCbrickyard\PQRShared\Central\EVS\EVS_Inventory\FEbkup\FE_Evs.accdb My question is how can we make it as soon as the users open their front end, it will automatically update by copying it from the server and replace their front end. I am as...

select the third option and then examine the code to see how you can do it. I better filter in the report George, coz, if show it in the form, other users could try to change it.

Thank you Arnel, I think I just show the selected transaction no. in the report, because if I remove it, other user may change it

Hello, Can anyone tell me how can I filter the form by transaction no?, so that we can see the transaction. Or should I filter it thru report?. It is better if we can filter/search by transaction number and jump to the transaction in the form. But here I see the filter on the ribbon is not...

Pat, I just read when I googled that attachment is not supported by SQL, can you give the sample of your form with VBA to put the picture, so you have like Image path right?. But can it do when we hover our cursor under the picture frame, it will say what to do, when adding the picture?

In the Option for Filter look up for database should we checking the box of ODBC field. Now I see the ones are checked: Local index fields and local nonindex fields. This is in the case we put backend in server. Any way what is a server connected with users, is it by cable of wifi or...

Thank you Isaac.

In order to improve performance, is it good, if on Option on current database, we put " Compact on Close" to True?

Are you saying under the 2nd share name we need to make a folder for each database?

Actually, I do not have any intention to make it long, but first, the name of the server itself, is already long, then under that name there are many subfolder we can say, so for our section we make one folder, then since I have 2 databases, I need 2 folders, and under each folder there is a...

Hello, because even the server name is long, and I will make the name of our folder and subfoler, so it could be long. My question is if the path to the server is like this: \\abcyard.llt.ad.lltahsc.org\ PQRInventory\PQRInventory_Main\Pictures, Database_backend will be in PQRInventory_Main...

Thank you Pat, I study this first, how to make it work in batch file.

(easiest): \\server\users\bob\ Ranman, is n't in opposite?, starting from Bob\......

Thank you Pat, I will look into it

Hello, I want to know the sequence of splitting database and making Accde. Let's say on my PC, I already split the database from my C drive to \\Server. Then I make the Accde of my front end in my PC. Then I go to user1, with the copy of my front end of my Accde, I put it on the drive C of...

I do not know how to use a temporary table and it will work, can you teach me?