Search results for query: *

Yes I did, but I missed the enabled for this app. I didn't want the button and I was confused why this app didn't work and the other did - just missed the enabled property. Sorry for your time but thanks for your help.

I have a form with a subform. In the subform code on a click event of one of the fields, I have code that grabs the ID of that row and then opens a detail form for that record. But when you click on that field, the record selector is still pointing to the first row in the subform so it opens...

Thanks everything works great!

Thank you, I appreciate the info, gives me another approach!

I'm sure this is simple and it works on another app I have, but this app - when I code: DoCmd.OpenForm "frm_Household_Inventory", acAdd, "", "", acFormAdd, acNormal The ID is an autonum field, and when the form opens the autonum increases to the new number (30) although when I look in the...

I've looked up StrPtr and realize it is a string pointer, but I'm not sure how I would use it in the following code: Private Sub btn_PhotoLoc_Click() Dim rtnPath As String rtnPath = BrowseFiles() 'Code I got from TheAceMan1 If rtnPath <> "" Then Me!PhotoImagePath = rtnPath...

AceMan - you are the 1! Just too easy when you copy other work! Now I'm still not up there with you.....just how do you preset the folder location? And default to "All Files *.*" ?

I thank you both for your input, I just simply have to run out for now. I'll work on this in the am. I want to try them both, I'm thinking that AceMan's way would be good to know for other versions. I do have 2003, where do I find the FileDialog object? Thanks again to you both!

Wow, thanks for all that code, but I am confused. I'm assuming the Me!TextboxName is the text box that could either already have a file name shown, but then it would also give them the ability to select another file to replace what is there? What is "variable"? And when would you code these two...

I did what Pampers said, sorry AceMan1 - couldn't find the "In the far left of the toolbar is a combobox (tooltip saids Object when you hover the mouse over it)." And my Formatting (Form/Report) had a checkmark. In fact nothing in the toolbar looked like a combo box and I hovered over all the...

I was reading Thread702-840722, (now closed) and TheAceMan1 gave a suggestion for providing the common windows dialog for locations and file types that is below. I have a form that someone can add a photo from a text box. They can either manually enter the drive etc, but I'd like to give them...

I tried that and decided to just name the field to something else. But thanks for responding!

I know this seems strange, but how can I find a field named on a form that I cannot see? I have 2 combo fields, combo_Category_Type and Combo38. I want to rename Combo38 to combo_Location_Name and it says it already exists. I have checked all the fields and under images, moved everything...

Thanks, that's exactly what I needed!

I have a form with a Report button. When it is clicked a dropdown becomes visible and it displays multiple reports to choose from. When it is clicked another dropdown becomes visible and it displays multiple locations to choose from. When it is clicked I have this code: DoCmd.OpenReport...

Yes they click the text box which just displays the ID, then it has a click event to open the detail form. PH, I changed the subform enabled to Yes and Locked to No and the main form with the subform the same way and it works. I'm just baffled that I have an application that works correctly...

It's a text box, the table field is an autonum type. On the form I have it "not enabled" and "locked".

I have other applications that work fine, where you have a mainform and a subform. If you click on the ID on the subform, I want to open the detail record of that ID on another form. For some reason, I now have the same types of forms, but the focus is on the first record on the subform. If I...

That did help - thanks so much!

I think that will work. I coded the Me.subform_Inv_Detail.Form.RecordSource = qwyName in the afterupdate event before. Thanks again, I'll try it tomorrow. Might be back with my problems with syntax...Have a good evening.