Recent content by Harry_38

I'll study the suggestions of Gasman and Hartman; it will take me some time. Thanks very much so far

Thanks for the reply Gasman. The user is nowhere identified, neither in de frontend nor in the backend. I think I see what you mean. The startup form should ask for a username. And I would have to add a new field 'UserName' in the General table and link the selected year with the user. Correct?

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...

Creating a blank Access database with the necessary forms and queries took some time. When that was done, I found an typing error in VBA; no idea how it got there. I corrected the error and everything works again. Thanks for the help.

Change in field names or their order, could well be. Thanks for the hint; I'll try it out

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...

Minty, I tried the link to Ron and it worked. Thanks a lot and I will thank Ron as well.

I need to explain a bit more. My question concerns an Access administration application for a society with members. Some 80 members haven't paid their contribution yet. - I've made a query that selects the 80 members; - I got a tblLettres, that stores the text of the e-mail to be sent; - Using...

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?

Jdraw, : it worked (but , should be ; ) thanks a lot

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?

Moderator: please move this issue to the correct place Thank you.

Re: expressions in queries being truncated I found the answer in: http://support.microsoft.com/kb/207668 ACC2000: Exported Query Expression Truncated at 255 Characters.

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...

The reactions I received on this thread hasn't led to an acceptable solution. However eventually I found a way around it: - I gave up the idea of automatically including the parameter in a PTQ. - I removed the parameter entry that entered the course year in the query and replaced it with 'Submit...