Search results

Thus my question. Is this being done when using Excel, not Access?

What I posted is what I used on all my Db's, so you might try checking references etc. Apart from that, try puting the code in the DOUBLECLICK event of one of the fields. Make sure the forms name is correctly spelt also. Dave

Distractions (0)(0) what distractions (.)(.)

Does the Subform record source have a primary key (ID) (I presume so). If so, create a normal form based on the same record source, then on the subform double click event: Dim rs as Object Docmd.OpenForm "YourFormName" Set rs = Forms!YourFormName.Recordsource.clone rs.findfirst "IDFieldName =...

If you are moving data FROM excel, then this should be in the Excel thread. If you want to import data from Excel, when using Access, then I maybe able to help. Dave

In Australia we start DLS at the end of October, but in 2000 when had the olympics, the east coast started it in August, so it was dark until about 9.00 am and seemed to get dark at around the normal time. Really stuffed me up.

Thanks for that, will come in handy here in Australia !!

Well, I tried :D Lame answer, maybe, but sometimes you can spend hours or days stuffing around just cos "you SHOULD be able to do this". In the end you have to weigh up if it is really worth it. Or is the a home project and would just be nice to have it automated.

Why not just write them on a piece of paper :p

Try this.....

Sorry :p This was my effort..... Nowhere near as efficient, but I am still learning

Looks like a challenge. I'm prepared to give it a try.

My bad. The form frmLinkManager has a menu property MRHSKeyRegister. Find and remove this in the form properties and you should be right. Dave

Three sheep walk into a bar. Bartender says "Sorry my boss said i'm not allowed to serve ewes"

And read, read, read, and make backup copies of your Db's Many efforts to secure database have been completely screwed (including myself - I gave up in the end) and locking yourself out of all your databases. Keep us posted.

I have tried to cut out most of the BS. Hopefully you can understand a fair bit of it (I dont understand much of the basRetrieveBackEnd), but is reliable and easy to use and customise. If you copy the table tblDataFile to your Db, and hide it, then if the Split Database Wizard is used, this...

If you look at the Db, all the code in a couple of modules, and all you have to change is the number of tables to link (this changes the way the progress bar updates) Import these module into your database. Then look at the splash form, If I remember rightly the form timer has something like...

Did you update the row source of List0?

You could do this to the LHS Listbox also if you prefer.

This is because the code is looking for the field [txtProductBowlImage] which is not on the form. I inserted an extra column to the RHS list box so the rowsource now reads: SELECT qryPrintProducts.intProductID, qryPrintProducts.txtProductBowlImage, qryPrintProducts.txtProductBowlCode AS Code...