Search results

Hello All, I have a bit of code that generates the following error: Run-time error '-2147417856 (80010100)': Method 'CopyFromRecordset' of object 'Range' failed. Here is a piece of the code: With rsEMP .MoveFirst If !EmpID = 1 Then...

Thank you for that information. I ran a query and saw the information is not being organized according to the table. I guess I was wrong in assuming it would be, thank you! I will work at it and try to get things in order.

Hello All, I have the following code: techid = Forms!Main!txtCurrentUserID Task = 2 note = "Work Instructions" strSQL = "SELECT *" strSQL = strSQL & "FROM [tblTracking] " strSQL = strSQL & "WHERE ([EmpID]=" & techid & ");" Set rs = CurrentDb.OpenRecordset(strSQL)...

Wow that code seems to be more than I need Galaxiom, I don't even know where to start! I will look more into it and see how it works, thanks!

That sounds like quite the cumbersome task Brianwarnock!

That code will find a similar string if the variance is at the end, like such: Entered text: 123 St Similar string found: 123 Street But for difference in the middle of the string, such as: Entered text: 123 East Street Similar string: 123 Easy Street The code passes over that similar sting...

Thanks Galaxiom, but that doesn't seem to be working for my needs. Right now, I am testing that code with input 1650 E. Clark, and it is saying there are no results when there is a record named 1650 E. Clarke.....

Thank you for the information, I'm not sure if this will help with my situation since this is a data entry form and its not a combo or list box with values, but I will see if the ideas in that link provide some further insight, thanks!

Hello all, I am trying to write some code to search for similar strings. I am creating a database with records that all contain street addresses. These addresses may have more than one record attached to it, and we would like for folders to be created containing the records with similar...

So I found a link that seems to be the direction I want to go, as namliam pointed out, attachments seem relatively "simple" to add into your code: http://www.access-programmers.co.uk/forums/showthread.php?t=263084&highlight=email+hyperlinks+as+attachments I will post back when I find the right...

Ok so within typical fashion of posting my problems on the web, I was able to find a solution moments after haha. So in regards to selecting the auto feeder over the glass, I added this piece of code in: dev.Properties.Item("3088").Value = 1 So that problem is solved, but I still wonder if...

Hello all, I have some code set up to automate scanning from access to a specific folder on the server. I have searched the web for different codes and have not come across anything that will scan an unknown amount of documents. The best I found was the code I am currently using, that will...

True, but the attachments I need to add are not in the database, and they will be different each time, so it is not very efficient to add attachments that way I believe...

Hello all, I have a database which has several records with at least 5 documents needing to be attached to each record. Using attachments or OLE would cause considerable bloat, so I opted for hyperlink fields for all the document types necessary to save with each record. However, now I am...

Thank you for the link, but the information did not help with my specific issue. I basically set up another template with the Workbook_BeforeSave sub, so when all the information transfers from the main document to the template, it can only be saved by the user to the predetermined location...

I am wondering if there is a way to disable the "saveas" in excel from access with vba? I have the following code: Private Sub cmdReport_Click() Dim path As String Dim XL As Object Dim oBook As Excel.Workbook Dim pic As Excel.Shape Set XL = CreateObject("Excel.Application") If...

My goodness pbaldy I've been trying to figure out what the issue is for over an hour and in less than 5 minutes of making this post, my issues are gone! Thank you so much for your help, and for the link to that great site!

Huh, I was under the assumption that since a lot of the code was between the "With XL.Application" code, it was assigning the correct variable to the rest of the code. I will try that suggestion, thank you much!

I have the following code, which works the way I want it to when I click the button the first time. However, if I close out the excel and click the button again, it errors at the line "ActiveWorkbook.Worksheets("Ref").UnProtect", with the message "Run-time error '91', Object variable or With...

Thank you so much for that detailed explanation! I will look it over and report back!