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: *

  1. djmurphy58

    Adding Photos to Forms

    Here's a portion of the code I have for my form. The photo works on the form - so I know this code must be correct. Private Sub Form_Current() ' Display the picture for the current employee record if the image ' exists. If the file name no longer exists or the file name was blank...
  2. djmurphy58

    Adding Photos to Forms

    OK. I did that. but I got a compile error: "Method or data member not found" .txtImagePath is highlighted
  3. djmurphy58

    Adding Photos to Forms

    stupid question... where is the detail format event found? Am I adding a "bound object frame
  4. djmurphy58

    Adding Photos to Forms

    ok, so I've been successful with everything you've told me so far. No, how do I get the photo to print on my report. I'm assuming I need to add either an image, and unbound object frame, or a bound object frame. I've tried all 3 but can't get the photo to show up. I'm assuming I need to fuss...
  5. djmurphy58

    Adding Photos to Forms

    Ok, I think I got it now. A couple other questions: 1. How do I have the photo automatically sized to fit the size of my image frame 2. When the file open dialog box pops up and the user is prompted to select a photo, how chan I change the file that opens. I want a certain folder to open every...
  6. djmurphy58

    Adding Photos to Forms

    ok - nevermind. I got the erromsg figured out. I didn't have a label created called errormsg created in my form. But now I get the error, "runtime error 2165. You can't hide a control that has the focus" Please advise
  7. djmurphy58

    Adding Photos to Forms

    ok, I referenced the Northwind Database and used its VBS code. I keep getting the error: "Compile Error - Variable not defined" errormsg.Variable is highlighted under Private Sub Form Current. Please advise
  8. djmurphy58

    Adding Photos to Forms

    I am very much a novice with Visual Basic - in fact I know next to nothing about it. Here's what I want to do. I have a form to which I want the user to be able to click a button and have a file dialog box open up. I'd like the user to select one or more photos to put on the form. I want the...
  9. djmurphy58

    Writing letters

    I want to be able to have some sort of database for writing letters. When I write a letter, I want to be able to select off who it is to, and then simply type in the text of the letter. Also, I want the database to automatically number the letters sequentially. Is there a pre-made access...
  10. djmurphy58

    submittal tracking database

    I am a project engineer in the construction industry. Our company is very cheap when it comes to buying software. When we need to track submittals on a project, we usually track them in a GIANT excel spreadsheet. And though I am very much an Access beginner, even I can see the huge benefits...
  11. djmurphy58

    Problem with Form/Subform - adding a field in the subform

    AH HA!!!!! I think I found my problem: The RecordSource for the form is qryAddEmployee The RecordSource for the subform is tblEmployeeCosts I don't know why I would have made the recordsource a query instead of a table. D
  12. djmurphy58

    Problem with Form/Subform - adding a field in the subform

    OK, I'm a rookie, so bear with me. The bound table is the one that the information gets posted to after you type it in the form, correct?? If so, then here are the answers: Emplyee form is bound to tblLabor PK in tblLabor is EmployeeID Wages Subform is bound to tblEmployeeCosts PK in...
  13. djmurphy58

    Problem with Form/Subform - adding a field in the subform

    I'm having a problem with my form subform. My form is for employees, and the subform is for their wages as well as the dates those wages are valid. For example, Employee Joe Smith might have 2 entries in his subform: The first entry says he earns $25/hour between 6/1/02 and 5/31/03. The next...
  14. djmurphy58

    A combo box that looks up results of a qry based on date entered

    I have a form for entering daily costs on a construction site. The user enters the date that work was performed, the quantity of work performed, the applicable cost code for which wwork was performed, and finally the cost incurred on that date to get that amount of work done. Each type of work...
  15. djmurphy58

    Updating a Lookup list

    Say I have a form that contains a look-up field. That look-up field contains whatever.....say names of people. When I go into that look-up field, how do I add a new name directly to the look-up field (and have it populated to the source table of the look-up field), without having to exit that...
  16. djmurphy58

    Storing a calculated value in a table

    I have a field whose value gets calculated on a report. The control source of the field is "[DailyBudget]-[DailyCost]. This is a field that I created on the report itself - it doesn't show up in the query on which the report is based. How do I get access to store this calculated value...
  17. djmurphy58

    in a query - Too many digits after the decimal point

    Duane- Probably a stupid question - But how do I set the Format property of my text box to display null values as "No Budget"? Thanks, Dennis
  18. djmurphy58

    in a query - Too many digits after the decimal point

    In a query, I have an expression that calculates a percent over budget as follows: % Over: Abs([Gain/Loss]/[ToDateBudget]) Compounding the matter is the fact that sometimes the loss is greater than zero, but the budget is zero. Since I can't divide a number by zero, PaulBricker helped me...
  19. djmurphy58

    Using IIF when dividing a number by Zero

    Thank you very much Paul. It worked.
  20. djmurphy58

    Using IIF when dividing a number by Zero

    I have a query that I am using to select all cost codes that have gone over budget. The qry has the following fields: CostCodeNumber CostCodeDescription ToDateBudget ToDateCost In addition, I have added the following expr. to the query: Gain/Loss:[ToDateBudget]-[ToDateCost] The next...

Part and Inventory Search

Back
Top