Recent content by jbh1378

I am running queries in excel brining in data from an external data source. When i try to protect other sections of my worksheet, I can no longer have the option to refresh data in excel. I am not protecting my external data range in the worksheet. How can I protect parts of my worksheet and...

I have a start date and an end date in two different cells in excel. I want to get the true # of months (not assuming 30 day months) between those dates.

I have an Access Form with quite a few fields. When the user double clicks on any of the text boxes, I have entered the code to open a new form which displays the directions for each specific field. How can I do the formatting in VB. To Underline, bold certain text? If there is somewhere...

rry2k - can you help me with that macro for the save button that will copy data from one form to a second where it then gets added to the table? Thank You jh

I have a multipart question I was hoping someone can help with. I have a form that is used as a Tracker. There are 6 steps in the business practice being tracked and the form (source is just one table) needs to be updated as each happen. The form is set up where at each step there is a caption...

I need to do something similar and tried the following and it will not work. I think I might be declaring the variable in the wrong place. I declared a variable and set it to false Dim leaseadd as Boolean leaseadd = false Then: Private Sub AddRecord_Click() leaseadd = True End Sub...

Thanks sspainhour I tried that originally but whatever has been entered by the user is already in the table whether or not they hit the save button. The before update worked but it prompts the user to save when they click on a field of one of the subforms.

Instead of using the code above on the form's before update, would something like the following work. Upon closing the form, either by a button or by the x, a msgbox is diplayed asking whether the user wnats to save. If the user clicks No, then there is code to undo that record?

I am using this code given to me to update the tables only after the user is prompted to save. If the user hits no then the record is not entered in the tables. This works great BUT there are 3 or 4 subforms on this main form. Anytime a user clicks in a field in a subform, the user is prompted...

I am using this code given to me to update the tables only after the user is prompted to save: This works great BUT there are 3 or 4 subforms on this main form. Anytime a user clicks in a field in a subform, the user is prompted to save. How can get around this. I need it to act like the...

THANK YOU!!!

So I have set up a module which is global to hold the lease number and then created an event to display the lease number in a text box "on load". The first form works as it needs to. The main form's control source is the main table and each subform's control source is their...

The form was originally created with wizard. Can I override that so it is not directly entered into the table. If not what are my options Thanks-

Any Help with the code? Form1 and Form2 - essentially the same main form just in two forms becasue of size limitations Both have subforms. Need the leasenumber(primary key in main table) to drive both forms and be associated with the subforms (foreign key in those tables. This number has to...

Any help with the following would be great. Thanks in Advance. I have set up a new db with about 6 tables. The main table is Lease Details and the rest are child tables (many relationship, Options, Obligations, Rights, Notes, etc... I need to set up a Data Entry Form that hold all the...