Search results

Thanks Doc Man. I'm impressed and will keep a note of this post for future reference.

If there is no reason to work in the back end (such as security as pointed out by Uncle Gizmo), then you should work in the front end. The fact that you can't activate the form in the Front End suggests it is based on table(s) not linked to the back end. In a perfect world, there would be no...

The # signs are put round expressions such as 02/01/2017 to force Access to treat it as a date. It only works that way round - if it is already a date in access (like your [Forms]![CDB_LIST_FORM]![Begin-Date]), there is no translation needed, so enclosing it in ## will produce an error. In...

Hi there, I see no-one has answered your question, so I thought I'd at least have a go at giving you something useful (for what it's worth). The obvious solution would have been for Google Translate (or Microsoft) to provide a simple downloadable version so you didn't have to connect via the...

I knew it had to be Yorkshire! I lived in Hull in the '70s when it was officially "Humberside" but they always considered themselves Yorkies and I consider myself an honourable one! Yorkies are in a class of their own!

The first thing is to paste the procedure into the main Form's VBA. Then you can "call" it with the line: "Call AddRecordRowNumbers" (without quotes) from whatever control/event you choose. Not sure how familiar you are with VBA, but you'll need to enter the actual names where it says...

In order to "freeze" the sort order set up by the last user, you'll need a table field - not an unbound field - that saves the record number, so it can be used to sort the records when next opened. Used in a form's RecordsetClone, ".absoluteposition" outputs the record number position in the...

Thanks Royce and Static. As I have only ever linked to other Access databases as the back end, this problem is new to me. If in future I need to link to SQL Server, I can revisit this thread, knowing there's a solution.

I'm with Galileo. But good point!

There was a post on this website in Jan 2008 labelled: "Bringing an open Access form in the background to the front" Google that and it should hopefully answer your question. (Which particular "God's own country" by the way? I thought they were all God's.)

I answered your post "Cascading Combo Box with Value List Row Source Type" a couple of days ago. You may not have noticed because it's on page 2 of the thread.

Quick postscript - you can release the filter by clicking on the "Filtered" button at the bottom of the subform - very useful as you can toggle it on and off without changing the filter.

Yes, your code has a couple of small errors (c'est la vie!) In your code: Private Sub Text30_Click() Dim strFilter As String strFilter = "[Kit] In('" & "[q27_KitsWithSharedParts_2]![Kit_Number]" & "')" Me.Filter = strFilter Me.FilterOn = True End Sub The line strFilter = "[Kit] In('" &...

Sorry Shafara7, I missed off one "End If" at the end of the "if (cboProject.value = 0) Then" paragraph. There's always somethilng!

Hi Shafara7, In all the examples I've seen, the FilterOn property comes after the Filter, e.g. Me.Filter = "Country = 'USA'" Me.FilterOn = True not the other way round. It may not make a difference. In your AfterUpdate code for each of the two comboboxes, you should include filters for Both...

Hi Royce, I have been successfully using code to relink my databases for years, without knowing how it worked (it was a copy and paste job!) But now I know more about VBA I can understand it, and looking through it carefully, nowhere does it create a new table or delete the old one. The...

I see how frustrating this is for you. Have you tried creating the HTML body as a string (see my last post) to see if this creates the string you wanted in your email? As regards the variable declaration, I've had another look. You seem to have set the Outlook variables twice: Set myOlApp =...

I see you still haven't declared variables for myOlApp, myItem, appOutLook, MailOutLook as I suggested and this might be the cause. To find out, I suggest you create a string variable for the HTML body first and see if that is populating, before inserting it into the email. I tend to use...

Glad we got there in the end!

Hi, You haven't declared variables myOlApp, myItem, appOutLook, MailOutLook Dim myOlApp As Outlook.Application Dim myItem as Outlook.MailItem etc etc. Hope that helps.