Search results

I seem to be stuck in a tricky situation... I have a subform where records can be added or edited. There are two fields: firstname and lastname. I want a message box to appear when a first or last name is edited. I do not want that message box to appear when a new name is being added. I use...

That was it! Thank you.

Can anyone point me in the right direction on this... I have a field on a form where data can be added or edited. I would like to have a message box appear when the data in the field has been changed. I do not want the message box to appear when a new record is added. I tried using the On...

That was it! How silly of me. Thank you so much for your help. This works beautifully!

Thank you both so much for your replies. I see how this works in your sample, Taff, but when I try it in my database I get this error message: "An expression you entered is the wrong data type for one of the arguments." Any idea what this could mean? I appreciate any ideas someone might...

No, the table names will never change.

Perhaps I mean "append" Hi Taff, Thank you so much. That is a lovely example of exactly what I am talking about in terms of selecting the database to import from. Two things: 1. I suppose I am using the wrong word. I actually want to append data from tables in the old database to tables in...

I am looking for some advice... I am making a database for school programs that will receive lots of data every day. They will use one copy of the database for each classroom. I am worried that they will become too large very quickly because of the large amounts of data being entered daily...

Andy is clever... Thank you both for your suggestions. I went with me.caption = " " and it works great! I never thought of doing that. Thank you so much for all of your help, Carly

I am trying to avoid having my form or report names visible in that top blue bar of the database. When I set the form's pop-up property to yes I was having trouble with forms being maximized. Is there another way to have them not show, or is there a better way to use the pop-up function...

Got them back! Nevermind--I got them back using system restore. Thanks for the link-it works great!

oh no! Thank your for the post--it did work for a second, but there is one form I wanted to show a custom toolbar for and it was unable to be shown using that method. When I tried to open it again, it hid all the forms. I tried opening a backup database to start over and now my toolbars are...

I found a great example by ghudson for disabling the close button on the database window and it works great. I have searched high and low for a similar way of disabling (or even hiding) the restore and maximize options (though I am ok with minimize). Does anyone know how to do this? (I don't...

Thank you so much for checking up on me and bearing with me. Yes, it works! I did, however, like the way ghudson's original code disallowed the right click menu. If you know another trick to that, please let me know! Thank you so much for all your help and patience!

I have used ghudson's code in the Open event of my main form: Dim i As Integer For i = 1 To CommandBars.Count CommandBars(i).Enabled = False Next i To hide all menus and toolbars. I would like to show a single, custom toolbar when reports are opened so they can be printed and then closed...

Ok, I got it to restore the original ones and I am now simply back to the problem of the toolbar disappearing after the show toolbar code is run. Why would toolbars ever disappear from the list?

Now almost all the toolbars left town... I now only have two on the list: Menu Bar Shortcut menus How do I restore to system defaults? This must be a setting I selected for all of Access because it happens in my backup databases as well.

Toolbars are being dropped from the list it seems Ok, I see what you are saying, but I did have that toolbar and now it is gone. I tried creating another one and putting the name of the new one in the code and that is now missing from the list as well. I finally just tried editing the print...

I believe ghudson's code is also supposed to disallow right clicking menu as well, which is also quite nice. So, right clicking does nothing (but rightfully so). Ok, here is the database. Thank you so much for taking the time.

I have this code (posted by ghudson) in my main menu form's on open event: Private Sub Form_Open(Cancel As Integer) Dim i As Integer For i = 1 To CommandBars.Count CommandBars(i).Enabled = False Next i End Sub I then came across this posting which implied that this code should allow you to...