Thanks Paul, I've give it a shot. I was initially trying out using replace() in a query based on chr(10) and/or chr(13) but was running into where it was only altering the first line of the string. Will see how this goes.
I'm trying to work with output from one of our systems and it exports it's workflow history in a single text string with each of it's steps split by a line break, ie:
"02/11/10 09:38:03;Index;Enter
02/11/10 09:38:03;Transport;Enter
02/18/10 10:12:01;Index;Exit;USERID;10113"
Since it's all...
I have a simple table of cross references, built like:
ItemNo1 ItemNo2
12345 ABC1
32346 BBC2
53456 ZZZ1
53456 ZZZ2
I'm trying to figure out a way to query against this table to transform the output into the figure below due to the 1-many relationship between the...
Ah, this can be closed, I found the problem. I had renamed a button and in adjusting the code I accidently wiped out the _Click() suffix. Put that back in & everything is working again.
It gives the same error:
The expression On Change you entered as the event property setting produced the following error: Member already exists in an object module from which this object module derives.
I'm baffled on this. On one form in my database, the VBA has decided to stop recognizing all references to me.controlname, with control being the various controls on the form. I've gone through the other forms in the database & all are working properly but one. I can't find any property or...
Yeah...that works for if the user ends up choosing only 1 categories from the listbox, but they will be choosing multiple. Currently txtPicked is capturing the category ID's in the format of: 1000 or 1200 or 1500
When the query criteria is directly pointed to txtPicked, its reading its...
Im' trying to get the criteria into:
SELECT Min(IIf([Descriptor_Ranking]=0,9999,[Descriptor_Ranking])) AS Rank, tbl_Attributes.Descriptor_Name
FROM tbl_Attributes
WHERE (((tbl_Attributes.Category_ID)='list box results go here'))
GROUP BY tbl_Attributes.Descriptor_Name
ORDER BY...
I know I've this before but I can't remember exactly how. On a form, I have a textbox (txtPicked) which is populated with a series of numbers froma multi select list box, ie: 5771 or 1000 or 2000
I'm trying to pass this into a query as the criteria but by directly pointing to the forms...
I'm currently using VBA's DoCmd.TransferText to import a text file into a specific. Is there a way that for each record appended in this manner, to update a seperate field in the table with a value stored in memory but isn't in the text file? For example
Text File:
Item
Description
Price...
I was playing around with using the Replace function for chr(10) & chr(13) which does get it into the: 1 or 2 or 3 or 4 format, however I think the query is taking that whole string as the criteria instead of the four individual items.
What is the split function? I don't see it as part of the...
You are correct. I think a lot of the people would be copy/pasting in a list of items from Excel. Based on that pasted data, I'd like that to become the criteria in a query, ie:
From Excel paste an item list into a form somehow:
1
2
3
The query criteria for item becomes: 1 or 3 or 4
With...