Search results

The new code that I got to sort've work (it's doing some funky stuff and changing the names of my clients to the ClientID value): frmClientInfo Private Sub butNewProperty_Click() If Me.Dirty Then Me.Dirty = False End If Dim stDocName As String Dim tvClientID As...

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

@CJ_London So it can only be used with Yes/No fields. That's pretty cool, even if it's very situational.

I probably won't use this, as I can see additional revenue codes being used in the future, even if I'll always want just these three codes to trigger the Closed event. I still have a couple of questions though. Your earlier code was just a simple "parent.chkClosed" to reference the check box...

The new code worked like a charm. Thanks everyone! Also good to see what I was doing wrong with my old code.

I haven't seen that case statement before, that's very cool. Instead of doing a whole bunch of if then else statements for a combo box, I can just use that.

I changed the joins, but it made no difference. The Closed field was not a yes/no field, since I was using a query to calculate if an investment was closed (1) or still open (0) based off of certain events, but I eventually just created a yes/no field in my main table to do just that.

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'm curious about what's going on here though. I'm still in the beginning stages of learning VBA, as you can probably tell. I haven't done much with integers in VBA, but is this manually entering a value for the ID field? Instead of having the autonumber generating one?

I'm dumb. I just missed putting the ID field in the original form's record source. Such a simple mistake that took me so long to find.

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

In the midst of getting a copy of the database ready, and deleting the unnecessary tables, I tried something out and it seemed to fix it. When I created the table, it was defined as a one-to-one relationship between tblRevenue and tblPropertyDetails (because not all of the information was...

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

Actually, I did get it to work, though I'm sure there may be other/better ways. I created a new query with a calculated field to put into my main query. I did this by using a nested IIF statement to give me the values that I needed. ProgressID...

Basically, I want the criteria to check to see if the Option Frame is null. If it is null, I want the criteria to be Is Null OR "1" OR "2" OR "3" OR "4". If one of the options is checked, I want it to read Like "*" & [forms]![frmMainSearch]![frameClosed] & "*". Is this possible? I was thinking...

Yup. That was it. So simple. Thank you.

I'm not sure why this is happening. I have a listbox that is displaying six fields: Client, County, Street Number, Street Name, Case Number, and Judge Name. The row source of the list box also has many other fields that are not displayed, some of which are dates. Row Source: SELECT...