Search results

Administration program for a non profit organisation, that organizes courses and has 800 members. Front-end Access2016 with backend mysql dB; works fine. We work with 5 volunteers in different locations; they have access to read and write. You start the admin program by selecting an...

Access home built administration package. Among others functions: I download new student entries from a website into a .csv file (comma separated) The .csv file is then converted, in a number of VBA steps, into an Access table. For years I have been using a module , but last month it stops at...

I managed to write a script to initiate e-mails from Access2010 and send to Outlook. Access places the e-mails in the Outbox of the default e-mail account. How can I make Access place the e-mails in the Outbox of a chosen e-mail account?

I have a table that contains a field with 30 characters. Query: If the 15th character of that field is a 2 then that field of the query should return a '2' else it should be '1'. How to do that in a query?

I got a query with data and a module that converts that data to a .txt file. The .txt file is used to renew, thru an upload, the contents of a website. I got a.o. 2 fields that describe a course ‘CourseLong’ and ‘CourseShort’. If there is no long description, we use CourseShort. With an IIf...

Extensive Access program with a dozen macros. This morning I tried to open a macro in design, resulting in a crash of Access2010; other macro's also cause a crash when opening. The macro's run ok, without crash.:banghead: I get the following message on the screen, approx translation inbetween...

Somehow I lost some 50 records in a table, all records are of the same date. I asked the provider of MySql backen db to give me a backup of the dB. They sent me: full backup of the database as like on the server. I don't how to open that file. The provider could also send me a dump file...

Got an extensive Access program on my PC with a backend mysqldb with a provider. I know how to get a Pass Through Query running for a simple query but I get stuck with the following SPT query (SQL Pass_through): SELECT Bankbook.Date, Bankbook.SeasonID, Bankbook.Data1, Bankbook.Data2 FROM...

I have been working with Access(front end) and Mysql (back end) for over a year now. Would like to backup MySql to my PC and store. I have used AccessMySQL Convertor (Soft Galaxy); but that US based program makes mistakes with the date: 10th August becomes 8th October; no matter what I change on...

I have got my backend dB 9 tables (in MySQL) for my Access application on an external server. I need to create relations between some of the tables. For this pupose I dowloaded MySQL workbench; I created an EER diagram but am unable to create the desired relation. I picked up somewhere that the...

I have some very slow reports in Access program with mysql backend; and I am trying to improve that by building pass-through-queries (PTQ). I got a few of these queries working and the speed is ok; but I have the following questions: 1. Each time I activate a PTQ, I need to log on thru the ODBC...

Got a column: Season-id If I make a pass through-query, I get an error: Unknown Column. Is there a simple solution, else I will have to change the name of the column into e.g. SeasonId (but it has an impact on many forms and reports, would hate to that) Pls help.

In Access 2003 I was able to create an mde file. I am now using Access 2010, but can't find how I can create an mde. Please help.

Access 2010: Mainform (Table with persons) subform1 (table with course participants) subform2 (Bank book table) In the mainform, I select a person "XX" Next I see in subform1 the courses of 'XX' and the amount due for each course. In subform2, I note the amount received for a particular...

Simple backend table on mysql server: Bankbook (ID, date, IN, OUT) less than 2000 records. Made a simple query in Access, with a selection for the date of the last record. In a form based on that query, I calculate the balance (within the form: = SUM([IN]) - SUM([OUT]); the form takes 40 secs...

Administration program for a non profit organisation, that organizes 125 courses and has 1000 members. Access2003 with backend dB; works fine on a PC. Next year more people in different locations need access to read and write. I converted the Access dB to mysql and put it on a server; and I...