Access 2003

access 03 sending emails

I created a new database. with a data access page. when the person or persons are entering a new log i would like for access to send a e-mail to notify me of a new entry. I built a module to grab the fields i need to be sent. I just can't get it to work. Please help

Adding Serial Number to an already existing access document

Hi , I want to add a row of serial number for the existing records in MS access .Whenever I am trying to define a new row with type as "Auto Number" and save the same it automatically gets changed to Text type.Please suggest. Thanks, Ansh

Resizing Microsoft Access 2003 properties form

I recently installed MS Access 2003 SP3 on a new machine under Windows XP SP3. I find that I cannot resize the properties window when doing form design. The problem also applies to popup forms that I create. If I take the .mdb file to another machine, it works just fien. I have tried...

Temporary recordset in MS Access VBA

Hi, I am using MS Access 2003 as a front end to 2 Oracle databases. I am trying to retrieve a recordset from a database through ADO/DAO, display that recordset in a Form for users to make changes, and then write the records that have been changed to a different database (i.e. I don't need to make...

Access 2003 Form fields Sync

Hello, I am turning to you as a last resort :/ Here is the case, thought it looked simple to me at first... : I have a field which needs to be updated according to another field in a form according to the date in a table: Table contains [KEY, field1, field2] and the form uses to updated a...

Changing field format in Access 2003

We have an Access data base that includes date of birth in the format mm/dd/yyyy. For reasons I don't need to go into now, we have to change all of them to a different format - yyyymmdd. Is there a way of doing this without changing every individual record? This would save us hours of work. Thanks

Vertical text in MS Access 2003 report

I'm trying to create report headings that are perpendicular to the data fields. I have lots of fields with numbers and the headings fit on the page if they print at a 90 angle -- on a slant would be nice too. When I make a label (or text box) and change the properties to 'Vertical = yes' the...

Linked Server Question

I am trying to link an existing Access 2003 password protected database to a newly installed SQL Server 2005 Express database engine. I am using the ‘Add Linked Server Access MDB’ template in Management Studio to create the linked server. The linked server is created without error, however...

Problem with Microsoft Access 2003 write permissions

users have read and write permission to certain forms in the database but after loggin, they could not enter any data to the form,please could help,i checked users&groups account,users&group permission everything seem to be okay but still.is there something i over looked or have not done yet.

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...

MS Access 2003 write in SQL query to convert string to numeric

How do I write in SQL code in MS Access 2003 to create a query that converts a string into a numeric? Thanks

Update database when combo box value is changed

Hello, I am wondering how to update all the text fields, other combo boxes, and memo's when values are change in a combo box in MS Access 2003. For example, I have a form that when values are change of a combo box that has dates for every quarter. I want the values that I have set for the other...

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: Attribute A B C D E [Items Table] Serial Num Attribute 1 A 1 D 2 A 2 B 2 C What I want is a form where...

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...

converting text string to numeric

I am using Access 2003. I have a table with numbers that are shown as text data. I want to convert from text to numeric. Can this be done in a table or a query?

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...

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?

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...

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...

Adding new entries to a table via a combo box in a form

I have a Database for tracking conference attendance. Because of this I want to be able to both retrieve attendees and also adding new attendees. I have a form that allows me to retrieve attendees already input into a table via a combo box, but I can't add new attendees via that same combo box. ...