Search results

Thanks for the reply. I must be the syntax dummy, but I can't remember if Me is Me. or Me! Here is what I've tried and neither seem to work. Private Sub OS_Label_DblClick(Cancel As Integer) DoCmd.OpenForm "TransactionView_OS", acNormal, , "[OS_Parent]=Me!OS_Parent", acFormEdit, acWindowNormal...

I'm trying to code some VB code on a form that will open a second form for reference. It gets a little complicated because the procedure will actually be placed on a control within a subform on the original form. Here is what I have: Private Sub OS_Label_DblClick(Cancel As Integer)...

You got it SOS. Thank you. This was exactly the problem. I learn more each day.

Hmmmm. Still not working. Here is what I have. I copied it directly from the VB editor. Private Sub Subcategory_ID_DblClick(Cancel As Integer) Forms!frm_OS_Build!frm_OS_Build_subform_M.Form!category_id = Me.Subcategory_ID DoCmd.Close End Sub Any thoughts? The error message reads...

The main form is called frm_OS_Build. On that form there is a subform called frm_OS_Build_subform_M. Within frm_OS_Build_subform_M there is a control called category_id. When the label for category_id is double clicked, a pop-up form called frm_OS_Taxonomy opens up with the following code...

This is perfect. Thanks for the help.

Thanks pbaldy for your reply, however I think I'm still a little hazy after seeing the reference sheet you indicated. My cursor is in the subform on the main form, but I need to put the code on the pop-up form. Here is what I've tried so far and can't get either of them to work. On pop-up...

I have a form that pops up from a VBA function on another form. The form that pops up is based on a query that I never want to add values to. The purpose in opening the form is to give a more friendly view of the underlying field since it is a memo field. At any given point, the form that...

Thank you both for your reply. I find that it works just fine, however a detail I neglected to mention is that the original form is actually a SUBFORM. When I now try to run this as you both have detailed above it indicates that it can't find the form I'm referencing on the pop-up form. Any...

Thanks for the update. Wasn't aware there was a VBA section until after I posted in the forms section. i thought the question was better suited to a VBA discussion than anything. Thanks for your help.

I have a form that opens up when you double click a button on another form. The purpose of opening the form is that the form that opens is intended to act as a selection form. The idea is you find the record on the form that pops up, double click on the value you choose and two things happen...

I have a form that opens up when you double click a button on another form. The purpose of opening the form is that the form that opens is intended to act as a selection form. The idea is you find the record on the form that pops up, double click on the value you choose and two things happen...

PERFECT!!! This is exactly what I needed. Thank you for your help! I knew there was an easy way to do this.

I am collecting data on image URLs. My entry folks find the specified URL link, copy it and paste it into the field I've indicated. I need to perform a STANDARDIZED update to EACH record that gets a URL. Currently as they paste them into the field they begin with "ftp://" and I need to run an...

Thanks for the update. I actually just solved the problem with a Dlookup. I will look into the CurrentDb.Execute. I wasn't aware of that function. Thanks again for your help.

It sounds like a good idea, but I'm not sure how. Can you explain briefly?

Thanks for the update. I do know how to create a count query that will give me that information, but I'm not exactly sure how to assign a value to the variable "Countofnewrecords". Thanks again for your help.

I have the following code below that works to append a table within my database. What I can't figure out is how to create a Msgbox at the end of the code that says something like "There are _____ new records in your table", the ____ is the part I can't figure out. I want it to return a numerical...

I have an inventory management database that I use to manage multiple channel online sales. The platform is SQL, but the front end I've been using is MS Access because of familiarity. I have the following VB code in a module in Access that makes a record-set out of the current onhand inventory...

Can you give me an example of how I would do that? I've never used that before.