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!

Register Log in
  • Congratulations Chriss Miller 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: johngordon
  • Order by date
  1. johngordon

    Color change on record lock

    Could I use conditional formatting to set an ID field to red when a record is locked and green when it's not locked?
  2. johngordon

    Problem Networking Access

    Greetings all, Here's my problem... I've built a small Access database that I placed on my server. I have one workstation connected to the database. The folder that the database is in on the server is shared and I've mapped the path to the database on the workstation. The advanced tab of the...
  3. johngordon

    Need to remove # (pound sign) from table field

    I need to remove the # (pound sign) from all of the records (9000+) in a table field. I have tried using Find & Replace, with no success. Does anyone have any other ideas on how to do this? Thanks, John
  4. johngordon

    After Update?

    Actually your reply made me think about what I was trying to do. I finally used the following as a solution: rs.FindFirst "[ClientID] = '" & Me![Text73] & "'" Thanks for the quick reply!
  5. johngordon

    After Update?

    DAO
  6. johngordon

    After Update?

    Greetings, I use the following code to update a form based on a Name selected from a combo box: Private Sub Text73_AfterUpdate() ' Find the record that matches the control. Dim rs As Object Set rs = Me.Recordset.Clone rs.FindFirst "[LastName] = '" & Me![Text73] & "'"...
  7. johngordon

    Insert hyperlink locking all network pc's

    Greetings All, I have a 2000 db that is split. The front end(s) reside on several work stations and the backend resides on the server. On one of the forms there is a sub form that allows the users to link to scanned documents. The scanned documents reside in a seperate folder on the server...
  8. johngordon

    Record Locking?

    I have a Access 2000 db with a front and back end. There are 15 users accessing the back end. The back end is on a Win 2000 server and front ends are on Win XP Pro workstations. In Tools > Options > Advanced I have each users front end set to: Default open mode: Exclusive Default record...
  9. johngordon

    Greater than [yearEnding]

    I am trying to pull all records that are greater than a date set in a field named [yearEnding] Can someone help me with this one. I have tried using different date criteria as listed in Access' help files and have been unable to make it work proplery. Gracias, John
  10. johngordon

    Set Vaule IIf Is Not Null

    Can Me.ShippingMode be changed to reflect a field from a table? ie [For] field of the [tblQuestionnaire]table. Mucho Gracias Again! John [afro]
  11. johngordon

    Set Vaule IIf Is Not Null

    I want to set the value of a field [For] based on a not null value of another field [ShippingMode]. How can I do this? Mucho Gracias! John [afro]
  12. johngordon

    Problem with send object using

    Hi and thanks for responding, The PharmacyEmail variable comes from a table field. I am using this same type of setup in another part of the db and it works fine. In this instance I am trying to email a report from a sub form that is getting it's data from a query. I have a small variable...
  13. johngordon

    Problem with send object using

    I left one thing out. The send object command button is located on a sub form if that makes any difference. John
  14. johngordon

    Problem with send object using

    I am trying to use send object to email a report. The problem I am having is that the report will only mail once. I have attached the code that I am using: Private Sub Command42_Click() DoCmd.SendObject acReport, "rptPharmacyOrder", "HTML (*.html)", PharmacyEmail, "", "", "Express - Refill...
  15. johngordon

    Sum question

    I would like to get the sum of the field "ServiceFee" in a form based on "BillingID" and "OrderType". Anyone have any suggestions on accomplishing this small task? Happy Holidays! John
  16. johngordon

    FedEx and Purolator Tracking from Form

    Here is the correct UPS code that gets around UPS websites check mark to agree to there terms before going to the shipment tracking: http://wwwapps.ups.com/WebTracking/processInputRequest?HTMLVersion=5.0&AgreeToTermsAndConditions=yes&track.x=20&track.y=8
  17. johngordon

    IIF statement question

    I am building a report where the data is taken from a query. The main form that supplies the data has 12 check boxes with a small amount of text associated with each check box. I am wondering if it would be wise to construct one long IIF statement to allow the report to display the data for...
  18. johngordon

    No images?

    Thanks for the replies, My images are not showing at all. Or I should say images other than those that came packed with Apache in the icons folder. Any other image I try to display does not open at all. I have a feeling that it has something to do with AddIcons. Let me ask, do you display any...
  19. johngordon

    No images?

    I've setup Apache 2 on XP Pro. I've setup a directory named images in the htdocs folder. The web page comes up ok when I go to the URL. I can not figure why the images do not show or how to get the images to display on my web page. Any suggestions? Thanks, John
  20. johngordon

    Trying to get PHP to run?

    Ok great! Now it's loading with Apache. Apache/2.0.50 (Win32) PHP/4.3.7 Server at 4.4.208.11 Port 80 When I try to open a php page I get an Internal Server Error message. [Tue Jul 06 17:24:45 2004] [error] [client 4.4.208.11] C:/Program Files/Apache Group/Apache2/cgi-bin/Page.php is not...

Part and Inventory Search

Back
Top