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

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

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

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

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

Hi - I have several databases for our department which I secured a while back. Everyone has joined a common workgroup. Here's the problem - occasionally, users trying to open up a db will get an error (&quot;Couldn't use <PATH>.MDW; file already in use.&quot;). When I hit Help, it tells...

Hi - I've got a form which is based on a linked table. I would like the users to enter a social security number and have the participant's name, address, etc automatically populate a number of fields. Here's what I have cobbled together so far: Private Sub txtSSN_AfterUpdate() Dim varName...

Hi - I have a hopefully simple problem. I have a database with a lot of information, which includes almost 100,000 people. This database gets updated nightly. Now, I need to create a separate database for our customer service dept when one of these people calls in. I would like a form...

Hi - I am trying to figure out the best way to launch a Word document from Access and populate the Word fields with info from Access. I need to do this from within Access, as opposed to making a mail merge doc in Word and using Access as the data source. Once the Word document is populated, I...

I am trying to figure out a way to update a table column through a macro. Our customer service dept gets people who need their checks stopped for one reason or another. This info gets entered into an Access form and sent once a day by a central person via a macro. Now they (customer service)...

Hi - I am running an audit of our database once a month and am trying to create a unique ID number for each participant. This audit looks for deceased people and returns 'hits'. So out of 95000 people, maybe 100 die. The next month, I need to send out the 94900 people from the previous audit...