• Return nth record

    I have a db where I can not change any data type (they are all text). I want to retrieve every 237th record.

    Clockwatcher25 pointsBadges:
  • Access 2007 Query Help

    I need some type of statement that will check my query results for a number in a field and then remove any instance of this item from my query. Example: I have multiple books in a table and I have an identifier field (1 = English, 2 = History, 3 = Science, etc...) where it can cause one book to...

    ThisGuy5 pointsBadges:
  • How to connect Access database to a Visual Studio 2005?

    i use the following code to connect and i created DSN but its not getting connected... whats my fault can anyone help me?? Dim X As ADODB.Connection Dim RS As ADODB.Recordset Dim RS1 As ADODB.Recordset i am getting underlined error in adodb.connection, adodb.recordset i think there is some error in...

    Rajeshbnp20005 pointsBadges:
  • FAQ Database

    how do you build a FAQ database using Microsoft Access?

    Farkaska5 pointsBadges:
  • Unexpected error number in Visual Basic 6 and CR8.5

    Iam using VB6.0 with CR8.5 and backend as MS Acess. During setup creation it gives me an "unexpected error number 28 has occurred.Out of Stack space". plz help me out with proper solution Thanx in Advance...

    Ashutoshpatilak10 pointsBadges:
  • Pivot Table Error Field Message

    I have a pivot table in my spreadsheet that is linked to an access database. When clicking on the refresh data button at the top toolbar to refresh the data in my spreadsheet from the new data hitting the access database, I receive an error message stating "The Pivot Table field name is not valid....

    Buckeyes0810 pointsBadges:
  • How can I set the default to be on current date when form loads

    I’m using Microsoft Calendar Control 9.0 in Visual Basic 4 and would love some help on getting the calendar to show current date as the default date when it loads. Every thing else seems to work just fine, but I can’t get it to default to current date, it seems to be stuck on the date that the...

    TheFinder1,940 pointsBadges:
  • MS-Access like Combobox in VB6

    Need to create a combobox in a VB6 form having the following properties 1. It will populated from a table/query. 2. It will bound to a table and the selection will be stored in that table. (as access) 3. It will allow typing a data that is not in the list.

    WhoKnowsNothing15 pointsBadges:
  • Access 2003 report printing

    We've been using Access 2003 for a while and are now changing over to 2007. At the same time, I am creating a new report to replace a report we've used in a database successfully for several years. I open the new report, and it looks perfect on screen, then I print it using the printer icon. The...

    tlsanders11,340 pointsBadges:
  • MS Access Automating switch from Edit mode to Navigation mode.

    MS Access, I'm looking for a way through code, property or expression, to emulate F2 key. In other words, as you tab through fields in an Access form to have the cursor enter those fields in edit mode (insertion point at beginning of field) instead of navigation mode where the whole field is...

    Pwcky40 pointsBadges:
  • Search a specific file in Visual Basic 6

    Hello, I am using a vb6.0 and ms access in database, in my search button, i want to display a record a record that very specific, will u plz help me this....

    Tlosom55 pointsBadges:
  • Set Down Arrow Action In Microsoft Access

    Hi, I was wondering if there was a way to set when the down arrow is pressed on a Continuous Form in access that it goes to the next record and not the next field. Any suggestions would be great. Thanks, Dustin

    RoadDust390 pointsBadges:
  • Pass data from Access subform to another form

    In Access - How do I select or pass data from a subform to another form? I can pass the data back to the main form, but I want to pass to the subform data to another form

    Bdbarnes5 pointsBadges:
  • MS Access Report modifications

    I am using MS Access 2007. I am trying to modify a report and I want to delete the label in the page header section but not the detail field. I cannot find a way to detach the label from the detail field

    Heymon20 pointsBadges:
  • Converting from Access 2003 to Access 2007

    hi, everyone i have 3 desktop with Access: one have Access 2003 two of them have Acess 2007 so i divide my Access database in two parts on of them have tables an other a form queries, etc. My problem is, is possible link tables for these three desktop's. because of that diference i convert for two...

    BUG68235 pointsBadges:
  • How to connect Forms 6i with MS Access

    Can anyone help me in connecting the Oracle Forms 6i with Microsoft Access Database. Please send me an example also, so that i may be understood properly and clear my logics tooooo. Best Regards Rashid Shah

    SuperRad40 pointsBadges:
  • Software application to build database

    I'm Planning to build an application to store/update and retrieve data (say employee details) Could you please suggest me the best frontend and backend technologies to build this application?

    Serenechennai5 pointsBadges:
  • Print Preview and Printing Drops Pages from Reports

    WE have been using the same ACCESS Database for 7 years.  Suddenly, worksheets and reports that have always printed out perfectly are not dropping entire pages; for example, if there are five pages of information, it will drop page 2-3-4 but print page 1 and 5.  What would cause that?

    Analyticalminds5 pointsBadges:
  • How to pick a source for a subform in Access 2003?

    I have 3 different DB-s, I am working with. I have no problem linking the data in. The user is in DB-a. My problem is I need the little bit of tricky code to check my DB-A's plainid the DB the user is in. To check the DB-A's planid against DB-B' plainid then use the data to fill a sub-form. If...

    Techexpressinc10 pointsBadges:
  • Get the latest unique entries for user ID in Access database

    I have a database with a table that lists message entries. Each entry has an autonumber field ID, and a UID field that groups messages. My question is, how can I get the latest entry for each UID? Example Table: ID UID Message 1  1     Some Text 2  2     More Text 3  1     Message...

    Steveo2255 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following