Search results

Thanks, that helped.

Hey guys, It's been a while since I was last here, but I need to scratch your brains for some advice. Some background info: I have a table named tblCompanies. In this table, there is a field named BeenContacted. The BeenContacted field is a checkbox on my form so would take a Yes/No value. My...

Solved the issue. I didn't have child and master links set up. I can't believe I didn't see that before posting.

Hey guys, I have two forms each saving data in the same table (tblCompanies). On each form there are 3 subforms. On "FormA" everything works perfectly. On "FormB" one subform (frmProgress) is stuck on the same record. I have frmProgress on FormA too with no problems. By 'stuck', I mean that...

Hey guys, I'm very new to reports, and hope you may have some advice for me: I have a form with comboboxes each relating to a field (some in different tables). I then have a button which will open a report (which I haven't made yet; or rather which I made, remade and deleted over and over)...

I'm still a newbie here, would you mind dumbing your last statement down a little bit.

Thanks Bob for your quick response. I have done as you recommended, and all is in working order (no errors); however my issue is not altogether solved. How would I be able to allow the user to select multiple campaigns and capture the users choices? I could use many checkboxes (one for each...

Hey guys, Some background: I have a table named tblCampaigns (which has a list of campaigns offered, format is text); another table CompanyParticulars has a field named Campaign. In the CompanyParticulars table, the Campaign field is set to lookup values from the tblCampaigns. It allows...

Amazing! Thank you, that's been bugging me for days!

Hey guys, I have a form (for reference purposes call it "frmMain") on which I have placed various buttons; each linking to another form. My main form has a Payments button linking to a Payments form and a Meetings button linking to a Meetings form. On my main form I have 3 subforms (not sure...

Another piece of information (although I am not sure as to its relevance) is that there are 4 types of companies. In my master-form, if it is of Type A, B certain aspects of the form are revealed; and similarly if it is of types C or D. I didn't think this was relevant to the question, but I...

Thanks for your quick response. Some more information to add light to my issue; I have a table named Companies. In this table, there is a Category and Type field. I have both types of companies in the same table together with their category. Seeing that I already have a Type field in the...

Hey guys, I have a field on a form called Type. I then have another field (named Categories) in a subform. What I am hoping to achieve is that depending on the value of Type, the Categories value will change. Categories is a combobox of values. These values are stored in two separate tables...

Yeah, that could work. Will give it a go.

Thank you, well worded. It works like a charm. On a side note, I have a combobox and was wondering if it is possible to have the contents divided into two sections. Each section would then be sorted alphabetically in its own right. For example, the contents of the combobox could be as follows...

Hey guys, Does any one know if it is possible to use the standard/built-in navigation in access (I have access 2007, but the question is valid for other versions), but omit certain records as you navigate? I have a field: "companies" which falls into two types, for reference purposes call them...

Thank you both for your quick response. I apologize for not using a mdb file. It is attached. I'm sorry, I am not understanding you as well as I'd like; Are you suggesting I make a new form? At the moment I have this code: Private Sub NameOfCompany_Change() BeenContacted =...

The two forms are named "frmEditCompany" and "frmAddCompany" the others are used as subforms...

Hi guys, I'm new to Access. I have had experience in designing tables and queries but that is as far as it goes for my "expertise". I now find myself trying to make 2 forms - one to enter info and the other to update the current info already stored in the database. I have the tables, and the...