Search results

Im trying to design a tracking DB for phericals and ports located at workstations throughout the office. Theres over 200 workstations. Ok this is what I have so far. Please tell me if im on the right track and any suggestions. Ive never been good at doing the relationships. They are so...

Another section at work has asked if could help give them a hand to setup a database that will track phericals, ports on workstations They will will search items by dataports, workstations, asset numbers, serial numbers and staff names. This what I have so far. If theres any sample DB out...

Im "attemping to create a DB that records data on case that we investigate at work on fraudulent application. The person who is being investigated may have many people that assisted the client in making the application. Therefore addresses and names need to recorded for that case. The idea of...

I have an unbound combo box that finds the record that matches the control on a form. When the form first opens the combobox is blank. How do set the combo to the very first record. My form has a has a subform. The combox allows user to select the client and the subform shows the lessons that...

I want to build a query that will spit out a list of clients where they need to be sent reminders. The query needs to check the ExpireyDat against todays date. The query should spit all the clients where 7 days prior to their expirey date Do I use something like this e.g LetterReminders...

My question has two part. Firstly, Im tring to count the number of records in a form which is a child to the parent form. Ive place an unbound text box on the main form to show the count of records of the second formbut its not working. I tried the followig in the controlsource...

Im using FollowHyperlink - cannot find, errorsage? Application.FollowHyperlink "G:\Settlement\IHSS DIRECTORY\SOUTH SUDANESE PROJECT\Test_Sudanese_Pilot.xls" The excel sheet is bases on a query from the DB. When I click a button to open the spreed sheet Im getting a message : Cannot find...

simple but need help table construction Ive been asked to help with the construction DB that tracks courses attended by our call centre operators. I want make that my tables are correct before going any further I need to be able to report on who has or will attend/ed what course/s , and which...

I have a text box on a search form where a user can enter the SSN. The user clicks a button and I want it to open the another forms that has the record. can some help please

Im having a litle difficulty with the last few lines in the code. maily the last Mgsbox and VbYesNo Private Sub PrpSSN_AfterUpdate() Dim strRecordOwner As String Dim vntWhoGotIt vntWhoGotIt = DLookup("[ClientID]", "tblreferrals", "[ClientSSN]='" & Me.PrpSSN & "'") If Not IsNull(vntWhoGotIt)...