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?

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

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.

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

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?

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!

I am getting an error message when trying to open my database, it reads: The Microsfot Jet Database engine could not find the object "MSysACEs". Make sure the object exists and that you spell its name and the path name correctly. Any ideas?

I have a subform with a drop down box containing about five items, however I have had a request to have check boxes for the items instead since one customer can have more than one of the items. Currently it is set up as a continuos form so they just keep selecting from the drop down box. Is...

I have a subform with a drop down box containing about five items, however I have had a request to have check boxes for the items instead since one customer can have more than one of the items. Currently it is set up as a continuos form so they just keep selecting from the drop down box. Is...

I have an input form and I do not want users to be able to scroll through the records, so I have set the navigation buttons to No. I have also set the Cycle to Current Record. However, with the mouse with the scroll button on it, the user can still scroll through the records even with these...