Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Thank you very much Paul. It worked.

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