Search results

so if I'm understanding correctly, you have a textbox1 that is being populated with data from a query that you posted, and somehow (you didn't say how) you have textbox2 being populated with the same data, and you want a button that saves changes to textbox2 into textbox1. Begs the question...

it might be possible to use a checkbox on the main form, to control wether you want a "filtered" sub-form or "all" records and have the code behind the checkbox change the main forms property making it unbound and changing the source of the sub-form control, thus breaking/unreleasing the...

Not if you use the LIKE search criteria. It would go something like this, Select SomeFiels from myTableName WHERE SearchField LIKE *555-8977* If you are passing this value via a form, then replace the phone number with your forms control name, rememberiing to use the apostrophe for text...

sounds like you need a form specifically for this purpose (listing all RA's by RA #). Your form/sub-form design should be designed so that you can look at all RA's by Customer/Contact, and since you want a list of all RA's, then another different seperate form is probably your best bet. If you...

I agree with GolferGuy, though I was a bit curious about this myself. I did download the attached file and check it out - thought it might have something to do with your captions/text fields being unbound, but if that were the case, then it shouldn't preview properly either (theoretically). I...

I built a quick form/subform system out of one of my tables - and at first glance, I must have mixed up the 2 sources, because I had one based on the actual table (the sub-form) and the other I based on a grouped query that basically gave me a list of account numbers, so the sub-form would only...

You could modify your clickDate() procedure to take in the date of the clicked control, and pass the caption value to the clickDate procedure my making it say =clickDate(me.labelname.caption) Unfortunately, you will have to put the unique label name into each label, but if switching from your...

Jazz up the report export a bit Jimbot, You could change your msgbox code to open up "My Computer" to the export location for the end-user, or even add a Yes/No option for the msgbox to see if the user wants the directory opened for them... Shell PathName:="C:\WINDOWS\explorer.exe """ &...

Also, you might want to post the code you are using to modify the subforms recordsource, instead of assuming the problem is with Access. In my many years of programming, I have learned that computers usually do exactly what you tell them, and there in lies the problem ;-)

Your enabled/disabled is not changing because you're using the On_current event to set the state of the controls. Move your code to the On_click event of the check_box control. Also you can get away with shortening your code by making it say Me.query_subform_subform.Form![Order...

What I like to do - and is probably not commonly done, when I want to open a 2nd form (typically a detail form) from a starting form (usually a list type form with limited displayed data in grid type format), I use the OpenArgs argument when calling the 2nd form. Basically, in your On_Current...

Moniker, I took your suggestion and changed it a tad bit. I went and used the 2nd listbox as a source of what to delete, basically cycling through anything in that list and deleting it from list 1. For Each varItem In Me.lst_Files.ItemsSelected Me.lst_Holdings.AddItem...

I had to change the posted code to the following, For myCounter = 0 To Me.lst_Files.ListCount - 1 If Me.lst_Files.Selected(myCounter) Then Me.lst_Holdings.AddItem Item:=Me.lst_Files.ItemData(myCounter) Me.lst_Files.RemoveItem myCounter End If Next myCounter But it...

Dim varItem As Variant For Each varItem In Me.lst_Files.ItemsSelected Me.lst_Holdings.AddItem Item:=Me.lst_Files.ItemData(varItem) Next varItem The code will remove the first .ItemSelected, then stop running - I've used breakpoints to see what is happening and once it removes the first...

Moniker, Actually, I will be able to define the array size, beause what I'm trying to do is fill the array with a list of items selected in a listbox. I don't know if you have seen my discussion's in other posts on this board, but I am trying to remove multiple items from a listbox based on if...

I know there is a way to fill a single variable with multiple values, and I have been trying to find some examples of this on the web, but to no avail. What I need, in addition to filling the variable with multiple values, is the syntax for cycling trhough the values added, no matter how many...

Thanks, I've been doing this long enough for me to know what I know, and know what I don't know ;-) I still post in these and other boards/forumns when I'm stuck eventhough I've been doing this stuff for about 15 years.

I actually just received a sample database where the person sent me a bound listbox and no, RemoveItem has to be used on a value list. What you can do is create a RecordSet in VBA code and populate your listbox with the same records that are bound to the control. Then if you want to remove...

GolferGuy, I am thinking that maybe, by doing the first RemoveItem that the listbox loses all of it's selected items? That is the only thing I could think of that is happening, however, that doesn't seem correct either, but the code should cycle since the loop is initiated once on the first...

This demo isn't using a value list listbox, so I had to modify it and make the code behind form say pretty much exactly what I had already posted that my code is doing, and it did the same exact thing. Also, the code in this example is "unselecting" items that are selected, whereas I want them...