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: *

  1. fsupport1600

    Short Code to Route incoming calls to General VM Box

    My receptionist has asked for a short code be setup so she can put all incoming calls into the General Voicemail box when she leaves her desk for a few minutes. She mentioned that *84 was the code she used in the past but it is not working. When I lookup the *84 code its settings are: Code...
  2. fsupport1600

    Pull Header Information from a text file?

    Does anyone know of a way to setup a header in a word file that reads its header text from a txt file? We have a system in place that contains around 277 individual MS Word files in one folder. A user will go into this folder and copy out the individual word files they need for their project...
  3. fsupport1600

    Page Break based on First Letter Not working

    I have a report based on the following Query: Field: prodTagID Table: tblProducts Field: RoomNumber Table: tblRooms Field: Quantity Table: tblFunitureSelection The report is grouped on prodTagID. The product tags contain the following values: A101, A102, B101, B102, C101, etc. I want...
  4. fsupport1600

    Subform Not Updating Table

    I thought I had this database working exactly how I wanted it to till recently. I have a form with a subform on it for selecting products. If a product is selected in the subform, saved, and then later deleted it does not delete it from the table, so when I run my report the entry still exist...
  5. fsupport1600

    =SUM Calculation on Report

    Version: Access 2007 I have a text box (txtTotalCost) with the following control source: =([SumOfQuantity]*[ProductPrice]) on a report However, I want to calculate the total sum for all these text box values but I get the #Error. I created a new text box (txtSumTotalCost) and entered the...
  6. fsupport1600

    Calculation Incorrect

    I am trying to calculate the total number a product is selected based on the following table fields: prodTagId Quantity I created the following query: prodTagID sumQty: Quantity tblFunitureSelection tblFunitureSelection Group By Sum Ascending...
  7. fsupport1600

    Table Information on Form - No Relationship

    I have a table that hold "project information" Project Number Project Name 1 Project Name 2 Project Street Project City Project State Project Zip I would like to have this information appear on my reports in the header. When I "Add Existing Fields" to the report it wants to create a...
  8. fsupport1600

    "Could Not Create Report" Message

    I am trying to create a report using the report wizard in Access 2007 and recive a message, "Could Not Create Report". I have the following Tables: tblProducts productTagID productType ProductManufacture ProductModel tblRooms RoomNumber RoomName tblFunitureSelection...
  9. fsupport1600

    User Sent Items - Reporting

    I am looking for a way to run a report on my 2003 exchange server mailboxes that will list the user name and the number of sent items in their mailbox. I downloaded the Exchange Profile Analyzer, but the report shows the mailbox as a ID number and not a name. Is their another utility I can use...
  10. fsupport1600

    Prompt for user name in Script

    This has nothing to do with Authentication so I hope someone can help me here. I need to delete folders that are located within a user profile in XP. Since I am logging onto the workstation with a different account I want to create a script that will prompt me for the users name so it knows...
  11. fsupport1600

    Subform Help Please

    The database project I am working on seems somewhat basic but I continue to struggle. The intent of the database is to select products for classrooms in a school. I have configured the following tables. tblRooms ================== RoomNumber Primary Key RoomName tblProducts...
  12. fsupport1600

    Typical "selection" option

    I am working on a funiture selection database for my interior designer for my office. The designer will input the rooms names and room numbers in one table for the building, in another table they will input all the products for that project. Chairs, desks, tables....etc. In another table...
  13. fsupport1600

    Calculating Totals

    I am trying to figure out an expression to calculate the following: I have a product table, and each product is assigned a ProductTag. Example "S1". I then have another table called, Funiture Selection. This tbale is used to select a room number, then select the ProductTag which represent...
  14. fsupport1600

    Creating Subform Help

    Can anyone provide some help with a basic database I am trying to develop. The database is going to be used to select furniture for classrooms in a building. So I have created a table that contains the room name and room numbers. Another table that contains the product information for each...
  15. fsupport1600

    Auto populate Access DB field

    I have created 3 tables: Table1: Room Information - RoomName - RoomNumber Table2: Product Information - Tag ID - ProductName - ProductMake - ProductModel Table3: Quanity information - RoomNumber (Relationship) - Tag ID - ProductName - ProductMake - ProductModel In table 3, how...
  16. fsupport1600

    Access Calulations

    I have created 3 tables: Table1: Room Information - RoomName - RoomNumber Table2: Product Information - ProductName - ProductMake - ProductModel Table3: Quanity information - RoomNumber (Relationship) - ProductName (Relationship) - Quantity The user opens Table 3 and selects the...
  17. fsupport1600

    Basic Access Database

    I have very little experience with MS Access so I was wonder if someone could provide some help, even a sample database that I could get started with. I work for an architectural firm nad we are working on a furniture package for a school. I would like a way to run reports on the following...
  18. fsupport1600

    Stop logon/logoff script when disconnected from network

    Is their a way to prevent logon/logoff scripts that are pushed by group policies to not try and run when a laptop user is disconnected from the network running Windows XP Pro w/SP3? The laptop users have local profiles, but when they login while not connected to the network, their application...
  19. fsupport1600

    Key Management Services 1.0 for Windows 7 Licensing

    Can anyone direct to download KMS version 1.0? I am attemtping to install Key Management Service V1.1 on a Windows 2003 Server Standard, w/ SP2 and I am recieving the following message: "The image file/update\update.exe is valid, but is for a machine type other than the current machine" I...
  20. fsupport1600

    System Performance Report

    Can anyone recommend a good utility or software package that I can run on a local PC and have it run performance test and provide upgrade/performance suggestions in a easy to read report? I would like to have it not install anything on the machine but if it has too I am fine with it. This...

Part and Inventory Search

Back
Top