Recent content by HD20

Hello, I have the following code that is working fine to delete slide 2. However, I would like to delete the slide through its title which is "Agenda" rather than its index, can someone help with that?

Hello, I have a table with a list of dentists and which carrier's networks they are in. I want to produce a grid that will show a count of which ones each carrier has in common. The table has the following four fields; ID, Last Name, First Name & Carrier (see attached example). How do I set...

Every time I do a save as in my spreadsheet, the macros run through (and there are a lot of them). All the macros really do is hide or show various rows/sheets based on a control checkbox. When I do a straight Save, this does not happen, only a Save As. Any ideas?

Perfect GHudson, thanks!! My other reply was to the first response.

The file path is not constant, I want a dialog box to come up so the user can point it to the Excel file to be imported.

I have used the search and it proved to be very helpful, as always. However, I still have an issue with my coding, it keeps trying to open my Excel file I have imported after I have closed it (or at least I think I have). Here is the code (copied right from another thread with a few tweaks)...

did you ever figure this out, I am having the exact same problem....

Hello- I have an append query and rather than the defined error message that pops up when you are trying to append a record that is already in there, I want to put in my own message. Can anybody help me with this? Thanks.

Now I am getting the error, "Microsoft can't find the field 'frmData' referred to in your expression. frmData is my Main Form. This is my syntax: Form!frmData!subfrmVersion.Form.chkWellness.Visible = False Did I misunderstand your reply and put it in wrong?

I have read the threads on this subject and I thought I had my coding fixed, but obviously not, beacause I still get the error, "You can't hide a control that has the focus". Maybe it is a form/subform thing. Here is my code: Private Sub txtAge_AfterUpdate() If Me.txtAge > 39 Then...

I have a table with a large list of names and addresses. I do not want this large table in my database, so I linked it from another. I want to be able to have a drop down on a form with the names. Once the name is selected, the user would click a button that will bring it to another form and...

Crystal, thanks!

I am sorry, I don't understand your reply. How would I get the table to produce currency?

I have a Make Table query where one of the fields is formatted as currency. However, when it creates the table, the formatting reverts back to general number. Does anyone know how to fix this? Thanks.

I am looking for some code that would transfer data from a database on a person's desktop to a database on a central network server (either adding new records or updating existing records). I don't want to just link tables, that would be too cumbersome and I don't want everyone just working off...