Search results for query: *

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 =...

I want to be able to directly access a data source without having to add a control like a combo box to a form. I have been sucessful in accessing tables with the following code. Dim rst as ADODB.Recordset Set rst = New ADODB.Recordset rst.ActiveConnection = CurrentProject.Connection...

Well I do agree. I have hte same problem. I recently upgraded a "critical update" from windows. I am on a corporate network and other machines that run my access app. do not have this problem. It's localized to my laptop. So there has to be some setting someplace locally.

Yes this can be done if it is a combo box, memo field, text box. In Access 2000 you can use "Conditional formatting" In Design mode, click on the combo box (control) then go to the formatting menu then conditional formatting. Then just follow from there.

I have two tables. One is Calls and one is WhatWeDid. They are linked by a CallID with primary nad foriegn keys. The structure of the tables follows. Calls Table CallID etc... WhatWeDid Table ID CallID WhatWeDidID TimeIndex The WhatWeDid Table has a one to many relationship to the Calls...

'm using hyperlinks in a command button but the ".hyperlink.follow" extra controls do not behave as designed. I want link to go to a current open window and use the "ExtraInfo" however the link is opening an extra window. When I try to use the extra controls it give me...