Search results

Can I put the search function into the IF statement? If yes, how?

Access has rotten my brain. Whenever I need to write a formula in Excel, it is a challenge to remember. All I want to do is create an IF THEN statement that recognizes words within a colum. The idea is that when "Pension" appears in a column, it would do something. But "Pension" only...

Duh - you are right.

Hmmm....can I change the RecordID number to the autogenerated number?

Greetings - I am running on Access 2003. I have a table that has a field which is an autonumber. The problem is that I have an Auditrail Mod (from Irish) on a form that requires a Record ID (autonumber) to run. However, Access doesn't let me have two autonumbers in the same field. So when I...

Hmmm.... I changed [acct_nbr] from NUMBER to TEXT, and what happend was when I double clicked on the record, the form opened but in ADD mode, note EDIT of the record I selected. I assumed this had something to do with the link criteria. Any ideas?

I have a follow up question. For the code below, the field that is the link criteria is a TEXT field. DO I have to change DIM ... As String? (Sorry for the rookie question). Private Sub List2_DblClick(Cancel As Integer) Dim stDocName As String Dim stLinkCriteria As String stDocName...

Check out this thread: http://www.access-programmers.co.uk/forums/showthread.php?t=188209 I was looking for a similar solution as you, however I came across that thread and the solution Big Booty John developed - it is outstanding. You won't need a combo box or a command button, just start...

Do you have a recommended resource to help me figure out how to do this?

I'm looking for the same thing as Athlonio, but after reading this thread (and re-reading multiple times), I can't figure out what the answer is...

John, that's a great piece you threw together. I am looking to do something similar where you type in a name and a subform populates with the possible matches. Quick question, for that piece of the trick, do I just need the event from the unbound text box and the query that populates the...

Doh! That fixed it. Thanks!

Greetings, I have what I hope to be a simple error that is a result of me not being VBA-savy enough. Basically I took Irish's Audit Trail module and tried to customize it a bit. Basically I wanted to add a field in the audit table that captured an account number, so I can easily search for...

That all makes sense - thank you for the advice.

Is it better to have one table that will have null values for some fields depending on what program it is? If it were one table, there will be atleast 20,000 records. Is this a non-issue?

Okay, let me pose it with the first obstacle. I am designing a database to be used to record account information. Accounts can be on one of three programs, and each program will have its own unique fields (or common fields). Ex. Program 1 has 9 fields, Program 2 has 5 fields, etc. Because...

You are probably right about it being more difficult than needed. But yes, my plan is to split the database - I just haven't yet because I have seen it is better to do this after you have the database designed.

I have a form that will be used by multiple user in order to input new account information. Depending on what is selected, the data can be stored in 3 different tables, and once this code is executed the data is "erased" from the form. I also took away the navigation buttons. The reason for...

worked great. thanks.

I was thinking of doing that, but I don't know how to code the USER ID into VBA.