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

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

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

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

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

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