• Access 2003 Chart creation, scatter plot

    I am looking to create a scatter plot in Microsoft Access with independent x and y values. For example: x       y 0.3035 0.3300 0.3023 0.3249 0.3032 0.3283 I can't seem to find a good way to do this within Access... Any help is greatly appreciated.

    Apog5 pointsBadges:
  • barcode entered, still dlookup not populating “item” and “price” in the form

    I have two tables, one is "inventory" and the other is "sale". I created form using the fields from "sale". in the "inventory" table, I saved barcodes of all items. Here, I want the form to populate the "item" name and "price" of the barcode I enter in the barcode textbox of the form. Currenty, it...

    Akarimfox5 pointsBadges:
  • Windows XP virus Query!

    Hi there, I actually has 2 problems! I`m running Win xp with service pack 2!Mcafee virus scan 2004 Home Edition! 1.Each time i reboot my pc it doesnt load the explorer shell!Only the background is visible but nothing else!What i then need to do is open Task Manager - Processes - and end...

    Wazzup0 pointsBadges:
  • Compressing Old Files

    Hello, I would like to know the option(Compressing Old Files) which comes up during disk cleanup in win XP and win 2000. Is it good or bad? I mean, If I do the compression regularly will that effect my system/files in a long run? Is it same to that option (compress drive to save space) in disk...

    BinooDas123410 pointsBadges:
  • Access 2007: VB code to make a button press link to a specific record in another form

    The database is for a set of components. One of my forms shows details about each component on a separate record (the property "Default View" is Single Form). The other form is a list of all components by component number displayed all together (the property "Default View" is Continuous Forms). The...

    VinDibo5 pointsBadges:
  • MS-Access data inserted in to Oracle 11g CLOB

    I have an old MS-Access database storing data in bullet point format. I need to transfer this data across to an Oracle 11g EE database version at the same time maintain the MS-Access formatting.  How do I go about this?

    Sgafair5 pointsBadges:
  • 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:

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