Search results

Whilst running a report it is necessary to update a 'date printed' field in the source table. Trying to update the field from code within the report 'Detail_Format' procedure reports that I can't assign a value to this object. Is it that you can't update at all from within a report but have to...

Microsoft claim that a staged conversion is possible with some users remaining on Access97 using the database as usual whilst others who have migrated to 2002 can enable the existing database in 97 mode. Once all users have migrated to 2002 a conversion of the database back-end can take place...

We run a secure Access97 database in a back end/front end configuration and there is a gradual changeover taking place from Access97 to Access2002 front end. (I'm told that this is progress but I'm not so sure!) I have today spent many hours trying to get the new Access2002 front end to work...

Revisiting this after a year I find it is possible although as KDg indicated it appears that you can only set this property in form design view. I found that opening the required form in hidden,design view, setting the viewsallowed value and then switching the form to normal view achieved the...

Not a question-just a statement regarding msgbox. I have had countless instances where access hangs or crashes when it encounters a msgbox line. Just a simple 'msgbox "some text"' will do it. If anyone else has had reliability problems this might just be the cause.

Thanks for the suggestions Pat. I'm sure it is not related to design changes as the problem occurs after all design work has been completed. However there are a couple of Make-table queries in the system which I will check out although running them just now did not produce the problem!

Thank you for your suggestions. It set me testing and thinking again. You were correct in that the back-end resides on a server. However performance was no better when transferred to the local machine and also when most of the records were deleted. The problem turned out to be an OLE object...

Sorry! Last question for today. I have a "front-end/back-end" application and despite "compiling and saving all modules" the front-end database keeps slowing down and growing in size. When I check I find that the compile and save option is available once again. How can I prevent this...

The following code fragment is used to open a report based on one record from a recordset of around 2500 entries. DoCmd.OpenReport "AVPS_Quote-DD_version", acPreview, , "

Using the code 'Me.ViewsAllowed = 0' (or 1 or 2)produces the error 'You can't assign a value to this object'. Any suggestion of what I am doing wrong?