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!

Register Log in
  • Congratulations derfloh 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: kirnavi
  • Order by date
  1. kirnavi

    Access 2003 is bypassing my workgroup file

    I've had a workgroup and secured databases for a few years now in Access 97. A few days ago, we converted all databases to Access 2003. Everything was working fine up until about a few hours ago. Now Access (everyone's) is bypassing the workgroup, even though the workgroup administrator says...
  2. kirnavi

    Dlookup help

    I am creating a database. There are two main tables - Table 1 (customer information) is created via a Make Table query, which pulls from an Oracle db, which is the db for our department's customer service system. Because Table 1 has to be manually refreshed, it may lag behind or be ahead of...
  3. kirnavi

    Pulling info from query or table into form

    The problem with using combo boxes is that I want the user to be able to add if they need to (I only used SSNs as an example). Let me explain what I have a little further. I have one table (table 1) that is created by a query, which pulls directly from an Oracle db. Then I have another...
  4. kirnavi

    Pulling info from query or table into form

    Sorry if this is a stupid question, but hopefully that means there is an easy answer. I'm creating a form and when someone updates a field, I want another field to look up information and populate. For example, a form where someone types in a Social Security number and then that person's...
  5. kirnavi

    Need Date-based criteria and can't figure out how to do it

    What I need is criteria for a date field that essentially says, "Grab everything that is for the month before the current month and on back." In other words, it is now August 2004 and I would need to grab everything that is July 2004 and backwards. I've been playing with various queries...
  6. kirnavi

    Not printing the subreport

    Hopefully this is an easy question - I put a subreport into my report footer since I needed some of the numbers from the subreport to calculate the main report. I don't want anyone to see the subreport so I set the "Visible" to "No" and set "Can Shrink" to "Yes". It's perfect except now the...
  7. kirnavi

    Sum

    I need to sum a field based on whether the amount is below or above $1000000. I need to end up with two fields - one which totals all amounts under $1000000 and one that totals everything over or equal to $1000000. I can't figure out how to do a SUMIF in Access and I know this must be easy but...
  8. kirnavi

    Referencing a text box from another report

    Does anyone know if I can pull in a value from another report? Report A calculates a value and I name the text box "ValueA". Then in Report B, I need to use ValueA in order to calculate text box "ValueB". I've tried a few different ways (Reports![ReportA]!ValueA) and it keeps giving me the...
  9. kirnavi

    User entering information in report

    I'm creating a report where I need to let the user enter an amount and then add that amount to other figures created in the report to create a grand total. Is there any way to do this? I'm creating these total in the report footer. Thanks.
  10. kirnavi

    Sum of sums in report

    Can anyone tell me how to sum sums in a report? I have my report data, and I end up with three sums on my report. They are calculated in the report footer. Then I have to add all three but I can't get Access to reference the earlier sums. Furthermore, I have to create another report that...
  11. kirnavi

    WRKGADM.EXE giving me an error

    I just tried creating a new workgroup on the 2000 machine and it also gives me the "Access is denied" error when I attempt to join it. ?
  12. kirnavi

    WRKGADM.EXE giving me an error

    Hi - I have a 97 secured Access db that I would like to upgrade to a 2002 db. I am testing it on a Windows 2000 box (all the other boxes in the department are NT). When I try to join the workgroup (yes, I made a backup), it tells me "Access is denied". According to the MS white...
  13. kirnavi

    Access is bypassing our workgroup log-in... HELP!

    For anyone interested - my workaround was to move everyone's system.mdw out of the system32 folder. Then it seemed to know to look for the workgroup it was actually linked to. Still don't know why though.
  14. kirnavi

    Access is bypassing our workgroup log-in... HELP!

    I would give the ADMIN id full rights, just so everyone can work... if I could. Since the ADMIN id has been stripped of all its rights, and I'm logging in as ADMIN, I can't change/add/delete anyone or their rights. No, there's been no compact and repair. I talked to Network Services and they...
  15. kirnavi

    Access is bypassing our workgroup log-in... HELP!

    We run NT 4.0. MS Office is installed locally on everyone's machines. Everyone in my department has had their workgroup changed to a departmental workgroup and have various rights associated with their IDs. The generic ADMIN log-in has been stripped of all rights. This has worked perfectly...
  16. kirnavi

    Query returning only MAX record

    I'm trying to write a query that will return only the record that contains the most recent date. For example, if you had a customer database and a new row is added every time the customer makes an order. Now you'd like to see what everyone's most recent orders are. I'm sure this is simple...
  17. kirnavi

    Queries on linked tables

    Oh, I forgot to add we are running NT and Access 97.
  18. kirnavi

    Queries on linked tables

    Hi - I have a database that is shared by 25 or so users, who all belong to a shared workgroup. This database contains data that is downloaded from our payment system. The tables used to be refreshed nightly but became too big so we now download the data into *.dat files and then created linked...
  19. kirnavi

    Save MS Word merged file with date for name

    Hi - I have a form letter that uses an Access query for its data source. This letter will be produced several times a week. Once the letter has merged to a new document, I want the end document to save and name itself automatically. For instance, I would want a letter produced today to be...
  20. kirnavi

    .MDW - file already in use

    I forgot to add - the .MDW is on a network drive so I can update permissions on particular queries/reports as needed. Susan

Part and Inventory Search

Back
Top