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?

Works like a charm - Thanks!

Awesome! Let me try this out. I already have the email code going and just need to be able to insert this into the .body portion. Thanks again!

Thanks Bob, So, I guess my question is how do I do that? My function uses a loop For x = 1 To y Debug.Print Forms!FRM_TransactionDetailsEdit!PricingList.Column(2, x - 1) & " yrs, " & Format(Forms!FRM_TransactionDetailsEdit!PricingList.Column(9, x - 1), "#.00%") Next Which...

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

An easier way of asking might be to say: How can I take what is displayed in a list box and insert it into the body of an email?

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

Actually, Access wouldn't allow me to go into any of my forms, reports, queries, etc. It gave me the error and then took me to the VBA but didn't highlight a specific file that it couldn't find. I think I'm back on track now though. I found an old version that I had emailed a week ago and...

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

Nm- just a simple syntax error. It was the single quotes- didn't need them. Thanks again!

Makes sense, thanks! So now I am getting a datatype mismatch in criteria expression: CurrentDb.Execute ("UPDATE PricingList SET WinningBid = '0' WHERE PricingID = '689'") Any ideas?

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

Nm, think I just ansered my own question.... just needed to play with it for a minute. Thanks again!

Thanks, it does.... I had actually just stumbled on to the 'Append Query' and was going in the direction that you are advising. Now I'm trying to figure out how to point the 'PK' parameter to a specific row; I am assuming PK is what you are calling my auto-number field. Normally I would...

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

Nevermind- simple fix. Just figured out how to add rows. Thx again for the help! Steve

It works, thanks for the input! I have a new problem now though; I'm out of criteria rows because I had to use double the rows since I am using every other line. Any ideas on how to use more criteria without going through SQL?

I am writing this in the criteria of a query. I have tried the Nz and Is Null functions but no dice. The work for if the search field is null but do not return all of the empty fields in the table. I think it will work in the IIF statement if I can get the sytax right.