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!

  • Congratulations IamaSherpa 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: *

  1. Technyc2003

    Need understanding with relationships with my database

    There will be only 1 Electric Company, there are various Phone Companies, that's why I figured I'd put their various names in the Vendors table. BTW: is my relationship okay that I posted?
  2. Technyc2003

    Need understanding with relationships with my database

    I'm trying to create a rather simple database that I will be linking with Crystal Reports. My task is to create a Vendor tracking system for each department within my company. For example, we have 15 different departments in 15 different locations. We have to pay various utilities bills for...
  3. Technyc2003

    Should I use an AutoNumber for a PK or use a FieldName as a PK?

    I tried with ProductID but that doesn't let me choose different barcode items even though it's the same product but different code #. I tried Barcode# as a control source and that didn't work. Were you able to see the database and the issue?
  4. Technyc2003

    Should I use an AutoNumber for a PK or use a FieldName as a PK?

    I created a rental database in which I have multiples of the same equipment but barcoded with a different number. I know most inventory type databases uses 1 number for the same item. Like i.e. cans of Ajax: 50 cans with the same product ID. In my case what I did is that I have a Product ID for...
  5. Technyc2003

    Issue with Combo Box in Rental Database Need Advice

    The issue I'm having is just weird to me for some reason. I have a product id for each of my machines. However, I have a seperate barcode id# for each equipment. When a customer comes to rent the equipment I want to scan the barcode number but my combo box won't let me choose more than one.
  6. Technyc2003

    Issue with Combo Box in Rental Database Need Advice

    Good day! I'm near completion on a database project that's taken me forever to complete. With the help of so many sample databases here I'm 95% near completion. Attached is my database for your review and suggestions. I have an Order Products table which basically holds the name of the product...
  7. Technyc2003

    Bind fields to a tab control question

    I just spent 3 days creating a form for my job with all the info they requested. Today I'm told to add a couple of other items they need to track so I want to go with a Tab Control. I really would hate to have to re-do all my designs and coding. I know with Access's Tab Controls you have to...
  8. Technyc2003

    How do I run a script as administrator on a local power users PC?

    We need to create a script that will change the Power User access we have on all 300 of our employees workstations to Administrator. We're trying to setup a new proxy firewall into their internet explorer but in order for us to do that they need administrator access. We can do it manually by...
  9. Technyc2003

    Need help please with Checkboxes on Userform w/VBA

    After several hours searching I finally got it working. I didn't realize I had to create a code for a checkbox command click. Well this is what I used and it finally places checkmarks in the boxes. This worked while the form is unprotected. I haven't tried it yet with the form protected...
  10. Technyc2003

    Need help please with Checkboxes on Userform w/VBA

    It destroys the bookmark but it creates a new document which is what I want to happen since they are working from the original .DOT template form. for some reason the code you provided still does not add a checkmark in the New Admission checkbox...
  11. Technyc2003

    Need help please with Checkboxes on Userform w/VBA

    I've created a template form for my co-workers to be able to fill out easier by using VBA. The textfields work ok it's just the checkboxes. The form is also protected from the little lock on the forms toolbar. I created an OK command button so once they fill out all the boxes and text boxes...
  12. Technyc2003

    Trying to perform a mail merge into a MS Word Table from Access

    Phil, thank you very much, you are The Man!!!
  13. Technyc2003

    Trying to perform a mail merge into a MS Word Table from Access

    I think I got it, I put the <<Nextrecord>> after the ClientNo field only and did a test and I see each client the way it's suppose to be. On last thing my friend, how do I tell it to sort alphabetically by my Patient's Name?
  14. Technyc2003

    Trying to perform a mail merge into a MS Word Table from Access

    I'm not too sure what you mean this is how I have the form setup right now. «ClientNo» «PatientName» «Birthdate» «Gender» and what I've done is copy and pasted those fields into each row of my MS Word template form table. I don't use the Access Database for anything right now I just created a...
  15. Technyc2003

    Trying to perform a mail merge into a MS Word Table from Access

    Could really use some help with this problem. I'm trying to perform a mail merge into a Microsoft Word Table template from an Access Database. I created this template form that has 8 columns and 20 rows. Now when I click the button to perform the mail merge it works fine. BUT!!! the problem...
  16. Technyc2003

    Is it possible to join a Win2003 Server to a Win2000 Domain Network

    I'm currently working on a sharepoint server for my job and it required Windows 2003 Server which I did install. Now I'm trying to install Active Directory on that server but I get the following error message: The operation failed because: The active directory installation wizzard cannot...
  17. Technyc2003

    Can't login to the Sharepoint server using Windows XP

    I've just finished installing a test server for our company with Sharepoint Portal Server 2003. I followed all the steps accordingly from the Users help guide. Then when I try to connect from my Windows XP workstation I get the You are not authorized to view this page error. It asks me 3...
  18. Technyc2003

    Need help changing the tdm-group in my router

    I figured it out....took me a while but I had to type first: ------ interface T1 1/1 second: ------- tdm-group 1 timeslots 1-24 speed 64 Once that was done the telco did it's test and I was able to ping the router with the new config and I'm done. Thank the Good Lord.
  19. Technyc2003

    Need help changing the tdm-group in my router

    I tried it and it didn't work but it's my fault because I failed to mention that I'm using an Adtran router which is somewhat similiar to the cisco commands. Once I typed Config T I was in the programming mode. Controller T1 1 did not work so I looked in the manual and I guess I'm supposed to...
  20. Technyc2003

    Need help changing the tdm-group in my router

    I'm doing an upgrade today with the Telco and I need to change this line on my router and I need to know how to do it please. I need to change the line below from channel 1-8 to 1-24 (it needs to be now tdm-group 1 timeslots 1-24) Can anyone tell me how I can make this change? I know all about...

Part and Inventory Search

Back
Top