Recent content by Dhalsim
-
D
How to prevent users from typing values in combo box
yeah that's what I meant. Thanks for the reply. -
D
How to prevent users from typing values in combo box
Hello Is there a way to modify this bit of code to allow alphabet keystrokes to jump down the combox list. e.g hit "J" and go to first J in list. Private Sub ComboBoxName_KeyDown(KeyCode As Integer, Shift As Integer) If KeyCode <> vbKeyTab And KeyCode <> vbKeyReturn Then KeyCode = 0 End Sub... -
D
Error 3314 with mistyping in combo box
Hello again sorry I've been away for a while also and not been able to give this attention. Sorry the table was just to demonstrate the table in the db. And sorry I don't feel I can post the whole db because the data is not mine to share. I appreciate the set up might not be perfect but... -
D
Error 3314 with mistyping in combo box
Hello, none taken, thanks for the reply. No that does makes sense. So for the species table (see attached) that would involve having 7 tables instead of 1 with unique spp id as the key and linked via relationships. Then having 7 combo boxes with each of the tables as row source? How would I... -
D
Error 3314 with mistyping in combo box
Hello I'm working on a database for post mortem records. I've cobbled together a functioning database that does mostly what I want it to. It's not particularly relational, just one giant spread sheet, but the main feature is a form used to restrict how species data is entered. I have a... -
D
Using one table to induce a msg box in the main table if dup values
No i appreciate the help greatly, it's probably the way I explained it but the table is for dead animals only so I couldn't put in another column for ill or sick because there would be no line entry for the bird because it's not dead. So i need a running table next to it to act as a lookup to... -
D
Using one table to induce a msg box in the main table if dup values
Thanks for the replies, I figured it out in the end, the following code worked for me: If DCount("*", "DISEASE REACTORS", "RINGNO = '" & Me.txt_RINGNO & "'") > 0 Then MsgBox "Attention: this bird was a disease reactor" Cancel = False End If -
D
Using one table to induce a msg box in the main table if dup values
Hello, I'm fairly new to Access and at the final stages of completing a DB. It has a main table without too much relational stuff going on, the main feature is a form that constrains user input. It's for captive bird post mortem data, I have a text box field on the main table called RINGNO...