Search results

The Time() part is working fine. Been using this layout for yrs. It's the AppActivate that isn't working. It works on other forms; just not this one. And it was working on this form earlier this morning. That's why I am baffled.

Could someone please help me figure out what I am doing wrong here? When I open the database it keeps telling me "Run-time error '5'" Invalid Call or Procedure. I can't figure out what I have done wrong. In the "Tools/Startup" options I have the title set as "Financial Database" same as what...

Thanks for the code. Where exactly would I impliment this code or put it to make it work? Is this done in the Access FE or on the SQL side? Not sure how to use it. Thanks again for the help.

Thanks for the reply. I think I will change the stuff back to varchar. The databases I design or strictly domestic so I shouldn't have a need for the nVarChar. I will try out these changes tomorrow.

Thanks for the quick response all :) That was the issue. Now I had our SQL Admin tell me to use Char (if you are using a specific field size) VarChar (for non-specific field size) and never use nVarChar due to it using twice the space to store data.

I am in the process of converting my DB into SQL. What I can't understand is why since doing so is my custom error message putting a bunch of unwanted spaces in the message? (See attached image) Here is the code I am using. This was working fine until the tables were moved to a SQL backend...

How exactly would one go about doing this; as I am looking for a quick way to be able to remove the "DBO_" prefix from SQL linked tables.

Is there any way of trapping SQL Server error messages in Access and replace it with a more User Friendly easier to understand message? I have attached an example picture of what I am trying to trap.

I got this one figured out ;) Took a little playing around with the code.. Here is what I used to get it working: Forms![Search Form]![Search Results].RowSource = _ "SELECT [Letter Information].[Provider Name], [Letter Information].[Contact Name], [Letter Information].[Letter Type], [Letter...

Double WildCards: Can someone help me convert this to the proper SQL please? Private Sub Provider_Name_BeforeUpdate(Cancel As Integer) DoCmd.OpenForm "Search Form" Forms![Search Form]![Search Results].RowSource = _ "SELECT [Letter Information].[Provider Name], [Letter Information].[Contact...

Thanks. I tried that before you had replied and that was the problem ;) Now lets see if I can do this for dates and with multiple search options.

Syntax Error: ok.. Changed the code as suggested, but now I am getting a syntax error (missing operator) when the code is run. Here is the complete code I'm using now. Private Sub Form_Open(Cancel As Integer) Me![Search Results].RowSource = _ "SELECT [Letter Information].[Provider Name]...

Thanks guys I will try your suggestion when I get into work tomorrow morning :)

I am trying to set the RecordSource of a List in the OnOpen even of the form based on the text box "Last Name" that is filled in by the user on the Main Menu. For some reason I can't get the code to work with the "LIKE" command what am I doing wrong? I am getting Data Mis-Match 13. How can...

That worked great! Thanks for the quick response.

Hmm.m. let me try that out. :) Maybe that is what I am looking for. Can I implement that into a Select Case statement?

I have a subform that I am trying to use for 2 differnent forms. "Provider Information - I" & "Provider Information - G". What I need to do though is have the subform check to see which form it is currently linked to / open. Then based on which form is open run If/Then statement code specific...

Yes I tried that also, but you can only do that based on 1 table not 2. :(

Could you show me an example of how to use the Not In() clause? This is what I am trying, but it is asking for input when I run the query. SELECT * FROM RPIN WHERE (((RPIN.Provider_PIN) Not In (AR94.Provider_PIN))) ORDER BY RPIN.Provider_PIN;

Yes, but the problem is I don't need the duplicates per se. I need to show everything EXCEPT the duplicates found between the 2 tables.