Search results

@Auntiejack56 : Thanks Jack, that works well now!

Hi Jack, so these are some errors I have after migrating to Azure SQL! This is the screen when I try to open the "Employee Record" button on the Menu form And this happens when I open "All Working Notes" form from my "Client Basic Info" form

@Pat Hartman : Thanks Pat. I did a bit more research and am referring to your comments in this thread access-programmers.co.uk/forums/threads/connect-my-ms-access-db-to-google-cloud.299363/ - As you mentioned in this post, is it still true now that even though Azure is the best online database...

Thanks you everyone for enlightening me! @Auntiejack56 : So basically I did try your recommendation, but not entirely. This is what I did: - Create a MS Access App with Tables, Forms, Querry. - Create a MS Azure SQL Free Account to register for a server and a database. - Download SSMA and use...

Hi everyone! So basically I have 2 tables with 3/3 identical fields: Customer ID (Autonumber, Primary Key), Type of Customer and Customer Name. The Customer ID from Table 1 is formatted as 'PAR-"0000 The Customer ID from Table 2 is formatted as 'CHI-"0000 When I create a query to Union these...

Thanks so much @arnelgp 😄

Hi everyone! I am a newbie and I have a silly question here. Hope you could help me to solve it! I have a table with 3 fields: Customer ID (Primary Key and Autonumber), Customer Name and Customer DOB. Now I want to prevent my users from entering the same customer. For example, there are 2...

@The_Doc_Man @Gasman : Thank you so much for your prompt reply! I will try your recommendations and come back here once I learn which suits me best!

Hi guys, I am newbie who are extremely low-tech. I am currently building up a MS Access database with Tables, Forms, Queries, Reports for a team of around 6-8 people. We are working in a new office with no shared networks, no Microsoft Office Enterprise yet. Each of us is using our own...