Search results

Hello- I need help tweaking this criteria. I have a form with a combo box with 3 options. Once the user has selected this parameter, they proceed to enter text in the search box and click a search button. I also have a list box displaying results. Obviosuly the query behind the list box is...

I know how to export a query to a new Excel Wkbk via vba, but does anyone know how I can easily insert the new sheet directly into an existing workbook?

Gentlemen, When I use a function which contains debug.print in the Immediate Window it produces a string of characters i.e. 3 yrs, 1.15% 5 yrs, 1.65% How I translate this to a message box? Or even one step further into the body of an email via my .body = [some vba code]. Please advise...

When all else fails there is always Access World.... So, I have a ListBox that returns a different number of instances depending on which "account" I am working on. Example: Tenor Spread COF 5 1.58% 2.15% 7 2.81% 2.74% 10 2.57% 3.33% It could be anywhere...

My database was working fine until this morning I started receiving a 'File Not Found' error when attempting to access various forms. I am assuming that there is some corruption going on and I might be able to resolve this by transfering everything to a new shell. Is there an easy way to do...

Any ideas why this: CurrentDb.Execute ("INSERT INTO PricingList (WinningBid) Values(0) Where PricingID = '689'") Returns this: Query input must contain at least one table or query? Is it the '0' value that I am trying to add? I am trying to change the value of a 'Yes/No' box...... Steve

SQL Buffs, Is there a way I can copy a record line from a table and paste it in the same table with a new 'autonumber' ID? Manually, its a fairy easy task. I would think there should be a fairly simple SQL statement to accomplish this without have to copy individual fields. Thoughts? Steve

So far this site has not let me down.... I am attempting to disable MS Outlook security messages temporarily via Access VBA while sending a message. Should I use Outlook.SecurityManager and if so where would I find the vba reference as it is not currently recognizing it. I have the Outlook...

Alright all, been working on this one a while, can't fig it out. I have a table with 5,000+ entries, 20% (900 or so) of which have a create date entered. I also have a date field in which a user can enter a "start date" to return all accounts created after this date. Here is the output I...

I have a simple, unbound combo box tied to a list and I would like for the drop-down to automatically show when the user begins to type. I would also like for the options to change as the user types i.e. narrow the options based on the input. Sort of like the "search as you type" feature on...