Search results

I know file system object properties code, but I'm over-complicating how to search a file name for a string. For example, I want to find all files in C:\MyFolder that contain "ABC" in the file name. Like I said, I'm overcomplicating this. Brain fried today so any help on what's probably...

In 2007 when I want to refresh an external data link to an Access DB, 2007 won't allow me to if the database is open, even if nothing is open in design view or in the code window. I do not have the DB set to open exclusively. Because of this I'm having difficulty automating automated external...

Anyone know why "99.5 Mod 10" would return 0? I'm using Access VBA 2007 and Mod doesn't seem to be working right. Data types being used are currency although I did try changing the variable data type to see if it would make a difference. Try the code below like this -...

OK. I'm totally embarrassed to be asking this b/c I'm quite an advanced Access developer, but 2007 has me stumped on something really simple. I'm developing my first db in 07 and have tried everything from help searches to msdn to googling. How the HECK do I resize a form window in 2007 and...

I searched help and this forum to no avail. Anyone know the code to initialize the attachment manager in Access 2007? Also, anyone have any suggestions for testing the file sizes of the attachments users are adding? For example, if I want to test that the file(s) attached are no more than 3...

I have code behind a form that looks for missing data. When it finds missing data in the recordset, it finds the record on the form that matches the record ID in the recordset. It has worked fine until now. Nothing has really changed but all of a sudden I'm getting error # 2137 "You can't use...

Hi everyone, I'd like to use an array to store a list of names. Then I would like to search the array to see if my name is the last value in the array. In essence, I need to determine if the person currently filling out this form is the last person in a list of names stored in an array. Make...

Something's been occurring recently that has me stumped and I want to know if anyone else have ever experienced this when programming Access. I'll be using the debugger to step through code and it will do just fine for hours. Then all of a sudden, without having changed anything in my code...

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

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

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

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

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

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

Does anyone know if there's a true/false property that can be returned if a table is linked? For example, I have a loop going through my AllTables and want it to do 'something' if the table is a linked one. I just need to know who to determine whether it's linked or not. Can't seem to locate...

:eek: Hey all, I've been using this SetProperties code successfully in databases for some time now. I added it to another database but all of a sudden I'm getting "property not found" error on the line 'dbs.properties(strPropName)=varPropValue There is a trap in there (see full function...

Hello everyone! Does anyone have any code snippets that will pull up the outlook address book from an access form and insert the selected contact(s) into the "To" text box I have on my form? Any help appreciated!!! :D