Recent content by ShawnR

I'm having the same problem with opening when the 2nd or 3rd etc user opens the database. I'm using a front end and back end. The probem arose when I move the main forms to a new database(i was having probs with the original database and imported everything to a new database). This is when the...

This is a better way to do this. I use it all the time. Just have your record source equal to a string. For example. Me.SubFormName.Form.RecordSource = "qCallAll" This calls up a specific save query file or literally just paste in between quotes the SQL mentioned above. You can also...

Hi Jeremy: Thanx for the info. Yes I'm trying to do in as part of the criteria. If i only had one combo i would create a unique SQL strings. However I have 6 combo boxes and there could be 100's of unique strings. I guess I could eliminate some "all" selections to lower the number of...

Ok let me add the details of a new simplified SQL query. SELECT Report.ReportID, Report.Title FROM Status RIGHT JOIN Report ON Status.StatusID = Report.StatusID WHERE (((Report.StatusID)=[forms]![report]![SearchS])); Report Table ReportID (would have unique values,primary key) Title (text...

I will be happy to send you the database. Its has only 3 records right now. If you email me I will send it to you. srodgers@fieldglass.com thanx for your help

Thanks for the quick replies. The post from william won't work. Here are additional details. Below it the SQL form the Query I am building. I'm trying to build it in teh criteria field instead of creating a seperate query file for each scenario for each of the 6 combo boxes. SELECT...

I have a combo box (forms!report!SearchS) with 3 choices. 0 = All (Created by a Union Query in the combo box) 1 = Open 2 = Closed I have the IIF statement in the criteria of the query that looks at the combo box. The problem arises is the values in the database only includes 1 or 2. I want to...

I have this problem also and I tried the above suggestion but it didn't do anything. I put it in the load event on the main form.

Hey Thanks for the tip Danvlas I had a different variation of this but it didn't always work on every PC i was running. Yours is working on all ot them.

I had a very similar issue just yesterday with pulling in fields from form fields and the code above works for me if you break it up as in the code above.

Its actually 684 to 695 characters depending upon one variable. This hyperlink opens up a specific webpage and fills out various values on the fields on that form. What's this shellexecute? I'll search for that. Thanx for your quick response. Grant

I'm using the .hyperlinkaddress to call up a web page. However there seems to be a limitation to the sixe to the link for the URL. I truncates the URL. The URL I am using is quite long. I works if i just cut and paste it into the browser but the .hyperlinkadress doesn't work and only patrially...

I figured it out. I appears the same value cannot be queried twice. So i added a second open statement witha diff query set and it then worked.

Thank guys. I'm still having a few problems. Here is my code. I know it has to be something simple. I do appreciate your help. Dim conn As New ADODB.Connection Dim rst As New ADODB.Recordset Dim DataDBPath As String, strConn As String DataDBPath =...

Thank guys. I'm still having a few problems. Here is my code. I know it has to be something simple. I do appreciate your help. Dim conn As New ADODB.Connection Dim rst As New ADODB.Recordset Dim DataDBPath As String, strConn As String DataDBPath =...