Search results

We'll just keep the sharp pointy things between us... no need to involve adult supervision. Okay, here's a question: The current table already has an auto-number PK. So, like you said, if I preserve that in the data I unpivot, I'll have that key in my flattened table. Now, supposing I am...

Minty, using Excel to unpivot the data might work... But how do you load it back into Access with the foreign key reference? Assuming I'm using an auto-number as the PK for the general data on my "Widgets" in a separate "Widget" tab, I'm not sure how I'd be able to automate replacing the Widget...

You know what... you might be right about that. I finally decided I needed to normalize this beast because it used to be just me making updates to this system. I knew that the engine under the hood wasn't so awesome, but the output was fine, and the reports were useful to Sr. Management. As...

I inherited a database in my workplace a number of years ago. Initially the entire database consisted solely of a single table with all the associated data and a second table that was (and still is) as far as I can see essentially a copy of all the data in the first table. I still don't...

Oh my gawd, that should've be so damn obvious. Thank you!

Is there another way to link the value of the 2nd textbox to the value in the first?

I was trying something like that with code to update the second textbox based on the value in the first. Just can't get it to work. BTW.... thanks for the "Forms!F_TimeLog.ActivityID = iActID" code idea. Don't know why I honestly hadn't thought of that.

Yeah, i haven't figured out how to get the activityName to properly populate along with with ActivityID. Right now I have them in separate textboxes, and after the ID textbox is filled in my thought was to look up the Name and fill that in, but so far that bit of code never executes (not in any...

Let me throw out another idea I had but couldn't figure out how to make work. If I stored the ActivityID in a combobox, I could easily assign the ActivityName to a second column and display that instead. My problem there was aesthetic: I didn't want to see the drop down. In fact, I don't want...

True that it hasn't been saved it yet. I wanted to have the ActivityName auto-filled for the user before they add any additional data to the TimeLog and save it.

So, this fills in the ActivityID on the TimeLog form. So far, so good. But I can't find at what point the ActivityID is considered loaded into the form so that I can run my query on ActivityID and pull the ActivityName. I get nothing if I try to run the query in the Current event for the form...

That looks like an elegant solution. Let me give that a try.

Okay, first let me describe what I'm trying to do, then how I'm going about it and where it's failing. I've got one form ("F_NewActivity") where I create an id for an activity record. When I save and close this form, I want to automatically open the "F_TimeLog" form, create a new TimeLog...

That's a nice list of caveats. Some of the answers: This is for a system I'm building from the ground up. Currently, the only records that exist are example records that I've created for the purposes of testing code and queries. So I'm working with a fairly small set of data. When and if...

Whether I'm a sloppy programmer or not I can't say for sure. But I expect it would be better to assume I was since if I don't know the chances that I am are probably pretty good... Thanks for the response.

I feel like I've seen this addressed here before, but couldn't find it. I'm curious what the experts here think. (This may be a VBA question rather than a query question, but since it deals with queries I thought I'd put it here first.) Before I spend a lot of time designing a suboptimal...

I don't think I can use the ActiveWindow method - at any rate I get an error if I try - since I'm not running Excel in an open window, but invisibly from within Access. I tried replacing the "objXLbook.ActiveWindow.SelectedSheets.Delete" line with this: objXLbook.ActiveSheets.Delete Which...

Hi, I'm exporting some data from an Access Database into an Excel Spreadsheet to create a report in Excel, and I'm running into some problems with that. The idea is I have an Excel Template with a tab to take raw data from an Access Query, and then a couple tabs that manipulate that data and a...

Glad I found this. I was just today looking for how VBA handles Quotients. Looks like I can also get Remainders with Mod directly in VBA, too?

Thanks. I actually got this part working, previously, using layers of queries on queries. I was trying to see if I could do better than Access' query builder using SQL inside a VBA module to get something less cluttered and more efficient. I'll post something in the VBA section asking a...