Search results

No error flshes up against requery, so i believe its working, but still get all the names, not just the company's ones. Just to make sure my code is: SELECT [First Name] & " " & [Surname] AS Name FROM tblCustomers WHERE (tblCustomers.[Company Name] Like "*" & Forms!FrmSearchCriteria![Company...

I thought it might be due to the under score between Company_Name Private Sub CmboCompany_Name_AfterUpdate() Is now Private Sub CmboCompanyName_AfterUpdate() Still same error though

Hi Tim, Thanks for your advice i will take that on board, its diffcult to start renaming stuff once ive started isnt it? I have renamed my combo box though and tried to up run the following: Private Sub CmboCompany_Name_AfterUpdate() Me.CmboFirstLastName.Refresh End Sub but i...

When running two append queries from a button how can i suppress the confirmations msgs to make just one custom msg "Are you sure Yes/No" Then "Import Complete". Private Sub Import_Click() Docmd.OpenQuery "Append1" DoCmd.OpenQuery "Append2" End Sub

I have following to check if a contact already exists, If DCount("*", "[tblCustomers]", "[Surname]= '" & Me.Surname & "' And [First name] = '" & Me.First_Name & "' And [Company Name] = '" & Me.Company_Name & "'") Then Beep MsgBox "This name already exists in the database!" & vbCrLf & " Please...

This is the code i tried; SELECT [First Name] & " " & [Surname] AS Name FROM tblCustomers WHERE ((([tblCustomers].[Company Name]=[Forms]![FrmSearchCriteria]![Company Name] Or [Forms]![FrmSearchCriteria]![Company Name] Is Null)=True)); But get the same results; no matter what company is...

Hi Tim, They are both in the same table, and on the row source of the name box i have the following: SELECT [First Name] & " " & [Surname] AS Name FROM tblCustomers WHERE (((tblCustomers.[Company Name]) Like "*" & [Forms]![FrmSearchCriteria]![Company Name])); But this gives me the same result...

I have two combo boxes, Company Name & Name. The data that is selected is used to run a query from a button. However i would like to set it that if the user (but not required) selects the company name then only the names of the people belonging to that company appear, but if no company is...

IGNORE Me!!!! stupid error in code. Thanks for looking

Hi I have written my If statement as follows: If Me.Passwd1 <> Me.Passwd1 Then MsgBox "Passwords do not match!" Me.Passwd1 = "" Me.Passwd2 = "" Me.Passwd1.SetFocus Else Me.password = Me.Passwd1 Me.DateLastUpdated = Date Me.UpdatedBy = vUserID...

From other forums i found someone make a suggestion of a program that will automatically click yes called Express clickYes, can be found at http://www.contextmagic.com/downloads.htm It's slow as you have to wait for outlook's 5 sec countdown per email you send but it will the job, if somewhat...

Sorry its that friday feeling blocking messages from my brain!! thanks

Hi Everyone i am trying to run a query that gets the records within a date range, asking the user for a start date and end date. How i think the problem is because the field is date & time. >= [Please enter first date] <= [Please enter last date] This seems to produce all the results. I even...

Hooks; i am my exchange admin!!!! ha ha and i have tried searching the microsoft sites and even looked through and Outlook forum, but to no avail i haven't been able to search for the option to disable it. Maybe you can ask your exchange guys for me?? I have also been working on IzyRider's idea...

I have created a query that append all the records to another table3 that are older than two years. But at the same time delete from the original table1. If i was doing it from a form i would DoCmd.OpenQuery "MoveQuery" DoCmd.RunCommand acCmdDeleteRecord However it will be moving several...

Hi I have created some code that sends an email to everyone who has email ticked. This works fine no problem. However i have Outlook XP and everytime it access creates a new email. Outlook pops up a warning saying that a program is trying to automatically send an email will you allow this yes or...

So Simple should have thought that!!! thanks

I have a query that has a criteria from a field on a form... [forms]![frmSearchCriteria]![Company_Name] I would like to put wild cards * on eitherside that it uses will bring up with anything with what is written into the field. I have tried putting wild cards on the form field and on the...

I have created a button to save changes and to undo changes on a form. However if the user has not made any changes, i get a message saying that the Undo command is not available and the same with save changes. Therefore if no changes had been made i would like to just ignore that part of the...

Hi that works thanks