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...
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
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
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
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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
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...
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...
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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.