Search results

This has been annoying me for almost 2 weeks, but sometimes you need to post somewhere online before you finally figure out what's going on. Finally, I figured it out, the computer I'm using is using English Office, the computer I pass the database has a different language for Office. It's odd...

The computers have the same odbc driver. The backend is in Postgres

Here is my situation, I'm, working on a database on my computer, using Windows 10, Microsoft Office 2016. After making the database I move it to another computer, also with Windows 10, same version of Office. The database works fine on my PC, but when I move the database to the other PC, I'm...

No not wifi, just over a VDSL connection, the Access frontend is on one computer and connects to the SQL server which is at a different location

Oh that! The form takes data only from the table Orders, but it has subforms that get data from different tables. One of them is the Job table, which is connected to the Order table. The tables themselves are linked (there is an OrderID column in Job that connects Jobs with Orders, so an order...

Which query? It only applies on a single table, there are no joins. And the form rowsource doesn't have a join either it's a simple Select * from Order. Is it possible that every time I change the rowsource of a textbox, the entire form refreshes?

To update my post and add something even more confusing. I converted the Customers table (Structure and Data) so it runs locally on my access file (not a linked table) Modified the code: sSQL = "SELECT Customers2.ID, Customers2.CustomerName, Customers2.Phone, Customers2.Email FROM Customers2;"...

I have a front end created in MS Access and a backend in SQL Server, the server is remote and the frontend connects to it over the internet. I have a combobox in a rather large form with multiple subforms in it. The combobox contains names of customers, when someone types in it I wrote code to...

Hello! I have a Microsoft Access database with some client data, that includes name, address, phone and some others. It's about deliveries to clients, so it's important to know quickly who is calling and get their relevant data. What I'm looking to do is filter the database automatically using...