Search results

Thanks for you reply CJ London. Sorry, I didn't say did I? It's erroring as soon as I start trying to set the details of the appointment, ie. outMail.Subject = "Meeting room booked". If I rem out that line, the next one errors, and so on. So I'm guessing there's something wrong with the set up...

Hi, I'm trying to create an Outlook appointment from VBA, but my code keeps throwing up a RunTime Error 438 - Object doesn't support this property or method. I'm guessing it's something simple, but I just can't figure it out! Here's the code: Dim outApp As Object Dim outMail As...

Brilliant, thanks JHB! Finally something worked. I would never have thought of using the html!

Thanks for your reply! The logic in the statement is definitely working because the text from the [Text305] box following the carriage returns is being concatenated properly, but it's just displaying 2 spaces in front of the text where the new lines should be! We've also tried putting the new...

Hi All, The following code is in a text box on a report in a database that creates work contracts. The IIF statements and Dlookups pull the parts of the text together perfectly, but can anyone suggest why the new line and carriage returns are completely ignored in the last section? Been...

Wow, that works perfectly, thank you so much. It would have taken me weeks to work that out! Here's the final sql in my query which searches in 4 fields... SELECT tbl_MasterAccountBase.AccountRef, tbl_MasterAccountBase.BasisSAPNo, tbl_MasterAccountBase.AccountName...

I'll experiment and let you know!

Sorry Brian, I missed that. I should read more carefully! Yes, partial searches are essential, which is why I've used like. Often the user will be searching for a list of account numbers that begin with a certain number etc. Do you know any other way around this? Thanks, Simon

Thanks for replying guys, I did think of doing that, but I've just tried it and as I thought, when you input a search criteria, the query now returns records that match your criteria, but also returns all the blank records too! I need to show all fields when there's no search criteria...

Morning, I've created a filter using a query to list records in a continuous form. In the query I have a criteria in each field similar to this: Like "*" & [forms]![frm_ManageAccounts]![txtAccountRefSearch] & "*" The problem is that if there are any blank fields, the record is not shown...

Ok, so what about functions such as DateAdd, do they also regard the date as US format? So would I need to use something like the following: dtCurrentCallDate = Format(Me.txtDateEntered,"mm/dd/yyyy") dtNewCallDate = DateAdd("d", intInterval, dtCurrentCallDate) Thanks, Simon

Thanks Paul, that's brilliant, I've bookmarked Allen Browne's page. I've been looking for an explanation that made sense for quite a while. Access seemed to be so inconsistent with dates, now I understand why! I guess it's probably best to force the date into American format as soon as it's...

Morning All, I'm having a nightmare with dates in Access VBA! Here is what's happening: The date is entered on a form using the date picker. Let's say I select 07 April 2013. This is then then transfered to a date variable (dtNewDate). The value in the variable is then inserted into a date...

Thanks for that. That's the problem with being self-taught in a hurry - you miss some of the basics! I've now indexed all the fields in the accountbase that are used in searches. I'll keep that in mind in future.

Sorry, yes, every table in the database has an index field. It seems that running the DCount from the text box causes it to calculate a lot slower.

I've just moved the DCounts into the On Current event rather than putting them in the text boxes. They now load instantly!

Sorry, not too sure what you mean by 'index' on the criteria. Sorry if I'm being a bit slow!

There are actually 4 DCounts. They pull back totals of various account types from an accountbase of about 18000 records. The database is shared and updated by about 20 people at any one time. The DCounts work perfectly, just take a little while to populate when the form is opened...

Hi, I have a DCount in an unbound text box. When the form is opened this takes about 30 seconds to update as there is a lot of data to query! I'd like to display an 'updating data' message underneath the text box that disappears once the box has updated, but I can't find an event that is...

Ok, managed to solve my own problem! For anyone else trying to achieve the same thing this is how to do it... I was thinking along the correct lines with *, just wasn't applying it correctly. You need to use like and concatenate your original criteria variable with *. So in a query criteria...