Search results

Are the images embedded within the database or linked externally? You could try with SQL - something like: DELETE FROM yourTableName WHERE yourImageFieldName IS NOT NULL;

Absolutely agree but in my case, our network was causing mahassive bottlenecks (they were even worse when people tried to access through remote access) and the whole thing became unusable. In an ideal world I would have create a PHP front-end but that wasn't an option. I guess sometimes you just...

Or you could use a dropdown/combobox where the users can type in the name of the client rather than their ID number - might this me a more user-friendly approach?

Are you limited to how many characters long the barcode should be? You could format it something like this: YYMMDDHHMMSS0000 (if it's not too long) and that would allow you up to 9999 different barcodes with each click (assuming to people don't click at the same moment). TO achieve this, you...

I'm in a similar position - I have created a database, looks great work nice then I split it so multiple users can access it and still allow me to debug etc. in the background. I have merged the files together again because the split DB was soo slow over our network. WHat I do is keep a...

I agree with Galaxiom - far easier to count or lookup if you use discrete fields for difference information... Have one field that stores the 10-digit number formatted to '0000000000' to catch any leading zeros with the date... Then you could have a lookup field that merely states the job's...

So it's getting stuck when trying to add the actual price column, right? If the data in that column says £1.75 then I'm assuming it's formatted as text, rather than a number - this could well be a problem. In your table, you need to make sure that the price column is set to format as a number...

One way I have overcome this problem is to use a listbox rather than a dropdown or combobox with a separate textbox for the searching, so rather than giving an error message each time you press a key (which WILL get boring after the first three letters of their name, it reapplies a SQL filter to...

Hi Hunterfan - Are you wanting to remove the link or the image itself? Using SQL would seem the best way... something like: DELETE FROM myTable WHERE myField<>'';

If you want to find out the value of the dropdown box when the user changes it, you could always catch ti and put it in a message box yourself... msgbox me![Type of Comp].value That could go in the onChange event listed in the dropdown's properties... at least then you know whether you need to...

Hi Dave, To clarify - are you wanting to create 2000 separate Word documents - one for each record in your table?

Is the second form bound?

Hi Two options without using any VBA (assuming you don't want to): 1. IF your form is BOUND to its data source then in the table holding the information, you can set that field's Entry format to password - this should cover the text with ****s 2. If you're using an UNBOUND form, you can set...