Search results

I was not aware of that. I guess that's the danger with taking code from the internet and not 100% understanding it. I think I have resolved the issue(s). The recordsource for Four_Wire_Test had a requirement that the part serial number entered also be in the "NOx Inventory" table. However...

I believe it initially says it is waiting for the program to respond and then realizes it has crashed and attempts to recover. There isn't much of a delay, but the VBA code running before it.

Yes, "Four_Wire_Test" is the name of the form Good question! My SQL is not that strong, but here is the record source for the form: SELECT FourWire.Serial, FourWire.BlkBlu, FourWire.OrgBlu, FourWire.BlkOrg, FourWire.EEPROMRh, FourWire.AmbientTemp, FourWire.Factor, EOL_Data.RH_Target FROM ([NOx...

I am having a serious issue with some of my VBA code in my Access front end. It links to a SQL database. Here is my code: Private Sub New_Record_Click() Dim MySerial As String Dim rsCriteria As String Dim db As DAO.Database Dim rs As DAO.Recordset Dim Feedback Set db =...

Thank you very much gblack! I just started with a PassThrough Query in Access (haven't done a VBA version yet). I was able to adopt the code slight to give me exactly what I needed! Passthrough was not a feature I was familiar with. Infact, it is faster than the excel code I posted earlier. Here...

So my first step was to get rid of the line continuations and break it into the SELECT, FROM, & WHERE statements. SELECT AL1.PRP_BEZ, AL1.PRP_VAR, AL1.PRP_VER, AL1.RUN_DATE, AL1.RUNID, AL3.MRK_NUM_EXT, AL3.MRK_BEZ, AL3.MRK_WERT, "AL3.MRK_EINHEIT, AL3.MRK_EIN_GUT, AL2.MRK_TXT...

Hello. I am working with an Oracle database which I have linked to in access using the ODBC drivers. I have an excel sheet which is currently working to dump the data needed. Here is the critical part of the code in the excel sheet that I have: With ActiveSheet.ListObjects.Add(SourceType:=0...

I have solved the issue. It is a bit odd though that this occurred only after splitting the database. I had to add: DoCmd.RunCommand acCmdSaveRecordOther than that nothing was wrong with my original code. For some reason the code would not see the newly attached text file unless I saved the...

It appears some other people have struggled with this code, but no solutions that I have found: http://www.utteraccess.com/forum/Code-handle-attachment-t-t1954563.html http://www.tek-tips.com/viewthread.cfm?qid=1703840 Any ideas?

Now I can post links! Here's the original source for the code: http://blogs.office.com/b/microsoft-access/archive/2007/08/30/using-vba-code-to-open-a-file-stored-in-the-new-access-2007-attachment-field.aspx

I also tried: strFilePath = strTempDir & rstCurrent.Fields("strFieldName").Value and got Run-time error '3265': Item not found in collection.

If Right(strTempDir, 1) <> "\" Then strTempDir = strTempDir & "\" ' Make sure the path always ends with a backslash. 'Set rstChild = rstCurrent.Fields(strFieldName).Value ' the .Value for a complex field returns the underlying recordset. 'strFilePath = strTempDir &...

My database was working fine until I split the database and now I'm having issues with this function: Public Function OpenFirstAttachmentAsTempFile(ByRef rstCurrent As DAO.Recordset, ByVal strFieldName As String) As String Dim rstChild As DAO.Recordset2 Dim fldAttach As DAO.Field2...

I had to add this to make the code work: 'Remove trailing comma. Add field name, IN operator, and brackets. lngLen = Len(strWhere) - 1 If lngLen > 0 Then strWhere = "[NOx Inventory].[Serial #] IN (" & Left$(strWhere, lngLen) & ")" End If

I did. I tried it both. I then removed all of my old version of the code as seen above and replaced it with the code from that webpage. I was getting a different error, but then stumbled upon what might have been another one of my issues. I did not understand that a report has its own query...

Most definately. And wow is that code MUCH more efficient than what I am using....I think I will do some major stripping of the code once I get it going. Stuck with an error right now though, I'm sure it's a minor one about the handling of my text variable (not a number). Here's the exact code...

I am now understanding this a little better. It seems that by using the DoCmd.OpenReport I can send the "WHERE" part of the SQL function to my existing query. The entire "WHERE......" line in my query can be deleted as I will send it from the DoCmd.OpenReport command. For instance, here is what...

Here was the query I was trying to post: SELECT [NOx Inventory].[CQTS Event], [NOx Inventory].[CQTS Sequence], [NGK Tracking].[NGK Report].FileName, [NOx Inventory].Customer, [8D Tracking].[CQTS Updated Date], [8D Tracking].[C3 Status], [8D Tracking].[C4 Status], [8D Tracking].Comments...

To be honest, I don't really understand how to use that section of the code. I copied that from the same website that provided the "myInList" routine. The part where I get lost is after I am able to display the list of selected values separated by comma's in a message box. :banghead: If I went...

Multiple Selection List - Comma Separated String - Run Query & Create Report I've been battling this for a couple days now and I'm stumped/overwhelmed. My SQL experience isn't great. I've been doing a lot of VBA programming though. I'm using Access 2007. So far I have a Multi Select enabled...