• Access Error importing data from Lotus Notes

    I have a user that is importing data from Lotus Notes into Microsoft Access and is receiving a Microsoft error. I've already verified with IBM that it is not a Lotus Notes issue in any form. Here is an explanation of the process and the error: How the process is done: Opens lotus notes does the...

    Drumradmin5 pointsBadges:
  • Edit data in an Access Form

    I have done this before, but cant get it to work in my new database. I have created a form that is based off a query in my database. I want my users to be able to type data into one of the fields on my form and the table driving the query will update with what they type. Every form I've created...

    Lydytunes20 pointsBadges:
  • Iseries Queries.

    Hello, I have a query schedule that runs Daily and looks for events for the previous day and, it's access in access database, but on Mondays I don't get anything because is set for previous day and Sat and Sunday overwrite the query so I get ZERO results. I've set for YESTERDAYX. How can I change...

    Querys100 pointsBadges:
  • Microsoft Access 2007 Data Input & Report

    I am given a Start date 1/3/09 and an end date 1/5/09. 3 days. I am given 1 of 4 Codes (I, C, V, O). How do I get Access to show one of the predetermined codes under a monthly calendar starting day 1 through 31? ie., Rec# Jan 1 2 3 4 5 6 ** 1 I I I 2 C C 3 V V With the 3 pieces of information...

    PD15 pointsBadges:
  • Export Access to Outlook

    Is there a simple way to export an Access Database to Outlook? There seems to be an export to Lotus 123 but not one for Outlook, am I missing something?

    Msquared1110 pointsBadges:
  • Look at query results & pass a value to form in ACCESS 2003

    I need to be able to look at the results of a query & based on the values in one field (?) on a subform/table enter a Pass/Fail value to the main table. Here is a basic breakdown of what I have: t_Main: table defining dimensional layout requirements. There can be multiple parts of the same part...

    Rbrown3805985 pointsBadges:
  • Crystal Reports can’t connect to Access 2007

    We have just upgraded from Access 2003 to Access 2007 and CR-XI can not see the dB's. I think it is the new file extensions with Access 2007. Anyone know how I can connect and see the dB's.

    Rcsully6515 pointsBadges:
  • AS400/iSeries Queries on a schedule

    I have several queries that I run daily manually, I will like to know step by step how can I have my queries to run on a schedule using the SBMSCHJOB command, then I will like to export them to Excel or Access.

    Querys100 pointsBadges:
  • Access Database – Colorize one word or letter

    How do I colorize one character in a field in a table? I want the letter "O" to be in red for one customer and blue for another customer in the same column but different rows.

    BethG5 pointsBadges:
  • Microsoft Access 2007 Query/Report Calculated Fields

    I have a table with customer estimates and sales. I need a report to reflect the closure rate by total number of jobs within a given section (in this example subdivided by lead source). Each job can have multiple records. I need to get the % based on grouping estimates for specific jobs. (7...

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

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