Search results

I get what you're saying. I have no background in computer programming, save for the few bouts where I took some online class or another, so I'm no where near the level of being able to create complex code. That said, I take the time to understand every bit of code I put into my front end so...

@The_Doc_Man From the page that Markk linked: There is the option to not list the fields you're going to insert, at least in Access. However, I did add that into my SQL and it gives me the same syntax error (then lists the entire SQL statement). My SQL currently looks like: strSQL = ""...

Sadly, it just gave me the exact same error message that it gave me in VBA. When Access writes SQL based off queries, it's a little wonky and uses a lot of parenthesis when there are many joins. Could this be why it's not accepting my SQL in VBA?

OR, at least in Access, if the field names in the query exactly match the field name in the table that they're going to. If the above is best practice, I can certainly start doing that, but I don't think that's causing the issues here. I tested this part of the query: strSQL = ""...

I'm trying to write some SQL code from VBA to populate a table. This is what I have so far: Private Sub butTest_Click() Dim strSQL As String Dim strTable As String 'clear tblSEoSMergeList strTable = "tblSEoSMergeList" strSQL = "DELETE tblSEoSMergeList.* FROM...

@The_Doc_Man I'm not quite sure what you mean by domain environment. The front end is located on my machine and the backend is on a local server. I don't know what security is in place on the local server, but I do know as of right now, the only way to access it is through one of these...

Just to put this into context, the reason why I went the exported text file way was because I was having problems with using Mail Merge based off a form with parameters on a split database. Exporting the query to a text file resolved the issue, though I suspect using a table might also work...

This is the code I was using for a different mail merge: Private Sub butCreateSEoS_Click() 'Code source credit to: http://stackoverflow.com/questions/3905580/mail-merge-started-by-vba-in-access-let-word-open-database-again Dim pathMergeTemplate As String Dim strSQL As String...

So what would that look like? I'm still trying to wrap my head around all the new vba code I'm learning about that goes into to automating the word merge/mailmerge process. It sounds like I need code to 1) run a query that will append/insert values into a table (should this table already be...

Ok, so I can use an INSERT INTO query for the table, which I can then export to a text file and use for the word merge.

I created a user-defined function to create a string in a query to show a list of defendants in a single field. I'm then exporting the query to a text file to use for a word merge. The problem is that the string (strDefList) can be quite long and gets truncated when it gets exported. The string...

So, because I can't seem to get Word Merge to work on a query with parameters, I want to be able to run the query I need (with parameters) and then temporarily store that data in a table for me to base the Word Merge off of. So, In VBA, I want to set a button to run a query and then enter the...

@Galaxoim, I noticed. Though, that's fine. Access seems to have its own way of writing SQL, so it doesn't seem like it would help much in learning SQL in an applicable way if I want to move beyond Access.

It's called something else, "CompanyName_FE.accdb", so I never understood why it was referring to "Access.mbd" to begin with. And yes. You have to click on the data source (in my case, a query) to start the word merge. When I use Word Merge on an unsplit database, it work fine. For whatever...

I keep getting an "ODBC Microsoft Access Driver Login Failed" error when I try to use the Word Merge function in Access 2010. I can get it to work after a bunch of steps when I do the merge through Word, but I want this to be an easy, automated process in Access for the end user. Is this because...

Ok. Seeing that and how it relates to my data specifically helped make a lot of things click. Thank you.

Ok. So it's not just that I'm dumb, the code is also wonky. Good to know. So how should that be written out? How do you join multiple tables to one table? Would it be something like... FROM tblPropertyDetails LEFT JOIN (tblQuietTitle_PropertyDetails LEFT JOIN (tblQuietTitle INNER JOIN...

I'm trying to get a better grasp of SQL and JOINS. One of the things I'm doing to help the process is looking at queries I've created in SQL view, and I'm a bit confused at how Access is writing the JOINS. I have 5 tables: tblPropertyDetails tblQuietTitle_PropertyDetails tblQuietTitle...

Hello! I know I personally would love to see a more in depth look at how to perform word merges. Maybe I'm not searching well enough, but there doesn't seem to be a whole lot out there on how to build a template and assign which records (whether it's just one, selecting specific multiple ones...

Ok. So there isn't really a better practice for this sort of thing? I actually started with what you said, with the mindset of resetting the query after the filter has served its purpose, but then I figured that would happen automatically by putting it on the GoToRecord After Update event. This...