Question about Microsoft Office Access 2003 (077-02871) for PC

1 Answer

Record number using DAO

How to determine the current record number in a recordset using VBA with a DAO connection?

Posted by on

1 Answer

  • Level 1:

    An expert who has achieved level 1.

    Hot-Shot:

    An expert who has answered 20 questions.

    Corporal:

    An expert that hasĀ over 10 points.

    Mayor:

    An expert whose answer gotĀ voted for 2 times.

  • Contributor
  • 39 Answers

CurrentPosition = recordsetName.AbsolutePosition +1

Posted on Feb 06, 2009

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

Tip

Getting the highest value in a column less than some other value


This is good really for SQL Server, Oracle, or anything that can handle SQL.

Most hacks know about MAX(), as in:

SELECT MAX(col_name) FROM table

So if the column has a max value in it of 10, you get 10 back. But what if you want the highest value in the column that is less than a certain amt.? This for example is good for getting back the next most recent record when col_name is an incrementing key column and you want to exclude the most recent record (ID'd by it having the current maximum value key) in the column. Now you are faced with writing an SP or egad, traversing a recordset client-side. Ugh.

Here's the fix:

SELECT MAX(col_name) FROM table WHERE col_name < {some_value}

This works. It works even when the key column is not guaranteed to have continuous sequential values, such as when records are added and deleted over time and the key values assigned all stay the same (which is what happens in 99.9999999+% of all cases).

Have fun.

Homework: Haven't tried it but I am betting you can also do this:

SELECT MAX(col_name) FROM table WHERE col_name < MAX(col_name)

Whoa... well, try it and see if it works. Some SQL interpreters don't like aggregation/sub-computational functions on the right side of the comparator. In that case, you'd get MAX(col_name) first with a simple SELECT stmt., assign it to a variable, then use that variable as the right hand side modifier for the '<' comparitor.

Seems simple, right? But oh, the pain these kinds of situations cause. Hope this helps some of y'alls.

on Mar 26, 2008 | Microsoft SQL Server Enterprise Edition...

1 Answer

Layout/Printing issues


FileMaker 5.5 is a long time ago for me, but I think I will try to answer your question (although it is likely you have a solution or no longer need one.) While in layout mode, while working on the layout, go to printer setup and choose the printer and page size you will be printing to. This will cause FileMaker to have a dashed line where the printer pages are on the layout. Anything that extends over these lines will require additional pages to print. Simply bring everything back in before these lines to limit to 1 page (including the blank space at the bottom of the page. There is a tab you will need to drag above the page break line to prevent a second page from printing. Additionally, if you cannot work it out, while printing from FileMaker if you choose the page range of 1 to 1, only 1 page will print, however, doing this prevents you from printing additional records without writing a script to do it. However, if you are able to redesign the layout to only print 1 page then you will notice there is an option on the print dialog box that indicates something to the effect of "Print current record" and "Print records currently being browsed" (Don't remember the exact wording in FileMaker 5.5); Choosing the records currently being browsed option will print all records in your current found set.

I hope I've done a good job answering your question. I am a FileMaker expert for version after 7 and have used Filemaker since version 4; if you have any additional questions I will do my best to answer them. If my answer was helpful for you I'd appreciate a 5 thumbs up rating, or a click on the yes this was helpful button. Thank you!

Apr 06, 2009 | FileMaker Server 5.5 (540100U) for Mac, PC

1 Answer

HIGHLIGHT THE CURRENT ROW


Hi Rakesh,
in MS Access 2003/2007, the first record is always highlighted in table as well form's text controls when they connected to a database. In a query cursor is always at last record.

In flex-grid control you can set its properties to get cursor on a particular records.

I think your problem is solved.

Please contact if not.

Zulfikar Ali

Mar 07, 2009 | Microsoft Access 2003 for PC

1 Answer

How to make macro using the VBA


You can "record" a macro and look at the code or write one yourself. To see code, you'll need to open the VB Editor using <ALT+F11>. You may also enable the "Developer "tab in the Ribbon using the Options dialog and going to the "Popular" tab. From the Developer tab you can access the VB editor. From this tab you can recod a macro too.

Feb 23, 2009 | Microsoft Office Professional 2007 Full...

1 Answer

Increment a number per record in Microsoft Excel


For what you are talking about doing, Microsoft Access would probably be a better option. With Microsoft Access, you can create a custom form and have it automatically give a number.

More information about Access:
http://www.bcschools.net/staff/AccessHelp.htm

Dec 18, 2008 | Microsoft Excel for PC

1 Answer

Excel


Egad. Well, first off, I'd suggest splitting the document up if you can. The chances Excel will crash on all those records is pretty good.

Next, you'll need to use VBA I think. Do you know any VBA? I am guessing you probably don't. Anyway, I can't go into it all here, but I'd suggest you snag a local with some VBA skills and then point him or her to this:

http://www.automateexcel.com/index.php/2004/08/14/excel_vba_macro_to_autofill

Jun 11, 2008 | Microsoft Excel for PC

1 Answer

Writing macros


Anirbanmj

Macros for Excel and the rest of the office suite are based on Visual Basic for Applications (VBA) which is a subset of VB programming language.

If your not familier with this language then i would suggest "Googling" VBA Introduction or similar and have a look at some introductory info. If you are ok with VB then you can record doing a task you want to do and then look at the code generated to see what it has created.

Feb 02, 2008 | Business & Productivity Software

1 Answer

Macro on excel


Macros are a timesaving feature that allow you to record a sequence of actions that you do in excel, and replay them back later.

You give each macro a name, and you can invoke them later, and Excel will "do" whatever it is you did when you recorded the macro.

To record a new macro:
1) Open Excel
2) Go to Tools->Macros->Record New Macro...
3) Type in a name for your macro and hit OK

(A new toolbar will popup with a "stop" button on it. Excel is now recording everything you do)

4) Do something, like, for example, select some cells and make them bold.
5) Click the "stop" button.


Now your macro has been recorded! You can play it back later by:

1) Open Excel
2) Go to Tools->Macros->Macros...
3) Select your macro from the list
4) Click "Run"

The actions you performed earlier will now be executed.



-------


Macros are written in Visual Basic for Applications, or "VBA". It is a programming language which uses the Excel Object Model to perform various actions. You can edit and create custom macros by writing the code manually in VBA. To do this:

1) Open Excel
2) Go to tools->macros->macros...
3) Select an already existing macro
4) Click "Edit"

(The visual basic editor will open, showing you the code for your macro)

At this point you are writing a program in Visual Basic. To learn how to edit macros, you need to learn visual basic, as well as the specific quirks related to excel macros in visual basic.

Recording a macro, and then using it as a template while you edit it is a common trick for making macros manually more quickly.

If you are not familiar with VB, I would not suggest attempting to edit your macros in any but the most simplest of ways. If you're brave, you can try to learn about editing macros in VBA here:

http://www.anthony-vba.kefra.com/

Jan 28, 2008 | Business & Productivity Software

1 Answer

MS Access 2003 Development - Format Problem


Hi, the difficulty to solve your problem is that we are not familiar with Appx. I have faced this problem numerous time, but usually it was from Excel to Access. Now if you can transfer it to Excel then you can change the format in Excel to Text and import it into Access. I have also read a little of the Appx manuals and it says there that you can work with ODBC, are you using it? ODBC will create a connection between the APPX application Database and Access, you should be able to do your queries directly from the ODBC connection without the need to import the table. Here is a PDF manual of how to set it up from their website: http://www.appx.com/ftp/appx/documents/manuals/appx/appxodbc/current/appxodbc-manual.pdf I hope it helps, let me know and I will try to do my best to solve your problem. Daniel

Aug 10, 2007 | Microsoft Office Standard for PC

Not finding what you are looking for?
Microsoft Office Access 2003 (077-02871) for PC Logo

Related Topics:

117 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18298 Answers

Sudeep Chatterjee
Sudeep Chatterjee

Level 3 Expert

3267 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...