Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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