Recent content by shwan

Hello everyone, I want to address an issue I'm facing with ODBS connect failure error. I am using Access as a front-end application connected to SQL Server as the backend, and I have two machines, one at work and the other at home. Both machines have different names. When I load my application...

I have a dedicated machine with with windows server 2019 installed and sql server 2019. I also have multiple client PCs (Laptops) with access front-end installed and ODBC driver 18 n on them, every thing is connected using ethernet, a router and a ethernet switch. Everything works fine, except...

No SQL server is installed on users' machines, and I want to automate this process and make it painless as much as possible. While the code provided above is very helpful when you want to update the front end, it does not involve the hassles of new SQL server installatiion and deploying the...

Hello, I have built an Access application that is a frontend to an SQL server backend. Now I want to distribute this application to end users, those users will, of course, have different server machines. I have some experience with installers like SSE Setup but it would be very much appreciated...

Is not that what where clause supposed to do. I think when the form opens it is already filtered since it shows all the payment related to one record only, but still, you can enter a new payment unrelated to that record and I want to prevent that.

Hello, So I have this simple database that contains only two tables. one contains customers information the other contains their payments. I made a main form that pulls information from a query based on these two tables. When the user clicks on a record in this main form another form opens that...

You are my hero, thanks a lot. one more question if you don't mind I understand what Response = acDataErrContinue means, it will make the form behave as nothing happened. But I have difficulty understanding what Response = acDataErrAdded does and why you chose that over the first statement?

here is my database, it is a very simple database with two tables. one table contains customers information the other one contains their payments. the issue I'm having is in the frmpatients form. it is still an uncompleted project and I'm trying to learn while making this first database. Thank...

Thank you, yes they are all required. can you give an idea about that code? and why the undo button don't seem to do anything?

Hello I have a form with a subform that is based on a table with required fields. When the user enters something then delete it with backspace in keyboard and want to exit the form, an error message appears that say "you must enter a value in "field name" field, the form is completely empty and...

Thank you very much, sir. That was helpful.

Thank you for your replies, If I remove the default value from the table, how could I add the date automatically when a new record is entered? I want the user to see that the date has been added. Can you please share the code for that.

Hello, I'm new to access and I have this little problem that is bothering me. I have a subform based on a table that has a field with the default value set to current date using the date function. Every time I open this subform an empty new record shows below whatever records is already there...