Search results for query: *

Right now, the Departments table is just a simple table with the 11 departments. I created a table called ReportDepartment, which uses the Departments table as a row source -- tried using List box and Combo Box. I need the user to be able to select either one or multiple departments to...

Saw on a Lexus over the weekend: DILIGAF Missing an L, but the driver got his point across! __________ Veni, Vidi, Visa: I came, I saw, I charged it.

I have a table with a list box for departments to be used in a query, which in turn is bound to a complex report. It works fine with a single selection but I need the users to be able to select more than one department. How can I make this happen? __________ Veni, Vidi, Visa: I came, I saw...

MajP, Little massaging and redesign of my master query and presto -- Works like a charm! Union query did exactly what I needed to accomplish. Thanks so much! __________ Veni, Vidi, Visa: I came, I saw, I charged it.

Back to the drawing board. Thanks anyway. __________ Veni, Vidi, Visa: I came, I saw, I charged it.

The tables are normalized...... Table 1 looks like this: Rep Plan Volume1 Volume2 Volume3 100 A1 50000 60000 50000 200 A2 45000 45000 55000 Table 2 looks like this: Plan VolumeIndicator A1 Volume1 A2 Volume3 There will never be a...

I have a table with computed values that have column names such as Volume1, Volume2, Volume3. Second table with the plan name, and a field indicating which volume to use (so the row may be PLAN1, Volume2) The indicator in the second table is the exact name of the column in the first table...

I have over 1000 word documents with an embedded macro defining a merge data source. The server containing the merge data is changing. Basically, the users export a data file from our mainframe system, then open the merge doc and click a button. The doc unprotects, browses out to the user's...

Near my house, there's a small Mom & pop jewelry store; the owner and his wife have custom plates: His yellow Corvette: HUDAMAN Her Range Rover: YUDAMAN __________ Veni, Vidi, Visa: I came, I saw, I charged it.

Well, I have a new name for my jewelry business. Many thanks for the advice on pricing and photography -- to answer Dr B0b, yes I do have a good camera and a tripod so my images will be crisp. Background is important as well, especially to capture some of the fine details. So, without...

Recently I've decided to turn a hobby into a part-time business. I make jewelry -- hand made bracelets, necklaces, and earrings -- using Swarovski Crystal, Genuine Pearls, and other high-quality beads. I've been doing this for years, mostly for gifts and things to wear myself. I currently...

It's all working now. I placed the kill command in a VBA and set it as the "On Open" for an empty form. Then in the macro, I opened the form and immediately closed it. Works like a charm! __________ Veni, Vidi, Visa: I came, I saw, I charged it.

How do I issue the Kill command in a Macro using Access 2007? I've tried many different things and I can't figure this out. __________ Veni, Vidi, Visa: I came, I saw, I charged it.

I have a macro that runs a detailed daily process -- it runs several queries to create three final output tables. Two of the tables may be empty. Once the tables are created, they are exported in Excel format. I have a condition set for those two export lines so the empty tables won't...

Is there a way to lock (or hide) a checkbox if the contents of another field is not null? On one form, I have a processing date and a delete checkbox along with other information. If the item has been processed (in which case the processing date is filled in), I want the checkbox to be...

Duane, Precisely what I needed!! I'm on the right track now!! Thank you so much! [medal] __________ Veni, Vidi, Visa: I came, I saw, I charged it.

TRANSFORM Count([Reporting Query].appnum) AS CountOfappnum SELECT [Reporting Query].EnterMONTH, [Reporting Query].AMPM, Count([Reporting Query].appnum) AS [Total Of appnum] FROM [Reporting Query] GROUP BY [Reporting Query].EnterMONTH, [Reporting Query].AMPM PIVOT [Reporting Query].EnterDAY...

Yes, my process involves importing data, running queries to calculate some new fields, and then a make-table query to store the data. The crosstab queries are built off of the final table. __________ Veni, Vidi, Visa: I came, I saw, I charged it.

I have a process that imports data from another source, then calculates data and compiles information based on day of the month. I want to create a "scorecard" report, but I am having a hard time creating something that is reusable. A few of the data fields for February's data are as...

Unfortunately, I have no control over the SQL table's design or normalization (or lack thereof). The table is part of our CRM system and can't be changed. I guess I could create a couple views in SQL and query those with Access. A royal pain, but I think that's my only workaround...