Search results

I cant say again how easy and just convenient it is to have your form popping up with a shortcut ahah fan-freaking-tastic!! But could you explain a little the Customs tab and the debug properties..?

Sometimes its just ridiculous... it was the reports alternate row color and the fact that my text was white it looked like it was not showing hahaah sorted now! thx guys

I understand the process making a new column with the values 2, 3 and all other squads becoming 99 and the query works great doing just that. But....when grouping it in the report I get subtotals for the number 2 and 99 and a subtotal footer missing for the number 3...very peculiar...still...

ok ill test right away...thx

I have a field (squad) in a report that i want to group on and show a total for each group..the squad value is an integer from 1 to about 100 Now to the mess...i want to group the field on three values or rather three groups of values.. squad = 2 squad = 3 squad = all but 2 and 3 its the last...

Cant thank you enough :D its a great form for the properties im learning so much from it

Looks absolutely great! just have to figure all it can do and how haha :D I don't know what many of the properties stand for or when they apply.. but i guess testing is the best way :)

Ok so i have gathered a few examples : http://bytes.com/topic/access/insights/957166-how-create-user-permissions-customized-menus-ms-access http://www.access-programmers.co.uk/forums/showthread.php?t=193131 http://www.databasedev.co.uk/login.html None of the code is mine I just wanted to...

Thanks HiTechCoach for a thorough explanation on the way to think. And ....yes...i am way past the table design part haha im actually almost done with the DB's core functions, form etc..so i guess i get a F in that department coming at this stage and asking for some advice on ULS. Although I...

Ok just to summeries a little... Use this to create a table that lets you add custom RIBBON xml as above Column Name Data Type Description RibbonName Text Contains the name of the custom ribbon to be associated with this customization. RibbonXML Memo Contains...

Yeah sure I have seen a few examples on creating your own ULS with and without groups and so on. That part is kinda straight forward, I just wished someone with experience could advice on what not to do and what to do locking down the Access GUI as well as best practice to lock down the GUI for...

Yes I came a cross that ;) in my research....but....im at the stage where i can live with the "not" so secure status of access for the time being and migrate to a MS SQL later when ever its needed. I was thinking of getting some summary advice/links on the GUI of access like managing users and...

Hi all, I've come to the point where Im looking at user levels and security for my DB and I've spent countless hours testing and finding the best way. I've read many posts condemning MS for removing the ULS in 2007 and up and others praising it.. I've also tried several examples from users...

Im a little slow sometimes...my expression at the topped worked...i just forgot to change the automatic "Group By" to "Expression" in the query designer and it all worked...So thanks so much for all the help..again haha!!

Follow up Question: Can I somehow make a Column calculation like this in the QueryDesign mode Formation: [InMatesTot]-[JailS]-[JailWard]-[Hospital A]-[Q-Ward]-[Consult] For this Query SELECT DISTINCTROW tblInmateProfile.tblsquad_ID, Count(IIf(Nz([jailstatus],0)=True,[jailstatus],Null)) AS...

Not really sure how you mean, but thanks for helping :-)

Yes I noticed that it was the same on boolean values but not on the medicalconfinment and I have another field called jailaide that can have up to 4 different values from 1 to 4..but in any case your examples made it possible let for me to figure out how to solve it. I can't thank you enough :-)

Ahh thanks again :) you really helped me as i tested a bit and maybe my explanation was a bit fuzzy but the SUM function you use actually adds the values in the fields i wanted to count them. But no matter i just changed your SUM for COUNT and TATA!!! it all worked. I have a few other fields i...

HAHA almost perfect :D medicalConfinment 1 and 2 are superb!! But im getting the JailStatus column showing the checkbox not the sum of records for each squad with the Jailstatus set to true...

hi a quicky Question regarding grouping and counting... Im counting inmates per Squad in tblInmateProfile in the query below. As well as a few other fields but i cant get the records to group and count properly. just counting the Totals per squad is easy but then counting the "Sub" counts is...