I don't know why you have so many "" but I do know that you don't need as many as you have.
Try the following. Also since you are only selecting from 1 table, you don't need the table reference in front of the fields. The only time you need them is when you are using more than 1 table and there...
I don't know why you have so many "" but I do know that you don't need as many as you have.
Try the following. Also since you are only selecting from 1 table, you don't need the table reference in front of the fields. The only time you need them is when you are using more than 1 table and there...
Easier to understand if you use an alias for each table (A,B)
update MSP_TEST_MSP_SYNCHTABLE A
set A.Chargeable_Flag = (select B.FLAG_VALUE from MSP_TEST_MSP_FLAG_FIELDS B
where B.Proj_ID = A.Proj_ID
and B.FLAG_FIELD_ID = 188743752
and B.FLAG_REF_UID = 0);
The assumption here (since I don't...
Assume that the field that holds the birth date is called "BirthDate".
In the query, in the last column, paste the line below in the "field" row.
showmonth: Month([Birthdate])
Leave the "table" row empty.
Select either ascending or descending in the "sort" row.
Deselect the check box in the...
Instead of opening a recordset, try deleting using DoCmd and RunSql, as follows:
Private Sub cmdDelete_Click()
Dim strSql As String
Dim intActivityId As Integer
intActivityId = lstCurrentlyBooked
strSql = "Delete from ActivitiesBooked where ActivityId = " & intActivityId & ";"...
I have never seen both the "if" and "else" sections of a "if...else...end if" get executed. I would suspect the the email is getting generated elsewhere.
As a test, comment out everything in the "else" section. Add a simple msgbox command as shown below:
msgbox "email will get sent"
Run it...
I found that checking a control for null in that manner doesn't necessarily work so I wrote a little function that will check if a control is empty.
-------------------------------------------------------
Function IsSomethingInControl(MyControl As Control) As Integer
IsSomethingInControl =...
I will assume that Me![Text56] is the text box with the string search criteria.
For partial search strings you need to use the "like" operator, the wildcard character, and a combination of single and double quotes.
The stLinkCriteria would be as follows.
stLinkCriteria = "[strCity] like '*"...
Open the form in design view, open the form properties box, click on the event tab, double click in the "On Open" event so you see "[Event Procedure]" in the box. Click on the small box to the right of the "On Open" event to get to the code window. In the "Form_Open" sub procedure key in...
In the sql statement below, replace the table and field names with your table and field names. Create a new query, click on "View" and select "SQL View". Cut and paste the modified sql statement into the query "SQL View" box. Run the query.
UPDATE CustomerTable INNER JOIN ProvinceLookUp ON...
Yes, unfortunately, that is normal. To get the size of your database down, you need to compact it ever so often. Use menu options "Tools/Database Utilities/Compact and Repair Database" and select your database to compact.
Your query was as follows:
SELECT Main.FirstNm, Main.M, Main.LastNm, Main.Address1, Main.Address2, Main.City, Main.State, Main.Zip, ID.IDNum, Main.SocSecID;
FROM Main INNER JOIN ID ON Main.SocSecID = ID.SocSecID WHERE Left([ID.IDNum],2)="CA" AND CLng(Mid([Main.IDNum],3)) Between [Please enter...
Paul
Not sure what you want as the stating of your needs is a little difficult to make out exactly what you want to do.
However, I get the idea that you want a user to be able to enter a 2 character state designator and a from/to number range.
To test a solution, I created a 1 field table -...
Sorry bluegnu - I did this on the rush and forgot to have the search string append to itself when it finds a criteria that has a value.
All you have to do is append the new part of the criteria to the current search string as shown below:
SearchCriteria = SearchCriteria & " and
in each of...
What Golom mentions about formats for different data types in the search string is correct.
I would approach building the search string differently. I would add to it as I tested each control for null - as follows.
Private Sub Search_Click()
Dim SearchCriteria As String
'set criteria to an...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.