Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 63
Search took 0.07 seconds.
Search: Posts Made By: mab9
Forum: Queries 03-04-2010, 10:58 AM
Replies: 2
Views: 4,722
Posted By mab9
Re: Parse a Multi-Line Memo Field into Multiple Fields

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. ...
Forum: Queries 03-04-2010, 10:30 AM
Replies: 2
Views: 4,722
Posted By mab9
Parse a Multi-Line Memo Field into Multiple Fields

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...
Forum: Queries 08-13-2009, 09:59 AM
Replies: 2
Views: 530
Posted By mab9
Re: Transformating Query Output

That's perfect, thanks!
Forum: Queries 08-13-2009, 08:22 AM
Replies: 2
Views: 530
Posted By mab9
Transformating Query Output

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...
Forum: Forms 03-17-2009, 10:43 AM
Replies: 13
Views: 2,590
Posted By mab9
Re: Form VBA won't recognize me.controlname

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.
Forum: Forms 03-17-2009, 10:38 AM
Replies: 13
Views: 2,590
Posted By mab9
Re: Form VBA won't recognize me.controlname

Nope, nothing of the like. Everything is named cb_controlname for the combo's, list_controlname for list boxes, etc.
Forum: Forms 03-17-2009, 10:37 AM
Replies: 13
Views: 2,590
Posted By mab9
Re: Form VBA won't recognize me.controlname

Nope, I've double checked all the modules and forms. There aren't any duplicate procedures anywhere in the code.
Forum: Forms 03-17-2009, 10:32 AM
Replies: 13
Views: 2,590
Posted By mab9
Re: Form VBA won't recognize me.controlname

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...
Forum: Forms 03-17-2009, 10:28 AM
Replies: 13
Views: 2,590
Posted By mab9
Form VBA won't recognize me.controlname

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...
Forum: Forms 03-10-2009, 06:27 AM
Replies: 9
Views: 5,698
Posted By mab9
Re: Pass Textbox to Query as Criteria, not as String

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...
Forum: Forms 03-09-2009, 06:00 AM
Replies: 9
Views: 5,698
Posted By mab9
Re: Pass Textbox to Query as Criteria, not as String

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...
Forum: Forms 03-06-2009, 02:42 PM
Replies: 9
Views: 5,698
Posted By mab9
Pass Textbox to Query as Criteria, not as String

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
...
Forum: Modules & VBA 10-02-2008, 06:46 AM
Replies: 1
Views: 880
Posted By mab9
Using VBA to Append and add in an additional value

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...
Forum: Forms 06-19-2008, 10:13 AM
Replies: 6
Views: 711
Posted By mab9
I was playing around with using the Replace...

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...
Forum: Forms 06-19-2008, 05:07 AM
Replies: 6
Views: 711
Posted By mab9
You are correct. I think a lot of the people...

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...
Forum: Forms 06-18-2008, 08:02 PM
Replies: 6
Views: 711
Posted By mab9
Using a form for custom criteria (list)

I have an odd problem that I can't figure out a decent way to do it. I have a simple table:

Table1
Item Price
1 $5
2 $10
3 $15
4 $20

I'd like to have a...
Forum: Queries 06-03-2008, 05:09 AM
Replies: 3
Views: 740
Posted By mab9
Perfect, thanks!

Perfect, thanks!
Forum: Queries 05-29-2008, 01:41 PM
Replies: 3
Views: 740
Posted By mab9
Non-updatable query due to aggregates (max)

Hi,

I'm stumped on this & have been trying to figure it out today. I have two simple tables:

tbl_cost - contains the cost history for a series of items & the dates when that cost goes active
...
Forum: Queries 05-02-2008, 09:29 AM
Replies: 1
Views: 472
Posted By mab9
Count of Records that Make Up 80% of a Sum

I have a table which essentially is:

- Category
- Item #
- Sales $

I'm looking for a query that will tell me the count of items that make up 80% of the sales per category (probably would have...
Forum: Modules & VBA 01-09-2008, 05:28 AM
Replies: 2
Views: 691
Posted By mab9
That dawned on me this morning, was a long day. ...

That dawned on me this morning, was a long day. Thanks.
Forum: Modules & VBA 01-08-2008, 02:08 PM
Replies: 2
Views: 691
Posted By mab9
DoCmd.TransferText + Concatenating Results

Hi,

I have a button that current just exports the results of a query into a text file onto the C:\. The output code I'm using now is:

DoCmd.TransferText acExportDelim, , "my_query",...
Forum: Forms 11-09-2007, 10:38 AM
Replies: 16
Views: 1,263
Posted By mab9
I don't believe that it's the model. I think it...

I don't believe that it's the model. I think it really just has to do with the visible field displayed in the combo box vs the field captured and the fact that the combo box's row source is...
Forum: Forms 11-09-2007, 09:32 AM
Replies: 16
Views: 1,263
Posted By mab9
Well sort of. In the sample you can see the two...

Well sort of. In the sample you can see the two fixture types:
- E1
- G1

Of the 73 selectable items (from qry_maxkey2), it breaks out as:
- E1 = 24 possible choices
- G1 = 49 possible choices...
Forum: Forms 11-09-2007, 09:21 AM
Replies: 16
Views: 1,263
Posted By mab9
It's more of the 2nd, the type of fixtures within...

It's more of the 2nd, the type of fixtures within a building. It's giving a place to select what goes into each of the fixtures but restricted that list due to its type.
Forum: Forms 11-09-2007, 07:08 AM
Replies: 16
Views: 1,263
Posted By mab9
Attached is a very stripped down version of the...

Attached is a very stripped down version of the file. You'll notice there are two forms in there:

frm_wrong: this form replicates the problem I'm trying to overcome. In the third column is a...
Showing results 1 to 25 of 63

 
Forum Jump



All times are GMT -8. The time now is 11:49 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World