Search results

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

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

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

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

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

I have a main form with a continuous sub-form. On the main form I have a series of text boxes that I want to use as a makeshift status bar. The text boxes would be filled in if a value was entered into certain records on my sub-form. The problem I have is since the sub-form is continuous...

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. I currently have the following tables set up: tblClaim ClaimID ClaimNumber tblEvents EventID EventName...

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. I currently have the following tables set up: tblClaim ClaimID ClaimNumber tblEvents EventID EventName...

So I was posting a question earlier today and when I attempted to navigate away from the page I was presented with a dialog about "Stay and earn credit to talk to hot girls" With the options Stay or Leave. I clicked Leave, and now in my browsing history I have an entry for an adult website...

I have the following table (tblQuestions) structure and example data for a survey database: QstnID(PK), QstnNum, SubQstnID, RespType, QstnText 1,1,A,1,Text of Question 2,1,B,Blank,Text of Sub-question The RespType field defines whether the question can be answered Y/N (RespType = 1) or...

I am trying to apply the following filter to my form: Me.Filter = "[ClaimNum] = '*" & Me.txtSearchClaim & "*'" OR "[ReviewerName] =" & Me.cboSearchReviewer.Column(1) but I'm getting a type mismatch error. I'm using the .Column(1) property to return the text value of the combo box rather...

Just moved this from the Queries forum since it has more to do with Reports, sorry! I’m working on a file audit database, which has a series of questions with possible Yes, No, or NA responses. I’m using the At Your Survey database as a guide, but there are a few details in my database that...

Hi all, new member here. I am a long time lurker, first time poster. Been using Access for basic projects and hobbyist stuff for a few years, off and on. This time I can't figure things out on my own from searching and need some more personalized assistance. So see you in the forums!