Search results for query: *

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...

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...

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...

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...

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...

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...

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...

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...

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.

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...

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. ?

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...

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.

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...

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...

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...

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

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...

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...

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