User Profile
George_Hepworth
Silver Contributor
Joined Mar 07, 2018
User Widgets
Recent Discussions
Re: Attachment.Add issue
There are a few different ways to handle this. One might be: ... .Attachments.Add Iif(Option1 =-1, OrderEntryProcedure, "") ... Another might be: ... If Option1 = -1 Then OrderEntryProcedure = "File location" Else OrderEntryProcedure = "" End If Both assume that a ZLS would satisfy the requirement .Attachments.Add must have a value. As an alternative, you could wrap the line .Attachments.Add OrderEntryProcedure in a conditional and only include it when Option1 <> -1. Try those options and pick one that works in this context, or let us know if you need further refinement.Re: 3044 error in Access
You can use the Linked Table Manager to fix the path for the errant database, You'll find it under External Data on the Ribbon. One possibility is that the original link was created on a Mapped Drive, rather than the UNC path to the back end. It's always safer to rely on UNC paths for linked tables.Re: Should be easy...... Open a form to a specific record
It can be helpful to incorporate fully qualified parameters in cases like this to avoid the problem of putting parameters in the wrong position. Consider, for example: DoCmd.OpenForm formName:="frmYourFormNameGoesHere", view:=acNormal, FilterName:="SavedFilterNameGoesHere", WhereCondition:="ID= " & LngValue, datamode:=acFormEdit, WindowMode:=acDialog, OpenArgs:=lngAnotherValueIDRe: Microsoft Access and Outlook
Your new laptop now has "New" Outlook, which no longer supports COM automation--in this case the ability to automate sending emails. The solutions available include rolling back to "Classic" Outlook, and developing a different approach to automating the sending of emails from Access. https://www.accessforever.org/post/new-outlook-the-situation-in-december-2024Re: Database in an "inconsistent state" and other errors
Access is telling you the truth. This particular accdb has been corrupted and is no longer usable. The alternatives are trying to find a repair service which you can pay to recover as much of it as possible, or going back to the last previous working backup copy. Depending on what is in that database, the cost of a repair service might not be justifiable. If you decide to try that approach, check out https://www.everythingaccess.com/accessdatabaserepair_info.asp Since you indicate that the most recent backup you have is also corrupted, you may have to go back to an even earlier saved backup, or perhaps it can be used to recover the objects that are not corrupted. Create a new empty accdb and try to import the tables, forms, reports, etc. from that partially working accdb. After each import check to see if is okay at that point, then proceed to the next. When you get to the point where an imported object doesn't work, or fails to import at all, you'll know where the corruption is. Good luck with the recovery.Re: Access SQL Syntax Highlighting, Autocomplete, and Formatting
Here's the key: " ... there is a checkbox for the Monaco query editor in Access on my laptop, but not my desktop." The Monaco query editor is actually the feature that supports enhancements to the SQL editor. If you do not even have the checkbox to enable Monaco SQL Editor available in the version of Access on your computer, that would probably indicate it is actually an older version of Access, not M365. If it is there, check it to enable Monaco. Can you verify the version of Access on both in case you don't see the option for Monaco? You'll find it under File-Account.Re: You must start microsoft access by double click
Apparently, the trial version of Microsoft 365 which you installed does not include MS Access. The version of Access on that computer is NOT the full version. It is the runtime version only. The runtime version only allows you to open existing accdb (Access database) files. It doesn't allow you to create or modify databases.Re: Access Abfrage Schaltfläche Ausführen! deaktiviert
If you are talking about the disabled option to "Run Selected" as shown in your screenshot, then you should know that it applies in SQL view, not in the QBE view. It is part of the Monaco SQL Editor. It allows you to select part of a query and run only that part, not the whole query. If you are saying that the button itself, and not just the option below it, is disabled, that is a different matter.Re: Troubleshooting Queries in Access
We don't have enough information to know what the problem could be. Why are you deleting old tables at all? Why are you then importing "new data for these tables"? Does that mean you are actually re-creating those same tables with new data? Why not delete the data from those tables and simply reimport new data? In fact, deleting data is probably not something we'd normally expect to see anyway, so please elaborate on the business purpose being supported. SHOW us the query that is expected to populate the table. What table would that be, by the way? Is it one of the ones being deleted and re-created? Or a different table? What data is being used for this repopulation? We need to see the SQL from this query, not a screenshot of the query design view. Once we have a better picture of what's going on, we can offer useful suggestions.Re: Access Query Finding Old/Deleted Data
What does it mean to say that you uploaded a new version of the "Medical Department and Chair" table to override the existing version? Uploaded to where? Again, I am not sure that you actually replaced the table as it is used in the current database. To repeat, please describe, step-by-step how you did that. It does appear that you have a split database, with a Front End (FE) accdb contains the interface and logic objects and a Back End (BE) accdb containing only tables. That's good. The problem appears to be that the link from the FE to the table in the BE was not changed when you "uploaded" a new version of that table to the BE. That implies a) the new table is there in the BE in addition to the old table and that b) the process did not include changing the link to that table. That's why I want to see a screenshot of the Navigation Pane showing all of the tables, please.Re: Impossible d'installer Windows 10 22h2
Unfortunately, you posted your Windows Installation question in a forum for support of the MS Access application, which is used to create relational databases. Please repost your question in a forum that supports Windows Installation to get the attention of people who can provide pertinent suggestions.Re: Access Query Finding Old/Deleted Data
Please explain what you mean by "replacing outdated tables". Please describe, step-by-step how you did that. Queries can only retrieve data from tables when the tables are available, so that old data does exist and that implies the original tables are still available, not replaced. It would be very helpful to see a screenshot of your navigation pane showing ALL of the tables in the accdb. Thank you for helping us help you.Re: Access Not Responding
Unfortunately, it's very hard to guess what the problem in this particular situation could be, based only on knowing that Access stops responding. In order to help us help you, provide a step-by-step description of what you have to do to produce the error. Include information about the version of Access and about the version of SQL Server involved. The more detail you provide, the better the chances are that someone will recognize potential problems in your environment and procedures.Re: Access
We need more context to attempt suggestions for you. Please give us a step by step description of those situations when data is saved. Please also give us a step by step description of those situations when data is not saved. However, start by telling us about the version of Access you are using. We also need to know how long this problem has existed. Did it appear as soon as you created a new database? Now that I think about it, did you create this database yourself or did someone else create it for you? Also describe any errors that occur when you try to save new records. The more details you provide, the better our ability to offer useful suggestions. Thank you.Re: VBA
Thank you for the clarifying screenshots. The middle screenshot does suggest that you are trying to instantiate a template, rather than create a new accdb from scratch. That doesn't follow from the statement that you tried to create a new database, and the 3rd screenshot looks like it would be a newly created database. There's something really wrong. That does indeed indicate a problem with your Access installation, as Richard said. Reinstall Access and see if that clears the problem.Re: VBA
That error is usually the result of corruption in an accdb. You should not see it when trying to create a new database accdb. So, there is something definitely off in the process you are experiencing. Please explain how you go about creating a new file. Are you saying that you start Access, Select File and then New here? Or do you use a different method? Please be as specific as possible. Show us screenshots, if possible, along the way.Re: Adding sub form for a new year
This question sounds a whole lot like this previous question: https://techcommunity.microsoft.com/discussions/access/adding-sub-form-for-a-new-year/4449332 Rather than start off down a parallel path, please confirm whether you are working on the same project as viclea8. The answers being provided in that discussion address the underlying problem, including solid recommendations on how to correct the invalid table design itself.
