Show record on form, bookmark for record was found using seek?

I used seek to find a record with certain criteria. I then recorded the bookmark in a variable. How do I then set the form to show the current record identified by that bookmark?-- Regards, Michael
0
Utf
3/13/2007 2:40:44 PM
access 16762 articles. 3 followers. Follow

6 Replies
1413 Views

Similar Articles

[PageSpeed] 39

You can (and should) use an ADO recordset if the form is based on an ADO recordset, such as if you use an ADP instead of an MDB.But if you use regular Access tables, in a normal Access form, you will have a DAO recordset, because Access itself uses DAO.About 7 years ago, Microsoft was trying to wean Access users away from DAO, in the misguided hope that we would all convert to SQL Server back ends. That's what all the hype was about, including ADPs. Today, ADO is dead, replaced by the quite different ADO.NET in environments outside of Access, and ADPs are not well supported in A2007 and Microsoft is suggesting you don't use those either:    http://www.amazon.com/exec/obidos/tg/detail/-/0672319446/qid=1091775101/sr=8-1/ref=sr_8_xs_ap_i1_xgl14/104-9274862-0445505?v=glance&s=books&n=507846You should also be aware that MS restored DAO as a default reference in A2003, and continues to use it in A2007.So, the information you have been given is:a) out of date by 2 versions, andb) never was right in the first place.DAO is the native library in Access. When you create a query, Access is using DAO. When you open a form bound to an Access table, Access is using DAO. The "A" in ADO *is* Access, i.e. the library is designed to expose the data objects in Microsoft Access.More info about the libraries:    http://allenbrowne.com/ser-38.html-- Allen Browne - Microsoft MVP.  Perth, Western AustraliaTips for Access users - http://allenbrowne.com/tips.htmlReply to group, rather than allenbrowne at mvps dot org."Mac" <Mac@discussions.microsoft.com> wrote in messagenews:59937F83-1FD2-48FA-9AC4-C0F88A8AAAFC@microsoft.com...>I don't want to use DAO (FindFirst) because I read that it is dead and ADO >is> better. So in ADO there is no way to set a forms record to a bookmark> variable? Is there a way to use a Recordset clone in ADO and then set the> form's bookmark to that of the clone set?> -- > Regards, Michael>>> "Allen Browne" wrote:>>> That's not going to work.>>>> Use FindFirst in the RecordsetClone of the form.>> You can then set the form's bookmark to that of the clone set.>>>> "Mac" <Mac@discussions.microsoft.com> wrote in message>> news:6127A737-E98F-4A73-A017-3EAB243C4B2D@microsoft.com...>> >I used seek to find a record with certain criteria.>> >>> > I then recorded the bookmark in a variable.>> >>> > How do I then set the form to show the current record identified by >> > that>> > bookmark?>> > -- >> > Regards, Michael 
0
Allen
3/13/2007 3:29:16 PM
Man this stuff is too confusing! Well it is too late to redo everything. I am using normal MS Access forms and tables but I have been creating ADO recordsets and using all ADO properties, methods, and actions. I guess I can start to incorporate some DAO code now that you have enlightened me on the real situation.I'm still amazed that there is not a way to set a form bound to a table to a certain record based on a bookmark.I'll try your earlier suggestion to see if applies. Thanks for you help and understanding.-- Regards, Michael"Allen Browne" wrote:> You can (and should) use an ADO recordset if the form is based on an ADO > recordset, such as if you use an ADP instead of an MDB.> > But if you use regular Access tables, in a normal Access form, you will have > a DAO recordset, because Access itself uses DAO.> > About 7 years ago, Microsoft was trying to wean Access users away from DAO, > in the misguided hope that we would all convert to SQL Server back ends. > That's what all the hype was about, including ADPs. Today, ADO is dead, > replaced by the quite different ADO.NET in environments outside of Access, > and ADPs are not well supported in A2007 and Microsoft is suggesting you > don't use those either:>     http://www.amazon.com/exec/obidos/tg/detail/-/0672319446/qid=1091775101/sr=8-1/ref=sr_8_xs_ap_i1_xgl14/104-9274862-0445505?v=glance&s=books&n=507846> > You should also be aware that MS restored DAO as a default reference in > A2003, and continues to use it in A2007.> > So, the information you have been given is:> a) out of date by 2 versions, and> b) never was right in the first place.> > DAO is the native library in Access. When you create a query, Access is > using DAO. When you open a form bound to an Access table, Access is using > DAO. The "A" in ADO *is* Access, i.e. the library is designed to expose the > data objects in Microsoft Access.> > More info about the libraries:>     http://allenbrowne.com/ser-38.html> > -- > Allen Browne - Microsoft MVP.  Perth, Western Australia> Tips for Access users - http://allenbrowne.com/tips.html> Reply to group, rather than allenbrowne at mvps dot org.> > "Mac" <Mac@discussions.microsoft.com> wrote in message> news:59937F83-1FD2-48FA-9AC4-C0F88A8AAAFC@microsoft.com...> >I don't want to use DAO (FindFirst) because I read that it is dead and ADO > >is> > better. So in ADO there is no way to set a forms record to a bookmark> > variable? Is there a way to use a Recordset clone in ADO and then set the> > form's bookmark to that of the clone set?> > -- > > Regards, Michael> >> >> > "Allen Browne" wrote:> >> >> That's not going to work.> >>> >> Use FindFirst in the RecordsetClone of the form.> >> You can then set the form's bookmark to that of the clone set.> >>> >> "Mac" <Mac@discussions.microsoft.com> wrote in message> >> news:6127A737-E98F-4A73-A017-3EAB243C4B2D@microsoft.com...> >> >I used seek to find a record with certain criteria.> >> >> >> > I then recorded the bookmark in a variable.> >> >> >> > How do I then set the form to show the current record identified by > >> > that> >> > bookmark?> >> > -- > >> > Regards, Michael > > 
0
Utf
3/13/2007 5:36:16 PM
On Mar 13, 3:29 pm, "Allen Browne" <AllenBro...@SeeSig.Invalid> wrote:> ADPs are not well supported in A2007 and Microsoft is suggesting you> don't use those either:>    http://www.amazon.com/exec/obidos/tg/detail/-/0672319446/qid=10917751...You are citing Amazon for this?! Seriously, is there a Microsoftsource for this other than blogs? TIA.> About 7 years ago, Microsoft was trying to wean Access users away from DAO,> in the misguided hope that we would all convert to SQL Server back ends.> That's what all the hype was about, including ADPs. Today, ADOis dead,> replaced by the quite different ADO.NET in environments outside of AccessSaying now that ADO is dead is about as helpful as saying seven yearsago that DAO was dead. ADO classic has not been replaced by ADO.NET;that's like saying VBA6 has been replaced by VB.NET i.e. clearly notthe case in Access land, where IMO ADO classic is more likely to bereplaced by an enhanced version of DAO.Jamie.--
0
Jamie
3/14/2007 9:42:41 AM
On Mar 13, 3:29 pm, "Allen Browne" <AllenBro...@SeeSig.Invalid> wrote:> When you create a query, Access is> using DAO.I assume by 'Access' you mean 'the Access user interface' rather than'the Access engine'. If I use ADO to create/execute a VIEW/PROCEDUREor execute an ad hoc query then at no point is DAO used.Jamie.--
0
Jamie
3/14/2007 9:47:32 AM
????:         ?????????"Jamie Collins" <jamiecollins@xsmail.com> ??????:1173865361.104731.203710@p15g2000hsd.googlegroups.com...> On Mar 13, 3:29 pm, "Allen Browne" <AllenBro...@SeeSig.Invalid> wrote:>> ADPs are not well supported in A2007 and Microsoft is suggesting you>> don't use those either:>> >> http://www.amazon.com/exec/obidos/tg/detail/-/0672319446/qid=10917751...>> You are citing Amazon for this?! Seriously, is there a Microsoft> source for this other than blogs? TIA.>>> About 7 years ago, Microsoft was trying to wean Access users away from >> DAO,>> in the misguided hope that we would all convert to SQL Server back ends.>> That's what all the hype was about, including ADPs. Today, ADOis dead,>> replaced by the quite different ADO.NET in environments outside of Access>> Saying now that ADO is dead is about as helpful as saying seven years> ago that DAO was dead. ADO classic has not been replaced by ADO.NET;> that's like saying VBA6 has been replaced by VB.NET i.e. clearly not> the case in Access land, where IMO ADO classic is more likely to be> replaced by an enhanced version of DAO.>> Jamie.>> -->> 
0
ruanhong
3/15/2007 3:12:07 AM
??!????????Hello!l have read your artide."Jamie Collins" <jamiecollins@xsmail.com> ??????:1173865361.104731.203710@p15g2000hsd.googlegroups.com...> On Mar 13, 3:29 pm, "Allen Browne" <AllenBro...@SeeSig.Invalid> wrote:>> ADPs are not well supported in A2007 and Microsoft is suggesting you>> don't use those either:>> >> http://www.amazon.com/exec/obidos/tg/detail/-/0672319446/qid=10917751...>> You are citing Amazon for this?! Seriously, is there a Microsoft> source for this other than blogs? TIA.>>> About 7 years ago, Microsoft was trying to wean Access users away from >> DAO,>> in the misguided hope that we would all convert to SQL Server back ends.>> That's what all the hype was about, including ADPs. Today, ADOis dead,>> replaced by the quite different ADO.NET in environments outside of Access>> Saying now that ADO is dead is about as helpful as saying seven years> ago that DAO was dead. ADO classic has not been replaced by ADO.NET;> that's like saying VBA6 has been replaced by VB.NET i.e. clearly not> the case in Access land, where IMO ADO classic is more likely to be> replaced by an enhanced version of DAO.>> Jamie.>> -->> 
0
liushuai
3/15/2007 3:17:05 AM
Reply:

Similar Artilces:

GetObjectData not firing using XML Serialization
What attributes/code do I need to add to a class to get GetObjectData to fire? I need to use XML serialization to serialize an object with private members including complex data structures which eventually may contain other private objects. I can get that method to fire using SOAP serialization, but shouldn't I be able to customize my serialization process using XML serialization? Thanks, Todd. ...

Using pivot table without summing, etc. #3
Of course! I don't know how that slipped me by. Thank you. -Pete -- Peter Bernadyn ----------------------------------------------------------------------- Peter Bernadyne's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=701 View this thread: http://www.excelforum.com/showthread.php?threadid=26649 ...

analytical accounting lookups should only show valid codes
When entering AA transaction distributions, the code lookup window should only show valid code combinations. It's not intuitive for the user to have to select a code and get an error message to discover which codes are valid. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the mess...

Outlook shows offline during dial up
Having a problem with outlook 2002. Over the WAN everything works fine. Dial up and connect to the network (VPN) internet work fine. Outlook will sync up however, a red x shows up in the bottom right hand corner. Outlook shows offline, I can send and receive but must hit send and receive. I have reloaded the computer from scratch and still have the same problem. Could it be a Excange setting? Any Ideas? Thanks for the help, If you hit File | Connect to Exchange Server what happens? -- Aloha, -Ben- Ben M. Schorr, OneNote-MVP http://home.hawaii.rr.com/schorr **I apologize ...

Show a blank result in a cell when there is no value in the "Lookup" cell
I apologize if this question has been asked, but I have been unable to find an answer searching the topics. I'm using the following formula in cell C3: =INDEX(LastName,MATCH(A3,EmpID,0)) When I type in an employee ID in A3, his/her last name shows in C3. However, when there is no value in A3, C3 shows error "#N/A". Is there a way to show a blank cell in C3 until a value is entered into A3? Thanks in advance! Mike On Aug 5, 10:45 am, "Michael Slater" <mslater...@comcast.net> wrote: > I'm using the following formula in cell C3: > =INDEX(LastNam...

Show Window
I am currently developing a MFC SDI application. I want to integrate a tray icon with it. When the application is minimized it hides by ShowWindow(SW_HIDE) and then when double clicked on tray icon shown by ShowWindow(SW_SHOWNORMAL). But the problem is if some other application is activated after my application is minimized, ShowWindow shows it but it's behind some screen. I have tried with SetFocus didn't work. Please help me to solve this problem. Thank you. Varuna Try BringWindowToTop. ---- Ajay Kalra ajaykalra@yahoo.com In addition to Ajay's idea you can also use SetFor...

Information Stores show dismounted yet mail is still flowing...
Background: Windows AD Mixed moded. Exchange 2003 installed on to a 2 node Microsoft cluster. 1 Front End server...connecting to the primary cluster node. Windows 2003 Standard on, FE Windows 2003 Enterprise Server on BEs (<---cluster) no service packs on either. Exchange has SP1 installed on both nodes and the FE. There are still Exchange 5.5 servers in the environment although they are not being used. The Issue: .....the information stores and public folders all show that they are dismounted...yet email is still flowing into and out of the server without any issues. I just...

reminder still shows up
when I run Outlook.exe /cleanreminders it simply opens Outlook, I am running Vista "Toppro" <Toppro@discussions.microsoft.com> wrote in message news:7AE8DBF7-6BE3-454A-82F9-5A040566026C@microsoft.com... > when I run Outlook.exe /cleanreminders it simply opens Outlook, I am > running > Vista Outlook version? The Windows version isn't as important and that of Outlook. -- Brian Tillman [MVP-Outlook] ...

Using ajax call to fetch multiple results from multiple queries and showing them 1 by 1 as the results comes.
Hello, I've 20 labels in a 2x10 table on a page. for each label, data comes by individual queries. (total 20 queries for the page.) and it takes about 30-40 seconds for the page to load, and it's not comfortable for the user to see blank page. I want that each cell will show loading.gif images. As and when data comes from query, the images should go visible=false, and the label should display the values one by one. How do I do this task using ajax? Some ASP.NET code example will be helpful for me, as I'm a kind of beginner. Thanks ...

Results show as a minus. WHY?
I have an application that was developed by another developer using VB.net which reside in a SQL table. I need to use some of the data from this table, however the data shows as -0.5 or - 0.99 or -1.70 etc in my Access tables. How can I get those numbers to show as a percentage with only one decimal point to the left? Example: 3.6% or 31.4 %. Any help would be greatly appreciated. No matter what I do it shows that dang "-" at the beginning. You can use the Abs function to strip off the negative Abs([YourTable].[YourField]) And you can format that as percentage either using th...

User Form
I am creating a user form. One of the fields is for the date of birth of the person being entered. The person being entered has to be between 14 and 16 on the date of entry. Is there a way to set up some type of validation so that if the person isn't between 14 and 16 an error message will pop up? If so, how? Thanks. There's a function called =datedif() that you can use. Select your cell (I used A1). Data|Validation Custom formula: =AND(DATEDIF(A1,TODAY(),"y")>13,DATEDIF(A1,TODAY(),"y")<17) First, take a look at Chip Pearson's notes at: http://ww...

difference in macro recording from 2003 to 2007 excel killing me.
Hello, I'm trying to figure out why there is a difference like this between excel 2003 and 2007. Perhaps there's a setting somewhere that I need to change. When I record a macro in 2003 to the personal workbook, that macro then works for me in every document that I open thereafter and try to run it in. In 2007 it seems to associate my selecting with the particular file that I record the macro in, so that when I go to run it later on a different report, but I want to do the same changes, it comes up with an error because it is searching for the selection in the other document name. ...

Creating scientific data collection form
Is access right for me? I am a natural resource and environment management specialist and I would like to create a data collection sheet for an ecological survey. I have used access in the past for data management, however, I am still a beginner. I understand that I can use access to create forms that can be used to collect and enter data. But I am not sure how to do this as it has been a while since I have used access. Are there tutorials available for this? I wish to collect scientific data on a number of ecological characteristics. Are there examples of forms that have been...

show comments when cell is highlighted Vs when cursor runs over? #2
How do you make the comments appear when the cell is highlighted opposed to when the mouse cursor runs over the cell? You can press Shift/F2, or Insert/Edit Comment. If you wanted to see it "automatically", when you select the cell, you'd need a macro, but I don't think this is what you're asking. Bob Umlas Excel MVP "Don" wrote: > How do you make the comments appear when the cell is highlighted opposed to > when the mouse cursor runs over the cell? To at least Excel 2000, if you have the Tools, Options, Comment Indicator Only you will see the co...

failed to restore full backup using ntbackup
hi everybody I tryed on my lab inviroment backup my xp (C:) partitian using ntbackup, then I changed ntldr file, the restore didn't work here is the report restore Status Operation: Restore Backup of "C:", Restored to"C: " Backup set #1 on media #1 Backup description: "Set created 12/7/2009 at 1:13 PM" Restore started on 12/7/2009 at 1:34 PM. Warning: File AUTOEXEC.BAT was skipped Warning: File boot.ini was skipped Warning: File CONFIG.SYS was skipped Warning: File IO.SYS was skipped Warning: File MSDOS.SYS was skipped Warning: File nag...

how to show numbers that begin with 0 in excel
I need to type numbers into an excel spreadsheet some of them begin with a zero some do not. How can I have excel show the 0 in the numbers that begin with 0. If I type 0236547 the number shows as 236547. I don't want all the numbers I type to begin with zero. I am using Excel 2003. Thanks very much for your help. Best regards, Dee use a custom format with how ever many digits you need, 000000 -- Gary Keramidas Excel 2003 "Dee" <Dee@discussions.microsoft.com> wrote in message news:EA60FC8A-C7CB-432A-B2B2-EEEBF86D2646@microsoft.com... >...

Comments not showing
When a SharePoint workflow is edited and a comment is added. The comment does not display in the workflow status screen under workflow history. It shows as follows: Task assigned to Andre Wessels was completed by System Account. Comments: Instead of: Task assigned to Andre Wessels was completed by System Account. Comments: Please update to the new company logo. This happens for all standard SharePoint workflows (Approval, Collect Feedback). Any custom workflows does show the comment. The comment field is update in the task item. It just does not show. There is no error in t...

Report Server shows 'Service Unavailable'
Hi, before install, the SRS setup, send me a warning, some like "the Windows Sharepoint Services are install and not permit initialize a Reportserver component" i skip wiht the installation, so.. I can't run http://<localhost>/Reports and http://<localhost>ReportServer show a message "Service Unavailabe", but the ReportServer service is running How initialize that or what do i do? ------=_NextPart_0001_09E699C9 Content-Type: text/plain Content-Transfer-Encoding: 7bit <Miguel@discussions.microsoft.com> wrote: > before install, the SRS set...

Using Mid Function with Pivot Table Calculated Item
Hi, I'm using excel 2007, I have a pivot table and I'm trying to create a calculated item, the formula for the Calculated item is: IF(MID('Project Title',7,1)="S", .20, .10) The Project Title field contains text and if the 7th character of the project title field is "S" I want the calculated item to return .20 otherwise ..10, but for some reason it is always returning .10. Am I doing something wrong here? Thanks. Simon ...

Show more time in weekly view?
Outlook 2007 On default the weekly view is only showing until 4 PM without scrolling down. I know there is a way to let you see into the evening hours also without scrolling. Help please. Thanks... Bob ...

How to change existing table record value by VBA and How to add new record in existing table by VBA
Hi all, I got table in my database with name "tbldata" and i have two fields in that table with the name "Ticket_No" and "Amount". In "Ticket_No" filed column i have value "SD001" and in same row of "Amount" column i have figure "50". With VBA how can i lookup for value "SD001" in "Ticket_No" field and change figure "50" to "30" which is appearing in same row of "Amount" column field. My other question is that how can i add new record in same table with VBA. I want...

TransparentBlt doesn't show the bitmap in ME?
The following doesn't print the bitmap on ME while it works on 2k/xp, can someone help me? Though the status returns TRUE. Thanks. Jiac. CDC *hdc, bghdc; CBitmap bgBitmap; BITMAP bmpInfo; //loads bitmap into memory bgBitmap.LoadBitmap(IDB_BITMAP5); // this bitmap has no needles // get bitmap info bgBitmap.GetBitmap(&bmpInfo); hdc = m_obj->GetDC(); bghdc.CreateCompatibleDC(hdc); bghdc.SelectObject(&bgBitmap); BOOL status = hdc->TransparentBlt(0, 0, 80, 80, &bghdc, 0, 0, 80, 80, TRANSPARENT_KEY_COLOR); //TRANSPARENT_KEY_COLOR if (st...

Showing a Null result
I have a parent table linked to several child tables via a unique text string The report shows reults from the main table, and has subreports for the child tables. Some records in the parent table have no equivalents in the child tables. Can I insert some code to produce the subreports with a "None" or "NA" text string, without populating the child tables with these terms? My problem is that, I need to run "counting" queries on the child tables, but the "N/A" records skew the numbers by adding records where there should be none. I'm not su...

mail box rights it only shows "SELF"
Once the user has been created, checking the Email address tab show nothing (empty), I pointing rus to the right DC, this solve that problem, but i have still have the next problem: under the mail box rights it only shows "SELF" where as all the other account show 8 or more system users? exchange 2003 Gr, Marco On Tue, 21 Feb 2006 13:10:27 -0800, "Marco" <Marco@discussions.microsoft.com> wrote: >Once the user has been created, checking the Email address tab show nothing >(empty), I pointing rus to the right DC, this solve that problem, but i have >...

Using Dynamic XML as a datasource of DataRepeater
Hi: I have a listbox which contains data such as EmpName and EmpID is the value. Once a Emp is selected it should be added to an XML ( it is not an XML file but can be XML string)...and it should check whether that Emp already exists... This dynamic XML should be datasource to datarepeater... and Emp can be deleted from XML until a Save button is clicked nd the XML is saved to Database. The whole thing is instead of saving the Emp data in a dataset .it should be stored on client side..thus saving the server trips... Any inputs will be appreciated.... Thnaks ...