Search results

I like the idea of importing... Also here is a link for a compact utility for corrupted databases, I haven't used it , just thought about throwing it your way... http://support.microsoft.com/default.aspx?scid=kb;EN-US;295334 The Jet compact utility, JETCOMP.exe, is a stand-alone utility that...

I am considering playing music media files that can be used for presentations or stage appearances etc. The player used might have to be installed etc. on users machines, play the desired music and still have enough resources for Access to work correctly... any opinions? Thanks, Rick

Just a quick note... I believe there are only two events that fire on a subform... On Enter, On Exit. Insert a breakpoint on all the events you have tried and see which one it halts on, if the breakpoint doesn't force you to go into your debugger then it never ran. Once you find the correct...

Here are some more links given to me by Microsoft... I have found these extremely helpful... --------------------------------------------------------------------------- 225048 INFO: Issues Migrating from DAO/Jet to ADO/Jet http://support.microsoft.com/?id=225048 168335 INFO: Using ActiveX...

Found this excerpt basically defining DAO and ADO... ----------------------------------------------------------- The DAO object model is designed specifically for the Microsoft Jet database engine. Jet itself incorporates ISAM and ODBC connectivity and makes the back-end providers look as much...

I have recieved a reply... _______________________________________________________________ This is in reference to the case *************, expressing your concern about the deprecated components and their effects as a database. I have some updates that I found on the MSDN and also have...

I have called Microsoft and asked that they respond to this thread... Their first response was that of commitment to the lifecycle of all current versions of Access using the jet engine (I believe the life cycle support of an application is 7 years...(?)). As for the future of Access and which...

Here is some more suggestions... may be geared toward the intermediate level, but I find that it helps going back over the fundamentals to review concepts... Special Edition Using Microsoft Office Access 2003 (general Access info book - has some good basic VB etc. in it - a little - but more...

This was thrown my way a little while ago... and actually it is old news :eek: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/mdacsdk/htm/mdac_deprecated.asp When you go to the web page: In the left hand column: click on "Deprecated Components" Deprecated Components Each...

A little farther in the process, but heh, this works, but not perfect or very pretty. Dim db As DAO.Database Dim rst As DAO.Recordset Public Function Next3() Dim A As Double Dim B As Double Dim C As Double Set db = CurrentDb SQL = "SELECT * " SQL = SQL & "FROM Query1"...

Thanks Pat. What I forgot to put in was that the field 'Price' is sorted ascending in the query. Anyway I worked on it a little while and I have this, but how do I correct or handle the errors when I come to the end of the code or query where I only have one or two entries left and not the...

Form1 is built off of Query1. What I want to do is call a pop-up Form2 from Form1 and inside of Form2 list the next 3 records that are in sequence from the current value of Form1. The values of Form2 of course have to change accordingly with Form1 when navigating through Form1. For instance...

Thanks Rich That did it. :)

ghudson In reference to the code above... The code runs fine, but if I put in a 'breakpoint' and step through the code it will stop at: DoCmd.Requery With: Run-time error '2046': The command or action 'Requery' isn't available now. Any ideas... what about the effects of a run-time application?

ghudson I got it to work with the following using the 'close' event of Form2: Public sSSN As String If CurrentProject.AllForms("Form1").IsLoaded = True Then Forms![Form1].SetFocus sSSN = Forms![Form1]!FullN DoCmd.Echo False DoCmd.Requery Forms![Form1]!FullN.SetFocus...

Thanks for the reply ghudson. It didn't work. Correction I got it to work! I will post back to the link since it is originally what I wanted to do and someone else is interested on that thread. http://www.access-programmers.co.uk/forums/showthread.php?t=37310 Thanks

still doing research. I found this which helps... and just may be exactly my case... Requerying a form invalidates any bookmarks set on records in the form. However, clicking Refresh on the Records menu doesn't affect bookmarks. Since Microsoft Access creates a unique bookmark for each record...

I have Form1 that is built from Query1, Form2 is built off of Query1 also, but is used as a quick or small 'update' form that is called from Form1, you could say that Form2 is a pop-up form called from Form1. While Form1 is loaded, I use Form2 to update or make changes on certain items. I would...

Don't really know... but here is my shot... http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbcon/html/vbconhscrollbarvscrollbarcontrolsoverview.asp I would assume you would have to make changes to the LargeChange and SmallChange Properties of each form involved in the proper...

I found a way to assign the values to the filtered combo boxes on the form (which in this case has to be a pop-up form) without saving to a table, providing that the main form is or remains open, other wise you will have to go through the sequence or save the values to a table. Private Sub...