Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: ShawnR
  • Content: Threads
  • Order by date
  1. ShawnR

    iif Statement in an Access Query

    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...
  2. ShawnR

    Hyperlink Address Truncation problem

    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...
  3. ShawnR

    Using a Query instead fo a table in ADO.

    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...
  4. ShawnR

    Cross Tab Query - I Think

    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...
  5. ShawnR

    hyperlink follow method in Access 2000

    '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...
  6. ShawnR

    hyperlink follow method in Access 2000

    I'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...
  7. ShawnR

    "data has changed" error in Access 2000

    I have a form where I enter various data, some combo boxes, one check box and a memo field. I have a command button on this form that will change the check box to "true". However sometimes when I click the button I get a "runtime error 7878 data has changed" error. It usually...
  8. ShawnR

    Creating Outlook Tasks in Access in a public Folder

    Hello All: I need to create an outlook task through automation in access. I have been successful in doing so with the code below HOWEVER I want to create the task in a public folder and assign the appropriate owner. I can't figure how to naigate to the following folder: Public folders \ All...

Part and Inventory Search

Back
Top