Search results

Dear All, I'd like to create a linked table in my Ms Access Database (sorry if I don't attach it), connected to an online Google sheet. before I give further info, is it possible? My IT team give me an open door to connect, but I don't have an idea how to use it. Thanks in advance Georg B.

Dear All, https://www.comparitech.com/net-admin/microsoft-access/ I love Ms Access, After reading this article I was a little disconcerted. Where I work, I have created many Access Databases that have become part of the work Iter. In many ways it simplifies our work by making it faster and...

Dear all, I have Office 2013, Is it possible schedule the sending of a report by e-mail, every working day at a certain time? Is it possible do it via VBA? Best regards, Georg

Deae All, is it possible with a key or combination buttons select a table into a sheet without empty cells. I explain better, the same way when you insert a pivot table, you select A and automatically takes all the table (sorry but I have italian version):

Hi to All, this DB works with a barcode reader wifi connected to pc so the sound is important, on error -- sound. Thank you but I don't know how to do it.

Dear All, in attachment a very simple one field DB, I have created a formatting condition in order to avoid errors (begin with 9* and must be 9 characters. Is it possible that on error the PC produce AN ALARM SOUND? Thanks in advance

Hi thank you for information I will investigate, and will try to find the library that must be checked.

Hi, yes there was a missing Reference I have unchecked it, but the issue still believe, 4 years without an error and now after a beautiful weekend this Error, I am desperate ...

Dear All, I have a shared Access Database Splitted, 3 years without an issue, and this morning the following VB code give the error shown below (sorry it is in italian, no idea how is in english): Partial Code: Private Sub IMPORT_PIR_BUTT_Click() Dim rstIssues As DAO.Recordset Dim...

In The End I Am A Little Bug But It Works !!! Thank you.

Hi the issue is on Italian Office where the Function are in english but separator needs semicolon, so I used your string I paste it with semicolon lowercase , lower , lower the only difference and now it works. Thank you a lot.

Dear All, an Italian problem. Premise that all functions, in Italian MS OFFICE needs a semicolon ; instead of a simple comma , (requested in functions and formulas in the English office), so I can't get "CHOOSE" function result, WEEKDAY works perfectly, here below what I set in a query: WDay...

Dear All, I need to create into the table "TabellaBase" an attachment field, unfortunately seems impossible, because the field propriety don't suggest "Attachment", in italian Allegato. in attachment you'll find the Backend of a split Database. could you please help me on this matter? Is...

Gasman, my ignorance is absolute sorry, but I don't understand... do you mean that is not possible email last record content in the body?

Dear All, In the attached file I have create a button, that sent to me an email and save / close workbook. I'd like to place in the body (strbody) last record created from the user. Is it possible? Thanks in advance best regards,

Grazie Fantastico!!!

Hi, I used another way Replace - " " with "" afterupdate Seems work... crossing fingers thanks again

Hi Spawn or Deadpool (:LOL:), Thanks for prompt answer I will try.

Dear All, I need to avoid blank / spaces in a Unique ID field in a new record form, I don't know if it is better adopt an After Update code or something So. Could you please help me on this matter? Which is the best way to apply this rule? Thanks, Best regards,

Ciao, many thanks, I will study bettter how relathionships in access works. I will go on using your suggestion