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

SJ McAbney I looks like there is 2 parts to the questions but I only provided part of the solution to his/her question . As for the limit to text box question, your link to the thread is spot on SJ McAbney.

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

try this in the OnClick Me.YourtxtboxName.SelStart = 0 This will always make the cursor go to the start of the first character in a text box when any one clicks in the midde or any in a textbox. hope this what u need.

Im a autonumber primary key person as well and I just need some feed back before went any further with the DB. thanks

. I knew what you meant dude!:-) Just one more question. Would u use FileNo in the client table to link it to case details table using the client File No or would it be better to user the Autonumber as the primary key. We consider fileNo important in our organisation. I use to using auto's as...

Thanks for the tip. I'll take it onboard.

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

The IF and Then statment was incomplete. try this Private Sub saveRecord_Click() If IsNull(txtJobDetailsStaffNo) Then MsgBox "You must enter data in this field", vbCritical, "Data requested" Else DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70 Exit Sub End If End Sub

Yep! that did the trick..thanks bud!. Another one to store in my memory bank..hehe

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

Thanks Tim!! my apologies! next time I will direct any queries in the correct forum section

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

Thanks Pat you are so right. I guess i just wanted to the no. in the recordset to stand out.

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

Ah huh , good point! thanks Milo how about this, Is this fine! I didnt include the staff table. tblWorker WorkerID LastName GName etc tblLink_Worker_Course WorkerID CourseID tblCourses CourseID CourseName CourseCode tblPresentors PresentorsID Presentor tblLinkCoursesToPresentors...

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 Knew it was len but I could remember . Thanks!

I dont suppose you know how to make a button visible after the 12 digits have been typed in. Im using this imput mask and as the last digit is clicked I want the command button to be visible. I have set the command button to invisible on open on the forms properties 000\-000\-000\-000;;_ I...