Search results

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...

If I have gone up to version 1.06 (I am not using the patch level) on a program and then do a major revision, is the next number 2.0 or 2.06?

Perfect, thanks

I am getting a type-mismatch error in the coding below at the line Set rst = db.OpenRecordset("tblProspect"): Private Sub CmbProspect_NotInList(NewData As String, Response As Integer) Dim strMsg As String Dim rst As Recordset Dim db As Database strMsg = "'" & NewData & "' is...

I have a query with a field of names and I would like to have a filter option, but still maintain the capability to show all records. I put [Enter Name] in the criteria section of the query so it prompts the user to enter a name and if they enter Joe Smith, his records appear. Is there a way...

I am trying to export a report to Excel and it doesn't seem to be going anywhere. When I export to Word, it opens Word and goes into a specific directory. I check that same directory for the Excel file and nothing! Anyone know what may be happening? Thanks!