Recent content by Elvis72

Its been awhile since I have created a database, I have done a categoryid and subcategoryid and a table combining them...not sure that falls under normalized?

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...

Just a suggestion, when dealing with forms for work I place text fields on the document where I need them. This allows the user to input data without having to create a form. The other thing you can do is create the form in word and then convert to PDF. Hope this might help!~

Well this is what I have figured out this far... I am in Word...and I was able to create the Header Table using the AutoText Function....works Great!~ So, I created another AutoText for the next line in the table, works great...Except when I try to use a Macro to insert a Field for the...

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...

Mintjulep!~ Thanks so much, the Seq did not work but I did find ListNum did!~

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!~...

OK... I am thinking I have not conveyed my issues completely... I have the above Query that produces a Chart on a form. It is currently asking for Project Number. I have a combined combobox in form: Select Project/Proposal that has: Job Number/Client/Title in the drop down to switch the...

I have multiple subforms that can be updated that have this code so we knoe when a record has been modified. A Few of the Subforms are: Project Information Language College/University Experience Memberships Etc. Each of these has the event. Is there a better way to look at every field and...

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.