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 Wanet Telecoms Ltd 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: nja5150
  • Content: Threads
  • Order by date
  1. nja5150

    Rookie GPO question with WSUS

    I'm running server 2003 with terminal services, active directory, and DNS installed. I've confirmed the DNS portion is working properly from the client XP machines. My active directory is setup as follows: Forest: mb.s Domains mb.s ->Default Domain Policy <block inheritance>...
  2. nja5150

    error handling input boxes for excel

    Hi guys and gals! I hope this might be something someone can shed some light on for me! I've got an input box that opens up to rename an excel sheet. The trouble is...I get a run-time error if the user clicks cancel before entering in a name. The second message box (which verifies the users...
  3. nja5150

    BEFVP41 VPN viewing Network Neighborhood glitch...

    Hey guys- I was wondering if anyone had any ideas. I have set up VPN tunnels for two BEFVP41's. Subnets 192.168.3.0 and 2.0. My machines are all configured static, with the gateways on x.1. I wanted to selectively use IP ranges for my local and remote groups. However; unless I use the...
  4. nja5150

    Extract data with details from .ASP

    Hello- I have access to a web driven report site that has a list of transactions. Each transaction has a detail link associated with it. The site has a built in export to excel for the list of transactions....but not for the extra detail you can link to on each transaction. I need to pull...
  5. nja5150

    Use Excel Cell as input for formula

    I would like to use something typed into a cell within excel to update other formulas within the spreadsheet. Basically I want to be able to update a group of formulas by changing a single cell. Is this assigning a variable or defining a name? This is probably really simple. I have one...
  6. nja5150

    Move data from Access query to Excel sheet

    Hello- This is a very basic question. I'm looking for any ideas. I have an access query that I need to use to fill data in on an excel worksheet. This work sheet already has some headers and other stuff already created at the top of the sheet (like title and company info). I need to start...
  7. nja5150

    Replace character in fields on update query

    I was wondering if anyone could help me with some SQL code to run an update query for a memo field I have. The memo field was imported from a dbase file and as a result I have these funny characters throughout the memo field in each record. The problem is defined in MS Knowledge base and their...
  8. nja5150

    code for fields, renaming fields, and changing field lengths?

    Hello- I was wondering if anyone knew a way to use VB to change field names at the table level. I also require code to add fields to a table and rearrange order plus change the field length property. So far it seems that only changing the field lenght property is possible. Does anyone have a...
  9. nja5150

    Get latest dated record -multple tables -multiple field names

    Mpastore helped me with this issue...it was simpler at the time I need to return the most up to date record entered by the invdate AND the receipt in the respective tables below. I need to return the address information for that most current record. The invoicenum will be the same in both...
  10. nja5150

    Filtering a query for the most current date

    Hello I have a dbf file that has some record entries with the same invoice number. Each set of records with the same invoice has a sequence # field and date when it took effect. I need to write some code (or maybe a slick filter for my query) that will return just the 1 most current record...
  11. nja5150

    Copy the same record to all employees

    I've been stuck on this for a week now! I have a form and a subform: -Mainform- EmployID(PriKey- from Employees Table) controlling -subform- DayPK(PriKey HIDDEN),DayID(dates), EmployID,Day(names) This is for a timecard database. I want to be able to add days (records) to each employee...

Part and Inventory Search

Back
Top