Search results

Haha very afraid, it's getting so frustrating I may burn my house down lol.

I tend to start from 2, haha, but yes your right I need to go back to basics with this. I thought it would be a simple project. I will draw up some designs and maybe come back with something more specific. Or scrap the project.

Hi namliam, thanks for your reply. "Start by making the 0 normal form" I am not sure what you mean by this? "find all things you want/need to store" My data items show all what I "need" to store, the problem is figuring out what i have to store in order to identify the individual bookings...

Cancel the wizard. On the on_click event change to [event_procedure] then click the ... which will open the VB Edit window where you can enter your own code.

Hi all, I have created many (10s) of databases for commercial use in the past and have taken on another project where I work now (a school). I am completely stumped as to where to start on this project and was hoping someone could help. The Project: Create a ICT Suite booking system for staff...

If the first form is still open then the value may not have been updated. Either close the first form or requery it when you open the second form.

Have a look through the form properties, the answer must be somewhere in there? Could try setting Auto Centre, Auto Resize and Fit to Screen to yes.

Works fine for me. Access 2007, Vista. Can add programs, images and open them in the program set. Good little app.

scalextric59 - The user was copying a pasting images from Excel which were inserted from a digital camera (thankfully not a very good one). The source files were just over 1MB therefore I presume it was copying the full image into the database with some bloat. It was this that was causing it to...

Thanks for your input dave. Yes the clicking idea would speed it up and has been suggested however the user is not happy with that approach. The only way I can think of doing it at the moment is to add 5 subforms, move to the appropriate record on load and then have a button which makes the...

Hi all, I have a database with a continuous form based on a query. The problem I have is that the database includes images and therefore the continuous form is loading very slowly. What I would like to do is limit the view of results so that I only see 5 records at a time and have a button to...

Hi All, Thanks for the help. I am reviewing a program called DBPIX at the moment and it seems to do everything I need. It costs $99 however I think it may be worth the investment. Has anyone else had experience of this program?

Hi David, Thanks for the input. I could not get that working properly, missing .OCX references etc. I notice it stores in Long Binary. Would storing the image in Long Binary format stop the bloating do you think?

Hi Bob, How do you actually get the JPEG images into the OLE? If I right-click it in Form View and Insert Object, there is only an option to insert a bitmap. Then if I create a new file I get a version of MS Paint come up with a Paste From option whereby I can paste in my JPEG. A bit long winded...

2007. No support for dragging and dropping jpegs, or copying and pasting unless from another Office App. Cannot find any options for compressing/reducing file size or quality of the images, only to leave them in their native format.

Any ideas how I can embed without the bloat?

Hi Wazz, Thanks for the input. Yes I agree, so does the rest of the Internet population that embedding = bloating. As different PC's/Laptops will see the USB as different drive letters I am looking for a way to use a relative reference i.e. ..\Pictures rather than H:\Pictures, any ideas? I do...

Hi, I have a database which has 400-500 entries for a particular product I sell. I would like to add pictures of these products. I have added an OLE object field to my table for the purpose of storing an image of the product. I have 2 problems: 1. The only way I can seem to add an image is if...

Hi all, Thanks for your input it is much appreciated. It seems that the orginal code is correct (what you would expect from an Access MVP). I just did not understand fully what it does. As Brian said it just formats the date input to what JET expects it to be. It was actually working in the...

So you are saying that I must get the user to enter the date american style. Surely not. I will figure out a work around then... Date picker formated to enter mm/dd/yyyy maybe. Thanks for the help, Andy