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

    2620 router w/ Wireless modem

    We need to connect to our corporate office through a vpn encryption card with a ipsec ios upgrade for our current ios. We have 1 t1/dsu card in the cisco. We have a wireless point to point to another building for our internet access. How would you guys recommend setting up the cisco router? the...
  2. paul123456

    Upgrading from 2k to 2k3 potential problem?

    We have a domain that was upgraded from winnt..the problem is that the domain name is called "domain" with no extension. and the netbios name for the domain is also "domain" the exact same name as the domain. currently we have 2000 domain...will this be a problem upgrading to 2k3? Thanks, PAUL
  3. paul123456

    Recomendation for VPN router.

    Can anyone recommend a good VPN Client router? I have a 2k server and want to connect the two locations with 1 end being a VPN device and the other end the VPN server on 2k server. can someone recommend a good VPN device that they haven't had problems with? Thanks, PAUL
  4. paul123456

    Group an object within a group?

    Is there a way to group an object within a group? I would like to group a date field by month. Jan,Feb,March,April..etc.etc. but the date field is within a group already created.? Thanks, PAUL
  5. paul123456

    Table relationships not working..

    I have having a hard time getting this to work..Heres what i have Table1 = Calllogs Billto Extension Number Date Duration Cost Calltype Table2 = Calltypes Name ID Table3 = Departments Site Name Department Name Billto I am trying to pull up infor based on the Department name.. Basically i was...
  6. paul123456

    Picture is wrapping around?

    I have a table on the top of my page with the backround set to a gif that i have as the site title. The problem is that it is wrapping around..the picture shows..but after it ends it starts over again? i been trying to figure out were the setting is but had no success? can someone help me out...
  7. paul123456

    Compact and repair..

    We do a import process that adds about 100 MB to the database. even though the data that is temporaly imported is deleted. Is there any way...any way at all that at the end of my import i can automate a compact of the database without the front end users having to get off the database? as of now...
  8. paul123456

    IIF statement and then

    Does the code go IIF ([table.record]=data [in record] , display this , or else this) And... i want to be able to make a reference on my report.. my question is the a comma (,) the same as then? and the second (,) is or else? im trying to pull information for a field... if it = to CA then...
  9. paul123456

    Export to excel using certain criteria.

    I am trying to export data based upon a query..the kicker and the problem i am having is that I need to export using 2 queries because of the different criterea..and the problem is that is it asking my between statement twice...enter start number..and enter end number. I would like it to only...
  10. paul123456

    Seperating a field into two

    I have one field as text with 2 letters followed by numbers. how can i cut out the first two characters of each record and put them in another field and leave the remaining characters in the original field?? here are the records i will be using IDNum StateCode The data right now is in the...
  11. paul123456

    Reference to Text field and display information.

    I have some reports that i would like to display different data depening on what the first two letters of a field are.. IE if the field starts with TX i would like to display a different ="text " field in the report but if it starts CA then it displays ="differenttext"?? how can i go about doing...
  12. paul123456

    Reference Report to Module instead of Query

    I have several of the same reports that i run only because the records sources are pointing to different criterias that ask different types of questions. Instead of the report referencing to the query..is it possible to make a button reference to a module that will open the report with the info...
  13. paul123456

    Excel Macro that stips characters from fields in a column

    Can someone help me out. Im looking to create a macro for excel that will strip out the first 2 characters in a text column for all records. say the column will always be D. is there a way that a macro will strip out only the first 2 letters of the record in all fields under column D? Thanks...
  14. paul123456

    Limit the amount of queries.

    Hi people. i have multiple reports that are the exact same that point to different queries to give different criterea. Is there a way i can convert my query and insert it into a module.. I would like to have a module with a my selections in critereas that i want.. and then use 1 report that...
  15. paul123456

    Update query not working on where statement?

    UPDATE temp1 INNER JOIN Items ON temp1.MainNum = Items.MainNum SET Items.ItemNum = temp1.ItemNum WHERE Items.[Date] IS NOT NULL AND cDbl(Items.[Date]) > 0 everything updates ok if i take the where statement out. but for some reason its not working ..i just want to update the itemnum field only...
  16. paul123456

    Moving update queries to modules.

    I have a module that does mulitple things to allow a excel file to import. During the module process it calls a few different update queries. Can i just copy the update query in the module? or does it have to be in a update query? I have 2 many queries and i want to move as much as i can to...
  17. paul123456

    Restoring 1 mail box

    The Ad account has been deleted but now we want to add the user back in with her mailbox. I have a backup and it shows the users mailbox..but how to i restore if the user has been deleted from AD.? Thanks, PAUL
  18. paul123456

    Update a field if date is present??

    I am importing data from excel into a temp1 table..then in a module it runs this query below. what it does is the following It joins tables temp1 and Items And takes MainNum on both temp1 table and items table if they are the same it will then update the Itemnum and overwrite the Itemnum in...
  19. paul123456

    Status bar.....ohhh it would be nice

    you know...I don't know if you can do this..but i do no this is the place to ask...it would be awesome if theres a way to display a status bar as a form...or a box in the middle of the screen...just like the status bar in the bottom left..it would say...running query...importing...exporting..or...
  20. paul123456

    where is the default excel templete stored?

    I would like to install a macro and have it be available on all excel document opened? do i do this by modifying the default template? were is this stored at..and is it possible? Thanks, PAUL

Part and Inventory Search

Back
Top