Search results

After trying your recommendation, I am now getting the following error: Invalid SQL statement; expected 'DELETE', 'INSERT', PROCEDURE', SELECT, or 'UPDATE' I appreciate your help, but after a little more thought on this, I've decided to scrap this portion of my database and attack it in a...

I keep the the above error when running the following query DELETE db_TempAddEquipmentToTicket.TicketID, db_TempAddEquipmentToTicket.EquipmentID, db_TempAddEquipmentToTicket.EquipmentCategory, db_TempAddEquipmentToTicket.Equipment, db_TempAddEquipmentToTicket.EquipmentName...

so while copying everything over to a local database I noticed <DIV> tags on the string in question <DIV>This is a reminder that your Server and Kiosk maintenance is scheduled for </DIV> I removed the DIV tags and it works how its supposed to The form that field is entered on is a Rich Text...

all came back with 0 for both 10 and 13

Here is the full code Private Sub MxEmail_Click() Dim srs As Recordset 'Schedule Records Dim ers As Recordset 'Email Recordset Dim drs As Recordset 'Maintenance Date Recordset Dim smx As String 'Scheduled Maintenance day Dim mdy As String 'Maintenance...

If I change the fields from "Rich Text" to "Plain Text" the issue goes away as its only 1 line, but if I try to add any additional lines to the nmt field, it still combines it all as 1 line. Its almost like the Rich Text and Plain Text fields are broken

That works just fine as it should so the "nms" content is the next line down, however the beginning content should only be on 1 line. This is a reminder that your Server and Kiosk maintenance is scheduled for Friday 07/17 at 11:00:00 AM CST. The maintenance typically takes about 30 minutes...

I have a bit of code that searches through some records and generates emails based off of the results, but for some reason, when the email is generated, it is adding a carriage return or something that is making txt drop to the next line and I can't seem to figure it out. Here is the bit of...

Actually I just realized i'm the only one can enable/disable the navigation pane via the code and I was setting this up on a laptop with a lower resolution than my screens so it won't be an issue for me. However, I would still like to know if it is possible to determine if the Navigation Pane...

I have the navigation pane set to be closed via the Access Options, however there are occasions when I need to use so have I have code to enable /disable it as needed which works fine. This issue i'm running into is when the navigation pane is active, my forms shift to the right and I can no...

same thing, it opens in front then jumps behind Private Sub Issue_DblClick(Cancel As Integer) DoCmd.OpenForm "FacilityTicketDetails", , , "[TicketID] = " & Me.[TicketID], , , "SearchResults" Forms!FacilityTicketDetails.SetFocus End Sub funny thing is if I set it to run on the single...

I have this same line of code on the double click event for 3 different fields on my form. 2 out of the 3 opens the form correctly when I double click on them, however when I double click on the last field, the form opens behind instead of in front. The only difference between them is the 3rd...

So while looking around on the web, I came across an article that says if you are returning Unique values, this can cause Long Text fields to truncate. I did have Unique Values set to Yes, changed it to No and now it is bringing everything over.

Actually I am wrong on the above, sorry about that. I edited the first post My query runs regardless of the results, as stated before its a Make Table Query and copies over several fields from a few different tables into the one table, however it cuts that one field short

I have a table in a SQL backend with a column set as nvarchar(MAX) that has a string of characters that is 402 in length. I have a query that runs to create a new local table on the access front end and copy the specific info in it, however for some reason it is only copying over the first 255...

Previously I was able to generate a few emails using the code below, and when I would click the Send button, they would send without needing to open Outlook. 'Starts email Set oOutlook = CreateObject("Outlook.application") Set oEmailItem =...

Wow, so I thought I did that but it kept saying Expected: list separator or ), turns out I wasn't putting the first quote on there and only had & '" Thanks again !!

Since the first issue was resolved, I started a 2nd thread. Please feel free to merge the two if warranted I would like to group the emails per facility,i.e. Facility 1 - Test@email.com; Test2@email.com Facility 3 - Test3@email.com; Test4@email.com; Test5@email.com so I setup the following...

Never mind, it was because the file is on my network storage and I am running it from a shortcut on my laptop. I enabled Trust Network Locations on the DB itself and its now working. Guess Microsoft Updates changed my security settings.

I have a database that I made to track my finances, however when I launch it today, I am getting the "Operation must use an updatable query error", with code 2950. Is anyone else getting this error with Access 365 or ave any suggestions?