Search results

So I've tried to come at this piece by piece, but you guys are absurdly helpful and I'm at the end of my rope, so I figured I'd just throw my entire problem up at once. :) I have a folder full of Excel files that contain similar information, but all in different formats: the name of a holding...

Perfect. Thank you!!!

I have an extremely sloppy table I need to clean up. The first two fields are the origin file and the origin worksheet of an Excel import. The next fields are often, but not always blank, fields that I need to consolidate into a SINGLE field. In other words... OriginFile OriginWorksheet F1 F2...

I've been through Ken's excellent list of Excel import VBA. However, I'm not very good with VBA, and could use some help. I have a number of poorly formatted Excel files, with different layouts, etc. etc. etc., and I have everything I need to import it into Access and clean it up, but the one...

You are a beautiful, beautiful man... thank you!!!

I need help converting a sheet in Excel to a table in Access, but the data in Excel is arranged poorly. Can anyone offer some suggestions? The Excel table has headers corresponding to each country, and then each record is some data on that country (and yes, there are blanks). UK US AU 1 2...

So I have a fairly complex database of software bugs, and three tables are giving me a huge problem: t_Bug t_TPID t_BugAction t_Bug is the main table of bugs, PK is bug_id. t_TPID ("Third Party ID") is a table of all the multiple ways that our various clients refer to the particular issue. It...

So I have two combo boxes on datasheet, cboProduct (a list of software products) and cboRelease (a list of releases, with each product having its own set). When you select a product from cboProduct, then cboRelease updates to show only releases tied to that product. The rowsource of cboRelease...

So I'm self-taught, which means that most of my code is crappy, brute force, and redundant. Usually I just let it go, but this time it's driving me crazy that there's not a more elegant way to do what I'm doing. I have two combo boxes on a form called "Main": "ProductSelect" and "QueueSelect."...

So I have a bug tracking database, and I want to create a form that lists active bugs in a datasheet so that users can easily make edits to certain fields without having to open up a form for each bug. The issue I'm running into is that some of the fields I want to show, but not have users...

Yes, it is an .accdb.

In Access 2010, I'm creating a table with a rich text memo field. I name the field (BugDescription), select "Memo" as the Data Type, and from the Text Format dropdown I select "Rich Text." However, as soon as I do that, it switches back to plain text. I can't find any documentation anywhere...

Okay, I don't remember why I included the Products table in the query, and it really shouldn't matter, but removing it seems to have solved the problem. Weird!

So to the After Update event of the first, I put: Me.ProductRelease.RowSource = "ActiveRelease" Me.ProductRelease.Requery That works, but it still seems weird to me that the first way wouldn't. Thanks!

SELECT t_Release.ReleaseName, l_Product.ProductName, t_Release.Release_id, t_Release.isReleased, l_Product.Product_id FROM t_Release INNER_JOIN l_Product ON t._Release.Product = l_Product.Product_id WHERE (((t_Release.isReleased)=False) And ((l_Product.Product_id)=Forms!NewBug!Product)) ORDER BY...

Tried that. I even tried the same thing for the OnClick event of the combo box itself. This is driving me nuts! How is the combo box pulling data from an empty query??? :banghead:

I have a combo box that's based on a query which uses as its criteria the value of another combo box on the same form. Basically, a user selects a product from the first combo box, and the second combo box populates with any product releases associated with that product: Combo Box1: Product...

I've looked at multiple solutions, and none of them are as streamlined as I'd like, or function exactly the way I want. I'm particularly interested in developing a system that works equally well for internal tracking as well as generating client-facing reports, like UAT guidelines and release notes.

I'm sorry, I'm not sure I understand. What do you mean, "use the recordset"? What does that mean? What about the table structure?

So I guess this is kind of a theory / best practices question. I'm writing a bug and issue tracking database for a small business that's going to involve issues at multiple levels (e.g. account managers, product managers, developers, QA, clients, etc.). I envision the issues going through a...