I have a form that has the following:
Category SubCategory
Dogs Maltese
Dogs Golden Retreiver
Birds Parakeet
Birds Finch
I would like to select Dogs from Category and have SubCategory automatically limited by that selection.
I have looked through pages of postings...
Hello!~
I am trying to setup a Macro that will create a table header and resize the cells.
When I create the macro it will not let me edit the table parameters, I can't change the margins or the cell size?
Is this a finite thing or is there a work-a-round?
Thanks!~
I have a Table of Contents in Word that I have had to create with Hyperlinks to 400 Word Files.
The client wants to be able to open the external documents from the TOC on a CD.
I found an posting here that gave me this:
Option Explicit
Dim TrkStatus As Boolean ' Track Changes flag...
Good Morning!~
I am working on a client driven procedure template.
Each action in the procedure has to have a sign-off so the page looks like this:
TIME
Start Stop Initials
_____/_____ ________ 1. Action
_____/_____ ________ a. Subaction
I have tried this 2 ways:
-...
I am in the All Documents View and I have a list of folders that hold procedures.
The name of the folder has the procedure number, but we need to also add the title for reference.
I added the Description column to the view, and I see it...but I cannot for the life of me figure out how to add...
I have Drawing 1 which has text boxes on it that I want to copy to Drawing 1A, when I copy and paste it flips all the boxes where the text is upside down.
It even does it when I insert the pages into the same document and copy/paste.
Any ideas?
This will save hours of work for my engineers!~...
I have the following Query:
PARAMETERS [Enter Job/Proposal Number] Long;
SELECT TblProjectInformation.JobProposalNo, TblConstructionServices.Title, Count(TblProjectInformation.ProjectID) AS CountOfProjectID, TblDate.TheDate, TblProjectInformation.[HR Classification]...
OK, I have a Main Form with several tabs and subforms.
On the Main Form I have a Text box: Text153 which is linked to Date Last Modified in my Resumes Table.
Then I have this event on After Update:
Private Sub Form_AfterUpdate()
Me.Parent.Text153 = Now()
End Sub
Which was working fine but...
One of the guys I work with has a spreadsheet he has used for forever.
All of the sudden the column headings went from A,B,C to 1,2,3?
He hasn't done anything different, I have not clue?
It has links to different pages in the spreadsheet with formulas but other than that I can't see any issues.
Same Search Form as the previous post but it just hit me that either you have all the criteria given or you have nothing.
So how would I change this to an AND/OR Search?
Private Sub Command12_Click()
Dim strWhere As String
Dim lngLen As Long
Const conJetDate = "\#mm\/dd\/yyyy\#"...
I have a great multiple filter search form:
Private Sub Command12_Click()
Dim strWhere As String
Dim lngLen As Long
Const conJetDate = "\#mm\/dd\/yyyy\#"
If Not IsNull(Me.txtfirstname) Then
strWhere = strWhere & "([First Name] Like ""*" & Me.txtfirstname & "*"")...
I have a Demobilization and an Mobilization for every Personnel record related to a project.
I need to accomplish this:
Name Mobilization Demobilization Total Months
Jack Sprat 1/1/2008 1/1/2009 12
June Carter 1/1/2008 2/1/2009 1
All I can locate to...
Hello!~
I have a user that opens PDF's on the portal and then draws on the PDF.
When he goes to save, he hits save...it acts like it does but does not update the portal.
When he hits save as it opens to his My Documents.
How can he save directly back to the portal?
I have this multiple search criteria form that I need to make the search results exportable by simple users into an excel spreadsheet.
The simplest approach in my mind is to add a button...but from reading some of the posts...maybe not?
For grins here is the code for the form just in case it...
I have this code for one of my text boxes:
If Not IsNull(Me.txtfirstname) Then
strWhere = strWhere & "([First Name] Like ""*" & Me.txtfirstname & "*"") AND "
End IF
Now, I need to make one that can handle a range of numbers.
I have the following field:
Years Experience
They...
I have in the past created forms that had 2 search boxes that popped up for searching like this:
Enter First Criteria:
Refinery
Enter Second Criteria:
Saudi Arabia
At the moment I have a Find as You Type Form that works fine, but I need to be able to narrow results with multiple criteria like...
At the moment I have the following:
TblPlantType
PlantTypeID
PlantType
TblPlantTypeList
PlantTypeID
ProjectTypeID
JobProposalNo
TblProjectInformation
ProjectID
TitleID
WorkerID
JobProposalNo
Requisition No
Mobilization Date
Demobilization Date
TblResumes
WorkerID
First Name
Last Name
Address...
I have a report that has a Title Field on the Page Header which on the Report its fine....
When I click to have it put into Excel the title of the text label shows up but the information the the title field does not.
So I have this:
===============================================
Project One...
I need to have the whole record on a report highlighted in Red if the Last Name field is null.
I understand the Conditional Formatting tool in reference to dates and numbers, but not text?
Any help is GREATLY appreciated!~
OK, I have searched and searched, while I have found helpful posts I can't find one that hits home with what my end goal is.
I have a Main Form, then I have multiple SubForms, I need to have a field on the Main Form that shows the date something on the Main Form or Subforms was last updated.
I...
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.