Search results

Corruption can occur without notice. Take the details of the query and create it again. If you now can update from the query, point the form at this new version and it should now work. If the query works but not the form, recreate the form also. Chris B

You can create your new table in design view by starting from scratch or by copying the structure from the old table and then modifying as needed, then using an append query to copy the data to the new table. The query lets you specify which columns receive the data. Chris B

Sure you can. I have updated the demo db so it sends the content of a text box on the form as the subject text. You can elaborate on this as required by building the text string including other data sources, e.g. "This is to notify you that contract - " & [Another Text box] & " has expired...

Here is the db I tested with. For the exercise, I am emailing the content of the form you see on open as an excel sheet. Should point you in the right direction. Chris B

The vagaries of Access just keep on keeping on. Curiously, if you do it with a Macro, it will fail, as you can only enter a specific Email address in the To field, but if you convert the macro to a module and then grab the business line and copy it to the on click event of the button on your...

You would do this in several steps, starting with taking a copy of the db so if you muck up it doesn't have consequences. A find duplicate query using the the ISBN column will supply the matches, and you can include whichever fields you wish in the output. Change the query to a make-table, and...

I like this a lot ... http://www.addintools.com/english/menuoffice/ Chris B

Is it 2003? If so I have recovered from the same message by opening in 2007. If it opens, convert it to new format, then convert it back. Chris B

Scrolling text isn't for forms, only data access pages. Chris B

The included Activex calendar writes it's value to a table which you can query. Here is a demo... Chris B

Yes, I suggest create a new db and link to it's tables. Typically the fronts get replaced without notice if an update occurs, so if you add tables there they may get arbitrarily deleted. Chris B

Not storing a calculation where the data may change is a good and correct policy, however if the calculation is unique and will result in an outcome which never changes, then store it with a clear conscience. Chris B

Without exploring the combobox issue for the moment, assuming you have full access to your front end, why not create an additional backend for yourself and add the required tables to this? You can link to another db with File - Get external data - link tables, and when the IT guru gets around to...

Better to create a shortcut to the macro (right click - create shortcut) and use Windows Scheduler to run it. Db can be closed or open, doesn't matter, but if you want to close it again, do so with the macro, don't let scheduler terminate it or you will get errors. Chris B p.s. Pat, you...

It is bound to fail/corrupt eventually, so best not to use it. Always safer to copy then compact. You can do this with a scheduled task. If it is the BE you have set to compact on close however, this will only occur if you open it. Having a linked FE open and close will not trigger it. If you...

I used to be apathetic, but now it doesn't bother me. Oh, and I don't have a solution, but that doesn't matter either..... You are correct though. Vista and XP hate each other, even before SP1. Do make sure that admin accounts with the same username and pwd exist on both systems. Chris B

Some system is required for order in a society which insists upon crowding its members into small spaces and expecting them to co-exist peacefully. The ten commandments work well enough for this purpose, provided no-one really believes that eternal life will happen. This just leads to war...

MS code here to disable the X. You can then have an exit button on your form or command on menu. File - Close beats it though. http://support.microsoft.com/kb/245746 Chris B

Can't be done, but you can print a tick or an X on it's own - http://support.microsoft.com/kb/888696 Chris B

Sounds like permissions have changed on the network folder. Ensure that you have "Full Control" otherwise the process cannot complete correctly. Chris B