Search results

I wonder if I'm doing this correctly, because debug.print doesn't seem to do anything, it just highlights a line of code telling me the following error: Case Is = "Sites" MsgBox "Searching in Sites only", vbInformation...

I wonder if there's a way to change the WHERE clause: SearchContactWhere = "tblContact.chrContactCompany" & " LIKE '*" & Me.TxtSearchText & "*'" & " Or " & "tblContact.chrContactFirstName" & " Like '*" & Me.TxtSearchText & "*'" & " Or " & "tblContact.chrContactSurname" & " Like '*" &...

Thanks guys! That worked fine! I knew it must have had something to do with the quote marks and parenthesis etc, but couldn't work it out. With regard to the OR bits further on, mailman, I was wanting use OR statements in my where clause so that if the text entered into the textbox existed in...

VBA Query gets Syntax Error (missing operator) Hi there, I'm getting an error with the following message which I wonder if anyone could help me with? : Basically, I have a form: I enter the text in, select the area of the db to search, and it runs the relevant query with the typed in text...

Ok, so since I started in this form, I will keep it here, even though it's SQL based now. This is my new form, as you can see, it's got the #Name? in the control as I changed it to "=[qryQuoteValue]!

nope. It really isn't. It's an order entry database I'm trying to work on for work. I've got quite far, but am stuck on what really should be a simple thing. Edit 2: ooooh, I'm so dumb, it's simply done in SQL :) - I found it in one of the queries.

Thank you Rabbie, I shall do that now Edit: I can't seem to make heads or tails of it - The code seems to have no reference to the complete total on the order form. I can't see any calculation at all.

Would I be right in assuming an amalgamation of a "FOR EACH" loop and a "Do While" loop? I would then need to put all the values somewhere so I could sum them... Possibly a variable...? possibly a temporary table...?

Hi all, I have a quote form, pictured below: It accesses data from these 2 tables: tblQuote (the main one) and tblQuoteItems (the subform which is as a datasheet style) Basically, for all the items in the subform, they will each have a value in the subtotal column. I want to sum...

Hi there, My company's quote numbers are a combination of a few letters (which correspond to the last name of the client, or their company's name), the EnquiryID and the month and the year. For my quote table, I wish to utilise this but not quite sure how to go about it... I already have the...

Hi all, Even though this is query and report related, I think it's likely to be more relevant to this area than the query or report areas. I am getting the following error: This is my code: Basically, I created a report (shown below) based on a query so that I could get the query to...

In terms of registry editing, I have done this before and from what I have just done, it seems to have worked. :) Oh, and Banana, we've gotta love UNIX/Linux. :D

Hi Neil, I just went to my respective one, and there was more than 1 key value. There was "a" and "a"'s value was set to NorBuild.exe, but the value wasn't set for (default) so I edited it's value to be NorBuild.exe also. I changed my code to use shellExecute() instead, and it seems to be...

okies, will try

Sorry for being dumb here, but do you mean opening up a command prompt as in start -> run -> cmd ? Thanks, Si

DJKarl, I tried your method but it didn't work unfortunately, it still just opens the program without the file. It's a shame, cause double clicking the .nbp file from within windows explorer will open the file in the program. It remains to me a mystery. strWholePath is, however, returning...

You did assume correctly, strWholePath was the combination of the 3 bits. I get you now. Thanks.

Hi DJKarl, Thanks for your post. Before I attempt this, I'm confused as to why I'd have to do the first line in your code as I thought I was supposed to be making it equal to the other 3 bits (me.projectpath, "\", and me.lstboxprojectfiles) Cheers, Si

That's a cunning plan. Will try that one maybe instead, it seems less intrusive. Edit: Yep! that worked mailman, thanks muchly :)

This is why I love this forum so much :) I shall try it and let you know.