Search Result

Hi, I have a form with a combo box. That cbo box has a simple qry which pulls in two fields, email and name.

I want to have two check boxes below the cbo box for view report and email report

below the check boxes I have a button for that report.

When I click what I want, for example email report. I choose a name from the combo box, click the email box and press the button. What I want to happen is that...

I am trying to put a text box on my form where I can just type in what I am searching for (I want to be able to type in information in the search box that may be on any field on the form; I want this text box to have the ability to search any field on the form without me using a combo box where I have to select the field then type in what I am searching for and I don't want to use the Wizard to create a search command that is basically CTRL+F). ...

I have set the Record Locked property to Edited Record so only one user can make changes at a time (using Access 2003). The circle with the line through it appears but everyone is freaking out that they can't make changes. The MS message doesn't appear that lists three choices which is fine because I don't want to allow them to do anything but move on to a different record until the person with the record open is done.

So, what I...

I have four tables in access 2003: T1 (8 fields), t2 (5 fields), t3 (7 fields), t4 (3 fields) all connected to each other with t1.a = t2.a, t1.a=t3.a, t1.a=t4.a (T2, T3 and T4 contains the FK for T1.
My program has a listbox with t1.a populated on it. When the user clicks on an "a value," it would search the database and populate the textboxes which are supposedly connected to the fields (distributed to the 4 tables).
My...

After running the following code:

Application.Imp ortXML _
DataSource:=str Path & strFile, _
ImportOptions:= acAppendData

I check the values in my table. None are seen.

This code works fine on a win xp box....

Any ideas are welcome...THX

I'm trying to create syntax that will allow me to find the max customer ID from the customer table and then add 1 onto it so that it is completely unique. I would like this to be generated automatically into my add customer form, any ideas?

I am getting an erro on line 11, OpenDatabase(Na me As String, [Options], [ReadOnly], [Connect]) I can leave the Options field blank, and it errors saying that the password is invalid, I am 100% certian that the password is correct, and if I leave it blank it prompts then errors. I have read countless articles, and reregistered the DLL's and even reinstalled office, to no avail. Anyone with any ideas that would be excellent.

...

In MS ACCESS version 2003 I have a form that is based on a table. I have indicated that I want the form to display the table content in the order of the tracking id number (InvoiceNumber) which is an autonumber field.

In detail view of my form, I select the upper left corner black box properties to get to:

Form - Properties
Record Source - Table1
Order By - Table1.InvoiceN umber

As the field...

I have one table with the majority of the information. This table holds the following:
SalesRep (lookup from another table)
Invoice Date
Date Paid
OE
Customer
NetSale
GP
Adj GP
Rate
Paid Amount
Paid in full?
Additional Notes
Commission Payout Date
Bonus Amount

I have a query that calculates the commission by multiplying the rate times...

I am new to working with Access 2003. I have created a query that counts the number in incidents by month (columns) by type of incidents (rows). The query works fine, except my problem is that if a particular type of incident had no activity for the year, that particular row does not show up at all. I'd like it to appear with all zeros showing by month. I've figured out how to show zeros in a particular month is the row does apprea if there is...

Basically I want to hit a button on the switchboard, it looks at a table (where data was previously entered). This table has yes\no check boxes and if all the check boxes are ticked it returns a positive result with a green textbox and if it's false it returns nothing (or a result with a red text box would be ideal)
I can get it to create the form dynamically but that's about it.
here's what I have so far:

The table...

I have a form that I am creating for an Access 2003 db (I'll call this "addform"). I go the form working as desired and decided to now call it from another form, which I'll call "callingfor m".

In addform, I do create a recordsetclone and do a Findfirst to get the desired record (I get the name off of a combobox) and fill in two text fields. This works well when I just work with this form directly.

...

I am begining to work on a VBscript to use inside a MS Access Query, so I started to do a little looking around the web to see if there was already a built-in VB function or at lease an example of one to convert a large number (6 sign. digits & larger) into SN (Scientific Notation) format for manipulation later within my script.

Example:
I can find all kinds of examples for...

I have an unbound listbox (list1) on my form.
Another unbound listbox (list2) that shows the totals of the values in the months in (list1)
I am trying to add a third listbox (list3) that subtotals the selected items in (list1)

I have multi-select set to extended to allow the multiselection.

I suspect I need to code something with the listindex and itemsselected?

Was hoping to copy (list2)...

I am building a database in Access 2003 with a included scorecard. In the scorecard, i am atttempting to offer a grade on the bottom, based on a relevant percentage. I will refer to this percentage as X. I have built another Table, which has three columns, grade name, lower limit, and upper limit. When X falls between lower limit and upper limit, I would like the query to generate the relevant grade name on that respective record. Is this possible?...