Search results

Check the permissions for the folder they're unzipping it to.

Has the recipient actually properly unzipped the zip file or are they opening the database from within the zip file?

I downloaded the Visual Studio and SQL Server Express Files last week, but am wondering now, is there a way to download the software to disk? I can download the set up programmes to disk, but running them downloads the actual programmes from MS, with no option to save to disk. I presume the...

I can pass a value with openargs without a problem, but I'm struggling to know what I need to value I need to pass to the second form for my filter. Something along the lines of where me.custid in (select custid from firstform.recordset) maybe?

Your primary key needs only be something like an autonumber field or any field in your table that will be unique for each record. You then relate records in another table to the first one with a foreign key. If you use an autonumber field as your primary key in the first table then you just need...

Thanks for the reply Jerry, I forgot to mention that my forms are continuous forms so I don't think this will work.

I've got a form based on a query. Is there a way I can filter the records showing on the form, based on the records in another form's recordset. I've managed to get the second form to show the same records as the first using me.recordset = forms!otherform.recordset but I actually want some...

OK. I've managed to do that now. I used me.recordset = Forms!OtherForm.recordset Cheers

That should work. Have a look at the attached database. It demonstrates what I've posted.

Each control on your form has an "enabled" property. You can set this to true or false for each control through vba on the afterupdate event for the tick box as mentioned above.

I think the instr function is what you need instead of your find function.

right([field],len([field])-4) should do the trick I think.

I have a continuous form based on a query with the criteria as all records where a certain field is null. From this form, the user can fill in values for the null field. I then want to click a button on the first form to open another continuous form showing the same records so the user can go on...

I've had a quick look and I've come up with a couple of things. I get a "Data Type Mismatch in Criteria Expression" when I open your form. I think it's to do with the subform as the main form opens but the subform doesn't. Also, you have a different table for each type of product i.e. drinks...

Why the huge difference between size, and size on disc? I would expect maybe a few Mb, or maybe even a few tens of Mb, but over 6 times the size?

That's a good point you make about the orders and order detail. I will take that back to my client when I go and see him to find out if he wants that added. I realise that off the shelf packages could provide what I have done and more, which is another reason I couldn't justify charging an...

I recently got asked by a friend to set up a database for him to store his business contacts (so he can do mailshots etc) along with some basic order history. I've come up with the basics of this database (attached). There is still some work to do on it, a bit of tidying up and some reports etc...

You might run into problems here with different numbers of digits for the year as you mentioned earlier. i.e If you enter 1 for the year, it will match any year starting with a 1, including 2 digit years. 1AF, 11AF, 12AF, 13AF etc. If the part to the right of your year is always letters, you...

Thanks Len, that looks as though it will work fine. Sorry for the delay in replying. I've been away for a couple of weeks. I've added the record locking as suggested as well now.

I also can't delete the record. When I try, it gives me an error message "The seach key was not found in any record".