Search results

Another quick question...Since these DB's are on a network share drive, if I would like to refer to the DB on the other share drive, how do you write the VBA to find the share drive but each computer will have the drive mapped with a different drive letter?

@Uncle Gizmo - What you said makes a lot of sense. I was actually just more concerned regarding the database used on a daily basis to send that information through to the other database. Will have a look at linking them. Thanks

Hi everyone If this is a repost, please redirect me to the relevant one. I have 2 databases that are on different network share drives. With the one database, we use every day, I want the details of the person (first name, last name, date of birth, etc.) I save to get carried over to the other...

Works perfectly. Thank you

Good day everyone In my table, there are 3 columns I want to concatenate in a Query. These columns are named LEO1, LEO2, and LEO3 which are the Initial and Surname of a person. In the query I create a new column LEO with the following string: LEO: IIf(IsNull([LEO1]),"",[LEO1] & ", ") &...

Thank you for your inputs, gents. I'm not as advanced in databases as you guys but I did read about splitting databases and put some of that info into practice but i'll work on a better one next time

That is why I am doing an updated version of the database. This one was my first attempt to get things going. But thank you for your reply

We use a network share drive. They log in on the same front end file but don't have access to the back end file.

And if I should do maintenance, it will be to update a report or make small changes to some errors picked up. Maybe I found new code that I can implement in that app

No there are 3 different computers in that control room but they use the front end file on the network. So if user 1 uses PC 1 and goes off duty, user 2 comes in to use PC 1 with user 1's account still logged in

I've disabled the close button so the users are forced to log out first but they still leave the app open but the next users just continue on their account and I don't want that to happen

I think I'm just gonna finish up with the updated version. Not gonna let it bother me for now

Ive changed the code and did a debugging but no error showed. It seems it only does that with the first check box. The dutycontrol table might be the cause of it because viewing the other reports does not give that error

If I click last 7 days it shows me the records but not 30 days. I will look into your suggestions and see what comes up. It worked perfectly before but somehow today it showed me that error

Does anyone have a sample database where the admin can kick current users out while doing maintenance? or to notify the users that database maintenance is scheduled and have them locked out from using the database

Sorry guys. Here is the front end and back end file. The form where I get the issue from is ViewReports. Clicking on Last 30/31 Days and search gives me the error

I've edited my post and attached the DB

I forgot that user level 3 is standard user and wont be able to view reports when you log in so keep shift in when opening

Hi Arnel I am working on an updated database and corrected that issue with the new version

Here is the database There isn't many confidential data in so go ahead and have a look the username is sampleu and password is newpassword