Genalube
Last Activity: Oct 23 '07, 08:36 PM
Joined: Nov 3 '06
Location:
-
Actually I saved when I closed and had noticed the space after I posted (it doesn't show in the actual query). I guess if it happens again I'll have more information. Thank you for your reply.... -
I am even more confused now, it is working again.
Can anyone tell me what is going on?Leave a comment:
-
Self Destructing Query Expressions?
All right I am new at access but why would my calculated fields in my query self destruct all of a sudden? I tested these expressions, saved the query and closed it. I reopened them and tested it. Then left access for a minute, but left it open, and when I return to it I get the following:
Compile error . in query expression '{quotes expression}
This is the expression that is quoted when I try to run the query:... -
I thought the following thread and this one were different, but thinking about it, they are really two ways of looking at the same problem. Perhaps merging them would be good. I think this violates one of the posting guidlines, sorry if it does. I did not intend to make two posts on the same thing.
showthread.php? p=2640647#post2 640647
I really don't know, maybe using code is better than using a query, I am too new...Leave a comment:
-
The purpose is for a file name that gets created, if this is the third owner than the file name has a 3 at the end. The problem with autonumber is that there is a many to many relationship between owners and the subparcels. Parcels can have more than one owner and owners can have more than one parcel. I only want to count the owners that apply to a specific parcel that is a parameter in my query....Leave a comment:
-
Okay that works great, I forgot to mention the datatype is text and it is already sorted so I just wrote this:
After I got...Code:'Check if there are more than one owner conveyQueryData.MoveFirst FirstOwner = conveyQueryData("OwnName").Value conveyQueryData.MoveLast LastOwner = conveyQueryData("OwnName").Value conveyQueryData.MoveFirstLeave a comment:
-
I am really pretty new at this, and don't really understand the differences. The help files in access just seem to say it is for changing the format so columns in tables become rows. I am sorry to ask what feels like a dumb question, but could you please enlighten me?...Leave a comment:
-
I have gotten my subquery working so now my count field shows 3 for my three owners (for all records returned). I would really like to know however how to asign each their respective number (1, 2, or 3). Is this relatively simple?Leave a comment:
-
Calculated Count field in Query
I am trying to count the number of owners that show up in a query (conveyQuery). The query will produce a column OwnName that will contain names like John Smith, Mike Jones, Frank Vaugn. Each of these names may show up several times and the sorting is such that all the items that person owns will group together. There is a field callled SubParcelNo that has an ID that defines what the owner actually owns. When the query is run, it will return... -
Looking for data in an ADO recordset
I am tyring to write something in VB that lets me check if the first and last record in the OwnName field are identical.
I am also trying to find out if the field SubParcelNo has a 2 in it. This field may also have entries like 2A, 2C I don't want to know about them, only if it has just a 2.
Is this possible?
My attempts at it have failed. -
I am rather new at using access and VBA, and don't quite understand. In the query you used, is the name of the function "ModifiedNo " ? Do I store it under the macros or modules objects or somewhere else?
Since the number of leading zeros is dependant upon the number of records, how could I tweak it to not count all the records?...Leave a comment:
-
I have a query called parcelRange which formats the parcel numbers according to this SQL query:
The query is sorted ascending on the Expr1 field.Code:SELECT Parcels.ParcelNo, Format(Val([ParcelNo]),"000") AS Expr1 FROM Parcels ORDER BY Format(Val([ParcelNo]),"000");
When I open a form I have it run this (in part) I didn’t really know how to do this well so I used a record...Leave a comment:
-
Problem with conditional formatting
I am trying to format text that represents user defined "numbers" these numbers have text on the back end sometimes.
Here is some examples of these numbers, which is how they are stored:
1, 2, 3, 12, 12B, 15, 16, 20, 100, 156L
I want to format them based on how many records there are in the table. The table is called "Parcels" the numbers are in the field "ParcelNo" as text.... -
SELECT vs. SELECT DISTINCT
I am running a query that includes the inclusion of memo fields, my query pulls from four different tables with one to many relationships between them. The relationships are such that when I run my query I get several identical records.
I thought I could just put the DISTINCT keyword in and solve this problem. It does but the 255 character limitation that crops up with memo fields, rears its head and cuts out large chunks of the... -
Thanks, I also found out that
wordApp.Run "SetNotesEntry" , NoteEntryNo
works too.
I have two questions, and I think my clunky little application will work. My current data set has the information for creating 98 seperate word documents, when I make all my documents the errors are focused on two problems. My word macro creates a table in word with standard text and bookmarks in it. My access routine calls...Leave a comment:
-
Wow, well thanks to you for your help.
I can't close the connection because this is part of a nested loop, and need to do operations on the first recordset.
However trying and thinking about whether that would work lead me to the following. If I can name the bookmark, I don't have to do any nested loops and that would effectively solve my problem. I wrote a new maco in word, SetNotesEntry(E ntryNo As String). It jumps...Leave a comment:
-
I have a word template with several macos in it. Their names are AddNoteLine, AddNotesBookmar k, AlsoRecord, CreateAdditiona lOwnerTable, CreateFirstOwne rTable, CreateOwnership Table, CreatePropertie sTable, CreateRecordTab le, EndDocument, GeneralNotes, JumpToEnd, LessRecord, NewTableBookmar k, and StartDocument. The document is formatted using tables but views as a complex letter. Each macro creates a table, populates it with standard text then populates...Leave a comment:
-
I cut out the parts that were not applicable
Here is the first part of my code
...Code:Sub RunWordMacro() 'Word application and document variables Dim wordApp As Word.Application Dim wordDoc As Word.Document 'Create Word application Set wordApp = CreateObject("Word.Application") 'Set template location Dim strTemplateLoc AsLeave a comment:
-
NeoPa, Mary
Thank you, I hope my reply didn't sound angry, I am just new at this and feel like I am imposing myself upon others.
I found examples of ADO, so I utilized them, I don't really understand the difference. What are the advantages of both?
Let me apologize for my code, I am sure I am writing sloppily and excessively, but I think I comment everything (perhaps to excess).
I tried...Leave a comment:
-
To NeoPa
I was paraphrasing my code, I only included about a tenth or less of the code I have written. In order for you to be able to test the code, I think would have to send you data, and some word templates. I think that would be asking too much. Maybe I am misunderstandin g. I tried a few other things, see below:
To mmccarthy
I tried doing that but it didn't work
I think when I run...Leave a comment:
No activity results to display
Leave a comment: