Microsoft Access

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

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

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

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.

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

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

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

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

Using Access query data in Excel

I have a need to use some employee data that is contained in an Acess database in a dashboard like application in Excel. I have tried several attempts at getting this data but have not had any sucess. I can move the entire file, but I really need to move only the data that meets some selection...

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

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.

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

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.

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?

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?

Access/Word Mail Merge Currency lost digits

I made a Donations database which merges with a Word document that provides a receipt. The data that comes over drops zeros after the decimal. Ex: $700.00 appears as $700 ...Even worse $700.60 appears as 700.6 How do I get the decimals to show?

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