Search results

I don't understand why I need the sort table though. I think we're on different pages here. My current junction table looks like Audit_ID***Question_ID ***1*******101***** ***1*******102***** ***1*******103***** ***1*******104***** If I want to keep track of the SortOrder by Audit_ID (not...

I don't. All the questions are stored in a QuestionAudit junction table that holds Audit_ID and Question_ID. We only need the sorts to be related to the Audit_ID.

Sorry, I've been a little busy... So, I don't really understand why the table has to have the AuditorID. If we don't need to have custom sorts by AuditorID, wouldn't the current table with SortOrder column be sufficient?

Hmm...the queue order needs to remain permanent for the auditor to use weeks later. I think that eliminates option 1 and 2. For option 3, we don't need to have a custom sort by each user; just a general rank that will remain the same for all users. So...what do you suggest?

Great! Thank you very much :D

The business process is: 1. User selects an audit (#123) 2. A form opens and allows the user to add questions to audit #123 from a list of questions in the db 3. As each question is added, a continuous form at the bottom requeries and displays the questions assigned to audit #123 4. My boss...

I will have to say at most 20 per audit.

Haha sorry about that. Netflix is an online streaming website for movies and tv shows. Here's an image of what their queue list looks like. Yes, this is a multi-user database but at most three people at a time editing their own audit information so the likelihood of write conflicts is very...

This is a cross-post from dbforums. My boss wants a Netflix-like queue feature on a continuous form. The user will select items and add it to a 'checklist'. This 'checklist' is a continuous form. The user should be able to sort the continuous form results by adding a rank to each result (like...

Hi there, I am able to use Application.FollowHyperlink to open files on the network drive but I wan't it to be read only. For example, if they open a Word Document I don't want them to edit anything and save the file. I can't make permissions for read/write access because the users need to be...

I saw a solution that involved using multiple transparent textboxes, but this won't work because the color only shows when the textbox has focus. Does anyone know a way to have more than 3 conditions and have the colors always show? Thanks!

I want to import the outlook contacts information into a table. I went to External Data --> Import --> Outlook Folder --> Folder. I choose link tables and then create a linked table. When I open the table, everything seems correct except for the email addresses. Here is a sample email address in...

Problem Solved. Turns out I didn't refresh the linked table so the column didn't exist in the Access table. :o

I am trying to retrieve text from a textbox and store it into a table. I am getting a Too Few Parameters error and I can't seem to find a way to fix it. I've tried all sorts of suggestions on Google but it doesn't seem to be working. The problem occurs with the 'Audit_Scope' parameter. If I...

The code below works with the OpenArgs. Is there a reason why this solution wouldn't be as good as using the rst.Bookmark? Private Sub Form_Load() Me.subfrmPlanAudit.Form.Filter = "[Audit_ID] =" & Me.OpenArgs Me.subfrmPlanAudit.Form.FilterOn = True End Sub

I'm sorry, I forgot to mention that when I open the second form, the record set is in a subform. Does this affect anything? I tried your code above but it doesn't go to the specified record with matching Audit_ID. When I debug it, the openargs is correct and the rst.NoMatch = False so that it...

Thanks for the reply. This works but it doesn't accomplish the business objective. What I'm trying to accomplish is to have a user select an Audit, store the Audit_ID into a variable and then open a new form where the record is set to match Audit_IDs. I don't think I can set anything up to find...

I want the user to be able to double-click a textbox in the continuous form and then have a specific piece of string (Audit_ID) from that textbox stored into a variable and then somehow, if possible, open a new form and have the current record set to where it's Audit_ID matches with the variable.

I have a table with Audit_ID as the primary key and I am trying to open a subform and have it load the record where Audit_ID equals a global variable called AuditID. The AuditID is an integer and the Audit_ID field of the table is also Number (or smallint in SQL Server). When I try to execute...

I have a continuous form with many rows and columns. Is it possible that when a user double-clicks a cell, then it will pass the value in the cell into a textbox? Thanks for the help!