Search results for query: *

Hi, I have a macro that runs a series of delete and append queries. It runs fine. BUt once it is done, my copy of Access is sluggish and not all of the interface is showing. Task master shows Access is running, not non responding. TIA Danny

I have an 80 GB Western Digital drive from my desktop computer that I installed in a USB external case. Everytime I hook it to my laptop, I get a USB device not recognized error message. Not sure what to do. I also have a 160 gb Seagate in the same brand of box and it is recognized perfectly...

Hi, I am trying to be able to use a form to set criteria for a query. This query needs to be able to either pull by recieved date or closed date. I put an option group on my criteria form. I am having trouble making the logic with the option group work. The user will determine if they want...

Hi, I am needing to be able to work on queries and forms while others are in the database. I keep getting a message that I do not exclusive access at this time and I will not be able to save my changes. Is there a way around this?? TIA

Hello All, I am trying to use Dcount and I have hit a snag. This is what I currently have # NC: DCount("[product_Cat]","Audit_Report__Base","[NC_Score]>0 ) This works fine for one type of product, but I am needing to count the non complies for each product type. I am...

Hello All, I have a combo box that is sourced by a query. The critieria is the service center of the analyst. This is supposed to limit the choices for the dat entry person. The data entry person is identified by a text box that identifies current user. My problem is that my analyst box...

Hello All, I have a form and I am trying to tie all the combo boxes criteria to the auditor field. This will allow the database to have better flexibility and be used across the enterprise. If the auditor is a corporate employee e does not belong to a specific service center. Some employees...

Hello All, I have a combo box that I want to control the choices shown based upon the entry in a prior field. I can get this to work where I do not have to use like and the field name. Here is what I have SELECT s_Markets.[Market Code], s_Markets.[Market Name] FROM s_Markets WHERE...

I understand that Visio can map out an access database. I am looking for few pointers in how to do this. TIA Danny

Hello all, I have a database that is going enterprise wide. What I would like to do is have combo boxes filters change depending on what user is logged it. ex. Joe from Cincinnati logs in. Then I am wanting to have [Market] field only show Ohio, Florida, georgia. The rep table shows JOe...

Hi All, I am trying to limit the choices in a combo box based upon the answer in a previous field. Ex. if [Product] = Medicare, then [market] choices are SA or CC or KC or IL. TIA, Danny

Hello All, I have a db that I built to do case audits. Each record has 25 fields to record answers to questions. What I need to do is turn the data from rows into columns so that I can then query the data for the top 5 most missed questions. TIA, Danny

Hi all, I have a an entry form in my db. I am needing help to make fields required based upon previous data entry. ex - If the product is Medicare then I need to make sure that they fill out the Critieria met field and then if this is false then I need to require the Criteria Not Met Letter...

Hi All, I am needing help creating a unique id # that is never repeated. The issue is that it is needed only some of the time. The number would be needed based upon the answer from another field. If the platform field = B, I need the new unique #. All other reponses have there own unique...

Hello all, I was wondering how to make a combo box act like on the web? To be more specific when you enter a state you can keep hitting the first letter till you get to the state you want. Ex. Hit "T" twice and you see Tennesee, then you get Texas. TIA, Danny

Hello All, I have a form with 43 questions that are answered with a choice in an option group. Each option group can either be yes, no or N/A. I need to be able to count all of the answers by type, ie # of Yes # of no. I need to do this to calculate a score. I need to be able to add up all...

I recently added a new 80 gig Western Digital HD and a Memorex CD Burner. I went in an configured to make the new drives the mastes. I decided to reformat my little hd and install a clean version of Windows 2000. Now I start to boot and the machine will not find the 80 gig drive. I...

Hello All, I have a form that we use for auditing records. What I am needing to do is calculate the score for each audit and I would like this to show up at the bottom of the form. Option group values Yes = 1 No = 2 N/A = 3 All questions must be answered. So I am trying to just count the...

Hello All, I am having an error when I try to compact. This database lives on a network and has user level security. I get the following error message "the db the database is opened exclusively by userid ( This user id is mine) and I should try again when the db becomes available. I did...

Hello all, I have a filter for my report and everytime I run my report I have to keep resetting my filter. Any Ideas to fix this?? I know that I could use a seperate query, but I would rather not since I source 7 reports from the same query due to different users needs so a filter per report...