Forum Widgets
Latest Discussions
Move Existing Sharepoint Linked Database to a different Sharepoint Site
Hi. I have a Sharepoint Linked Database that is working well within our company. We would like to use it within another subsidiary company that operates with its own Name and Sharepoint sites. Could you please assist as i am struggling to do this. ThanksMulti-line Text Box misleading text and cursor display
Starting with 365 Version 2603 on 4K monitor, in a multi-line text box, typing multiple words followed by line feeds (Enter key) then moving cursor back up to previous line causes trailing characters to disappear, entering characters at the end of the line shows the new character with the cursor in front of it, and other bizarre behavior. Selecting all the text shows it is all there but trailing characters at the end of a line can disappear depending on cursor position. If I change the monitor resolution to 2K, the issue goes away. If I rollback to version 2602 the issue goes away. This is an issue with version 2603 on 4K monitors. We have many customers reporting the same issue.
Access adds brackets to text in quotes in Iif statement
I have a query of 1 short text field. If the field has the value "NOCOV" I want to return Null, otherwise I want the value in the short text field. The problem is that Access add brackets around "NOCOV" and treats it like a parameter. I enter: PRM_PreMedicare_Plan_ID: IIf([PRM Pre-Medicare Plan ID]=“NOCOV”,Null,[PRM Pre-Medicare Plan ID]) The result is: PRM_PreMedicare_Plan_ID: IIf([PRM Pre-Medicare Plan ID]=[“NOCOV”],Null,[PRM Pre-Medicare Plan ID]) It doesn't matter if I use <> or Like instead of = or Switch instead of IIf. The same problem occurs. I don't know how to prevent Access from adding brackets. I'm using Access for Office 365 Version 2603.
"File not found" error (Error 53) when opening Access database
I'm getting a "File not found" (Error 53) error when trying to open an Access database (.accdb file). The error appears during the database startup process and points to a VBA subroutine declaration line: The error message mentions "The file was not found where specified" which suggests VBA is looking for a file during project compilation, but I can't identify what file it's looking for. Has anyone encountered this issue where the same Access file works with some SQL Server backends but fails to even open with others?
Attachment.Add issue
I have the following sub routine Private Sub Command6_Click() Dim Msg As String Msg = & ",<P> Please find attached the quote you requested." Dim O As Outlook.Application Dim M As Outlook.MailItem Dim Brochure As String Set O = New Outlook.Application Set M = O.CreateItem(olMailItem) If Option1 = -1 Then OrderEntryProcedure = "File location" With M .BodyFormat = olFormatHTML .HTMLBody = Msg .To = "email" .Subject = "Test" .Attachments.Add OrderEntryProcedure .Display End With Set M = Nothing Set O = Nothing End Sub My problem is that I cannot return a null value for OrderEntryProcedure which is often the case. As far as I can tell the Attachments.Add must have a value. What type of work around exists so that I can simply not attach a file to the email if Option1 is <> than -1?
3044 error in Access
I have two computers networked Windows 10 together and have moved to two new computers windows 11. I have also moved from Microsoft 365 to 2024 office professional plus. Everything seems to work on the new computers except one Access database. That file has a front and back built in. I get a 3044 run error and the data base will not open. The error says it can not find the data base. I think in the transfer the old computer may have a different name than the new, It appears that is the problem. In the network I can see both new computers, it seems they are set up correctly but that could be a problem as well. I simply do not know how to fix it. I hope someone here may have a solution.Should be easy...... Open a form to a specific record
I have a form with rows showing individual audit for staff members. Each audit would be individualized by an Autonumber ID field. I want the user to be able to click on the ID field, have it close the form, and open another form on that specific record. Both forms are based on the same underlying table. The VBA I'm trying is the following: Private Sub ID_Click() DoCmd.OpenForm "Case_Notes", acNormal, "[ID] = " & Me!ID DoCmd.Close acForm, Me.Name, acSaveNo End Sub It does open the other form, close the form the user is clicking from, but it does not go to the ID number I click. For example, I click on ID 3, and the other form opens on ID 2. Any help would be greatly appreciated! Let me know if you have questions that I haven't clarified.Access Northwind Dev Ed - Error GetRandomPkValue
Just downloaded the newest MS Access and selected a new Northwind Dev Ed as the first DB to create. It fails to open due to an error in the code as it searched for a non existing function GetRandomPkValue... The purpose of the missing function is to return a random primary key value by passing in the variables for a query name and a field name and then it should return a "random" numerical ID from those possible based upon the passed in variables... My question is, Is the new Northwind Dev designed to fail on purpose or did I manage to download a corrupted incomplete version or???
