Search results

Hi to you all! I have a question about exporting a table to a csv file where I need the combination of: a fixed (variable per field) width per field AND a "; " (semicolon) as a delimiter Using Access 2016 is this even possible? Many thanks in advance!

Dear all out here, Hope you can provide me with some tips for the following issue I am currently facing. I have a Access DB (2010) with 6 tables with each around 1,2 million rows. The size is 1,3GB. The DB contains data that is also loaded (monthly) in some application, but we use the DB for...

Dear people out here, I am trying to combine the result of two specific (and different) queries on a set of loans. As a result I have to sets of query results: + result query 1: with first field LoanID and several other fields + result query 2: with first field LoanID and several other fields...

Dear all, As a Access newbie I am looking into a problem that I hope to solve structurally and "transparently" via Access in stead of Excel. I would like to compare two similar tables for different months. I am looking for: + loan id's that are new in table(t), i.e. not exist in table(t-1) +...

Hi there, Can anyone please explain me how to have Access 97 insert (in a table) a current date and time on starting-up access and shutting it down again? Can that be automated? What if I have an intermediate computer crash? I want to use the information as a log for the time I have worked...

Hi there, Hope somebody can help me with this: is it possible to have just one form serving multiple (but simple) tables? I am thinking about such a form whereby you first select the kind of entry (task, contact person, document or weblog entry) and then certain fields are open for entry and...

Dear All, I am trying to "access" three specific tables and some queries in VBA but do not have any clue what code to use. Can someone please share some samples? The general idea is to fill a database with three tables: + Activities: description, date, project, comments + Issues: description...

Hi to you all, It may sound silly to those of you familiar with dynamic webpages (and blogs etc.), but I would like to use Access to: + store project activities (description, date worked on, which project) + store project issues (description, date worked on, which project, issue solved on) +...