Search results

No, its a text field

Sorry, I thought it was how I had changed it, I tried your version of the code & don't get the error anymore, I get a different error when I try & do a search for the number "4421" like in the attached image in the VBA window Me.SubNPUListSearch.Form.RecordSource = SQL is highlighted in yellow

That's exactly how I tried it :rolleyes:

Hi theDBguy, thanks for your reply I was wondering about that & tried changing the 2nd WHERE to an OR like the lines below by still get the error. Is it not possible to use a search VBA code like I use when there are Criteria specified or is there a way around it?

Hi all I've just tried adding a VBA code to a button for searching a subform on one of the databases I am currently building but I am getting the error "Expected: End of Statement " I have used the below code before many times & haven't had a problem before, here is a sample of the VBA code I...

Thank you @pbaldy That has sorted the problem & it is working fine now

I've ran different sites myself & without a good staff team sites can get really messy, I've also spent loads of time clearing up the mess on an un-moderated site & it is hard work & takes up a load of time. Great work guys!!

Sorry, not been online for a few days. Thank you both for your replies I'm still not 100% sure how to add what you have said above (still learning :rolleyes:) I was wondering if it had something to do with that, I think I had the same sort of issue in the past, a control for the formatting...

Thanks again @pbaldy I wouldn't normally format a table field like that either but I was guessing for the code I'm using to auto-name the file with different fields it needs to be done from the table, I was only guessing that. I'll give it a try tomorrow

Thank you for your replies @MajP & @pbaldy Both are different, where do I add either of the above?

Hi all, I've come across a problem with the database I am working on, there are a few things I need to suss out but I want to get this out of the way first I'm posting this in the tables section as I guess if it can be done in a table then it can be transferred to forms & reports etc, I want...

Hi all, I'm working on fixing one of the databases at work, it wasn't displaying the client name or site address when a text field was added, only the clientID & siteID numbers were displayed, to get it to display the client name & site address how it should I used the below DLookUp code as the...

Great move changing to Xenforo, I used to use it myself on sites back in the day, I never looked back after changing from vb

Sorry, I have seen that posted before, I should've put that the combo box would be on the form, just as part of m learning curve, how come you don't like the lookup fields that are available when setting up forms but others think they are ok? I thought as much, just wanted to check though :) I...

Hi jdraw, The requirements are basically listed in my post, we have a set of 20 questions on a sheet that is taken to the sites we are auditing & the database needs to be able to store the results of the audits with the same questions answered to calculate the result. I will have a look at...

Hi all, I need to build a database to log the results of the audits our managers do on site, I haven't ever built anything like that before & I was wondering of the best way to go about it. Each audit would have the following fields updated on a table AuditID (pk) AuditDate (date/time)...

I'm getting the same warning using chrome too, I'm sure they'll get it fixed soon though

Thanks theDBguy, I'll give that a try Hi Gasman, Each of the buttons on the form have text in the body, I just copies the blank template, some use the "CC" & have attachments too :)

Thank you theDBguy, I haven't ever used that before, could you give a bit more info on how to use it please

Hi all, I am using the below code to create a temporary file in .pdf format, open an email in outlook, attached the .pdf file & add an email address, a subject & body to the email. Everything is working fine with the code apart from one thing, it doesn't add the signature at the bottom of the...