Search results for query: *

dalenz, thanks.

Actually, we have multiple newsletters. Form works, drop down with newsletter choices, once the choice is made, you then have an subscribe check box and an unsubscribe check box. Let's say someone subscribes to letter 1, drop down letter 1, check subscribe, a week later they unsubscribe, go...

P, we not only want to see contacts who have subscribed, but those who have unsubscribed as well.

Ok, I have a newsletter field then Subscribe/Unsubscribe check boxes. I need to make it so if you check one box, you can't check the other. Does this happen in the table or form, and how? Thanks!!!

I have a table called ItemOrders, it has ItemID ItemName and ContactID. I built a form with a drop down box so that data entry can be done by selecting which item has been ordered, I need to be selecting the ItemID, BUT I need the ItemName to show in the drop box for data entry, how do I make it...

Ok, I have a database that consists of a Contacts table (general contact data). I have three other tables, Items which consists 10 items contacts can order (free)...this is yes/no check box. Another table for trainings attended. Last table contains a couple newsletters contacts may sign up for...

We had to uninstall/reinstall Access on the machine.

Yes.

We have an Access database on a shared drive, on one machine (in the entire company) I cannot open the report in the database..I can open the table and form in the database buy I cannot open the report. What could cause this? Again I can open the report from other machines without problem...

I have multiple Companies and a revenue for each, in my report I need to include the sum of all revenues at bottom...do I use a text box, if so, how do I make it add all of the revenue...please help....thanks!

Anybody???????

This updates 0 rows and I still get the parameter pop up form.

Anybody?????...help....tryin to update a blank field in one table with the data in another...tables have matching Work Orders, Company IDs.

Yes

Ok I entered this, just as shown: UPDATE tblconsulting INNER JOIN tblsalescredit ON tblconsulting.[WorkOrder] = tblsalescredit.[WO#] SET tblconsulting.SlsCrRev = tblsalescredit.credit I get the Enter Parameter form for "tblsalescredit.credit" if I just click ok....and continue it says I am...

Ok....I am a newbie, I enter the above into SQL Data Definition just as written?

I have two access tables both contain a field that contains a Work Order #....tblconsulting contains work order numbers that may or may not be in tblsalescredit ....I need to update a field called SalesCredit in tblconsulting with the data in a field called credit in tblsalescredit according to...

Both tables contain the same work order # in the the field name WorkOrder. Table consulting contains a field called SalesCredit and table SalesCredit contains a field called SlsCredit. I want to update field SalesCredit in table Consulting with the data in field SlsCredit in table SalesCredit...

Can't get this to work.....thanks anyway. Anybody have any other ideas of how to get this accomplished?

I an fairly new to Access....so I do this in the query design grid?