Michael Adams
Last Activity: Dec 8 '10, 08:44 PM
Joined: Jul 14 '10
Location: Helena Montana
-
Is it true that when you close the first tab of your form and go to the second tab the car you just entered is not showing up? -
Make an if statement that looks for the "closed" field then have a message box say something like "This car service has been closed. Please select another car."
That way you don't need the query.Leave a comment:
-
When you click "save" on the first form what does it do? Have the car combo box pull from the field and table where you wrote it to on the first form.Leave a comment:
-
And the new number is being written to the main table DB? And the second form new car field is being populated by the main table DB?Leave a comment:
-
After you enter that number Your problem arises when you go to the second form and that new number is not there, correct?Leave a comment:
-
On the new car tab, when one enters the car number and clicks save what field does that number populate?Leave a comment:
-
Ok, I just took a look at your images and this is what I can suggest to make this very easy.
1. Create a table with the "employee" and "Car"
2. Link that table to your sub form and next to car have employee combo box
3. That way you can get the info from that table Unless you have a master table with alll the field from every form/sub form.
Questions:
1. Do you have a master table with...Leave a comment:
-
I ment in VBA. The code that I have used starts with ssql then the SELECT...Leave a comment:
-
Just for a side note then, When he is coding a SQL statement does it need to start like?Code:ssql
Leave a comment:
-
F430, are you using the program Access by Microsoft or are you using SQL by Microsoft or perhaps you are in Visual Basic Studio or VB.net? Which one are you using, because the code is fundamentally different for each!
IE... Code for running a SQL Statement in SQL is different than running the same code in Access(VBA).
So, Which program are you using? (Is this a good question NeoPa?)Leave a comment:
-
I was not offended at all, I was just clarifying. I just hope that I could be of help cause I was running into the same problems that f430 has been running into.Leave a comment:
-
No questions, My code works for comparing literal strings against the table. Before I used this code I was getting the same parameter thing f430 is getting. I believe it is looking at what the user is inputting and notices that there are different values in the field and is asking for wich one the user wants returned.Leave a comment:
-
This is what I have.'
...Code:Private Sub Bank() 'This sub is to search the table workordertracking for the criteria that is in the drop down box 'This is the variable for the form to be opened and populated Dim BnkDocName As String 'This is the variable for the matching strings Dim BnkLinkCriteria As String 'This is to assign the form "SubSearch" to the variable stdocName
Leave a comment:
-
Try this, create a variable for each. Then use this code after your dim statements.
This should match the literal string from your filter and the string your table holds.Code:If Not isnull(Me.[i]your text/combo box that holds your literial string[/i]) Then [i]your variable here[/i] = "[[i]field on table[/i]]=""" & Me![i]your text/combo box that holds your literial string[/i] & """"
...Leave a comment:
-
Might I suggest that you do one piece at a time? For instance just create a real quick form with a single text box for your part number and put a command button on that same form. Use the command button wizard to open your final form with the information you want diplayed after the search.
Thanks,
MJALeave a comment:
-
If you two do not mind my input, here it is.
I have a "Search Form" that asks the user for given information, either user input or selection from a combo box. I then search the "Literial" string from the "Search Form" and compare it to the Master Table. If there is a match between the Search Form and the Master Table the results are populated to a new form that shows all the information in the (single/multiple)...Leave a comment:
-
Yeah Baby, found it!!!!! Check this out, and it works!
...Code:Private Sub command0_click() Dim stDocName As String Dim stLinkCriteria As String stDocName = "SubSearch" If Not IsNull(Me.Text2) Then stLinkCriteria = "[workedby]=""" & Me!Text2 & """" End If If IsNull(Me!Text2) Then MsgBoxLeave a comment:
No activity results to display
Leave a comment: