When I sum checkboxes in a query they total the checkboxes as 0 or -1 so the totals result in negative numbers. How can I resolve this and obtain positive...
Hello, friends! Do you need to develop software or website? Post your project for free and get quotes! If you are owner of software company or freelancer this...
can you not put a negative sign in the query field. e.g sum_checkBox: -[CheckBox] and then group in the query Or something similiar. ... or -1 so the totals...
Not using a formula to calculate...just using the sum function to sum the field on the select query page. Perhaps I should use a calculation expression rather...
Hi: i need convert a significant .mdb from 97 ==> 2003 and i need generate an assessment on the conversion effort and risk involved; the .mdb is DAO intensive...
Dave- Then do: =-Sum([MyField]) John Viescas, author "Microsoft Office Access 2003 Inside Out" "Running Microsoft Access 2000" "SQL Queries for Mere Mortals" ...
By "significant number of macros" do you mean Visual Basic code or actual macro objects. No "production" application in Access should use any macros. Before...
I'm converting several large applications from A97 to A03. The conversion should be relatively straight forward with the likely exception of any coded DAO...
Tom- One correction: Access 2003 now references DAO by default in any new database and places it ahead of ADO in the references list. (Microsoft finally...
T: thanks V ... conversion should be relatively straight forward with the likely exception of any coded DAO recordset declarations. Where they are likely...
J: thank you; your advice on this reply , and another one you wrote from my same inquiry, helps a lot V ... actual ... any macros. ... is fully ... some ... ...
Thanks for the correction John, I was recalling some 2000/XP conversions - where you had to reference the DAO library. I've been using Access since inception...
Tom- First, thanks for the "thanks!" I do it primarily for the satisfaction of helping others. I've been using Access (code name Cirrus) since late 1990, but...
I've created a 3 column report with one of the columns being "review date". What I'd like to do is grab the most recent review date and place it in the section...
Gary- Put a text box in the header, and set its control source to: =Max([ReviewDate]) That should get the latest (most recent) review date for the group. John...
DHB, Your problem translates into finding the largest possible combination of records (for a given grade) where the positive & negative values of the OffSet...
Thank you John, that did the trick. Gary ... From: John Viescas [mailto:JohnV@...] Sent: Tuesday, June 01, 2004 2:22 PM To: ms_access@yahoogroups.com ...
Hi There - I am going crazy trying to figure this out! My menu bar is missing from Access 2000...(File, Edit...) I have tried going to the customize toolbars...
Jenni- I believe the only way to delete a built-in command bar is to dink with the Registry. So, you're saying that you don't see "Menu Bar" at all on the ...
mr.viescas, does it mean that i have to create the query first? i've look into your samples of databases but i can't understand all the vb codes. does vb will...
Hello! After 48 hours this new group for posting offshore projects has 80 members. And there are already some messages! If you are company owner or freelancer...
I have a fairly complicated problem with executing an IIF statement in a query. Hopefully somebody will be able to help me with this. I have a query within my...
To build a custom search form, you'll normally perform these steps: 1) Design a query that displays the data you want. 2) Create a form or report to format...
Grace- I'm having a hard time picturing the table structure that would support this. I would imagine you have a "tables" table that lists all tables in the...
Hi Guys, I got my form/subform working ... sort of. Thank you very much everyone especially John O'Malley for the wonderful help and inspiration and...
Ilona- You should normally use the form header to display captions, unbound search controls, or bound controls that you don't want the user to update. When ...
Thank you Thank you Thank you That worked very well. If you have the time, what does AfterUpdate actually mean in regards to this date control in the...
Hi Grace, I must admit I have not fully understood your problem but I have had some experience with QUERY and have discovered that it is not very smart when it...
Ilona- After Update means just what it says - the event fires *after* the text being typed into the control is saved to the form buffer. So yes, it fires when...
Thank you John. My mind set has been fixed on "AfterUpdate" being concerned with a record being updated. Thank you very much. Ilona Adelaide, Australia ... ...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
