Search results

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...

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...

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...

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...

I think I'm finally at a point that I can roll out my first database. I put in error handling and think I've discovered a majority of the errors/quirks that my database can run into. I'm expecting these next couple of weeks to be the beta stage and fixing any other errors or weird things that...

I feel like I got this working, but I also feel like I went on a roundabout way to do it, using more code than I need to. Currently I have cboCounty updating and filtering cboJudgeName when a county is selected. This part works fine. For reference, here's that code: Public Sub...

I want to change the backcolor and fontweight properties of a listbox depending on if it's displaying a record or not, but I'm getting a mismatch error. What should I set my variable as if I'm trying to manipulate these properties? Private Sub Form_Current() Dim stBackColor As String...

I'm having trouble with figuring out how to check if a column in a listbox is null or not. Private Sub butOpenServiceChart_Click() If gEnableErrorHandling Then On Error GoTo Errhandle Dim stDocName As String Dim stQTRecord As String stDocName = "frmServiceChart"...

Is there a way I can improve this error handling or do I not really need much else for such simple procedures? Private Sub butNewProperty_Click() If gEnableErrorHandling Then On Error GoTo Errhandle If Me.Dirty Then Me.Dirty = False End If DoCmd.OpenForm...

Crosspost that went unanswered on another forum, so I thought I would pick your all's brain a little bit. Just wanting some input on the best way to go about designing my homescreen form. Right now I have it so that all my navigation buttons are on the left with multiple list boxes in the body...

I keep getting the "Control can't be edited, it is bound to an Autonumber field" error whenever I try to link a PropertyID to a new case. I have a main form where I'm creating a new case for my Quiet Title table (tblQuietTitle). The user inputs the new case number and assigns an attorney and...

I have two sub reports in a main report. One sub report is for different sources of revenue and the other sub report is different sources of expenses for any given investment fund. So for example: Republic Holdings, LLC Revenue Sub Report Rent Income: $ 4,800.00 Sold Income...

Can I use tempvar to carry on a value from one form to another? For instance, I have a form called frmClients, where the Client name is displayed from a combo box bound to the ClientID. I want to carry that ClientID value to another field in my next form. To give you an example of what I'm...

Perhaps it's just me, since this is my first database building project... Ever come to your Relationship window and just can't help but to admire it every now and then? Looking at how all the data connects and interacts with each other with all the one-to-many, many-to-one, and many-to-many...

I'm trying to update a checkbox in a parent form based off a combobox in subform. Does this code make sense? It's giving me a 2465 run-time error: Microsoft Access can't find the field '|1' referred to in your expression. What am I missing? Private Sub cboRevenueTypeCode_AfterUpdate()...

I can't edit this decently simple query and I don't understand why. Can you just not edit a query that has a subquery in it? Is it as simple as that? According to http://allenbrowne.com/ser-61.html, as long as the subquery isn't in the SELECT clause, then everything should be good. SELECT...

I realize this may not be the best way to go about this, but here is my situation... I have a Client Information form with a combo box for the client name, as well as other generic information text fields. If I want to add a new client, it's my understanding that I can't type in a new client...

I know this answer is going to be simple, but I can't seem to figure out the root cause of this error message: The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields...

I just noticed that when I open frmServiceChart from another form, frmMainSearch, that the search box in frmServiceChart no longer works. When I open up frmServiceChart from the Navigation Pane, it works as intended. The code for opening up frmServiceChart from frmMainSearch is as follows...