Recent content by Wicklund

I am working with a database that someone else set up, that has an input mask for a phone # field. It works fine for US numbers, but we are running into some international #s as well, and it is not working with these #s. Is there a way to set up the input mask to select either format, based on...

Thanks IMO!!! Worked Perfectly.....

I have a button on a Form that runs some code to update a couple of fields, and then I would like the curser to automatically got to a field in a sub-form. I am not having any success in getting the control to a Sub-Form Field. Any Help?????

harra, So, I take it there is code that allows you to specify the cell locations for the fields from your report. Can you help me out with this? Also, how did you get the pic of Wolverine to appear under you name? Thank you for the help,

I may be over simplifying, but you could try: If [Start Time (New)] >= [Start Time (Old)] then If [Start Time (New)] <= [End Time (Old)] then 'Your error message here" End If End If

I have data from a Query that I would like to put into a formatted report in Excel. When I do the Export, is there a way that I can specify which cells the information from my query will be placed in?

I have a report that, for too many reasons to explain, I have been asked to put into Excel. I have quite a bit of structure/formatting in my report, so a straight dump will not due. I was told once that I would need to make a template in Excel that would be called up whenever I needed to run...

I verified the Child / Parent Fields. I have a similar link and another form in the same database, and that is working fine. That is what is so strange about it. Thanks anyway..

I have a very strange problem that I can hardly explain. When I am opening my 'Main Form' the information in the Sub-Form is not coming up (It's not linking properly). However, when I go into the Design View of the Main Form, and then back into the Form View (Without making any changes) the...

Well, since that won't work, here is my next dilema. When there are enough records in my sub-report, and I end up with multiple pages, the heading (Report Header) of my sub-report is only on the first page. The heading (Page Header) for my main report does show up on both pages. When I put...

Is there a way to set an Access Report to fit to one page (similar to Excel)? Depending on how many records in my sub-report, my main report can be multiple pages, and I would prefer only one. Thank you,

Rich, Thank you!! Once I understood what your code was doing, I applied it to mine, and it worked perfectly...

On a Purchase Order, there may be some instances where it is revised, and some of the items can be cancelled. I am showing items are cancelled by adding an 'Item Cancelled' button for each item. When this button is {Active}, and an item is cancelled, I would like that item to stay on the PO...

I have a subform, that I would like to automatically size to the amount of records it is displaying. When I set the [Can Grow] & [Can Shrink] options to 'Yes' for the sub-form, it does not have any affect on viewing the form, but will affect the printing of the form. Any suggestions????

That worked! I didn't have the Field Name in there correctly. Thank you,