Search results

Manually setting tags is a form of hard coding. There is no reason to hard code anything in Access because you can load values from a table.

Dim imported As DAO.Recordset With CurrentDb.OpenRecordset("select bookingref from tblBookings") Do Until .EOF Set imported = CurrentDb.OpenRecordset("select * from tblEmailExamples where emailbody like '*" & Trim(.Fields(0)) & "*'") If Not imported.EOF Then Debug.Print...

If there's a chance you have more than one workbook open you need to specify which one you're using. myworkbook.sheets("Proposed Area Plan").Select Selecting is a gui action. You don't need to select an object to do something with it. Everytime you select something you force the screen to...

I don't think so. The web browser doesn't have a control source. You either point it at an existing html file or generate the dom document on the fly. If the page is generated by code in your database a 'back' button is unlikely to work. search your code for things like "innerhtml" and...

^-^ My reading fail ;)

I don't understand why a record count of 2 is correct for the first record if you are only adding one record. The data is duplicated twice because you have 2 records. If you had 5 records it would be duplicated 5 times. Remove the loop You will still get duplicates if you click the buttons...

funcname = your function's name ? Anyway, functions use brackets MsgBox xl.Run("yourfunction") myvariable = xl.Run("yourfunction") edit++ otherwise they're just subprocedures

NP. If I try to open frmTreeView01 it locks Access up. I did a quick edit on mine. The logic for getting child nodes is in the class so that each node can load it's own children recursively. All I did was take the recursion out. And because items are stored in collections, by deleting a...

I think that's quite common for ADO if you've edited a database object. I got it myself when creating the example. Close the database and retry. If that's going to an issue in a live environment I think you'll need to build the recordset and populate it yourself.

me.x = me.y doesn't make any sense anyway in database terms.

Post the error.

Either change the readonly setting of the form open, or add a button to the form to unlock the form/subform MySubform.Form.AllowEdits = True

While Not .EOF if len(strResult) then strResult = strResult & ", " & vbnewline strResult = strResult & !f1 .MoveNext Wend and remove the last If

You've still got cursorlocation set on the recordset. As I said above, it should be on the connection. And since you can't change the project connection you need to create your own.

I think you need to create your own connection. I just tested it on a read only query and only got error "Insufficient key column information for updating or refreshing." when doing the update... Dim cn As New ADODB.Connection With cn .ConnectionString = CurrentProject.Connection...

I've never seen a dial control in Access so thought I'd make one. The file also contains... - Slider control - Windows 8 style calendar - day names adjust with form size. Click header for month, year, decade, selection. - Analogue clock

You can use a query to add some normalisation to begin with. select projectnr,machine,[hour meter,[date / time], ucrollers as chk, 'rollers' as chktype from tblchecklist union select projectnr,machine,[hour meter,[date / time], hydhoses as chk, 'hoses' as chktype from tblchecklist union select...

The recordset is updateable otherwise the form would be locked. So something is being updated. Perhaps a record other than the expected record is being updated? Check Master Child fields of the subform.

My take was that he's running this from Outlook, not Access. He's trying to open the file, but if he's got another database open it's returning that one which isn't the one he wants to update.

Since this is an Access forum you probably want to post your code so people can run it and understand what you mean. If your original code created the table at the bookmark, but now the table isn't updating at all, my guess is that the bookmark was replaced by the table you inserted originally...