Search results

Hi all, I have the following query/sql that unfortunately doesn't calculate the exact number of hours between "Date1 Hour1" and "Date2 Hour2". If the result is under 24 hours it works but if the time that pass is over 25 26 27 28 hours it says too long to be displayed. How can adjust thais...

Hi everyone, here at our company, we have several shared Access databases. At the same time, we are migrating all our files and folders to Onedrive. I have a few questions for you: What will change? Will they still function properly? Are there any precautions we need to take? Thank you in...

Dear All, is a way to obtain the result from a starting table, what I am showing in the attached file? EXAMPLE SIMPLE: STARTING TABLE: A 1 APPLE A 5 ORANGE B 2 TRUCKS B 5 CARS RESULT NEEDED: A 1 APPLE 5 ORANGE B 2 TRUCKS 5 CARS...

Dear all, apologies for my lack of knowledge. I'm trying to create a form where hundreds of HUs can be input using a barcode reader and maintain focus and visibility on the new record, so it doesn't get hidden under the form (in the center of the screen). The database will be used on a 20"...

Dear All, I am trying to find a formula similar to vertical lookup that searches for partial text in column "A" of "Foglio2". The goal is to match the partial text in column "A" of "Foglio1". I tried using the formula =CERCA.VERT(""&A2&"";Foglio1!$A$1:$D$768;2;FALSO), but it doesn't seem to...

Dear All, in a query how do I set data only from the last working week? i.e. Monday to Friday without putting dates. I have this SQL but it doesn't work: SELECT [2021].Date, [2021].ECO_LABEL, DatePart(weekday, [Date]) Between 2 And 6 AS Weekdays FROM 2021; Thanks in advance best regards Georg

Dear all, I have a table with filed "Shipments", with i.e. the following records: 1234567 5432188 2345678 5555555 in need in a textbox in the report that shows the data concatenated: 1234567_5432188_2345678_5555555 And in second moment name a PDF output with this text...

Dear All, from this simple access DB I need a way to remove duplicates, I mean the value must be unique. So if a value is present several times, must be only one value, not deleting all of them. Is it possible to create a button that performs this operation? Thanks in advance.

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):

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

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

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

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,

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,

Dear All, Could you please help me understanding, what I am doing wrong in the attached Acces. I'd like to create relationship, so when I put a new record and the title of the Course "TITOLO" automatically fill the other related fields "ISTRUTTORE", "DESCRIZIONE". I can do it with a query in...

Dear All, I'd like to simply filter the form clicking button, based on date in FilterData TextBox. I cannot find correct VBA expression.