Search results

Hi, 1. Like to find out how do I compare login name with value from table 1, results search lists in table to in query criteria ? 2. Eg: Leave Application> Supervisor Login> Display Lists of Names FROM Personnel_Table (ONLY) Where Dept= '" & LoginID!Dept & "'" & " AND AccessRights > '" &...

Hi everyone,:) Background: Am developing leave application. Supervisor login> System able to detect any leave awaiting for approval. My Solution: - Search by supervisor dept> list out lists of names (this lists are not captured in any particular controls just using normal quries Eg: SELECT...

Hi (appreciate if someone can provide some suggestion), SITUATION: 1. I have main form that contain subform. 2. Subform generates display of an APPEND QUERY. PROBLEM: 3. Though in my query I set sorting (using one of the field- Sequence in asending order), only 85% of time data display is...

Hi, Thanks for reading my thread. 1) I have a situation whereby I did a Database Spilitter in my MS A2K. 2) Setting Default to User, Startup in User, Application resides in Common Network Drive of my company. 3) Workstation A could start up application, but Workstation B click on my...

Hi, 1) My applications have a main form and few subforms. 2) I set enabled for all forms & subforms (under properties). 3) I do also set my forms & subforms programitically/coding wise (AllowedEdits,Enabled to True) 4) I go to the extend of open up the form in acFormEdit from the calling...

Hi, 1) I develop my application(Ms-Access 2k) and put into company network directory. 2) The problem here is only 1 user allow to access per time. 3) Is there any setting I miss out? Thanks (In Advance) & God Bless

Hi, 1) My application allows Librarian to search by book name instead of browsing through large numbers of record. 2) In my form, I had 3 other subform- 2a) Borrowers Record. 2b) Books Info (Containing ISBN, Author, Publisher) 2c) Books Detail (Contents, Topics, Pages) 3) So I able to...

Hi, 1) I am pretty newbie to this access programming, do forgive me if my questions sounds stupid. 2) Basically I create an application in access capturing or production information for my company. now the top management suddenly wanted whats their main concern:- Total Daily/Monthly...

Hi, 1) Is there anyway whereby I generate on total sales from user input from Calender control? 2) Eg: I insert a Calender control to my form, Once User Click on particular date I generate Sales for that particular Date? Thanks (In advance for advice sharing & God Bless)

Hi , 1) Currently I set my db project startup to loginform, only able to edit using exclusive rights by prssing <shift> + double click/<enter> on icon. 2) Is there other way whereby I can load project as per normal startup screen still goes into edit (tables, forms) ?

Hi, (Its going to get slighly lenghty below, My Apologies) 1) I have a form whereby I need to compare value input by user with values from 4 fileds in my table. 2) User supply 3 input : (a)Model of Bicycle, (b)Budget for New bicycle, (c)Budget for Used bicycle 3) System Perform following...

Hi, 1) My application calls up differents form. 2) In every form I wrote coding creating .ADO & .Recordset instances to compare user input data with previous record in my table for some error checks. (Eg: Login Screen Test for existing UserId, Account Name Test for correct account no) 3) I...

I am a newbie to access programming. currently working on a project whereby I need to insert .wma file into my form through window media player control by writing coding in VB editor. seems like there isnt much help from web sites and reference books regarding this topis. hopefully someone...