Recent content by shafara7

What do you mean Split Form? The one that I said on post #1 is split(OpenArgs) which is a command code to copy records from one form to another. If you mean Split Database, it means that you split your database into two - for private and for public.

Okay I just saw your latest post. You're a genius! For Login Name, there is nothing else we can do about it, right? Because it is the name of the computer itself, unless the user change the name of the computer, right?

Certain BE db is okay, certain will execute Error 3251. Certain FE db is okay, certain will execute Error 3251. Certain non-split db is okay, certain will execute Error 3251. I don't know what's wrong with my databases. I can't point out which line that produces the error from your utility...

The error from the second photo is: "Run-Time error '3251': Object or provider is not capable of performing requested operation." Wait, shouldn't it be, if I connect it to my FE, it will only show me? Because everyone makes a copy of that FE. Or is your utility can see other user from my FE?

Thank you for your replies! ridders, I tried opening it with my Backend database, but an error occured. See the first photo. Is it because that database is encrpted with password? And when I test it with a dummy database (not split), another error occured. See the second photo. arnelgp, I...

Hello, I wanted to see who are using my split database in the company (a lot of user). I'm trying to understand about the Microsoft Jet User Roster. I found a thread about this here https://www.access-programmers.co.uk/forums/showthread.php?t=292292&highlight=jet+user+roster and downloaded the...

I don't want to disable the whole subform because I still want to be able to click on each records (because there is an Infobox on my main form that will display the properties of each record). Thank you for the suggestion :)

Nevermind I figured it out already. Setting only one of that properties will not work. The Active and Lock must be set to No and Yes respectively.

You're right. I was thinking of replacing the combobox with textbox too. But if I change it to textbox, it will also be editable isn't it? And I must set the Active to No and the text shown in the box will still be grey. Right?

Is there any way to prevent the combobox/text from being grey in colour when it is deactivated? I want to disable the subform which consist of comboxes and textboxes from making any changes, thus setting the Active to No. But this will make everything shows in grey. If I just set the Lock to...

SELECT tblMessauftrag.txtTeilesachnummer, tblMessauftrag.indFOLand, Max(tblMessauftrag.datLieferterminSoll) AS MaxvondatLieferterminSoll, tblMessauftrag.indMessaufgabe, Last(tblMessauftrag.indStatus) AS LetzterWertvonindStatus FROM tblMessauftrag GROUP BY tblMessauftrag.txtTeilesachnummer...

I have a table and I want to create a query with a criteria X-OR. My table looks like this: BillID CountryID TaskID Dates 10 1 3 01.01.2017 20 2 3 01.02.2017 30 2 4 01.03.2017 40 1...

Thank you!

I have a button on a form that should open a opup form when clicked. But the popup form is not visible. I can see something flicked on the screen when I clicked the button but the form is just not showing up. When I turn off the popup properties of that form, it works fine. This popup form...

Okay I'm sorry I think I know why it shows all grey. I just figure out there is an "Activate" button at the Format Conditions window. It is grey because it is inactive. When I clicked the button, the colour will be visible.