Search results

I'll find a way around but thank you for your input. Much appreciated.

The tag of the fields I want to trigger is set to "Required". Some of the fields are mixed between text and date fields. I've used your suggested code and the result still produced the last message box of the code instead of telling me the required fields are left empty.

Just saw this thread and have the same concept with my registration form. I used the following code that will give you a pop up of unfilled fields and added code to check for a duplicate value if you have something like I do that includes an employee code: Dim db As DAO.Database Dim rs...

Hi everyone Just need some help quickly with the following code: Private Sub btnSubmit_Click() Dim ctrl As Control Dim missingFields As String Dim isValid As Boolean ' Initialize variables missingFields = "" isValid = True ' Loop through all the controls...

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...