In compromising, I may be too concerned about Lisa's timeframe for getting a draft ready. The duplication of "stats" into the 2nd table, you're right, is not necessary, although it would require less sophistication for generating reports, and I'm not sure what those might look like. I'd like to see the right package produced, so I am looking for the light.
One thing though-- She says she's already running calculations "in"...
C CSR
Last Activity: Feb 8 '12, 03:02 AM
Joined: Jan 14 '12
Location:
-
Lisa,
This may seem over-simplified, but I keep thinking all you need is a working "hot" table and a monthly table off to the side that contains your final results at the end of the month, or whenever you choose to close-out. The tables would be linked by a "PeriodID." So, after you work out your calculations (which hasn't been fully explained to me yet), when you run the update, the two tables are joined for the...Leave a comment:
-
Correct me if I'm wrong. You said you have a "...startin g on-board strength number... and each time the garrison loses or gains [the on-board strength number] needs to reflect ... [the calculations made using the loses or gains dynamically]," meaning you overwrite the strength number as the gains and losses change. Is this what you're saying?
Then, at the end of the month, you want to freeze the "dynamic on-board strength...Leave a comment:
-
Hey Lynch, what's your status?Leave a comment:
-
The query below won't make much sense without looking at the structure of the database for this problem and a basic process for conducting business based on your example. You hadn't presented me with much detail so I did the construction myself. Here we go!
Explanation: Upon opening the books, the Inventory Table has to be rejuvenated with the Closing-Inventory from the previous period and preserved as the Starting-Inventory for future...Leave a comment:
-
Hang in there. I've got a query to do what you want, but I'm reviewing an integrated update process that you'll need to refresh your starting inventory and provide tracking for current transanctions and subtotals as they occur within a given period (if you haven't given up on me). No reply necessary, I need the same configuration for something else that's similar anyway.Leave a comment:
-
When you got the error in "FROM" clause that meant a syntax error, and you just needed to tweak that part of the query string. The FROM clause refers to the list of Tables your pulling from OR something else further down in the string that won't allow the FROM section to terminate properly.
Don't get in a hurry to start changing things like the Table or the nature of the Split Form, etc. If the query works in Design View...Leave a comment:
-
If the numbers are "number" types in the field definition of the table then they should not have quotation marks. If they are "text" then they would need single quotation marks '9'. I'm going to check your query composition and get back to you.Leave a comment:
-
Here again, the following Docmd works great for me. Let's start back with this.
In my table I only have 2 fields:Code:DoCmd.OpenForm "Check1split", acNormal, sqlStr, , acFormReadOnly, acWindowNormal
1) Recs_ID, type: number (which I used for the "Default Value," 1 thru 10 for each of my checkboxes).
2) TheInfo, type: text
So when I build...Leave a comment:
-
Hey Lynch, I knew the code was good, but what's really fantastic is that you went one last extra step and found the missing configuration monster! Kudo's! You just inherited the Earth.
Now back to work. I was trying to avoid that string loop at all cost because it's just bad practice. Modifications can be a nightmare if you ever have to make them.
I'll look the openform issue and get back to you [tied up]. Again, Co...Leave a comment:
-
There's always a less than pretty method that'll work, but you'll lose flexibility for adding or taking away controls. I'll rethink it. I did some research and the use of the "control.va lue" for checking forms is constantly used for other applications, and it has issues that can usually be resolved. Do a couple of other things while I recompose. We've hacked away on this thing, so clear your mind and first read all of the following and...Leave a comment:
-
Not related to above error, but you are missing an "=" sign in the following line:
Put "Door="Code:RecsChose = RecsChose & "Trailers_Unloading_LA.Door" & Narr(j) & ";"
Leave a comment:
-
We've got some other issue. Are you "saving" and then "compiling" the code? If not, make sure you code looks good and click on "Debug" on the menubar, the click "Compile...[your dbname]". If no error, then try the form again.
We may need to check the "References " from inside the Visual Basic window. On the same "Menubar" click on Tools>Reference s. You should at least have...Leave a comment:
-
Note: in the line below, "Check" should be the name of the form, not a control or option group control.
Your not using an "Option group" for your checkboxes right?Code:For Each ctrl In Forms!Check.Controls
Leave a comment:
-
Let's do this to cover the bases. Under the Narr declaration in the top of the sub:
Everything is declared now (especially "Ctrl as Object"). Also, your "sqlStr" is in the wrong spot (make it the 3rd parameter in the docmd line, Not the 4th).Code:Dim Ctrl As Object, i, j, RecsChose, sqlP1, sqlStr, ThisChkbox, ErrMess ThisChkbox = 0
I've tested it here with and without...Leave a comment:
-
Also, try making an "Explicit" reference to the forms controls like this:
Here's a docmd line that'll work and open the form in read-only (you can change the read-only part). It uses the whole query "sqlStr" instead of just the WHERE Clause.Code:For Each Ctrl In Forms!MyFormName.Controls 'instead of For Each Ctrl In Form.Controls
...Code:DoCmd.OpenForm "MySplitFormName",
Leave a comment:
-
Well, look at the bright side--you get to learn some more stuff.
Let me check a couple of things: 1) Are you using this code in MS Access (the title said "Access"--what version)?
Your procedure name should reflect the name of the button name (i.e.; "YourButtonName _Click()") and this should be in the Form's Class Module, which should have opened automatically when you used the buttons event property...Leave a comment:
-
Okay. You caught me. Thanks for the "wake up!"Leave a comment:
-
I used "=" just as shorthand. If the New code still isn't working I'm out of my league on this. I was just looking at random questions and I noticed the 2a = 2 discrepancy. Hang in there:)Leave a comment:
-
Why does it look like you're comparing holder2a to holder2? Shouldn't it be holder2 = holder1, holder2a = holder1a?Leave a comment:
No activity results to display
Leave a comment: