Search results for query: *

The DB is 17meg before running and after running the macro it is only almost 18 meg. I don't think that compacting is the solution.

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

That is what I was afaid of. Thanks for your help.

I am not ready to go to that step. I used to have this ability in Access 97. Is there a way to have it again?

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

I would set up user level security to handle this issue. Here is an explination. 1. Set up a mdw file for your db. Use the help instructions in Access for a Workgroup file. 2. After you create the new mdw make sure to rejoin the system.mdw file for your copy of access. 3. Create a...

In a query. That I will use to source a report

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

do you want the whole list to be seen at once? Is it not wide enough? Could you be more specific?

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

Robert, Thanks. Works great. One more question. In a similar instance except that the service center is different from the entire string in service center code so I would like all choices to show. Service Center = CP and Cp is not part of the string for service center code. So I would like...

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

Why not just use internal Access Security. It would give you more control than just access into the db. Here are instructions that I have written. I would add users level security. This allows Access to know how many users are in the db. It also will fix any write errors that may occur...

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

You can hold the shift key down and then launch the db. This will bypass security. You should then be able to do what you need to do.

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