Search results

I have an area on my form for basic marketing information, with the following 4 fields: HowHeardAboutUs: (drop-down box can choose either online, friend, flyer) OnlineMethod: FriendName: FlyerLocation: Now, I want all the irrelevant fields to become inactive and state "n/a" depending on...

Great help, both of ya. I tried the "easier" way first as Pat mentioned, and it worked like a charm. 1) Create a main fom with 1 subform (main form being the client table, subform being the payment table) 2) Create one form based on income table. 3) Open the main/subform in design view...

Thanks a lot scschroeder, appreciated. I learned I had to make two subforms and one main form yest. Not sure how to build a form off a query, so I'm using the wizard (i'm a newbie to access). I have a new problem creating the forms though, thus new thread, still trying to figure out. See...

-- I'm trying to create a main form (based on the Client table) and two subforms (based on the two other forms). I followed instructions found, and used the wizard. The wizards steps seem to go fine up until the point AFTER i add all the 3 tables and their respective fields...when I click...

I've searched around and have the same problem... :( Did you figure it out?

Thanks a lot. This is really helpful info. I'll try some of these things and give you guys an update to what I do. Regarding the actual editing of records (as opposed to adding), Pat made a good point mentioning a human decision is needed whether or not to replace some of the data - sometimes...

Thanks for the help. The form seemed to show up blank because I did not have any data (for some of the fields) in some of the underlying tables fields. Basically, I have a form that has many fields from 3 underlying tables. Once I added data to the underlying tables, the form view does show...

Thanks for the help SJMcAbney and Tom, really helps. :) Regarding the database splitter, I'm assuming this is a function built into Access? I think this will work successfully in keeping the backend of the database untouched. Tom, was wondering if you (or anyone else) could elaborate a...

I think I'm having this same problem, except, when I create the form using the wizard, the form in form view is completely blank (only background is seen). The datasheet view is fine though. When I use the wizard and select only a few fields from each of my 3 tables, it looks and works...

Thanks, I wasn't aware of Briefcase. With seems with Briefcase it updates the actual file/folders that aren't synchronized, and replaces the entire database when there are changes. The only problem with this is, let's say my partner and I are updating client data for two different clients at...

I am not familiar with what features are available with access to solve this problem. Basically here's the scenario, once my database is completed it will be stored in a central desktop. I'll also have a copy in my laptop and my partner will have a copy in his laptop. A client calls us, we open...

I have a few tables linked together by a ClientID autonumber. I'm creating a form now with some fields from each of these tables. After creating the form with the Forms Wizard, I get a blank form (just see the background design), with no field names, or anything. I've searched on this topic...

Thanks, I understand more now. I followed the instructions below on relating tables, but still have a problem. First, here are the instructions I've followed. Close any tables you have open. You can't create or modify relationships between open tables. Press F11 to switch to the Database...

Here's the situation: I'm trying to relate two tables, a 1) CLIENT table, and an 2) INCOME table. I have made the primary key in CLIENT table as an autonumber (named CliendID). The INCOME table has ClientID and TaxYear as the primary key (two fields that form the primary key b/c each client...

Thx a lot for ur help, Pat and KenHigg. I've added a lot more fields/tables since last week. Re. my question above, I went ahead and created another table, with ClientID and Contact Year being the combined primary key for tables that have yearly changing data for repeat customers. Moving on...

Maybe I should just add a DATE field in the Income and Refund Amount tables, and for clients with multiple years, the Income and Refund Amount table fields will contain multiple records for that client? Is this the best way?

I'm still drawing it up actually, but something simple like this for example: Client Table: -email -firstname -lastname Client Income: -email -income Refund Table: -email -refund amount --Help appreciated.

-- Hi everyone, I'm a new user to access, so sorry if this question seems trivial. I'm trying to create a small database for a small tax firm. Basic scenario: Client database (email is primary key) with basic client info table, client income table, amount of tax return table. I have all the...