Search results for query: *

Hello, I have (at last) finished my first Access (2007) Project and now I need to deal with its final appearance. So: [1] Do i have to get rid of the "Shortcut Menu Bar, Allow Full Menus, Allow Default Shortcut Menus"? [2] What do i do with the "Dont Display lists where more than this number...

Thank you Leslie, this looks very promising. unfortunately im always trying to avoid SQL code, but yes! this is very good. I rewrote it like : SELECT..., AValue+BValue AS TOTAL (or Sum) FROM... and it does create the TOTAL/Sum Column on its own... It be interesting to know how to do this in...

Hello, im trying to do a crosstab(?) query and im lost (Access2007)... Two tables with ID's and some Values: tblA: AID, BValue tblB: BID, BValue Many-to-many Relationship with Junction Table: tblA_B: AID, BID I want to create a query that returns a table with all the ID combinations and for...

Im afraid not, it doesnt work either... keep in mind we'r talking about Times and not Dates... So im not sure whether i use the 'yyyy-mm-dd', 'hh-mm' or what do i replace these with. But this looks promising, i think ive seen similar codes to this online. Anyway... Record Time Range...

Hello PHV, thank you for your reply, im afraid your suggestion did not work... i also tried: If Me.txt_TS.Value <> "" And Me.txt_TF.Value <> "" Then sql = sql & " AND (TS <= #" & Me.txt_TS.Value & "# AND TS <= #" & Me.txt_TF.Value & "# AND TF >= #" & Me.txt_TS.Value & "# AND TF >= #" &...

Hello, im trying to do a simple search/filtering based on a time range. Each record has a StartTime and EndTime (Short Date field). I want the result of the search to be inclusive. ie. the searchable time range should be inside in the actual time range of a record. i have tried several codes...

hello! Im having trouble with the Date and Time fields in my db. I have a BeginDate and EndDate and BeginTime and EndTime fields indicating the working hours of hotels. 1] The first thing is: can i use ONLY day and month (for the date fields)? I have tried everything but i think Access...

fneily and Joeatwork, thank you for your replies, Yes im new to Access, but the thing is i have read the theory behind relational databases etc etc, and now im just doing my very first Access project. I have finished most of it (including macros, SQL coding etc with a little bit of help from...

Hello, im working on my first database and have no clue as to how to create and design the Final interface on Access2007. Microsoft's Help is helpless! Can someone please point me to some links on the web explaining how i can create the GUI or provide other general advice? I do have some...

Hello IceMan, i have returned back to my project and this little problem still persists... I copied - pasted the code in a new module (changing txt->jpg and Text->Image). Then on the button i embedded the code: Me!DepartmentPhoto = BrowseFiles() . . . DepartmentPhoto is the TextBoxName of the...

Ok got it, thank you Daniel Vlas!!

hello, im new to Access (got the 2007 version) and have very very limited knowledge of coding, macros, SQL etc... I have created a Search Form based on a query, which has a lot of unbound text boxes, ticks etc for various data types (numbers, text, dates, Y/N etc). Also there is table at the...

thanks gkl895, i have since solved this problem (took me ages though) and it turned out to be fairly easy...there is even an InsertSubform button on the Design Option in Access 2007. The Single/Continuous From you are talking about, I THINK is something different, and it refers to the way old...

thanks IceMan, i tried what you propose in your other thread but no luck. i opened the a new module - copied/pasted, and attached the other code on the execution button but nothing happens. Any other ideas? Perhaps more precise steps into this module/code procedure you've created? Please keep...

hello, this should be fairly easy, but im very new to Access (ive got the 2007 version). My field is a Hyperlink field for attaching photos (it's hyperlink and not OLE as photos may change in the future. I just want a button (called Attach or Insert Picture etc) next to the Hyperlink...

Thanks PH for your reply!!! I did try the Form Wizard, but it always presents the subform as a datasheet (tabular and something else). I just want a DEPARTMENT subform under the COMPANY form shown as a FORM! with boxes, ticks etc...I want that cause there's lot of info on DEPARTMENTS and i want...

hello, im brand new both to this website and to MS Access (2007 version). Pretty glad to have found this cause im gonna need a lot of help :-) Basically the dB im struggling with at the moment has: the main table COMPANY (main form) with 1-to-many DEPARTMENTS (to be the Subform). [1] I would...