• Replace an Exsisting Table

    I want to make a Table in Access. I figured this out but how do I overwrite this table because obviously I don't want to make new tables again and again. Right now i have just implemented a simple table. Any help would be help. Thanks

    ProgrammingGal30 pointsBadges:
  • Creating a query in MS Access 2003 that converts text data to numeric from a table that has links to it.

    Creating a query in MS Access 2003 that converts text data to numeric from a table that has links to it. I have an idea on how to convert the text data to numeric. The problem is that I want to take text data from one table then temporarily create another table where the converted data will be...

    SacramentoSil25 pointsBadges:
  • Checkboxes with INSERT and DELETE actions

    I'm fairly novice with Access, though I know how to program in a variety of languages. I need to know how to do something in an MS Access 2003 Form. I have two tables:

    Trobertson5 pointsBadges:
  • vb 6.0 conect with access to create a report

    i have created a table in access to manage the house rent.i want to create report only for particular customer rent detail. the customer id is retrived from the table and stored in combobox in one form.when i choose particular id from the combo box, the respective details of the particular id...

    Aapabirami5 pointsBadges:
  • Using WildCards in IIF Statement

    Hi, I have a query that uses a field on a form to filter what information gets displayed. This is simple I know but what I need it to do is display all records if I don't enter anything in the field on the form. I tried putting the following IIF statement in the Criteria:...

    RoadDust390 pointsBadges:
  • Creating form with combo box to enter data

    I trying to create a form in an inventory database that uses a combo box to select size and depending on the size, use a text box with the quantity and have it populate the correct size field. If I am way off base, please suggest alternative.

    Cecee5 pointsBadges:
  • Passing Parameters in Access into Vb6.0

    How to pass Parameters in MS Access into Vb 6.0 and get the results through ado recordset

    Bijaybehera2915 pointsBadges:
  • Microsoft Access database too large – Can I divide my Access file?

    Im new to access and have been given a task to compile a data base, which i have very nearly completed, Im in the military and using a PC networked into a military system. However i found out whilst compiling the Database the system has many limitations, the Document has got to 1.99 GB now and will...

    Ukmale5 pointsBadges:
  • Writing vertical data to a flat (unfortunately!) table

    I have an application that I need to update (written by someone else) that requires that I take data from a nice, vertical table and write them into a pre-exisiting flat table. Column 1 of the vertical table is the PK for the flat table, while there are up to 35 entries that must be written into...

    Kingle15 pointsBadges:
  • mixed 2000 db and 2007 mixed datepicker results

    I had an old access database (2000) and ported it to access 2007 all well and good then created a new date field in my form, now i get the datepicker option for the new field but none of the old date fields. any ideas how to get access 2007 to give date picker to my old date fields, i have already...

    Jarcher1230 pointsBadges:
  • VBA to print to specific printer with print button

    In Access 2007 how do I use VBA code in my print button to print to a "specific printer" for my report.

    RPJ5 pointsBadges:
  • Microsoft Access 2007: Using an IF statement

    I want compare a field in one record to the same field but in the next record. For example I have this IIF statement: IIf(([MAILADDRESS]=[MAILADDRESS]),True,False) This will compare the MAILADDRESS in the same record but I want to compare that same field but in the following record. How do i do...

    Servent15 pointsBadges:
  • Excel to Access conversion

    When I import data from MS Excel v2003 into MS ACCESS v97, some of the data converts (numbers) converts to scientific form (4268411 converts to 4.26841e+006) even though I specify that the column format is text. How can I stop this from happening?

    QAMAN15 pointsBadges:
  • Migrating data from Microsoft Access to SQL Server 2000

    I want to transfer data from access to sql table and vice versa through windows service. so, plz help me.

    VBNET5 pointsBadges:
  • SQL Server 2005 or 2008?

    I am a database user going back many years and have used several different platforms from the high-end (NCR's Teradata) down to MS Access. I work for a Marketing Service Provider and we do alot of Marketing Database building with associated reporting and analysis and also use SAS for statistical...

    Habana5 pointsBadges:
  • Combo box question when developing a SQL database in Visual Basic 6

    I am developing a SQL database using Visual Basic 6 with ADO and Microsoft Access, but in it, I have a combo box with two options - yes and no. I want the combo box, after yes or no is selected, to open another form where a user can enter other details. How would I do this?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Navigation Pane

    In Access 2003, my database window showed me all my database objects. Now I have a navigation pane that I have to scroll through to locate things. Is there any way to display all the objects in my database at once?

    Medved5 pointsBadges:
  • User security based on table in database

    I am using Access 2003. I have a small (2 table) database. One table contains unit rework information. The second table contains User information(ID, FirstName, LastName, Security level). I built a form with a place for 3 users to 'sign off' - one for operators, one for supervisors & one for QA....

    Rbrown3805985 pointsBadges:
  • Complex Database Issue

    I'll try to be brief: I have excel files that are downloaded via ftp to a folder where I have my DB. each of the excel files is "roughly" the same headers, I want to import all of these files, filter out all but 3 columns and then filter out certain rows in each table (at minimum, 25 tables) can...

    Mreed725 pointsBadges:
  • Microsoft Access menus

    How do you setup menus using MS Access?

    Danljonessr10 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