Forum Widgets
Latest Discussions
Tengo una base de datos e Access que contiene una serie de documentos Word y PDF.
Tengo una base de datos e Access que contiene una serie de documentos Word y PDF. Me ha funcionado perfectamente hasta el día 14 del 05 de 2025 que ha habido una actualización, desde entonces no puedo abrir ninguno de los documentos Word, me aparece el siguiente mensaje: Microsoft Word Word detectó un error al intentar abrir el archivo, Pruebe Io siguiente: * Compruebe los permisos del documento o la unidad. *Asegúrese de que hay suficiente memoria y espacio de disco. Abra el archivo con el convertidor de recuperación de texto. y cortar un Jamon.docx) Sin embargo, los documentos PDF los sigue abriendo perfectamente. Pero me sorprende que tengo instalada una copia de esta misma base de datos en otro portátil que no ha sido actualizado y me abre estos mismos documentos Word perfectamente, sin ningún problema. ¿Qué puedo hacer para solucionar esta situación?
Distinct Count Subquery, MS Access
Need some help in getting a Distinct Count result in this query. For context, i work in healthcare and of course an not share the actual data behind the query. My goal is to modify the current quiery - which returns total charges by account financial class (medicaid, commercial, medicare, sellf pay) and account date within a given month (post date, in the query), but add on a distinct count of hospital accounts in the grouping. Current SQL below, all data lives in the ez_hosp_chg_v. table. End goal is to return a distinct count of the bold/red data point: "HOSP_ACCT_ID" SELECT ez_hosp_chg_v.POST_DATE, ez_hosp_chg_v.TX_FIN_CLASS, ez_hosp_chg_v.ACCT_CLASS, Sum(ez_hosp_chg_v.ORIG_AMT) AS SumOfORIG_AMT, ez_hosp_chg_v.PRIMARY_PLAN_NAME, ez_hosp_chg_v.HOSP_ACCT_ID FROM ez_hosp_chg_v GROUP BY ez_hosp_chg_v.POST_DATE, ez_hosp_chg_v.TX_FIN_CLASS, ez_hosp_chg_v.ACCT_CLASS, ez_hosp_chg_v.PRIMARY_PLAN_NAME, ez_hosp_chg_v.HOSP_ACCT_ID HAVING (((ez_hosp_chg_v.POST_DATE) Between [enter start date] And [enter end date])); I've attempted incorporating a subquery like this distinct count example, but can't get the syntax correct in my version: source: https://www.access-programmers.co.uk/forums/threads/count-unique-values-in-a-query.327614/ Any help or pointers are appreciated. -JoeRunning my 32 bit access on a 64 bit computer works, But wont let me email !
I have moved my Database from a 32 bit operating systerm to a 64 bit computer. I am Running Microsoft Access Runtime 2013 and it operates my database just fine, Except when my database goes to send a email, It creates the pdf files then I get this error [ Active X component cant create object ] Thanks for any help , Bob This is part of my email code to Outlook: Dim myitem As Object Dim myout As Object Set myout = CreateObject("Outlook.Application") Set myitem = myout.CreateItem(0) With myitem .To = strMail .Cc = Nz(DLookup("EmailCC", "tblOwnerInfo", "OwnerID = " & lngID), "") .Bcc = Nz(DLookup("EmailBCC", "tblOwnerInfo", "OwnerID = " & lngID), "") .Subject = "Your Statement/Invoice" & " from " & Nz(DLookup("[CompanyName]", "tblCompanyInfo")) .Body = strBodyMsg .Attachments.Add myfile1 If ckbTerms = True Then .Attachments.Add myfile3 End If If mytot > 0 And ckbStateOnly = False Then .Attachments.Add myfile2 End If .Send End With Set myitem = Nothing Set myout = Nothing cbOwnerName.SetFocus Case Else Exit Sub End Select ExitProc:
Block users from exporting queries and tables
First off apologies very new to access and databases in general, but I am having an issue where users can just grab my queries/tables out of my access database with excel. I'd like to know how I can prevent it. Current things I have tried. Shift bypass disabled Forced into runtime via script Split the database and encrypted the back end Saved as an accde Hidden the tables/queries No matter what else I try a user can just open excel click get data and has a free pass to copy everything. Is there anyway to stop them from pulling the tables/queries out?
Access keeps giving syntax error
Hello, I wanted to classify test results in different groups and used this formula for a calculated field in a table: IIf([Testscore1c1]>28,'Plus',IIf([Testscore1c1]>15,'I',IIf([Testscore1c1]>6,'II',IIf([Testscore1c1]>2,5,'III','IV')))) This worked (although I started with " " and had to change them to ' ' for my Dutch Access365 to accept it. The problem is that I copied this formula and wanted to use it in a different field (only changed [Testscore1c1] to [Testscore1cR] which is in the table as well. But the same formula is now giving me endless syntax errors without telling me what is wrong. I've tried everything I could think of and have spent hours searching for answers online already. Could you help me?
Query error 3141
Yesterday I started my Microsoft 365 free trial. I created a database and made a query, when i tried to save the query i got error 3141"The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect" but the spelling was correct. So i tried a new database and got the same error again when saving a query. This error happens with multiple different types of queries across multiple databases and when i download a database with a query already in it and copy the code from the already made query into a new query it still gives the error 3141 even though it works in an already made query. I assume this has something to do with my Microsoft Access. this is the query i made: SELECT * FROM ttblTraits;
Linking Access to Excel does not work
I have created a simple Access that is connected to a linked table to an Excel file as a data source. I can run the Access without any problems. It accesses the data and everything is fine. But when my colleague wants to run the Access, she gets the following error message "Microsoft Access “C:\Users\User\ [Source Path] .xlsx” is not a valid path. Please ensure that the path is entered correctly and that you are connected to the server where the file is located." We use OneDrive/SharePoint in our company and the colleague has access to the folder where the Excel and Access files are located. But it doesn't work. I think it's the path, as it seems to be local. But I don't understand why. This Access in turn serves as a source for another Excel (the target file). There it has a similar error message: ‘’Microsoft Excel [DataFormat.Error] “ [File Name] .accdb” is not a valid path. Please ensure that the path is entered correctly and that you are connected to the server where the file is located." I can open and run both the Access and the target Excel without any problems. Thanks a lot in advance. I appreciate your help a lot.The New Access Features in 2025
Hi, Yesterday, I posted two videos on my YouTube channel. They are a short version of the presentation given by the Microsoft Access team at my recent Access DevCon conference. They show a lot of new features they are working on and that are planned for the rest of the year: Breaking Access News - Signing/Monaco/SCC/Charts Breaking Access News - Zooming and Extending Form/Report Size Limits Here is my article with some more explanation: https://www.accessforever.org/post/the-new-access-features-in-2025 Servus Karl **************** Access Forever News DevCon Access-Entwickler-Konferenz AEK
