Search results

How do I send email from a table list? Can anyone please help me or lead me in the right direction as to how I can have this code be more effecient, by storing the e-mail address information in a table and having this code look to the table or a query to figure out which e-mail address(es) to...

PERFECT! :) That did the trick. Now I just need to figure out how to requery the "Transaction Code" field on the form w/out getting the 2118 Error. "You must save the current field before you run the Requery action." :\

So this would be like On_NotInList GoTo NotInList_Err type code? What exactly am I going to try and capture with the code? Any examples I can work from? Thanks.

Could anyone tell me what I am doing wrong here. I read through several posts and tried using the solutions, but to no avail. Here is the code I am using: Dim db As DAO.Database Dim MySQL As String Set db = CurrentDb() MySQL = "INSERT INTO...

I myself am running across the same issue. Any one have more extensive information? Field isn't showing the correct calculation unless I click the selection twice.

Yeah I had tried that already too.. what happens doing that is that it will return 0 letters unless all fields 9 fields have data in them.. I want someone to be able to use any or all of the 9 search criteria. So I need something added to the query to say "If any search criteria fields are...

@Ken Just tried changing the code around to the IsNull([Frms]![Search Form]![Analyst]). If I leave the "True" in the criteria field it gives the OBDC Error. If I remove the True it shows all records regardless of what I enter in the "Analyst" field.

@Pat: I did try removing the "=True" from each of those prior to your suggestion and everytime I did; the criteria disappeared from the query all together. @Ken: The OBDC error is coming from the Criteria. I rebuilt the query from scratch and with no criteria it worked fine, but once I added...

I somewhat get what you are saying. I think where my problem comes in is that my "Search Form" has a list box that get's populated. Here are the steps. User enters criteria they want to search by. User Clicks the "Search" button. The "Search Results" ListBox .rowsource gets set to the...

Could you explain how I would do that, please? I am very new to the whole SQL thing. Are you saying I need to throw the Query by the wayside?

I am in the process of converting my database backend from Access to SQL Server 2005. Everything was going pretty good until I hit a snag with this query. This worked fine until I moved the tables to SQL Server. To give you an idea of what this query is supposed to do. I have a search form...

Predator Software Backup Utility: OSB- I like the way this looks and is setup. My question would be how can I get it to work by backing up a specific location where the drive letter is unknown? Example: I am creating an installation program for the database which will get installed in the...

Hmm.. so it looks like trying to use the "NotInList" event is my problem. So what you are saying is that I could code the beforeupdate event to try and accomplish what I need to do? I want the user to be able to decide if it isn't on the list if they want to add it to the system; and if so...

I think the code you gave me will work, but how do I get it to accept the "Custom" transaction and continue to the next field? To clarify [Transaction Description] is a ComboBox (Pulls Data from the "Transactions" table.)

I tried that code, but it is throwing the "This item is not on the list" error message. [Transaction Description] is the combo box name where the data is entered. Any other ideas?

Can someone please help me figure this out.. Can't for the life of me get this to do what I want. What I am trying to accomplish is that if a "Transaction Description" is Like "Gas*" Then allow that to be used without getting a "NotInList" error message, but if it is anything <> Gas* and isn't...

PERFECT! That did the trick. Thanks for the quick response. :)

Could someone please help me get this figured out? Any help would be greatly appreciated. What I am trying to do is once the user clicks the "Save" button (thereby adding a new Bank Account to the system) I want to have a new record created in the "Bank Register" table automatically. What I...

Thanks for the input all. I figured out the problem. I had it written correctly; the problem was that for some reason a second instance of the database was running in the background and I had to End Process MSAccess.exe. Once I did that it was back to working fine again.

So Could I do something like ? And "AppTitle" do I put anything there or just leave it like that? AppActivate CurrentDb.Properties("AppTitle")