Search results

If Access has the following limitation: Max users connected to database: 255 and MSDE has the following limitation: Only five concurrent batch workloads or 25 concurrent connections for websites is it worth upsizing using msde as I need up to 40 connections. Cheers

Cheers, Andy! This works great! I converted it to accomodate 5 images. However, I now get the following error: "You entered a null value" when I don't have no image. Is there a way around it in the code? I suppose I could set the table's default value to "null.jpg" and auto update it is there...

I'm having difficulty in viewing pictures in a subreport. The related table lists 5 pictures: photo1 -> photo5 Their fields hold the link to their location. Here is a previous post with more information if necessary: http://www.access-programmers.co.uk/forums/showthread.php?p=267539#post267539...

I have 4 tables, each dedicated to a different level of personel. These need to be discreet! The other functions that I use them for wont work if they are all in one table. I need to generate either one of the following: 1) Either a list of all of their names, pulling from each table. I've...

Thanks for your help! Thanks for all of that! I have now got it up and running for 5 seperate images and it creates my folders for me. I am, however, having difficulty in getting the pictures to show in my subreport. Any ideas? Thanks again

That may well be the ticket! Thanks! I'll try that asap! :D

So you reckon that I'm going to just have to put them one underneath the other with a minute gap between them? I've tried this, but as I have 20 sub forms, if the last subform is active, and the others aren't, there's going to be a good inch's gap.

Thanks! I've tried what you've suggested and got stuck again. I've got my main report based upon the Consultation. Within this I have several subforms, each relating to each outcome. They only show when active=true by using the statement: select table from table where [active]=true; However...

yep I'm sorry - you're absolutely right it does hold up to 2,147,483,647 as a long integer. Will it not hold any more than this? I may just convert to text. Many Thanks!

I need to be able to type in a 10 digit number as a reference. I can't seem to be able to type in a number above 1999999999 Any ideas? Thanks

This is my problem, and I can't solve it! My parent table/form is "Consultation". From this there are many subforms all linking to their respective tables all linked to "Consultation" via their ID (primary key). They are used for the different outcomes or requirements arising from the...

I'm a retard Yes - found it. You're absolutely right. Sorry! Cheers

Wahey! Thank you ever so much! My children's children's children will be thanking you for that one! Perfect! What I'm going to do to it is preset the destination directory to a specific folder. Does this automatically create a new folder too, or do I need to add that code in? Also - I'm...

Thanks! Thank you both very much! It's nice to know how these things work!

When compacting DB, is there any data loss? Is there any advantage in having it full size? Also - what does it do? (My DB is 97MB at the moment, 1.9MB when compressed - what happens??!!) Cheers

Here's my latest problem! For regular readers, you may have noticed that I've hit a few brick walls here all at the same time! I need to be able to select a file, upload it to a predefined folder and link to it all in one. So, from the user end, Browse -> Select FIle -> Copy file to...

Thanks! Thank you both for that! I'll explore each of these very soon! Very useful info. The primary reason I would need to upgrade is multiple users accessing the same data accross multiple sites with forms and reports that need to make multpile searches (workstations wont always be...

Thanks Thanks for that - very valuable info! Just a couple of questions (I am a complete newbie to SQL databases, particularly upgrading from Access, however a little exp w/MySQL and PHP): Is it worth upgrading? I presume I'd have to run Win Server + SQL Server Each machine would just use an...

Um... I'm afraid I can't find this option under "Properties, Format" I'm using Access 2003, but in 2000 format. Thanks

Does anyone know anything about converting access to a standalone app such as Java, or VB with an SQL backend? At somepoint I'll need to upgrade it to SQL, and a VB front end would be easier! More to the point, as I know something like this does exist, is anything any good? Is it worth doing...