Search results

  1. H

    pulling the top 40 records for each user

    I have a database that has the testing scores of users but some users did the test more then once when they were only suppose to do it only once, for every test there is 40 records generated with a time stamp. I want to pull off the first 40 records for each user so i can get their first test...
  2. H

    Slow Query times with SQL Server

    I have an access database frontend with a SQL Server backend, the backend is located in Kansas City and the frontend is on a users desktop in Cali. It takes forever for the server to run some simple querys, is there a better way to do this so it doesnt take so long? What i think the problem...
  3. H

    SQL Sever side query to filter for user ID

    I currently have a query in an access database that filters the records in a Sql Linked table for their user ID. So basically i use Environ("UserName") to filter for a field that contains their user name. I want to secure this and put it on the SQL Server so there is no way anyone can see any...
  4. H

    Securing Your Database

    I want to secure my database so no one can mess with it or see anything other then what i give them. I have tables imported from a sql server and want to be able to make it so they wont be able to see those, whats the best way to do this?
  5. H

    Vertical Labels in datasheet views

    Does anyone know how to make the labels in datasheet view vertically aligned?
  6. H

    Text Box Expression for Summing a query

    I am trying to build a dashboard kind of database. I have a text box on a form and a query that is the totals of how many calls was done per day. I want to make that text box equal the total number of calls that are in that query, how is this done?
  7. H

    Chart Labels bunching up

    before i pull out any more of my hair, I am making a pie chart and the "Best Fit" function in access charts for form flat out doesnt work. Does anyone have any suggestions on how to get these labels from bunching up?
  8. H

    Access Database Size Issue

    I just got done migrating the tables in my database to a SQL server, I went in and deleted the extra table that was created with the migration manager so all the data in my database is on a SQL Server, For some reason the size of the database is still the same. Why is that? I even when in and...
  9. H

    Filtering for Lowest Date out of Duplicate records

    I have a table that has a list of order information, there are multipule records per order that have information about when the order was processed. There is a day tied to the process time of each record, I need to filter out the duplicate records and get one record for an order, but that one...
  10. H

    2003: Not Like Query

    Hey i want to search a string for Not Like in a query, I tried this: Not Like "*" & "total meds" & "*" but it just gave me all the records suggestions?
  11. H

    Sorting Records by Times

    ok so im not sure how to explain this but ill give it my best shot. I have an excel sheet that has a list of order info. heres a sample of what it looks like: 701 44:37.0 Starting order split <34010993;01> gregory_pm 34010993 702 45:16.0 Script complete for <34010993;0106> Rx <24073318>...
  12. H

    compairing/retrieving info on a record

    I have a table of all the user logon IDs in it with the employee's name and infos. Is there a way to select a record out of a table by the logon ID and assign the employee's name to a variable/field? basicly i want to filter a table by the employee name after that.
  13. H

    Looking up exisiting records

    Im trying to make a PO database where people can enter, submit, and approve orders. I'm having trouble allowing a user to start a record and then return back to it when they want to finish it. How would you allow a user to look up an existing record so they can edit them?
  14. H

    How much do you get payed?

    I was wondering what a person would get payed for making databases with Access and Visual Basic all day? Anyone have a job doing that? If so how much do you make a year and how long have you been doing it? where do you live?
  15. H

    identifying the user

    I have made some accounts with the user-level security wizard, and i was wondering is there a way to know who logs in? Im wanting to give a person preset information on forms and stuff.
  16. H

    Problem with getting information from a table

    Im using Access 2003. I have a form with a combo box that has a list of all the names that are contained in a table. I am trying allow the user to select a name but then when the user selects that name it pops up the email in another text box. The name that is being selected is in the same...
Back
Top Bottom