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: *

  • Users: iuianj07
  • Content: Threads
  • Order by date
  1. iuianj07

    Updating data from an UnNormalized table to a Normalized table

    Hello guys, I am currently in the process or re-structuring one of our current databases. We currently have an aweful unnormalized table structure that I changed the table structure to hopefully a properly normalized table structures I think I did an okay job in normalizing the tables, I am...
  2. iuianj07

    Simple DateDiff query takes too long to run

    Hello guys, I have a simple Job Tracking database wherein we track a number of SitusIDs and determine which phase/status is it going through. Our Client is a bank wherein they send us deals (PK in db is SitusIDs) and we track the status of each deals in the database. To have a quick view of...
  3. iuianj07

    Query/Report as of prior Saturday Help

    Hello guys, I have a Job Tracking database wherein our team does sizing reports (in case you're familiar with Real Estate terms) from our client and we track the status of each loan in this database. I want to share the table structure of the Job Tracking database (tables that I think relates...
  4. iuianj07

    Update query messed up, looking for a quicker solution

    Hello guys, I need help with a messed up update query I did today... I had the wrong approach on how to correctly use an update query, and I know now how to write it correctly, however there are about 53 total fields I need to re-write per query, and I have to do it for 3 different queries...
  5. iuianj07

    query criteria help

    Hello guys, I am creating a new db project in our office, and it is kind of a job tracking database wherein we have a bunch of loan numbers, and we create ASRs and/or Data Tapes (using excel) and we just use the database to track the status/phase of each loan number, wherein if it has been...
  6. iuianj07

    Rename query name in form's combo box

    Hello guys, I have a frmDailyReport wherein I have a unbound combo box, and a subform names subFrmQueries... I actually found this form here in Tek-Tips (I guess from MajP..) and found it useful, what it does is in the combobox, it will list down all queries in the database and show the results...
  7. iuianj07

    Calculating Turnaround Time error message

    Hello guys, I am trying to calculate number of turnaround days between two dates, we basically have a job tracking database, where we receive a bunch of loans/deals from the client, we enter the loan/deal information into the database and track the status of each database depending on how we...
  8. iuianj07

    Re-creating a query from unnormalized to normalized table

    hello guys, I am re-structuring one of our database which has an unnormalized table structure... I am now at the point of re-creating the queries from the unnormalized structure to the normalized one: Basically this database is a job tracking database, wherein we receive loan records from our...
  9. iuianj07

    Modify query to make a form updateable.

    Hello guys, I have a frmJobtracking which is bound to this query: SELECT tblJobTracking.SitusID, tblJobTracking.WeekNumber, tblJobTracking.DealName, tblJobTracking.UBSOriginator, tblJobTracking.Broker, tblJobTracking.City, tblJobTracking.State, tblJobTracking.Region, tblJobTracking.AssetType...
  10. iuianj07

    Open a form in datasheet view from a login form VBA

    Hello guys, I have a database (Access 2007) which has a frmLogin as my startup form... this is basically a combo box that displays usernames from tblEmployees who uses the database and a button to login... the code of frmLogin is: Private Sub Command2_Click() If Not...
  11. iuianj07

    Status Query Check

    Hello guys, I have a Job Tracking database wherein a record (a loan/work we do) in the database goes through a different phases/status to track status of the record (Loan received, In Process, Ready for Review, Sent to Client etc) For a quick background here is my table structure (that...
  12. iuianj07

    Calculating Days between 2 dates (excluding weekends and a twist)

    Hello guys, I need help in calculating number of working days between 2 dates with a little twist... I have a Job Tracking database wherein a record (a loan/work we do) in the database goes through a different phases/status to track status of the record (Loan received, In Process, Ready for...
  13. iuianj07

    Simplifying two queries into one help...

    Hello guys, I have a Job Tracking database wherein a record (a loan/work we do) in the database goes through a different phases/status to track status of the record (Loan received, In Process, Ready for Review, Sent to Client etc) For a quick background here is my table structure (that relates...
  14. iuianj07

    Append Query Help to fix an Un Normalized table

    Hello guys, I have a current db that has a table which is not normalized. Currently it is setup as (well these are just fields that relate to the append query): WorkFlow table: WorkFlowID Test1NOIDSCR Test1NCFDSCR Test2NOIDSCR Test2NCFDSCR Test3NOIDSCR Test3NCFDSCR So obviously this is not...
  15. iuianj07

    Sub form Criteria question

    Hello guys, I have a main form frmJob_TrackingAll with a subform,(set as continuous form) and linked via Situs_ID that acts as a tracking form for each status/phase of each parent record. on the subform I have a combobox that lists the different status/phase for each parent record, and I also...
  16. iuianj07

    Sorting Records in Form

    Hello guys, I have a main form frmJob_TrackingAll which is bound to this query: SELECT Job_Tracking.Situs_ID, Job_Tracking.Project, Job_Tracking.Facility_Number, Job_Tracking.Requested_By, Job_Tracking.Client_Sponsor, Job_Tracking.Property_Loan_Name, Job_Tracking.PortfolioID...
  17. iuianj07

    Sub Form Default Value should only be on first record..

    Hello guys, I have a form with a subform, the subform is set as continuous form. I have a combo box that lists down different status/phase of a record. I have setup a default value of "Indexing Request Received" on the sub-form, which should be correct. My question now though is once a record...
  18. iuianj07

    Calculating Sum Amount in a query help

    Hello guys, First of all, I apologize for the lengthy post, and thanks for the patience in reading this. I am about to create a Financial Spread Database, wherein we gather loan information from our clients (which are banks) including properties' Financial Statements and Rent Roll. What we'll...
  19. iuianj07

    Creating Two Records Instead Of Only One Whenever Form Unloads

    Hello guys. I have frmNewTransaction, wherein we enter data in whenever we receive a new deal (work) from our Client. On the form, I have 2 combo box fields for ASR (control source ASRStChID) and FileSource (control source FilSourceID). The VBA on the Unload Event is: Private Sub...
  20. iuianj07

    Query Criteria Help

    Hello guys, I have a query that for example--- I have this Indexing_Loan_Status table: Situs_ID Analyst InStChID 298 user 1 298 user 10 298 user 11 303 user 1 And I have a query that whenever a Situs_ID have InStChID = 10, then the whole...

Part and Inventory Search

Back
Top