Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. vasnas

    Final Touches on GUI/Appearance. . . !!!

    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...
  2. vasnas

    Crosstab Query for Summing up values from dif. tables?

    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...
  3. vasnas

    Crosstab Query for Summing up values from dif. tables?

    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...
  4. vasnas

    Simple Searching by TIME RANGE?

    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...
  5. vasnas

    Simple Searching by 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 >= #" &...
  6. vasnas

    Simple Searching by TIME RANGE?

    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...
  7. vasnas

    Date field WITHOUT year &amp; SEARCHING based on Dates/Time??

    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...
  8. vasnas

    Graphical User Interface (GUI) Basics

    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...
  9. vasnas

    Graphical User Interface (GUI) Basics

    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...
  10. vasnas

    Attach/Upload Picture on Form

    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...
  11. vasnas

    Code for initialising a NEW SEARCH on a search form

    Ok got it, thank you Daniel Vlas!!
  12. vasnas

    Code for initialising a NEW SEARCH on a search form

    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...
  13. vasnas

    Create Subform for Data Entry

    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...
  14. vasnas

    Attach/Upload Picture on Form

    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...
  15. vasnas

    Attach/Upload Picture on Form

    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...
  16. vasnas

    Create Subform for Data Entry

    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...
  17. vasnas

    Create Subform for Data Entry

    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...

Part and Inventory Search

Back
Top