Recent content by zanaeira

Hey, sorry to say I actually don't understand the code you have for your cmdInsertPic_Click. I've never seen this OPENFILENAME and when I tried it on my Access it didn't come up :S. I'm using Access 2007 by the way. You're loading an image using an image control with its control source set to a...

Hey. For the remove picture command button try setting the field that stores the image path as null. Also, add a label underneath the image control with its visible property set to No. For the remove picture command button, add code such as: Me.LabelName.Caption = "No Image is Displayed for this...

As far as I'm aware you can't declare variables (public or not) in any form's module and reference it in another form's module. You'll have to declare the variable (PassAnswer), in a standard module unrelated to any object and then set its value in the first / second form. Hope this helps.

Oops! Sorry yeah the parantheses is a typo here (didn't copy and paste just typed it up here). There shouldn't be a "(" before strNew. If you want the combo box to be updated after you amend the record in the dialog form you could try adding something like: Me![NameOfComboBox].Requery You...

I'm not 100% sure I follow what exactly you want to do. From what I've understood, users want to change the value that appears in the combo box? I'm not sure how you want to achieve that but one method could be to have a "Change" button or something, which would open the form bound to the combo...

Hey, if I've understood correctly what it is you want to do then that's quite easily doable. You're using a combo box right? So, say for example you have a combo box with its row source set to a specific table (I'm going to use the example of adding Titles (i.e. Mr, Mrs, Ms. etc.). So your combo...

Hey, sorry I haven't had time to investigate into this further but I've had a thought and it might be better to navigate to the chosen record using a DAO recordset. I'm not very good at DAO which is why I didn't think of it before but I think this is actually how this should be done. I'll try to...

PS. Sorry, forgot to include this: make sure you Right-Click the top of the navigation pane later and uncheck the show system objects once you'v done working with the USysRibbons table. Also, don't do anything the tables prefixed MSys as these are system tables in your application and you could...

Hey to get rid of the ribbon you need to program it using XML. It's not hard to just get rid of it. Do this: 1) Create a table named USysRibbons with the fields: RibbonName (Text, 255), RibbonXml(Memo). This table wil be hidden as it's a system table that Access will search to load up any...

Oh right sorry. I'm not 100% sure how to do this but I think you should be able o achieve it using DoCmd.GoToRecord I've never tried this myself but I'll try it out and let you know.

Hey, not 100% what you want exactly, but if I'm right you have 2 forms which are related by a certain field (let's say ID as an example). You want to click on a button on the first form to open the second form to its related record. The best way I can think of doing that is this: DoCmd.OpenForm...

No problem. :)

As far as I'm aware there is no standard way to do this. You can create a template, but that will only apply to new reports that you create, and those reports will not change if you change the template (to make a template save a report with the default background etc. with the name "Normal"). I...

Hey, I've never actually done this myself so I haven't got any examples to share with you, but I'm pretty sure you can do this by using a "Make-Table Query". This means that the recordset is saved as a table so that you can view/edit/delete those specific records. Hope this helps. :)

Ok this is the method I've used for a similar problem: Firstly, create an unbound form (meaning it has no record source). Then add a listbox control to the form. Set its properties on the property sheet to: Multi Select: Extended RowSource: "QueryThatRetrievesEmailAdds" (The name of your...