Recent content by steve_4477

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