Recent content by amc

pbaldy, thanks for your comment. I think you are suggesting what I am already doing this is my code for one telephone textbox in Before Update Private Sub telf1_BeforeUpdate(Cancel As Integer) if Not Telf_BU(Me!telf1) Then Me!telf1.Undo Cancel = True Exit Sub...

thanks for your comments. I understand relational design has advantages and disadvantages, telephones is an example, addresses and emails might be other ones. Anyway, the topic is trying to identify ways (if feasible) that could use inheritance or other mechanisms to reuse code in event forms...

thanks, I try to avoid a too purist relational design (and continuous subforms, as well). Anyway, the essence of the problem still remains, avoiding (if possible) verbose code in forms

I am used to develop Access forms (generally bound) in the very traditional way of writing code for all the controls that require them. For instance, textbox containing a telephone number will check if the number is well formed in before_update (and, if not, Cancel=true and control.undo)...

It works, thanks!

I am failing to find the right way to execute a param query in MySQL I am using the following code, where cmd param and cn are ADODB objects (Command, Parameter and Connection) Dim pkc As String sql = "SELECT * FROM Accions WHERE keyclient = @kc" cmd.ActiveConnection = cn...

I would like to have an outlook calendar in an Access 2013 Form (to see the Today's view as a reminder for instance) Is it possible? I thought that ObjectFrame would allow that; I see Word and Excel there (although it fails to connect to OLE server), but not a Outlook object. Is there any other...

Ooops!, My Access is 32bit But, then, how can I create the connection? I don't see any driver for ODBC 32 bit (except one for Oracle) thanks

I am trying to test MSAccess (2013) as a front end and Mysql as a backend. I am on windows 10, using Xampp. The odbc connection test works (from Administrative Tools, 64 bit ODBC), but when trying to link tables from Access it crashes with a very basic message: ODBC Call failed: Microsoft...

thanks I got to load one youtube clip, the first one. But is there any way to wait for the clip to finish and load the next one? I suppose it is a youtube api that shall inform on that, nothing to do with the browser itself

I built a youtube playlist, manually, one by one It can be exported to a json file (text), and from that, url can be extracted. Or it can be converted into a MS Access table with the relevant info. Once in the table, I can play with them to resequence, create new playlists containing just a...

thanks! Yes, you are right! But I preferred to apply more efforts on learning Wordpress and associated areas (php, css), instead of spending endless hours on .NET

I a need some file functions, included in the TextStream object. But, which is the reference I have to point to? thanks

I used to program small business applications using MS Access After a while trying to move to .NET I have given up. I retake ACCESS now, but I am afraid I have forgot many things, and looks like documentation in the net is fading out