Search results

Thanks for the replies guys, that's what I was thinking. I was kind of approaching this in the wrong way, almost have the problem fixed now.

If I understand correctly from what I just looked up, Me.Dirty checks to see if any changes have been made. I have a form that has text boxes and combo boxes (that I've changed both) and me.dirty still comes back false. Although, the code is under Form_Unload. Would that affect if it comes...

Thanks for the help guys, got it working. Gemma, thanks for the explanation!

How would that work? I'm still not completely sure I understand how InStr works, even after looking at the definition of it. EDIT: The thing is what I'm trying to grab right of the comma I'm never going to know how many characters it is, it's always going to be different.

I've found a lot of stuff for getting what's on the left side of a comma, but I'm trying to grab what's on the right side. I found the following for getting the left side: Left(Me.Employee, InStr(Me.Employee, ",") - 1) Can I do the same with Right? Using -1 (and other numbers) I still kept...

Yeah, it's an integer. Tried IsEmpty too and that doesn't catch it either.

I have a piece of code that says: If IsNull(Me.lstClientInvestments.Column(8, SelectedItem)) Then EntityToPass = 0 Else For some reason though, on entries that I KNOW the value is null and should run this code it doesn't. Then it skips to this line and I get a type mismatch...

Found a fix. Setting focus on an object on the main form and then running the code works.

Currently we have a function: Function GotoClientTab() On Error GoTo GotoClientTab_Err DoCmd.BrowseTo acForm, "subfrmClient", "", "", "", 1 GotoClientTab_Exit: Exit Function GotoClientTab_Err: MsgBox Error$ Resume GotoClientTab_Exit End Function When you...

Yeah I know, I was just making an observation. I thought that maybe it would.

I'll try that and post back on the results. EDIT: It worked, but there's not real noticeable difference in speed. Thanks for the help!

While it seems simple enough to right click and select small to large, low to high etc., is there a way to code a double click event that sorts the form? For example, they double click on the header and in the code I run something that sorts by that column. Is there a simpler way to do...

If I want to make the font color red (forecolor) red if the value of the text box is a negative number, what's the VB Code? I tried If text.value < 0 Then text.forecolor = vbRed . . . that makes the whole box highlight red. Is there a way to make JUST the font turn a color? If so, what's...

Recently imported some forms into Access 2010 from the old version of the program we're updating, the old version was made in Access 2003. A macro was present in the old version that didn't import in, but it still tries to run it but I cannot find where it is actually being called. Also...

Thanks for the code! That seems to be working when the page first loads. Now, if I refresh the page, how can I get that code to run again? On current? EDIT: On current doesn't work. Is it possible to run Form_Load() from anywhere on the top form? EDIT EDIT: For some reason that code...

Yeah, the problem I encountered yesterday is with List Boxes, I would use list count to determine how many records there were and resize accordingly. With this it doesn't look like I can do record count. If it's a contiguous from, what's the code for getting the record count? Like for list...

Is there a way to make these resize on their own based on the number of records? Auto Resize is set to yes. Also, it's a subform. Basically, I just need it to resize on it's own so there's only one scroll bar (it's a tab on a Navigation Form).

Would someone be able to run a program with an Access FE and BE on either of these tablets; Acer Iconia Samsung Galaxy If not, what is a similar tablet that they would be able to run it on? Thanks in advance. I apologize if this is the wrong area to post this type of question but I figured...

In the query I have, I have a couple columns that are formatted to standard and percent, but when I set the record source in the list box: SELECT [qryInvestmentsofAdvisor].[ClientID], [qryInvestmentsofAdvisor].[AssetLiabilityID], [qryInvestmentsofAdvisor].[ClientName]...

So I have one table that has all Client assets. One category is Investments. One tab on the navigation form is Investments, and it will pull all the information on Investments under a certain advisor. The query that runs basically says get all the investments for the currently selected...