Add a specific Record to a Table based on a check box

I have a Table called ServiceTypes. Based on a User's input on a 
ProposalForm, ServiceTypes need to be added to a ProposalServicesTable.

For instance, I have a Check Box on the ProposalForm. When a Check Box is 
clicked Yes, Access must search the ServiceTypes Table, select a specific 
ServiceTypeID, and add the ServiceType to the ProposalServicesTable.

How can I add the proper Service record from the ServiceTable to the 
ProposalServicesTable based on the Check Box?

0
Utf
12/13/2007 6:46:01 PM
access.formscoding 7493 articles. 0 followers. Follow

4 Replies
1383 Views

Similar Articles

[PageSpeed] 40

I wouldn't do it that way. I'd use a listbox (with multi-select set to YES) 
that was sourced to the ServiceTable. I'd allow the user to select as many as 
he wanted, then build a string to populate the ProposedService table. I'd 
probably just use the codes associated with the service name(s), and build 
the list of services at report-time.

"Jazflux" wrote:

> I have a Table called ServiceTypes. Based on a User's input on a 
> ProposalForm, ServiceTypes need to be added to a ProposalServicesTable.
> 
> For instance, I have a Check Box on the ProposalForm. When a Check Box is 
> clicked Yes, Access must search the ServiceTypes Table, select a specific 
> ServiceTypeID, and add the ServiceType to the ProposalServicesTable.
> 
> How can I add the proper Service record from the ServiceTable to the 
> ProposalServicesTable based on the Check Box?
> 
0
Utf
12/13/2007 9:44:01 PM
The problem with your suggestion (unless I am missing something) is that the 
User doesn't know what service he needs (they are technical in nature). I am 
trying to use a standard english questionnaire to enable a technical services 
selection from a table....I appreciate your response.

"Dennis" wrote:

> I wouldn't do it that way. I'd use a listbox (with multi-select set to YES) 
> that was sourced to the ServiceTable. I'd allow the user to select as many as 
> he wanted, then build a string to populate the ProposedService table. I'd 
> probably just use the codes associated with the service name(s), and build 
> the list of services at report-time.
> 
> "Jazflux" wrote:
> 
> > I have a Table called ServiceTypes. Based on a User's input on a 
> > ProposalForm, ServiceTypes need to be added to a ProposalServicesTable.
> > 
> > For instance, I have a Check Box on the ProposalForm. When a Check Box is 
> > clicked Yes, Access must search the ServiceTypes Table, select a specific 
> > ServiceTypeID, and add the ServiceType to the ProposalServicesTable.
> > 
> > How can I add the proper Service record from the ServiceTable to the 
> > ProposalServicesTable based on the Check Box?
> > 
0
Utf
12/13/2007 9:49:02 PM
So if I understand you, you have extended text at each checkbox (or ToolTips 
enabled) to assist the user in determining which service(e) he needs? 
Assuming that's true, I'd still build the responses into a single field in a 
table.

For example, I recently did a Security Incident database. In that, one of 
the tables was dedicated to "Suspect". Part of the suspect table was "HAIR". 
Well, there are lots of things associated with hair: Long, Short, Brown, 
Blonde,Grey (etc), Facial-beard, Facial-moustache and the like. So I built a 
string based on the checkboxes that might look like this:

Short;Grey;Moustache

Then I placed that string into a single field in the Suspect table. In the 
report, I broke the string out into its component parts for ease-of-reading.

That make sense?

"Jazflux" wrote:

> The problem with your suggestion (unless I am missing something) is that the 
> User doesn't know what service he needs (they are technical in nature). I am 
> trying to use a standard english questionnaire to enable a technical services 
> selection from a table....I appreciate your response.
> 
> "Dennis" wrote:
> 
> > I wouldn't do it that way. I'd use a listbox (with multi-select set to YES) 
> > that was sourced to the ServiceTable. I'd allow the user to select as many as 
> > he wanted, then build a string to populate the ProposedService table. I'd 
> > probably just use the codes associated with the service name(s), and build 
> > the list of services at report-time.
> > 
> > "Jazflux" wrote:
> > 
> > > I have a Table called ServiceTypes. Based on a User's input on a 
> > > ProposalForm, ServiceTypes need to be added to a ProposalServicesTable.
> > > 
> > > For instance, I have a Check Box on the ProposalForm. When a Check Box is 
> > > clicked Yes, Access must search the ServiceTypes Table, select a specific 
> > > ServiceTypeID, and add the ServiceType to the ProposalServicesTable.
> > > 
> > > How can I add the proper Service record from the ServiceTable to the 
> > > ProposalServicesTable based on the Check Box?
> > > 
0
Utf
12/13/2007 10:16:00 PM
Thanks Dennis, I will see if I can implement your suggestion in my context. I 
appreciate it.

"Dennis" wrote:

> So if I understand you, you have extended text at each checkbox (or ToolTips 
> enabled) to assist the user in determining which service(e) he needs? 
> Assuming that's true, I'd still build the responses into a single field in a 
> table.
> 
> For example, I recently did a Security Incident database. In that, one of 
> the tables was dedicated to "Suspect". Part of the suspect table was "HAIR". 
> Well, there are lots of things associated with hair: Long, Short, Brown, 
> Blonde,Grey (etc), Facial-beard, Facial-moustache and the like. So I built a 
> string based on the checkboxes that might look like this:
> 
> Short;Grey;Moustache
> 
> Then I placed that string into a single field in the Suspect table. In the 
> report, I broke the string out into its component parts for ease-of-reading.
> 
> That make sense?
> 
> "Jazflux" wrote:
> 
> > The problem with your suggestion (unless I am missing something) is that the 
> > User doesn't know what service he needs (they are technical in nature). I am 
> > trying to use a standard english questionnaire to enable a technical services 
> > selection from a table....I appreciate your response.
> > 
> > "Dennis" wrote:
> > 
> > > I wouldn't do it that way. I'd use a listbox (with multi-select set to YES) 
> > > that was sourced to the ServiceTable. I'd allow the user to select as many as 
> > > he wanted, then build a string to populate the ProposedService table. I'd 
> > > probably just use the codes associated with the service name(s), and build 
> > > the list of services at report-time.
> > > 
> > > "Jazflux" wrote:
> > > 
> > > > I have a Table called ServiceTypes. Based on a User's input on a 
> > > > ProposalForm, ServiceTypes need to be added to a ProposalServicesTable.
> > > > 
> > > > For instance, I have a Check Box on the ProposalForm. When a Check Box is 
> > > > clicked Yes, Access must search the ServiceTypes Table, select a specific 
> > > > ServiceTypeID, and add the ServiceType to the ProposalServicesTable.
> > > > 
> > > > How can I add the proper Service record from the ServiceTable to the 
> > > > ProposalServicesTable based on the Check Box?
> > > > 
0
Utf
12/13/2007 10:43:03 PM
Reply:

Similar Artilces:

Unbound form/Add rows
Hello. I have an unbound form. I want to know if there is a way I can add rows to the form in the same way a bound form works. So, when I start a new record in the last open row, I want a new row to add to the end of the form, so I can always add a new record. I have the form unbound because I do not have the data enter into the table until after I finish working on all the information in the form. Thanks You can't have a new "record" on an unbound form because, in fact, you don't have any "record," just a bunch of textboxes you've filled in! When people wa...

SEARCH BOX
First thank you in advance for any help. I want to put a search box on the first sheet of my program to enter data, either a name or an assigned number, and have it search for and go to that line of information on another sheet. Can I do this or do you have another suggestion? This should do it. Change sheet name and column numbers to suit Sub nameornumberfind() With Sheets("sheet34") mv = InputBox("Enter name or number") If IsNumeric(mv) Then 'MsgBox "number" mc = 4 Else 'MsgBox "text" mc = 1 End If Set mf = .Columns(mc).fi...

sent mail appears in my in-box
How can I change settings to prevent e-mail that I send also going to my in-box? Thank you in advance Under Tools->Options->Preferences->Email Options->Advanced Email Options, do you have the box checked to save mail in the same folder? Do you have any rules that affect mail after it is sent? --� Milly Staples [MVP - Outlook] Post all replies to the group to keep the discussion intact. After searching google.groups.com and finding no answer: TopCat <topcat@vettenut.com> asked: | How can I change settings to prevent e-mail that I send | also going to my in-box? | | Tha...

Running Access Query Returns Incorrect Number of Records
I am running some code which loops through and runs the queries in an Access Database. The count of the records is then stored in a Worksheet. For most of the queries, the figure stored in the Worksheet matches the number of records if you run the query in Access. But for certain queries, the count of the records does not match the number of records when the query is run in Access. If I change the query to a make table query and then base another query on that table, the results are correct. Can anybody suggest running the query from Excel would results in a different number of records bein...

CPropertySheet create failing when adding to dialog box
Hi all, I am having problems with a class that I made that inherits from CPropertySheet. I need to add this class to a dialog box with the following code: m_appPropSheet.AddPage(m_saleIllustrationPropPageClientOne); m_appPropSheet.AddPage(m_saleIllustrationPropPageClientTwo); m_appPropSheet.Create(this, WS_CHILD | WS_VISIBLE, 0); m_appPropSheet.EnableStackedTabs(FALSE); m_appPropSheet.ModifyStyleEx (0, WS_EX_CONTROLPARENT); m_appPropSheet->ModifyStyle(0, WS_TABSTOP); m_appPropSheet.SetWindowPos(NULL, 0, 25, 0, 0, SWP_NOZORDER | SWP_NOSIZE | SWP_NOACTIVATE); ...

Managing Data Table
Hi, I need help to wrap the tex in Data Table. If any one knows how to do it, please let me know. Thanks for your help in advance. Yogesh Hi Yogesh What version of PowerPoint are you using? What kind of table is it and how did it get there (e.g. insert -> table, or a table connected with a graph)? If it's a graph, is it an Excel graph or an MSGraph graph? Lucy -- Lucy Thomson PowerPoint MVP MOS Master Instructor www.aneasiertomorrow.com.au "Yogesh" <Yogesh@discussions.microsoft.com> wrote in message news:F68FDA89-6289-4341-8886-54C580...

Bank Rec Record Type Code?
We're trying to set up Bank Rec and can't figure out how to identify the record type code that is required by GP 8.0. Our bank doesn't provide us with a record type code so how can we set up bank rec correctly? The fields we get are: account # date amount transaction type check # description Any help would be greatly appreciated. Thanks, Mike Abrahamson If you're attempting to set up "Electronic Reconcile" I believe that the record type code relates to the records coming from your bank. You need to specify which records are headers, detail, footers. There ha...

OWA session Timeout (Form Based Auth )
Wondering if it is possible in Exchange 2003 SP2 to have different OWA timeout for different users using the same OWA HTTP VS to connect... If not, can a second HTTP VS on the same server as the first have different timeout, or is it a server setting ( I think it is done trough OWA web admin tool ) !!! Thanks !!! ...

Export Access Record to Specific Cells in Excel
I'm looking for suggestions on how to export data from an Access table or Query into specific cells of a Worksheet. The table I'm importing will always contain a single record only. For example, I'd like to export data from Field1, field2...etc in an access table to Sheet2!A3, Sheet2!B3...etc. Any sugestions would be most appreciative. ...

How to add time in mini second
i don't know how to add time in mini second eg. 1min 20 sec 09 mini sec plus 30sec 04mini sec. First format A1 thru A3 as: Custom > hh:mm:ss.000 in A1 enter: 00:01:20.009 in A2 enter: 00:00:30.004 in A3 enter: =A1+A2 and you will see: 00:01:50.013 just remember to enter the leading hours and minutes, even if they are zero!! -- Gary''s Student - gsnu200838 "happythong" wrote: > i don't know how to add time in mini second > eg. 1min 20 sec 09 mini sec plus 30sec 04mini sec. ...

Getting Combo boxes to change options based on other Combo boxes.
Using Excel 2007. I am trying to create either Form Control Combo Boxes or ActiveX Combo Boxes that will change the selectable options based on selections made in previous combo boxes. I am having a hard time finding any information that will work for me. Can someone tell me how to make 5 combo boxes change available listed options when specific options are selected in another combo box? Please? I've been working on this for a very long time without success. I've tried using Data Validation, but my formulas are too long for all the different possible combinations. You are...

ShAutComplete
Hello there, I am working on a browser based application, currently using ShAutoComplete in order to provide Auto complete facility for combo box used to enter the address of page that you want to browser. Used ShAutoComplete with SHACF_URLALL to show list of recently browsed web pages and webpage in history. Now how can I add address of web page browsed through my application into that list ? Means If I browser http://msn.com in my application, then it should go in the recently browsed page list that ShAutoComplete uses. Awaiting for your comments. The interface you are looking for ...

Add lines to a renewed contract
Whenever I try to add a new contract line while renewing a contract (ie the customer has purchased an item during the year and the contract template is coverage dates), the system rejects the new line with "invalid coverage dates". Doesnt seem to matter what dates are entered. Please advise how to add new lines while renewing a contract. Thanks Prue ...

add external application icon on toolbarr in R8
Kindly have a external application icon (like Frx) on the toolbar available that when you click on the icon it opens up the external application automatically. Having the Shortcut menu added to the toolbar is close, but not exactly what we are looking for. If there is a way to add the actual shortcut, such as a Smartlist, or an external application as an icon to just click on to open it would be great. I think that capability went away with Release 8.0. 3rd parties who have full blown Dexterity apps can still do it, but I think when pallets went away, so did this. Alan "mult...

Check query shows voided checks too!
I am running this query but its also showing voided checks! How can I make it now show voided checks? SELECT VCHRNMBR AS PaymentNumber, VENDORID, DOCDATE AS CheckDate, DOCNUMBR AS CheckNumber, DOCAMNT AS CheckAmount FROM PM30200 WHERE (DOCTYPE = 6) AND (DOCAMNT > 25000) Add this to the end of the WHERE clause AND (VOIDED = 0) -- Japheth Nolt MCP Microsoft GP/SBF Specialist Landis Computer http://landiscomputer.com "Michael@nyresume.com" <Michaelnyresumecom@discussions.microsoft.com> wrote in message news:7163A485-9E90-48C7-B931-C989827039D6@micros...

Invalid Add-in error message
When I open Outlook 2003, I keep getting the following error message: C:\Documents and Settings\Amanda\Application Data\Microsoft\AddIns\outlvba.dll is not a valid Office Add-in. Then I am booted from Outlook. How can I fix this? Try renaming outlvba.dll to outlvba.bak. Go to the add/remove applet in the control panel and perform a detect and repair on Office/Outlook 2003. /neo ps - outlvba.dll normally exists at \Program Files\Microsoft Office\OFFICE11\ADDINS. I've never seen it under a user profile. "urbangirl" <urbangirl@discussions.microsoft.com> wrote in me...

German Spell Check
Hello there, We are a German based Company in the US. To make life easier for our German Colleagues, we would like to implement the German spell check option. Du we have to purchase the program, and if so, how do can we purchase the mentioned. Thanks a lot, Maria Maria wrote: > Hello there, > > We are a German based Company in the US. > To make life easier for our German Colleagues, we would like to > implement the German spell check option. > > Du we have to purchase the program, and if so, how do can we purchase > the mentioned. > > Thanks a lot, &g...

WMP 11 will not "add to library"
I was out one day when the power went out. My computer obviously shut down, and as a result WMP shut down improperly. This hasn't been the first time, and whenever it does, I just start up my computer again, log in, and WMP 11 is working just fine. There has also been some instances when the library has been corrupted, and I've just re-added my files to the library again. However, this time it's different apparently; WMP 11 refuses to add ANYTHING to it's library, and whenever I choose a folder for it to monitor, it does absolutely nothing, as opposed to adding ...

Increase data type size in GP table?
I don't know whether this is supported or not, but we're planning to roll out the HR module on GP9, and one of the fields that is missing for job applicants is an email address. We'd like to use an extra field to hold this data, but the field length is too short to adequately contain that information. I'm wondering if I can change the length defined in the SQL table structure for that particular column, or, if doing so will likely mess up something else (stored procedures, mappings, etc.). Any thoughts? Thanks in advance! Technically, yes. However, if you do that, you...

alter the content of the from box in a message
in outlook my "from" box automatically defaults to the email from me and that is the email address issued to me by my ISP that I entered at inception. I want my default email to read a different email which corresponds not to my ISP but to my web site and email service by my web hosters? for example my outlook says that my emails are from blanchard@btinternet.com in my signature block i type my small company details and include my company website and my email which is mail@blanchardcon.com etc how do i get this email to appear as a default in the "from" box? Enter i...

Vlookup from Combo Box
Hello, I am trying to use the Vlookup function from a Combo Box. The combo box will contain currencies (USD, JPY, EUR). Once a user selects a currency, the lookup will use that currency to find the exchange rate from a table. Something like this =VLOOKUP("Forms.ComboBox1",Currency!A1:B4,Currency!B18,FALSE) Any help would be much appreciated. Thanks ACase If it's a Combo Box from the Control Toolbox toolbar, you can set the "LinkedCell" property (right-click on the combo box and go into "Properties") to a worksheet cell. When the user makes a select...

how can we transfer data from child dialog box to parent Dialog Box. #2
hi guys, i have created modalless child dialog box by parent dialogbox using UI Thread . now i want to do 2 things first i want to transfer CPoint variable from child to parent and second i want to call OnLButtonDown() function of parent DialogBox. i have hint but not proper please help me to complete this one. SendMessage(m_pParent, WM_LBUTTONDOWN, x,y); // from child side void CHRS_MoleDlg::OnLButtonDown(UINT nFlags, CPoint point) //on parent dialog box first of all tell me is it possible if yes then what will be "x" and "y" so that they can convert into CPoint v...

Using Drop Down box that can be edited
Hi, I have created a form in Word 2007, but would like to have the drop down box I created to also be overwritten by the user if the items in the drop box doesn't include their choice. Thanks fjcunninghamjr One possibility would be to replace one of the items in the list with a user input item. You could do this with a macro run on exit from the dropdown field Assuming the dropdown field Dropdown1, put an item at the end of the dropdown list "Enter your own value" then run the following macro on exit from that field Dim sChoice As String Dim fDD As FormFie...

Help with complex table lookup
I have a ranged defined in a spreadsheet that consists of a bunch of values. Some of the cells in the range may be empty. I also have 4 hidden lookup tables at the bottom of my spreadsheet. Using these 4 lookup tables, I know how to use the vector form of the LOOKUP function to determine the following individually: - Given the value in one cell, what is the corresponding "route" (lookup from table 1) - Given the value in one cell, what is the corresponding "set" (lookup from table 2) - Given the value in one cell, what is the corresponding "slot" (lookup from t...

Google Search Add-in update
Hi all If you use this add-in then update it to version 6.01 Reason : The product specific Knowledge Base search is not working in version 6.0 anymore because Microsoft changed there Knowledge Base search. I update the Excel add-in to version 6.01 to fix this. http://www.rondebruin.nl/Google.htm -- Regards Ron de Bruin http://www.rondebruin.nl Thanks Ron. Will go get and implement. -- Don Guillett SalesAid Software donaldb@281.com "Ron de Bruin" <rondebruin@kabelfoon.nl> wrote in message news:unUTwWnzEHA.3376@TK2MSFTNGP12.phx.gbl... > Hi all > > If you use t...