Search results

Just out of interest, what code are you planning to use? I've seen this one being used on a few sites and it doesn't seem that hard to implement. https://silktide.com/tools/cookie-consent/ There's even a wizard to help generate some code here: https://silktide.com/tools/cookie-consent/download/

I forgot to add, if you use the & operator instead of the + operator, it ignores the null values. This is why your code didn't work.

This should work: If IsNull(textbox1.value) or IsNull(textbox2.value) or IsNull(textbox3.value) or IsNull(textbox4.value) or IsNull(textbox5.value) Then Or this too: If IsNull(textbox1.value + textbox2.value + textbox3.value + textbox4.value + textbox5.value) Then The first way works...

Hi All, I was thinking of posting a load of modules, class modules and other bits and pieces I've built up over the years for others to use them. In the past anything I've shared contained a small comment that confirms they can use it freely. However I was thinking that perhaps something more...

Sorted! Private Sub Form_Open(Cancel As Integer) Dim cn As ADODB.Connection Dim rs As ADODB.Recordset Set cn = New ADODB.Connection With cn .ConnectionString = "Provider=ADSDSOObject;Trusted_Connection=yes;" .Open End With Set rs = New ADODB.Recordset...

I've got an idea what it might be. It looks like it only throws that error when there's around 1000 records or more to return.

Thanks Galaxiom, Certainly getting there. It's not crashing Access anymore and it's displaying the data in the first record and I can see there are 991 records returned. However, it's also throwing the following error: Run-time error '-2147467259 (80004005)': Data provider or other service...

Silly question - but I'll ask it anyway... if I recall correctly (I haven't got access to Gmail at work) you need to enable your gmail account to allow access through smtp, pop3, imap, etc. Has this been done?

are RemainingQty & stock numbers or text? IF they are numbers, you should remove the single quote marks i.e. ' also if dlookup can't find a matching record, I think it returns a null value so you'll need to handle that. also, the me.cmb_cutomer1 & me.cmb_stock_type1 might contain nulls as...

[SOLVED] Connect Datasheet form to Active Directory Search Results Hi All, I'm trying to tie a from into the results from and AD Query. I'm not that experienced with doing this kind of thing so I may be going about this the wrong way. Anyway here's what I've got so far: Private Sub...

Quick Examples: Select Field1, Field2 from Table where X=3 order by Field2 ASC Select Field1, Field2 from Table where X=3 order by Field2 DESC Select Field1, Field2 from Table where X=3 order by Field2 DESC, Field3 ASC ASC means ascending order, DESC means descending order

I would do except that there's too much variation. The CSV is generated on the fly and sometimes doesn't exist yet. It is written to to the users temp folder which can differ per user and per PC e.g. set temp TEMP=C:\Users\MyUserName\AppData\Local\Temp or set temp TEMP=D:\Windows\TEMP If I...

(MS Access 2010) Hi All, I'm trying to find some code to allow a datasheet form to link to a csv file. I'd like the link to the data to be dynamic so it connects when the form loads as the access database will be run from a network share by multiple people at the same time. The CSV file will be...

This is a simple module with functions that allow you to change captions, labels, etc. in your access interface depending on the current user's locale. It relies on a language table. As text fields in Access tables allow unicode, this method will allow text from Right-To-Left languages like...

oooh good spot. I thought Jibb's code looked odd but didn't read it through. However... careful - That's a vbYesNoCancel not a vbYesNo in there. The "Else" statements will execute if a user clicks Yes or Cancel. Test for =vbYes instead of =vbNo so the Else will apply for No & Cancel. However...

the docmd.sendobject allows you to send reports, queties, tables, etc. via email. It covers a few different formats but not as far as I remember XML. However, you can programatically export xml to a file using the ExportXML command. Here's a quick snipet from MSTechNet as an example: Const...

looking at the code you posted, the "If vbYes Then" line checks to see if the user wanted to save the record. So I'd pop it in just after that.

Hi mrodent, While your waiting, have you thought about using a Nested Set Model (NSM) instead of the Adjacency Model for your table? with that it's much simpler to write queries to list all child nodes without recursion.

to save the record stick in : If Me.Dirty Then Me.Dirty = False End If

Updated on 3rd Feb 2012 with new version of code (attached) Here's a Hebrew date class I've been recently building. It performs direct conversion between Hebrew and Gregorian dates, Yahrzeit calculations and GUI Hebrew Date Picker dialog box. The file is is Access 2010 format and contains an...