Search results

thanks for your reply but just returns: error 3061 to few parameters, expected 1. P.S. I didnt design the database, just have to fix it:rolleyes:

Im trying to update all the null values in my table (tblHours2010) to = 0 Columns in the table are week2 to week52 How would I rewrite this so I dont need to run it 54 times? Update tblHours2010 Set week2 = 0 Where week2 Is Null

Im using the method described in Article ID: 290136 (http://support.microsoft.com/kb/290136) to create a running total in a query, this is work great until the years changes in the data and it starts over again. How can I rewrite this code so it will give a running total over 2 or more years...

How would one turn warning back on if it did error out and there was no error handler for it?

Tried that Kryst51, the duplicate posts before where down to my network play silly buggers and timing out all the time:)

I’m trying to create a chart in a report that shows how much time each team in our department spends on a task. The chart is yearly split into months showing each team in each month. If I set my query for the chart like this: SELECT qryMNonEngRptTm.SumOfDuration, qryMNonEngRptTm.Dept...

Thanks although the field was EmployeeName took name off the end in all forms and query and now it works. great one

I am trying to do something I first thought would be simple, Doh! I want to open a form to add a new record to a table, (Done that) When the form opens I want certain fields already filled in with data from a query. What I have is: Table with Name, logonID & dept Query that returns the Name &...

ah, easy when you know how. thanks

Hi Im using sendmessage as a public function to send an email, I'd like to let the user set the importance of the message. Iv tried changing the code where it states the email importance to: .Importance = ([Forms]![frmTRupdate]![text101]) Text101 is unbound combo on form TRupdate with...

Thanks :):):)

Im using a public module. Iv tried this Set objOutlookRecip = .Recipients.Add([Forms]![form12]![Combo11]) looks like the emial will send to start with but dosn't actually send it. could it be because combo11 has a column count of 3 and only the first one showing which contains the recipients...

nobody know then?

I managed to fix the attachmentpath problem just by adding "as string" after "Optional AttachmentPath" but Im still stuck with how to get it to read the addres from a form and not outlook. Help...

Hi Im using “sendmessage” in a module to send an e-mail with an attachment. The code Im using is copied from HERE The code in full Sub sbSendMessage(Optional AttachmentPath) Dim objOutlook As Outlook.Application Dim objOutlookMsg As Outlook.MailItem Dim objOutlookRecip As Outlook.Recipient...

heres an updated version.. http://msdn.microsoft.com/en-us/library/aa159619.aspx :)

Doh! or me.combo0 and the () I thought it was a simple fix. Magic your a star RuralGuy...

it's there, just hidden. I dont know why!

Iv tried to attach the form with a couple of table needed to run it,