Search results

Public oRange As Object Public myfindFirst As Boolean Public intTextLength As Long Private Sub cmdFind_Click() Dim sSearch As String Dim strText As String Set oRange = WebBrowser0.Document.body.createTextRange intTextLength = Len(oRange.Text) If IsNull(Me.txtFind) Then MsgBox...

Your initial If Else If conditions are messed up dude. Way off.

"C:\Program Files\Microsoft Office\Office11\msaccess.exe" "C:\Program Files\Microsoft Office\Office11\samples\northwind.mdb" /X macroName replace the addresses with the correct ones and the macroName as well.

All good people! It miraculously worked lmao! I've never seen PHP results cache before... weird. Thanks for the help! :D

You're going to want to start it with Shell because creating a link between two access database's tends to get messy!

"SELECT comments.id, comments.comment, users.first_name, users.last_name FROM comments left join users on users.id = comments.user_id WHERE comments.post_id = 34 AND comments.date_deleted IS NULL ORDER BY comments.post_id DESC"

Seeing both null and valued.

Awesome job!!! I'm still afraid of more inconsistencies in the data to become apparent down the road. D:

TBH maybe the problem lays deeper. Where did you get your Original_Data_field data? Did it come like that from another table or did you get it by I/O parsing a file?

The data type is datetime. The result is returning all comments respective to the post. But it is not filtering for the date_deleted condition. To Dave: Sorry, I forgot to mention that this code snippet is written in PHP. :p

Lol! I love the imagery!

Hello Follow Nerdlings :D I'm about to bash my head :banghead: off of every surface in sight if I don't figure out what I'm missing... This query: $query = 'SELECT comments.id, comments.comment, users.first_name, users.last_name ' . 'FROM comments left join users on users.id =...

Dim errLoop as Variant. Might work, sometimes it gets pissy at me for using the respective object type in a foreach statement

on the bottom right corner does it show a green loading bar or display a message saying that it is running something?

Also, check his trust centre settings

I'm guessing you've checked the file->options->customize ribbon settings already?

change the query to have an order by date desc or asc not sure what one you're looking for.

Does it hang up for a bit before it crashes? Or does it immediately drop out? Also when it crashes, does it stay in your processes listing in your Task Manager?

That means you have some dirty, inconsistent data. I can modify the function to handle this, but I advise you to go and try to clean it up. Try that out. Public Function SplitReturn(ByVal str As String, _ ByVal delimiter As String, _...