Search results

Thanks for your reply Mailman. I can see what you are suggesting but even that brings problems, I need to enter the transaction date of my main query as part of the criteria in the summing query in order to get the sum of the transactions up until that date. As my summing query is a totals...

Hello all, I'm trying to build a query that sounds simple in concept, but I'm having problems getting my head around it and would like some advice. I have a table that stores stock transactions and so has records that consist of a transaction date, the product's ID, the quantity and transaction...

I've managed to resolve the first of my issues, I don't believe this was due to the version of Excel, I believe this was a compatibility issue with the software that was being used as the default image viewer. I changed the default and it started working. The second issue I think I now...

Good morning all, I hope somebody can help me shed some light on the following: I have a macro that formats a populated Excel spreadsheet into a new documents and archives it on one of our servers. The formatting macro has been used on a small scale and is soon to be rolled out to a larger user...

Thank you for your replies. The duration field is a number field consisting of the time in hours, i.e. 1.5 for 1 hour 30 minutes. Where a duration of a record had been entered as hour (and so 1), the time was calculated as 0:60. Just to verify that this was a problem with the Int() function, I...

Hello, I am working on the query behind a report that deals with durations and costs. At the moment the durations are in hours only. I'm using these durations in hours to calculate labour costs, based on hourly rates. But I'd also like the durations to be displayed in hours and minutes. So I...

Oh sorry about that Gemma, I just tried it again and it worked. Sorry, I must have mistyped something first time! Thank you all for your help! Matthew

Thank you both for the replies. Using test data, I tried them both. Gemma, your code set them all to be No (0), but Kiwiman, yours worked perfectly. Thank you both again. Matthew

Good afternoon, I'm looking for a way to reverse all of the values in a yes/no field in a table. That is that I wish for all 0s to become -1s and all -1s to become 0s. I've just checked the data and every record falls into one of those categories, none are null. I tried to build an update query...

We're undergoing an ERP at the moment and the old SOP is one of the things that is being replaced. Our newer SOP is currently dealing with some parts of the business process and the old SOP is working on others. The exchange rates aren't updated in the older SOP and haven't been for some months...

Thanks Neil, That's a good idea, it will certainly make the construction of the query easier, just thinking about it, I could re-design my rates table to have just two fields: a record name and a conversion rate. The name could consist of the last 6 characters of the date, ie "092008"...

Thanks for the reply, however, I'm still a little unsure of how you would retrieve the correct month's exchange rates. My plan was to create a new table that stored a record for each month, specifying the date range for that month and the conversion rates that applied during it. Then for the...

Hello all, My apologies in advance for such a long post, but I really want to make clear exactly what my problem is, I'm sure that there is a relatively simply solution to this... We have an incredibly old SOP system which contains data regarding orders that are required for the running of our...

I've found it! This is what I was looking for: ActiveSheet. OLEObjects.Add(Filename:= _ "C:\image.pcx", Link:=False, _ DisplayAsIcon:=False).Select Matthew

Hello, I'm trying to insert an image as an object in VBA. I have the following code: ActiveSheet.Pictures.Insert("C:\image.pcx").Select Which inserts the image as an image, but I would ideally like to insert the image as an object. I've tried replacing the word 'Pictures' with the word...

Never mind, it was me being an idiot! The data that I want to search is in column A, not D, that's why it was struggling with the range! Thanks for all of your help. Matthew

Thanks for the advice, but that still causes the exact same error, any other suggestions?

Thank you for the code. I'm having problems with it though, it doesn't seem to like the line "with range("D" & i)" and is generating a "Method 'Range' of object '_Global' failed" error. Here's the code slightly customised: i = 1000 Do While VarDiv = "" With Range("D" & i) If .Value...

Thanks again for that code, but it now leads me onto another question: is it possible to incorporate that range, i = 1000 to 8 step -1 with range("D" & i) into a While loop? I've just changed my specification a little and has now become necessary for an exit condition to be met. Any help...

That works perfectly, Thank you! Matthew