Search results

Hello, I successfully created imported database tables into MS Access database that import all tables from SQL Server database. I don't do the linked tables because I want to have a way to modify data from these imported tables that will not affect the SQL tables. I am looking for a tool or a...

I created MS Access linked tables to sql server already. I got all tables I need into MS Access database from SQL Server. However, it is like a copy so all updates on SQL Server database tables will not update on MS Access database tables. How do I make the automatic updates on MS Access...

Hello, I am trying to create a report to set all Labels on one column (left) and data to 2nd column, but it does not work. My code below will combine a few table columns on one column and delete any empty rows. Can any one help please? Thanks. Dim nBaseXAxis As String 'var to keep left...

Hello, I am using ASP to create a checkbox for 5 values and users can check multiple checkboxes at the same time. I store these values on ms access db table. If a user check 2 checkbox (e.g. Mexico, Spanish), then the values is stored in the field will be "Mexico, Spanish", separate by "," or...