Recent content by edisonl

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, (Thanks for your reading & reply firstly) 1. Basically Output of qury1 generate lists of names & userid with same department. 2. From the department & userid, lookup another table & check if this names/userid exists. Table1- Personne_table (Entails>> UserId, Dept, DateOfEmployment...

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

Oh No, Error Again Hi Bob, 1. The same error occurred in the case of previously mention Appearance Sorting Error. 2. However this occured only once in about 100 time? 1% chance, but I can't afford it. 3. Was Thinking: Maybe if I do another Query to the destination table to Re-Sort again...

Hi Bob, 1. Think is data type declaration error, record source-Seq= Integer 2. Destination Table-Seq= Long Integer 3. Will do few trial run & see if as suspected. 4. Wish me luck. ;) Regards & God Bless

Hi Bob, 1. Thanks for replying. 2. Pardon me, but my subform recordsource is a select query. 3. Sorting a numerical value integer. 4. don't really get what you mean SQL of the query ?

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

Queries Hi Bob, 1) Tried my queries it works so far. 2) I tried to fine tune the queries. 3) Will keep you posted Thanks & God Bless

DB Splitter Problem Hi, (Thanks For Reading this thread) 1) I did tried Db Splitter it manage to reduce the size of overall application. 2) However I face 2 problems here. 3) First, If I were to save my file db1 into db2 I had error says unable to execute SQL code3 bla bla bla...

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

Ok Hi, Right, will go test it out & see if it works. Thanks & God Bless

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

Tried & Works! Hi, 1) I tried & it works. 2) Btw, I hope it have no implication on my coding. I observe that Access split into back end tables & front end (Forms, Subforms, queries) Thanks & God Bless

Casade Updates? Btw, As my forms> subform(1), subform(2) link to main form by book name, 1)Do I need to create anything so that when user update by book name all other table will be able to do the necessary changes? 2)And I heard about casade updates things like that, If I implement it will...

Will Try it Out Hi, 1. Thanks Bob, will try it out. 2. But I aint so familiar with queries stuffs. 3. Is it going to be an update queries? 4. & All the subform link one of the primary field with the main form's field ? 5. How does update queries works ? Regards & God Bless