Search results

Hi! I just want to delete a file with VBA. Like this: Deletefile "c:\blabla.txt" But deletefile function needs some kind of object and I don't want that. Just to delete a file. How can i do this?

If I hold down the SHIFT-key and click on my access database the database boots up with the startup options! I can't get into my database even if I hold down the SHIFT key!! Help me, please

Hi! I have a helpfile that I want to open on a Event. But when i use Application.FollowHyperlink I get an annoying warning (the file can contain viruses or in other ways damage your computer) so I wonder if there is another alternative to Application.FollowHyperlink? Thanks, Johan Hjalmarsson

Hi! I have two queries: Grade CountOfHello1 1 0 2 0 3 1 4 0 Grade CountOfHello2 1 0 2 2 3 1 4 0 I want these two like this: Grade CountOfHello1 CountOfHello2 1 0 0 2 0...

Hi! I have this table from a query: 1 1,34 2 1,23 3 1,21 1 0,65 2 0,55 3 ... 1 2 3 1 And I want 1,2,3 at the Y-axis and the X-axis to be the other values (1,34...) But I only get a graph that shows 1,2,3 at Y but only the value 1 at the X-axis and the 1,34-values as legends! Why?

i have a subform that is based on a query but i want that the subform should get updated when i press a button. how is this done? regards johan

I want to display more records vertically than 1 column in my continuous form. Is this possible in some way? I want to have like 2-3 columns with 5-6 records each.

I want to open a image file external outside access. I want to have a VBA line that opens a specified image with the default association of windows. Example: .jpg is opened with the same program as when doubleclicking in explorer and i want to do this in access. open a image with the...

I have an external program that runs in my access_db and I want Access to wait till that external program is finished before continuing with the other. How is this fixed? I fixed it with this thread: http://www.access-programmers.co.uk/forums/showthread.php?t=74507 Thanks a lot!

How can I insert an object (image in this case) into a OLE object field with VBA code? Thanks!

I'm trying to present a little thumbnail image beside every record in a "continuous" subform after a search has been made. How do you think I should achieve this, please? Thanks!! Johan (PS. I have tried the following: 1. Tried to make a Image and on Form Current() update the image from a...

I don't want the form to add the record if I put in a value in a field. I want it to add the record when I press a "Add information to a record"-command button. How can I do this? My form is in data entry mode.

Hi! Do you guys think the database will get small in size if i have like 200 records and each one of them have a 4 kb thumbnail as OLE object? I know that putting big images in OLE objects gets very big but a small thumbnail is ok and doesn't increase the size of the .mdb so much? (130x98...

Hi! Wanted to do this: Forms![frmSearch]![qryModelAdhesive subform]![file9].SourceDoc ="c:\resize.jpg" Forms![frmSearch]![qryModelAdhesive subform]![file9].Action = acOLECreateEmbed file9 is a Bounded OLE object in a subform. But I can't get it to show my picture. Why? I got this...

Hi! I want to put my query results in some sort of array. So I can use index and get the records I want. Is this possible? I mean like this: If someone clicks on a button, a query is runned and the result goes into some sort of array. Then I can select specific records and show them in...

Solution to a thumbnail viewer Hi! I want to display 8 thumbnail images at a time per form of records that matched a search critera in a form. But it seems like a form is suppose only to have one record at a time? I want to have a "next 8 thumbs"-button so it gets easy to browse the pictures...