Jonathan Austin
Last Activity: Mar 28 '11, 04:01 PM
Joined: Jul 24 '10
Location: Florida
-
Its like AutoNumber except with letters, and it resets after the fifth letter, (Letter E in this case). I think this explains alot, considering I just figured it out. -
What I want Access to do is using only a set letters (A through E), going through each record in squence, then resets back to A. So for every new soldier (or record), the soldier will be assigned to one of the companies A, B, C, D, or E (based off of the previous record.) So in otherwords if the previous soldier was assigned A, then the next will be assigned B, then C all the way to E. Once E has been assigned then the squence resets back to A. I...Leave a comment:
-
Pardon my not so descriptive question. This is whats happening....
I have a database of my soldiers. As I enter a 'New Soldier' into the system, I want Access to assign certain data automatically in a sequence pattern. In this company assignments, A, B, C so on and so forth. (We are not using Greek letters. Alpha, Bravo, Charlie etc... are military letters.)
Example... If SoldierA was assigned Alpha Then
SoldierB...Leave a comment:
-
Rather VBA will assign them a company after I click a button.Leave a comment:
-
No I mean after the employees are already inputed, I sort them by Last Name Alphabetically, and then by Gender (Male and Female of course) Then all I have to do is click a button to assign a company, by going down the list... Alpha, Bravo, Charlie, Delta, Echo etc...Leave a comment:
-
How to assign certain data in a pattern?
My question is basically how would I be able to assign certain data automatically in a pattern (i.e. If employee1 is Alpha, employee2 is Bravo, employee3 is Charlie so on and so forth). How would I go about this? -
Actually I figured out what I needed, I'll post it, it may help others on this. Its basically like creating your own verison of an error report.
Check this out...Leave a comment:
-
- I could have all the fields required, but it would be annoying to hear 'dings' after each one, which by the way, all entries are required....Leave a comment:
-
Yes thats correct, after my personnel enter information, (its alot of information to be enter, so there will be entries that may be over looked.) So any blank entries I want the errors to show up as text in the error boxes (error boxes = textboxes) not msgbox.Leave a comment:
-
Unfortunately that won't, because my error box will be compiled with other text, so I just want to eliminate certain text. I'll write it out for better understanding.
...Code:Private Sub ReviewButton_Click() If ComboBoxA = "" Then ErrorBoxA.Text = "ComboBoxA Cannot Be Blank, Answer Is Required" End If If ComboBoxB = "" Then ErrorBoxA.Text = ErrorBoxA.Text & "ComboBoxB Cannot
Leave a comment:
-
Clear Error Message from TextBox
Ok I got it now, thank you everyone for that. Now I have another question. I'm creating an error report from, if a textbox is blank then it'll display a text in another textbox stating "Textbox is blank, please enter a value" etc... So it will look something like this....
...Code:Private Sub FormCheckButton_Click() If TextboxA = "" Then ErrorBox = "TextBoxA cannot be blank, please enter value" End If
-
Just want to make sure on this, though I have been looking into the DLookup() function, I just wanted to touch basis on it. My end result that I'm looking for is, if I enter a value into an unbound textbox, and if that value in the textbox matches the value in the column in a table, then (whatever code that I want to use afterwards.)
So I should be using DLookup() as everyone is suggesting? If so how do I use it exactly, I got somewhat...Leave a comment:
-
Sorry, forgot to also mention. I will be using a barcode scanner, but right now I don't have the barcode reader, BUT using the keyboard should be the same effect. If the number entered (in the textbox) matches the table column then the rest of the code kicks in. Hopefully everything I mentioned explained it a little bit better.Leave a comment:
-
The program is Access 07. Basically this is what I have and need. I have a textbox (TextboxA), if I enter a certain value, it looks up in the table in the certain field, if it matches then I setfocus to TextboxB and the textbox will read, "SIGNED IN @ (timestamp)". And so what your saying I should use VLookup() or something else?...Leave a comment:
-
What is the VB code for looking up a value in a table?
My situation is, if the value of textbox = any of the value in a table column then certain results will occur. I just want to know what the code would be for that.
My apologies for any confusion, just want to know the code that looks up value from...Code:Private Sub TextboxA_AfterUpdate() If TextboxA = (value from table column) Then TextboxB.Forecolor = vbBlack TextboxB.Text = "Signed In" End If End Sub
No activity results to display
Leave a comment: