Search results

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

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

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 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 form where the users could paste a list of the items they want to query off of, then click a button and...

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 tbl_detail - 2nd table which contains the items number and blank fields for date & cost I'm looking...

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 to use a subquery here). So if my table was: item #, sales $ 1, $10 2, $8 3, $6 4, $5 5, $1 Total...

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", "C:\results\output.txt", 1 The results of this is a table that looks like: 1234 1569 1478 1524 I'm trying to...

In my form, I have a combo box tied to a field in my table. The combo box is set to allow certain values based on the results of a query. The values allow for each record are different depending on another field in the table (let's call this the List Key). In order for this to work properly...

In a particular updating subroutine that is based off a form's recordset, its getting really slowed down due to having: Private Sub Form_Current() Me.cb_pogdbkey.Requery End Sub Is there a way to disable the on current event, run my sub & then re-enable it?

Hi, I currently have form that based on a branch number (in the header), the detail pulls in a series of pog's. I'm looking for a way to use dcount to check for any duplicates. I've tried using: =DCount("POG_ID","tbl_POG","POG_ID = '" & Forms!qry_load_branch!pog_id & "'") ..but each line...

In a table I have: - Category (A, B, C) - Family (A1, A2, A3, B1, B2, etc) - Item - Sales I'm looking for a way to get the top 10 items in each category + family based on sales (ie: top 10 in A-A1, then A-A2, then A-A3, etc). When I try using the top function, it doesn't treat each...

I'm struggling with a non-updatable query issue. I have a table at the category level that should allow entry but it needs to pull in information from another query. In this 2nd query, its doing group by/counts/sum's from an item level table. From reading about the dynasets and trying to fix...

I'm trying to identify the 2nd highest number in a field in Access. While searching, I ran across the =large(a1:a3,2) formula, which works perfectly in Excel. I'm trying to duplicate this functionality in Access 2003, but it looks like this formula isn't in there. Any ideas on how to...

Hi, I'm trying to compare partial text records across two tables. The first table simply has a description, such as: DescriptionHammer Bone Saw Power Saw The second table is a list of terms and a category, such as: Term, Category Hammer, 1 Saw, 2 I'm looking to build a query will compare the...

Hi, I have a rather large database with a lengthy append query that I'd like to run overnight. I've read some posts about using a form with a timer built in, its not real clear on how it works (http://www.dbforums.com/archive/index.php/t-331813.html). I've also come across some talking about...

I've gotten the medianf fuction that is pasted on these boards working in the attached db example. The problem I am running into now is the medianf function (correctly) takes the median for an entire table at once. My dataset example looks like: type num t1 1 t1 2 t1 3 t1 6 t1 6 t1 100 t2 1...

Probably an easy one here...I have a series of cascading combo boxes where once the last once it chosen, I'd like some sales info to populate in a group of text boxes. What command would I use for this? Also, I have a checkbox that I'd like to use to either enable or disable a textbox as well...

Not sure if this is the right forum for this. I have a switchboard that one of the buttons is tied to run a specifc report. Once the user clicks this button, is there a way to show a loading bar so they know its on the way (outside of the loading bar in the lower left). I'm looking to make it...