chembuff1982
Last Activity: Oct 28 '07, 05:30 PM
Joined: Mar 9 '07
Location:
-
I'm going to try to go to the local college to get help. It seems like nobody on here can figure the last part out. I called already, just going to talk to a professor who has a degree in computer science. -
Nope both changes didn't work. I think we came upon a mystery of computer programming.Leave a comment:
-
The new tests are being added by a command button.
Add New TestLeave a comment:
-
my rowsource for combo29 (tests) is filtered by companyID number, however if we add a new test for a company, or add a new company, I want to be able to put that new test from add test in the Combo29 (tests) box before the form is submitted.Leave a comment:
-
So frustrating, it's the last button on the form. I have it sending to the table, just need ot repopulate my combo29 box which is for client tests. I want it to do it from the add test button. So if a current client has no selection or they are a new client it will allow them to enter test parameters.Leave a comment:
-
label and goto? Loops?
Do loops work in ms access, I'd assume they would, what is the setup for them. -
backup you database, remove all relationships from that table, than you will be able to change it around. It worked for me in a similar situation. You have to make sure your relationships are removed. If that doesn't work, copy your table and after relationships are removed delete it, and create a new table with the same name and paste your old table information in and make sure that the new replacement table is set to number.Leave a comment:
-
That doesn't work, I did try that a while ago, see the table, is updated by the form, but I'm trying to sort of refresh the new drop down box with the new selection. Would some form of acLast work? I got aclast to pull up a number for the new record, but I need a string value.Leave a comment:
-
anyone? Almost there, almost there, so close to being done.Leave a comment:
-
http://i147.photobucke t.com/albums/r301/chembuff1982/form.jpg
that's a picture of my form I took a snapshot of, not an advertisement. It's in my photobucket.Leave a comment:
-
put a record in a drop down box
Here's my code, combo27 is working fine, however when I update my table Test (field Test) which works fine, I can't get Combo29 to update to the added test I just put in. I need to use the acLast or something like it to bring my record up, which works, however, it's numeric. I need to know how to bring the string value in the cell back to my drop down Combo29 here's my full code and form for the whole database, take a looksee if you want.
... -
Sorry about that I figured it out the other day. My program is pretty complex so it gets confusing at times. I'm programming a complete database for a lab with drop down menu selections, bench sheets, records etc. I defined a string
strCustomer well I'll show you my code I got it working most of the way.
Private Sub cmdprint_Click( )
On Error GoTo Err_cmdprint_Cl ick
...Leave a comment:
-
frustrating
I still am having trouble passing a value to a field in a table.
It's all one database in access. I have my form, tables etc. They filter to combo boxes. Than I sent the value to a text box like someone told me. That works fine. I now want the textbox to send to my field in the table.
I just need an example of how to send, from a textbox on a form, to a cell in a table. Let's make the textbox (mytextbox) and... -
They are new records I'm storing them, taking them originally from a table, and upon selection, through the drop down boxes, sending the submitted results to a new table to store the selections. Just pretty much for record keeping of clients and tests that go on....Leave a comment:
-
I honestly forget how to bind a field in a table to a textbox, I clicked on the wizard and than on textbox clicked on table and dragged it to form but it is saying subform, I want it bound to the field not be a subform report.Leave a comment:
-
Here's my code
...Code:Private Sub cmdprint_Click() On Error GoTo Err_cmdprint_Click Dim stDocName As String Dim MyForm As Form stDocName = "tbldate" Set MyForm = Screen.ActiveForm DoCmd.SelectObject acTable, stDocName, True DoCmd.PrintOut DoCmd.SelectObject acForm, MyForm.Name, False Text54.Value = Now() Text54.Visible = TrueLeave a comment:
-
I sort of gave up on that attempt, I have two tables each giving one drop down box it's selections, upon selecting I now have it passing the selection to a string value. I want to send this string value back to a new table now, called table print. Is this possible?Leave a comment:
-
I bound the combo box (drop down) to another table, it filters clients, I sent the selection from the dropdown to a string called strCustomer, I want to send this to a new table, just the string value. The thing is, I don't want all the selected values being entered into the table I print, maybe an overall table of records that were chosen, but I want to be able to print one instance of the selection out for a bench sheet. It looks sort of like...Leave a comment:
-
c++ or visual c++ is the best way to go.Leave a comment:
-
passing string to table
I set a string value up and took it from my drop down box, I now want to send this value to a field in my table. How can I do this?
No activity results to display
Leave a comment: