Search results

The local path seems to work on my PC. The reason why I don't want to distribute the FE locally is because they always tend to forget or they intend to mess things up and on a daily basis help to recover their files. But if it has to be done, it has to be done. So far had no problems using one...

There is no such option. I've just set up the share drive on another employee's PC and started the database. It gave me the same error but showed me the message bar to Enable Content and added to file as Trusted. No problem whatsoever. I've relinked all tables to the back end file and removed...

Hi everyone. To avoid duplicate thread, please direct similar solved post. I am running Windows 11 on a administered network. The front end and back end file is on th same share drive but back end is password protected and since many users are utilizing the FE, the BE is linked through network...

My thoughts exactly

That works perfectly. Thank you

When it shows me the error and I click debug, it highlights this part: ctrl = StrConv(ctrl, vbUpperCase) same with @arnelgp code: ctrl = StrConv(ctrl & "", vbUpperCase)

But now I don't understand is that I've gone through another database I designed and the exact method I used there, is used in this one. Same age display textbox with the expression and it saves perfectly without error.

There is one control yes that has the expression to display the age from the DOB value but the age value does not save to the table

Still gives me the same error

Hi everyone My code: Dim ctrl As Control For Each ctrl In Detail.Controls If (TypeOf ctrl Is TextBox Or TypeOf ctrl Is ComboBox) Then ctrl = StrConv(ctrl, vbUpperCase) End If Next This code is fired upon clicking the Save button in my form and is the first code in the line. All...

I've disabled the wifi on the laptop and behold...the f..ng thing did not freeze. What I don't get is that it's just the normal documents folder that you will get on any standard PC or laptop, and that folder was not shared on One Drive at all. But I did take note...The laptop has been spoofed...

Would disabling my network help by any chance?

Yes because if I use the laptop outside the organization without being connected to the IT network, I won't be able to access any of the files

The DB file is local. It's stored in My Documents folder on the HDD. I'm still busy with the design so nobody is using it.

Hi everyone Need some help on a frustrating matter. I've started a new database file and whenever I start working on a form or open the VBA window, the application freezes and becomes non-responsive for up to 5 minutes. This can be anything from opening a form in design view or renaming a...

It's basically one database that updates certain data or records to the other database. The other database only updates its own tables and records. For example, if I save a new record of a persons details from database 1, the second database also gets updated with the same details but if the...

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