Search results

I have to review 20 reports each month for quality check. I have a query that lists the reports completed within the past 30 days. Is there a way to filter this query to show only 20 random records? If there is no way to do this, can you suggest some way of doing this so that it's impartial...

I have a form based on a query where I want to document the status of certain records. The original data is on a SQL server so I am linking to it in my query. I have a local table with the added fields to document my review and status. My query has both tables in it and are linked by the...

First of all I consider myself to have Intermediate knowledge of Access. I am comfortable building tables, queries, reports, macros, etc. but get a little lost when needing to manually code something in a query. I need to create a database to document quality reviews of certain reports the...

I was thinking I had seen it done in a query. I ultimately want the results in a report.

Yes...that the whole point of my post. I want to see one record (because it's one event) but I want to see all the codes.

I run queries against an SQL database where I have read only access. This database has the following fields EventNumber BriefDescription DetailDescription EventCode CauseCode SignificanceCode Resolution When users enter one of the 3 "Codes", they can enter as many as are appropriate. So an...

That appears to work!! I can not believe that it's that simple. That's just unbelievable. I have tried and tried to figure a way to do this. I'm just amazed. I really appreciate the help. Jim

That does not work because F11aa sorts before F11a which sorts before F11. Also adding additional numbers results in G1 sorting before F1, G11 before F11, etc. See attached.

Yes the third character is the stumbling block. Lets take a little different approach. What if I used an append query to copy the data down locally to a table. Is there a way I could apply formatting to the code table so that it would know that the first character is a letter, then if the...

The first character is always a letter, the next character will always be a number. The third character may be a number or a character. The fourth and fifth will always be a letter. Below are possible examples F F1 F1a F1ab F11 F11a F11ab Again, I appreciate the help. Jim

I admit it. I screwed up. My bad. But can you please help? Thanks, Jim

I am getting error messages when I tried either one. It may be my fault. Let me give you additional examples of the codes. I think the most would be one letter, a 2 digit number, then a 2 digit letter. F1a F10cc F11s F12t F2b F22nn F3c

I have a report that shows data from an SQL Database that I only have read access to. The report has Event Codes comprised of letters and numbers. When I run the query that my report is based on, they don't sort properly because there is insuffient leading 0s. Below is an example of how the...

There is no number with the message Access is giving me. I just says "You can not go to the selected record.". It does not provide any kind of number. Any other suggestions? Thanks, Jim

I have a form with Text box that I am using for a case number. I have to use a text box formatted as text instead of formatted as a number because the format of the numbering sequence is 00\-000\-AAA\-00;;. In the table design, I chose "no duplicates" because each case number has to be unique...

I was able to convert my MDB to an MDE. While it does prevent editing Forms and Reports, it appears that Tables, Queries and Macros can still be modified. What I really want is a way to prevent viewing Tables, Queries, etc. so nothing could be viewed or edited. It looks like Tools>Startup and...

How do I create and MDE from my MDB? Thanks, Jim

I am doing more and more Access projects at work. I am using Access 2003. Is there a way I can prevent people from tampering with what I give them? I always create an autoexec macro and run "Windows Hide", then open the main form. Someone can easily unhide the window or hold down the shift...

Thanks. I already had me.requery in the AfterUpdate Event but I added GoToRecord.Requery and that fixed the problem. I don't suppose having 2 requery statements in one AfterUpdate event is a problem? Jim

In the attached file, at the top of frm_Data, I have a combo box "GoToRecord" and a combo box "Filter". They both work fine except for one thing. When I apply a filter to show only Closed records for example, the GoToRecord combo box is not updated. It still shows all records and when I...