Search results

My database is split with a front end that is used by upto 200 people,* size of front end is 12mb, and each user copies this into their temp folder everytime they open the database. The back end - I actually have 3 different back ends.* 1 that imports data from our system every night, this...

I have been asked the question about importing data from the body of a email into access, and then splitting out into separate fields, A example of the data is enclosed below, This would have to go into their own fields. email_Q1_1_Your_Name: John Smith email_Q1_2_Managers_Name: Jenny Smith...

I have the code below that looks between 2 dates. and returns a 1 if the value is true. Problem i have is that sometimes the Date_Removed is blank (Because the supplier has not been removed from the list) so how do i amend to include or iif date removed is null ? Targeted...

Done, in new database, no other Modules in DB. I get a Error on Dim olApp As Outlook.Application

Dim olApp As Outlook.Application Dim objRems As Outlook.Reminders Dim objRem As Outlook.Reminder Set olApp = New Outlook.Application Set objRems = olApp.Reminders For Each objRem In objRems If objRem.IsVisible = True Then objRem.Snooze End If Next objRem Set...

I checked the references and nothing was highlighted as missing. (Pic enclosed) I did not previously have a tick in the Microsoft Outlook Object Library, so i have now put a tick in that box and now getting error 424 Object Required at the Line Set olApp = New Outlook.Application When i hover...

Hi both, thanks for the advice so far, I tried the above code provided by Bilbo_Baggins_Esq and get a error message. "Compile error. User Defined type not defined" the following code is highighted. Dim olApp As Outlook.Application I have attached additional screenshots of the objrems locals...

OK, My laptop has now been upgraded to 2016 and i am now seeing the error. Looking in the locals window, I can see the enclosed. Objrem - Value - Nothing - Type - Object is this what you need ? how do i get round this ? Regards T61

My users input data into a continuous sub form, I look at a value of a field from this sub form and dependent on what is entered into the field I have a button that emails out to different people. Quite often the email address's are left blank, I have worked out that this is because the...

I have the following code which seems to have worked for ages, is all of a sudden giving me a issue. the code runs ok, but i get the message saying that the file has failed adding the attachment, check if it exists. Even though i know the attachments exist. In total there are 30 attachments...

Thanks, your guess was correct...

I have a subform which contains a field called Tbdesc, which is locked if the field is not null Code below. I want to add another criteria to this so that the field is unlocked if the user entered the original data. If Nz(tbDesc, "") = "" Then tbDesc.Locked = False...

I have spotted another issue with the above, I have 3 search buttons on my form, 1 using the code above, and this works ok, 2nd using this code. Private Sub BtnSupplierSearch_Click() Dim Supp As String Supp = InputBox("Enter Supplier Code . . . ", "Search Supplier")...

Ok, had a bit of a google and found that this code works just as well. i get error 13 if i enter text into the search, but i am capturing that using the same error trap Dim rs As Object Dim lngID As Long lngID = InputBox("Please enter the Job Number.") If lngID > 0 Then Set rs =...

I have a search button, that searches for a job number (tbjobid) yesterday i spotted a issue where that if people either left the search term null, or pressed cancel, or input text into the field i got a error message, SO i amended the code, but i am not convinced it is written in the best way...

I have a form with a button (Code below) that allows people to add a link to a attachment which is stored on our server. Problem is people are not the brightest and tend to link to files that are on their desktop (so no one else can open them) How can i change the code below so it checks the...

Thanks, we are using office 2013, could that be the difference ?

I have now updated to the new version of the code amended by Jdraw, which now looks at the subform. One of my operators is having a error message when it reaches the code Set cnn = CurrentProject.Connection and i get the error "Class not Registered" I am not logging the new records, or the...

When a user logs into my db I currently log login time , userid and pc number.. is it also possible via code to pull back which version of access they are using ? My db is currently in access 2000, but I am thinking of moving this to a later version (if all users have later version installed)...

Just read post 14, not even going to pretend that I understand it. Our db is created in access 2010, I did see a post from yourself in one of the other threads when you managed to get it working for subforms.. I might have a go at adapting that tomorrow.. Sent from my SM-T715 using Tapatalk