General Discussions | Forum profile

( Very few products are designed with sufficient prescience that they can open files created with future versions. <g> The only fix is to take advantage of the fact that Access 2003 can save the database in Access 97 format \(look under Tools | Database Utilities\) -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele \(no e-mails, please!\) "Roby" <Roby.RemoveThis@discussions.microsoft.com> wrote in message...

That worked great. Thank you! "Tom van Stiphout" wrote: > On Sat, 21 Nov 2009 06:51:17 -0500, "Douglas J. Steele" > <NOSPAM_djsteele.DeleteThis@NOSPAM_gmail.com> wrote: > > Yes, that's possible. I did mine as an expression in the ControlSource > of the control on the report, and I did get the full memo text, not > just the first 255 chars. > > -Tom. > Microsoft Access MVP > >...

( "Randy Yates" wrote in message news:m37hte5su6.fsf@ieee.org... > I have a subform in continuous form mode on a form, and depending > on the number of records in the subform, a vertical scroll bar may > or may not appear. > > By default, the subform is oriented so that the top-most records > are displayed and the scrollbar is in its top-most state. How do I > cause the scrollbar to move to its end state? You can...

Thanks DanielI apparently have the wrong concept. If I understand you correctly: If I want someone who does not have Access, to run my program, I would send them (or have them download) the free microsoft AccessRuntme.exe file for installation on their computer.) This isn't clear on microsoft's notices, though I guess it is obvious to those with some software knowledge. I have seen this same question posted eslwehere, never with an...

Sorry, you are talking way above my knowledge! I took over this database and simply followed what was already set. It appears that there is one table which stores ALL personal info., there are approx. 40 fields in the table, then queries, forms and reports are made from the info. in this table as needed. The table is then copied from one year to the next and inactive files are deleted from the newest table so that looking back there are...

On Tue, 24 Nov 2009 10:54:03 -0800, PPCO <PPCO.DeleteThis@discussions.microsoft.com> wrote: > Thanks for the info! I had actually thought of trying the number sequence > with gaps, but that seems like it has limits as well. How do you do the > up/down arrow in a continuous form? That might work...I've never used a > continuous form: will that guarantee that the records stay in order each time > I open the form to...

Sorry, trying to multi-task too much! My code would work when the form/subform first opens, but I think you'll need to use similar code in the subform when moving from record-to-record on the main form. -- There's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000/2003 Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access/200911/1

Access does not store automatically the last time an edit to the data was made. Your first task is to determine exactly what the request is. In order from least complex to most complex You could have a table with one field that gets constantly updated and would show the last time any field in the entire database was updated. Or you could have a field in each record that would show the last time each record was updated. Or you could track each...

Thanks for your help. I agree with you --the utility of creating this is not worth the time and effort. Thanks for answering and clarifying this. -- Nona "John Spencer" wrote: > Access does not store automatically the last time an edit to the data was made. > > Your first task is to determine exactly what the request is. > > In order from least complex to most complex > > You could have a table with one field...

There is no conversion to be performed. Simply create your db (as you normally would) and then anyone who only has the run-time will be able to use it. It is sort of like an image viewer for instance. If you create an image in photoshop with layers... and I use irfanview to open it, I can see the image, but cannot really edit it. Run-time is like irfanview and MS Access would be the equivalent to photoshop. No conversion necessary. That said,...