Search results

The form in question is a subform, and the one-to-many relationship is handled by the form/subform. The query that is the record source for the subform pulls in some related fields from other tables, and those fields are locked on the subform so they can’t be edited anyway. I’ve also verified...

This is a split database, with the backend stored on a LAN and the front end on each user’s machine. Sometimes the users access the database from home, over VPN. And did in the case outlined below. I’ve tried to discourage them from doing so, but... I have a continuous subform bound to a...

Thanks MarkK, I like your solution for the update, gets it all in one query! Keeps my navigation pane a little cleaner.

Well I was definitely making that harder than it needed to be! And then I can make the 2nd query an update query to change the ratings to 0. Thanks bob!

| ReviewID | QstnID | Rating | |:--------:|:------:|:------:| | 1 | 1 | 0 | | 1 | 2 | 1 | | 1 | 3 | 1 | | 1 | 4 | 2 | | 1 | 5 | 2 | | 2 | 1 | 1 | | 2 | 2 | 1 | | 2 | 3...

I ran the Not Exists query on both sides of the junction table and it didn't return any results. So I exported the data from the junction table into Excel, used the CLEAN function on all the data, copy and pasted the values over the original data and then imported it back into Access. I was...

Recently, after I run a compact and repair operation on this database, I get a referential integrity error on attempting to add a new record. I then have to export all the tables to a new database, and everything works fine until after the next compact when I immediately get the error again...

I think so too. Do you have any you recommend? I could Google for some, but there are so many out there. At any rate, I definitely need to study up on subqueries. That is what CJ's solution is, correct? Happy New Year to you both as well!

Yes it does, thanks!

It's not returning ResultID 5 now.

I'm sorry, in my first post I was trying to give a generic example to explain what I wanted to accomplish; I should have listed my actual table names clearly in the 2nd post. tblAudit is actually tblCatResult, which has a record for each review completed (Field ResultID would probably be more...

OK, hopefully I left enough data for you. In my original question I had renamed the some of the tables to try to explain their usage better. I think they'll be apparent looking at the data, but if not let me know (for example Employee = Adjuster). I reworked the tblAdjusters by removing the...

Hello all, I have a survey database that I’ve been using for the last year for monthly auditing of employees files. I need to be able to get monthly audit scores for each employee but grouped by their manager. The problem I’m having is employees have moved between managers throughout the...

I found the following info Here: The Text data type has been renamed "Short Text." A Short Text field can contain up to 255 characters in a desktop database. In an Access app, the default character limit is 255, but it can be increased to 4000 in the field properties. The Memo data type has...

Works great, thanks Bob and Paul.

What I have is a form with field list combo boxes, for users to select from several date fields and run a query to calculate the date difference between the fields. Here is my entire sub: Private Sub CmdCalc_Click() 'variable to hold the sql statement Dim strSql As String 'variable to hold the...

I have the following string I want to insert into a SQL string strFields = strFields & "DateDiff('d',[" & StrEvent1 & "],[" & StrEvent2 & "]) AS " & StrEvent1 & " to " & StrEvent2 the variables StrEvent1 and StrEvent2 hold strings containing spaces, so I'm trying to wrap the whole AS alias in...

I’m developing a claim tracking database that tracks dates of events that occur in the course of processing a claim; such as, Loss Date, Report Date, Estimate Date, Payment Date, etc. There are 16 different “Events” in all. I currently have the following tables set up: tblClaim ClaimID...

Thanks, I see that in Allen's example now. I need to read more carefully.

I'm trying to use the following expression: =IIf(ELookUp("EventDate","qsfrmEvents","[EventID] = 8 And [fkClaimID] = ' & [Forms].[frmClaim].[txtClaimID]'")>0,True,False) But I'm getting a data type mismatch. txtClaimID is numeric, but if I take out the single quotes I get a syntax error. Any...