Search results

So this may seem like a bit of an odd duck question but I've about 20 or so fields in a certain query that all require a certain set of calculations (all of which are related). What I'd like to is extract the field name of one of my arguments as a string and use it as a criterion for how the...

That's what I thought! Otherwise I'd wonder how I was converting our '97 db to our 2000 model through an interim 2000 FE with both sets of tables linked without having '97 installed on my system. :D It seems to me that in light of that fact so long as you ensure that your user is linking to...

That's perfectly okay. You can set up a form with tabs so that clicking an alternate tab brings you to your subform. :) If you search for 'multiple-page or tab-control form here or even in the questionable help that ships with Access you should find instructions on how to create a single form...

Forgive me for sounding foolish (as I'm only beginning to understand the versioning working system) but I thought 97-up back-ends were basically compatible with any newer version front-end through linked tables? Just curious, ~Chad

Someone please shoot me for forgetting about recordsets! *doof* Thanks Peter! Yeah... that's the way to go! ~Chad

I'm pretty sure InStr() is the function you want unless you want to start calling characters out by their numeric values. Are you opposed to creating a user-defined function to do what you're asking? Your query would then be no more complex than any regular query. Though performance would...

I'm just giving a guess as to what your actual object names are but maybe you can better correct your syntax by seeing this: Private Sub HideMe() If Forms!FormName!Command44.Seeds = True Then Reports!Report_Invoice!Label65.Visible = False End If End Sub

There are ways to do what you're asking but it sounds like what you want is not another form generated by the command button but a subform with relatant keys. To simply copy data from one table and add the same data into another (with the exception of a key) violates normalization. Are the two...

Oi. I am struggling here folks. It seems I'm stuck between using a temporary table with an autonumber field and using a Macro to append each [Site] and [Year] combination with the respective classes, then updating from the temporary table, deleting the data, using a function to reset the...

Ahh... Okay it's starting to come together... and the easy way out of having to manually input all the parameters is through a parameter table that stores a static [Year] [Site] and [Class]. With update queries and a few looped macros I guess I could continually update the three key fields until...

Actually, now that I think about it, I may not need the unique count. Let me try this on for size and see if it fits. (Thank goodness our [Site] and [Year] are at the very least numeric): Dim Y As Integer, MaxY As Integer, S As Byte, MaxS as Byte Y = Min([Year]) 'Establishes the First Year on...

Thanks for the reply FoFa but I admit I'm a little vague as to what you meant. I might have an idea, however, a good question to ask at this juncture if there is a way to force a DCount to count unique records only or do I need to create a stored query for that? Regards, ~Chad

So I used the last hour or so looking for a similar query to no avail. Thought I'd throw this to the wolves as I keep stumping myself somewhere around the DMax(). Basically we're converting an old 97 database with very bad keys and no naming system to a newly modeled 2000 db. In our old system...

Page Setup is found in the 'File' Menu. Select 'Page Setup' then use the according tabs and buttons to set your page size and if you need to notify the printer as well there is a button next to the selected printer that allows you to do that. Hope this helps, ~Chad

The director / star of SuperSize Me has his own reality TV series called 30 days to appear on Fox where people have to spend 30 days in situations they would never normally be in. For example, a deeply devout christian fundamentalist is placed in an all-muslim community. Or a homophobic...

I guess that maybe I'm old-fashioned, but I've never been one who's bought into the all-in-one solution, not even the TV-vcr. Ninety percent of the time I could find one or more components of a combo that I could get better quality out of a dedicated system. Sorta like why I have a rackmount...

I'm an iPod user but I'm also an audiophile and there's a part of me that wishes the Rio Karma was around when I was portable shopping. I don't know how much you know about mp3's but it's a lossy format and despite how intelligent the algorithm is for removal of 'unneccesary audio data' many...

Ahh, now I feel a bit of a fool. Spelling it was. Thanks just the same Pat. This was a re-design of an older form and there was a teeny-tiny little box with the same name. Thanks. Regards, ~Chad

Yup. I put Me.Requery into the AfterUpdate event on the form. Edit: Re 'on the form' I should say, in the AfterUpdate event of cboSchool

Heya. I hate posting yet another cascading query but I just poured through the first 40 bits and couldn't find something similar. Basically, I seem to have an errored idea in how to effectively used cascading boxes on a larger form-wide scale. Basically I have a form with an unbound combobox...