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 strongm 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: vanlanjl
  • Content: Threads
  • Order by date
  1. vanlanjl

    CombcBox with multiple Fields to populate Text Boxes and requery

    My problem is that i have a combobox that displays two fileds, when selecting it will populate the data in the text boxes. Before I explain my problem though you may need to understand my database. Also i am building the frontend in Acess 2007, the backend is already built in SQL Server, the SQL...
  2. vanlanjl

    link to SSH

    is there a way to link a visio network shape to ssh
  3. vanlanjl

    Create a ping by double clicking shapes

    I would like to be able to double click a shape (router or switch) and be able to actually ping the device. Any one know if this ispossible and how to do it?
  4. vanlanjl

    Vertical Growing/Dynamic Growth In Access Tables

    Okay this is very complicated (for me), but i need some help on this please. I am creating a Network Diagram in Visio, along with this I have collected all the Information for every Network Device in my companys organization for each location across the country. I have placed this all in a a...
  5. vanlanjl

    Import Access Database to Visual Studio Project

    Not sure if this is the right thread but I will go ahead and try. I have an Access 2007 database, backend and frontend. I was wondering if it was possible to export the Access frontend (forms, tables etc.) into Visual Studio 2008 or will I have to rebuild them all in Visual Studio? I will be...
  6. vanlanjl

    Windows Steadt State

    Question, I am currently imaging some workstations that we will call Kiosk. I have an account setup on the doamin called kiosk user. I am trying to use steady state to lock down the users from access to any programs on the desktop. What would be the best way to do this. Is steady state...
  7. vanlanjl

    Import Visio Document to Visual Studio

    Is there a way to import a visio document into visual studio for web devolopment?
  8. vanlanjl

    Connecting multiple Visio Documents

    Okay here is the situation: My company currently utilizes NETVIZ for Nework Documentation. I was tasked to Export NETVIZ to Visio 2007 pro. Since our documentation is over 1400 pages we could not export it as 1 document becuase Visio would crash trying to load it. So i went through it and...
  9. vanlanjl

    Access 2007 Back-End to Sharepoint Front end

    Does any one know how, or where a good tutorial would be to take an Acess 2007 database backend and connect it to a Microsoft Sharepoint frontend?
  10. vanlanjl

    "Not in List" event won't work

    I cannot get the not in list event to work right. On my form I have a combo box named "cboChargeCode" I have a table named "tblChargeCode" I would like it so when you enter a value into the cbohargeCOde that is not listed it will alert you and ask you if you would like to add such item. My...
  11. vanlanjl

    Form1 to open Form2 with same records in form1?

    Okay lets see if I can do this with out confusing myself or others. First I will give ALL the details then state my problem and request at the bottom. Tables: tblContacts ID Company LastName FirstName Initial E-MailAddress JobTitle BuisnessPhone HomePhone MobilePhone faxNumber Address City...
  12. vanlanjl

    How to create a "remove filter" cmd button

    I have created a form that contain two combo boxes and two cmd buttons. The idea of the form is that the user will select a search parameter from each combo box then will click the first cmd button "cmdCreateReport". Upon doing so it open a report based of the search criteria. My problems...
  13. vanlanjl

    Combo box selection to create report

    Form1" combobox "cboModel" Row Source SELECT [tblModel].[ID], [tblModel].[Model] FROM tblModel ORDER BY [Model]; combobox "cboContactName" SELECT [Query1].[Contact Name] FROM Query1 ORDER BY [Contact Name]; quick explanation: I have a table named tblCOntacts and in this table i have 3...
  14. vanlanjl

    Create reports based upon combobox selections

    Ok I am new with reports and never fully understood them for my purposes. I have a database that I created for work where a user can enter in customer information like name number location etc. There is also a table for assets that keeps track of assets added and who these assets belong to. My...
  15. vanlanjl

    combo box on form1 to open form 2 with the values of txtboxes

    Okay i have two forms. Form1 = frmSearchUsers Form2 = frmAssetTransferApproval. Form 1 Text boxes: File as Contact Name ID Company Last Name First Name Initial E-mail Address Job Title Business Phone Home Phone Mobile Phone Fax Number Address City State Province Zip Country User Name Charge...
  16. vanlanjl

    COmbo Box Headache

    Okay I have a form that has a combo box on it titled "cmbSearchForUser" Row Source: SELECT [Query1].[Last Name], [Query1].[First Name], [Query1].[Initial] FROM Query1; Row source type: table/query bound coulmn:1 limit to list:yes allow value list edits:yes inherit value list:yes show only...
  17. vanlanjl

    Cmd Button to open small form when value is not in list

    Okay I have afrom titled "frmContact". this form has txt boxes that are populated from the tblContacts. In the form header I have a cmd box called "cmdAddFromOutlook" whe this is clicked it will open a search window form outlook and enable the user to enter a name and the name will be added to...
  18. vanlanjl

    Print cmdbutton not visiable on printed form

    I created a form named "frmAssetTransferApproval". This form has ben designed to replicate an actual word doc my company uses. The form pulls the correct information in from the tables. I created a cmdbutton that will print the one record of the form. The macro: Action...
  19. vanlanjl

    Active directory and SCCM links to Access 2007

    I am creating a database in access ( may not be the best choice), that ideally will pull data form Active directory and SCCM. Active directory contains the employee user information that i need and SCCM contains the computer information i need. I will then need to be able to link these two...
  20. vanlanjl

    Access Form to Word Document

    Okay - here is the situation. I have created an access form and want the data that it produces to populate a word document. Any ideas on how to do this. I have tried to recreate the word doc in access but that wasn't working. So any help would be great and i will continue to search on google...

Part and Inventory Search

Back
Top