Search results

ok, im troubleshooting. and i don't think i need to mess with the afterupdate event b/c i was going to have check boxes and then a button to run the query, the query is just going to rely on the state of the check boxes. In my troubleshooting, this code...

I really fail to see why something so simple as this in a query criteria does not work..... IIf([Forms]![frm_qry_local_deliveries]![finished]=True,"GFS Brighton",[Delivery_Location]) That says if the check box is ticked, I want to see records where the Delivery Location is "GFS Brighton", else...

my VBA knowledge is little to none, I've done basics with many google searches.

right, i guess. but i got 3 filters i saved as queries b/c that seemed the only way to be able to make them available for use by the click of a button. the first one shows records in which the "Delivery Location" is "GFS Brighton" or "GFS Green Oake". The 2nd shows records in which the status...

um, not exactly unless im not understanding what you're saying. I've got three filters that I've made and saved as queries. i added buttons to start with but then i was limited to only seeing one filter, i could click the button for the filter and then when i clicked the other button, it...

alright, i have about 3 filters that i want to include on a form that is built off of an initial query. but i want to be able to use any combination of the filters. my idea was to write a query/filter using IIf statements that rely on check boxes in the criteria. I'm trying to get just one to...

wow, i didn't try hard enough. i found the answer to my own question. set "can grow" to "yes" in the property sheet!

I have a report where I'm trying to cram a lot of info into the width of one page. i have some fields that will have data that gets hidden like the "pickup/delivery location" field. is there a way to get access to expand the height of the field automatically to display the info on tow lines...

no subforms and it does work in normal accdb. just not when i open as runtime. im fairly sure that's a runtime shortcoming. kind of a shame, the fbf is easier for less technical people to figure out and get doing custom filters.

sorry for double posting but am i correct in the statement that filter by form does not work in runtime. i have come to that conclusion as i have gotten it added as a button but when i click on it, it does nothing.

finally got it to work! yaaaa. the visible = "true" was the key. why it was idk but it was. how come i don't need that for the rest of my controls and button that refers to a module? any insight on why? thanks vbaInet for your continued help, greatly appreciated!

there should be a button below home page to close the current window. i used <button idMso="WindowClose" label="Close" enabled="true"/> and it's not showing. this button does exactly what i want when i add it to the QAT in full Access. so i wanted it in run-time.

a google search brought me here http://www.utteraccess.com/forum/index.php?showtopic=1904722. a commands section at the top may be the answer??? i would assume u'd need a control section and a entry in the group section to add it to the ribbon. or is it just not possible to add this command...

alright here's my whole code <customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui"> <ribbon startFromScratch="false"> <tabs> <tab id="dbHomeTab" label="Home" visible="true"> <group id="dbHome1Group" label="Navigation"> <button id="Go_Home"...

umm, so i've been working on creating a custom ribbon with xml and im finding some commands just won't translate. like filter by form. i can get it to show but clicking on it does nothing. also, i wanted to add the close window button which cl,oses the active window whatever it is. but i add...

i don't know how to properly error handle (could prob learn) so I'm sticking with installing access on all computers and locking it down to the best of my abilities. Thanks everyone!

okay, so you guys think i should stick with installing access 2007 on all computers? customizing the ribbon to protect it from stupid people? password protect? accde? i also liked the idea of the runtime b/c it seemed more secure really limiting the users ability to screw stuff up.

I'm not all too worried about errors as i did very little vba, but how do you "create" the ribbons. can someone with little to no programming experience handle it? do you lose any of the filtering, sorting capabilites? i really wanted the filter by form on the home ribbon in access.

I've got this nice little database that is now ready for use by our 10 or so office staff. i have been doing research on how best to deploy it. i have split it into a front end and a back end and put the back end on our server. i have referenced everything without drive letters. i was sure...

i appreciate the offer but cutting it down and zipping it would still prob be pretty big and im on a slower internet connection with crappy upload. I think it's in my syntax. I have a form named "subfrm_pickups". Within that I have a tab control with two tabs. I dragged and resized my...