Rick Beach
Last Activity: Mar 23 '12, 12:59 PM
Joined: Jan 6 '11
Location:
-
The msgbox you are referring to is if there is no pdf file name. This message box I need. The two files being opened after the else statement is where I need assistance. I need to see if the Me.JobPlanFolde r (This contains the file path and file name) exists before running the "Call Shell(stAppName , 1)". If the Me.JobPlanFolde r does not exist I need to run the "Call Shell(stAppName 2, 1)". -
How to know if a pdf file does not exist
Below is the code I use to open a pdf file.
...Code:1.)Dim stAppName As String 2.) Dim varFile As String 3.) Dim varFile2 As String 4.) 5.)If Right(Me.JobPlanFolder, 5) = "\.pdf" Then 6.) 7.)MsgBox "There is no Job Plan associated with this record." 8.) 9.)Else 10.) 11.)varFile = Me.JobPlanFolder 12.) 13.)stAppName = "C:\Program
-
I had attempted this but was not placing this in the right location. This needed to be in the HEAD section and used the BODY ONLOAD event to run the script. This works properly. I appreciate your assistance.Leave a comment:
-
How to hide gridview on open
The below programming works properly to show and hide gridviews:
<script type="text/javascript">
function hideGrid()
{document.getEl ementById("Grid view3").style.d ispla y = "none";}
function showGrid()
{document.getEl ementById("Grid view3").style.d ispla y = "block";}
</script>
<INPUT Type="button" Value="Show... -
You are amazing.....
ThanksLeave a comment:
-
Actually, his programming works. That was when I stated the query was running after 20 minutes. Once I used the full tables, yours also does the same. There are 29,051 records in the Equipment table and 47,318 records in the Equipment Requested table. Do you have any suggestions to make this run faster?Leave a comment:
-
In Dsantino's the parenthesis were the onle real differences that I notice once the tags "e" and "chs" are removed:
Dsantino's where statement:
WHERE Equipment.[EquipJ-tag#] IN(SELECT JTag FROM CHSRRequestInPr ogressB)
Your where statement:
WHERE (((Equipment.[EquipJ-tag#]) In (SELECT JTag FROM CHSRRequestInPr ogressB)));
I do appreciate both of your assistance.
...Leave a comment:
-
The query listed above is different than any others that were sent. This one works. I really appreciate all of your time and assistance.Leave a comment:
-
I have Microsoft Access 2010.Leave a comment:
-
I forced the date to be 01032011 in the query and changed the table to reflect CHSR45949-01032011 and I still am not able to delete the record. The record is still not updateable. I will change this back to the original format of CHSR45949-1/3/2011.Leave a comment:
-
Also note that if the delete query is run in Datasheet view, the record is found and listed.Leave a comment:
-
I have the query result on the screen and it is:
CHSR45949-1/3/2011
This was copied from the query. There are no leading zero's in the date format.Leave a comment:
-
I made an error in the date for the above Equipment record, it should read CHSR45949-1/3/2011. I think I need to pay closer attention.
ThanksLeave a comment:
-
On the above sample of an Equipment Record, change the CHSR45948-1/4/2011 to CHSR45949-1/5/2011 so both records will match. I accidentally send one record off from the Equipment table.Leave a comment:
-
Below are the two tables used for the queries:
Equipment
EquipJ-tag# Text
StatusID Number
CabJ-tag# Text
EquipLoc Text
Manufacturer Text
Model Text
SerNum Text
NumCords Number
Floor Text
Notes Text
Updated Date/Time
PlanID Number
HLAmps Number
EquipmentReques ted...Leave a comment:
-
Error from Delete Query with Inner Join
I have logged off and back on. I even closed the browser and reopened. I still receive the same error stating "Your submission could not be processed because a security token was missing".Leave a comment:
-
Error From Delete Query with Inner Join
I cannot seem to attach a txt file or a zip file. I receive an error stating a security token was missing.Leave a comment:
-
I have also attempted the below statement:
DELETE Equipment.*
FROM Equipment
WHERE (((Equipment.[EquipJ-tag#])=(SELECT CHSRRequestInPr ogressB.JTag
FROM CHSRRequestInPr ogressB)));
This gives an error stating "At most one record can be returned by this subquery." The help section states "A subquery of this kind cannot return more than one record. Revise the SELECT statement of the subquery...Leave a comment:
-
This gives the same aggregate function error. I believe it is the "Group By" statement.
The table is an access table.Leave a comment:
-
This gives an error: You tried to execute a querythat does not include the specified expression 'e.[EquipJ-tag#]=' as part of an aggregate function.Leave a comment:
No activity results to display
Leave a comment: