Search results

Great idea. Why didn't I think of that? :o

If I have an excel worksheet and want to pass a boolean variable from the worksheet to Access, is this possible?

DOH! That was pretty simple. :o Thanks Baldy.

Great explanation! That helps quite alot! I can't think of ever having read a better explanation of the counter concept in a 'real life' situation. One last question to get me past this stupid list box thing. How the heck do you select all items in a list box programmatically?

Good stuff Baldy. Thank you. So help me understand... i often have trouble with counters. Why am I subtracting 1 rather than adding 1 to y? If I want it to find the number of items in the box first, then start from 0 and add each item to the criteria string, why am I subtracting 1 instead of...

I've seen plenty of posts that tell me how to enumerate selected list box items, but none that advise on enumerating the bound column for ALL items in a list box. Access VBA help says "You can use the ListCount property to determine the number of rows in the list box, and then use the ItemData...

Thanks Shades! I wound up having to copy a blank cell from another workbook into all the cells in that column, and then enter the formula and reapply the formatting I had on those cells. This happened to me once before. I still haven't quite figured out why it happens, but it seems the only...

Thanks a ton! It works, but there's one more problem... it only works in a new workbook, not the one I want it to work in. The one I need it to work in displays the actual formula text instead of the result of the formula. Any ideas?

Hello all, I am trying to write a conditional formula that will insert certain text in a cell if one or more of four other cells have a value in them. Below is my formula that's not working. I've tried several variations, none have worked. If anyone can help, I'd appreciate it. What I want...

Great suggestion. I checked another DB and it's fine. So I went back to the non-working one and exported the form I was working on to a new DB. Once I took that form out, the code started breaking again, so there's something in that particular form that's causing the debugger to not listen to...

Hi folks, all of a sudden, my vba editor is not breaking at any breakpoints I put into it. It won't even break on CTRL+BREAK. I've compacted/repaired and even put breakpoints on the very first line of code in several different procedure to see if maybe it was a condition causing the problem...

You could use a lookup query (info on this found easily in Help or online) as your recordsource for the form, but personally, I think the best way to populate fields in a form based on a user entered search value is by using the recordset object. You'll also want to be sure you have a...

PS - I should clarify that the current stSQL string isn't right because the list box's rowsource is not static, i.e. it changes each time the form is loaded. THAT's where I'm having the trouble. I need to build the other form's recordsource based on the listbox rowsource each time the list box...

Thanks for your feedback. The requery thing is just an extra that probably isn't needed but is there for added security. iTID isn't the list box. It's a global variable used to identify the currenlty active ticket number throughout the program while it's being created or edited. The problem...

This is probably simple, but I'm stuck. I have a Form1.ListBox 1 on Form1 that contains several rows of data from TableA. On the OnClick event of a button on Form1, I need to refresh Form2.Recordsource (a different form) to contain only the items in Form1.ListBox1, but from a different table -...

Does anyone know what is considered to determine the order a loop will run in when it loops through controls on a form? For example, if I am looping through all controls on a form, will it loop through in alphabetical order of the names of the controls, or will it first loop through by control...

You'll want to use the transfer spreadsheet method. An example is shown below. Be sure that all of the fields in your table match the data types of the fields in your Excel files, or you will get errors. Also, this code requires a reference to Windows Script Host Object Model Function...

I've finally begun to understand arrays but am still only 1 day old with them. I got one to work in my code, but have a couple questions I hope you VBA buffs can help me with. 1. The MSDN website has a help page discussing a Binary Search Function for arrays that is similar to the array text...

Hi Everyone! In Excel VBA, and ONLY on my laptop at work, I get run-time messages that say "Code Execution Has Been Interrupted" just as if I hit CTRL + BREAK. I have NOT hit break and this only happens on my laptop at work. The same exact program will run perfectly on any other machine but...

I have a piece of code that sets a variable as the following to set up a file name: variable = y & ".mdb" The variable is being returned as: DaVinci_Request_B_Database_BER_FE.mdb" Notice the quotation at the end. I'm stumped! What the heck!!! Can anyone suggest anything that would get...