Search results

Thanks for the advice. Is there any advantage to using that, other than ease of typing? Would that be faster to run? Thanks, Matthew

Of course, thanks for that. I thought I was missing something obvious. I've changed it now so that the first parameter (the number of rows) is the same as the record count, and the second parameter (the number of columns) is 2. After a quick test of a couple of recordsets (including one with...

Hello all, I'm working on a project in VB6, but the code that I have issue with is basically the type of thing that I have recycled from old VBA projects, so I've posted it in this category. I'm populating a multi-dimensional array from a recordset, and it works absolutely fine with my test...

Try: Int([AGACD]/60) & ":" & Format(([AGACD]-(60*Int([AGACD]/60))),"00") Matthew

Thanks for all of your replies. I've found a way around this now, it's not perfect but I've created a public variable and I am now using it to store the value of the combo-box on open. Then after update if the user opts for the vbno option of the message box the value of the combo-box is set to...

Thanks for your reply, this is what I usually do, but it reverses all of the changes to the form's data, not just the one for that object. I may have to use this if I can't find any other solution, as most of the time users will only have one detail to change.

Thanks but I have tried that and it didn't work. Any other ideas? I'm still confused as to why even at the beginning of the before update event the ID in the combo-box is that of the value it is being changed to, not changing from. Matthew

Thank you very much for your reply. I've tried this and although it works better than Me.Undo in the sense that it does not reverse changes to other objects, it doesn't reverse the change to the combo-box. Here is the code I am using, minus its error trap, in the after update event of the...

Hello all, I have a form which allows amendments of records. Before a combo-box on the form can have its contents changed, I am displaying a vbyes/no message box, which explains the consequences of a change and offers the facility to cancel the change. When the change is cancelled, I'd like the...

Hello, I'm trying to use some code in Access that was written for VB6. The code is in two parts, a class file and some code that creates a new object of the class at form level. When I've used it in VB6 I simply add a the class file to my project (control+D, and navigate to the file,) and then...

I never did get to the bottom of why it was behaving like this. In the end I just used DLookups. Not ideal in terms of speed, but this query shouldn't ever have to deal with a large quantity of data, so it should be okay. Matthew

Hello all, I'm building a database that stores scheduled working hours for various groups of employees. The idea is that working hours for various shifts will be stored and then a query will output to Excel the scheduled hours for each employee from a user-selected shift. So for example, it may...

Hi Chris, I a new thread regarding the similar project that I am working on and I received a link to a website that had a VB program that does exactly what you describe, displays thumbnails all of the images in a directory, which can then be clicked upon and viewed in your default image viewer...

Hi David, Thank you very much for your reply. I have tried downloading several VB image viewers but none of the ones that I downloaded offered the facility to preview multiple images on screen and select images from there. However, on the website that you gave me the link to I found the...

Just a quick update: I've looked at returning four records per row in the query (and subsequently the continuous form,) and with the quantity of data that I have in the database at the moment it doesn't seem particularly slow. What does seem slow is the rendering of the image on screen (the path...

Hello all, I'm planning a database to allow the storage and retrieval of product information. Each product is to have an image associated with it, by saving the path to the image into a designated field. I would like to display these images in with the search results on screen, so that the...

Hi Chris, In Access 2007 you can link the field that the file path is stored in to the control source of an image object and it will display that image. If you do this on a continuous form you will actually display the image for each record. I know it won't look exactly like a browser, but it...

Thank you very much Mailman, I've used a DSUM (it's a little slow but this isn't a query that will be run frequently.) It all works fine. I had a few teething problems with date formats, but I just specified "dd-mmm-yyyy" to bring some text in to get it to link to the American one. Thank you so...

Okay, thanks for the advice Mailman, I'll look that up and post back how I get on. Thanks again.

Good morning Mailman, Thank you for your post. The solution that you have suggested is what I tried initially. My problem is that in my first query, let's call it Query 1, which is the one that I gave the following example of: Product 1 10/05/2009 Issued to Factory Floor Product 1...