Search results

??? I'm not quite sure what you mean. Here is a picture of the relationships:

Thanks. Thanks. I will try this.

Good idea! This is a good idea. How do I get TO this front end/back end stuff to set it up that way? This is new to me. Since you suggested this for in the future, I imagine that it is too difficult to retrofit. Just as an FYI, my database is currently on a server, with shortcuts on...

All set & nowhere to go! Any thoughts anyone. I have my database forms finished, but I to not want to mess up the data when I transfer it.

Error message I tried this, but I got an error message when I tried to save it, "Join expression not supported." When I click the help button here, it says, Possible causes: · Your SQL statement contains multiple joins in which the results of the query can differ, depending on the order in...

I have a database I have been working on a copy of. Now that I am finished, (or almost finished) how do I transfer my data over to the new version? The problem is that the old database has been in use while I have been updating a copy, so there are new records. In addition, there are several...

I am working on a survey that uses report headers to sort & display the data from my survey. For Example, I have: Survey Header (there are a number of different surveys) Area Header (Different Departments use these surveys) Question Header (Displays each question) Answer Header (Displays the...

Thank you! I Just looked at it. THANK YOU THANK YOU THANK YOU! It is just what I needed!:D :D :D :D :D :cool:

Thread is elsewhere For anyone interested in following this, It continues in another thread: http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=60393&perpage=15&pagenumber=1

I think I have located the problem, but not fixed it. I am thinking that I have located the problem, but I am struggling with the syntax. Here is the OnCurrent code for the ActiveQuestions sub-subform. I am trying to get it to requery the combo box on the ActiveAnswers subform (I disabled the...

OK...this is the AfterUpdate code you created: Private Sub cmbSSN_AfterUpdate() If IsNull(Me.cmbSSN) Then Me.Filter = "" Exit Sub End If If DCount("CustomerID", "Customers", "[SSN] = [Forms]![frmCustomersPOP]![cmbSSN]") < 1 Then MsgBox "No entry for this SSN number - please complete a new...

Wow! It actually made it this time?! I guess the key is a new e-mail, not a reply. How STRANGE! Anyway, thanks so much for your time & perseverence. :cool:

Sorry! Sorry about the extra hassle...the database is complex, with four interrelated forms that reference 11 tables via 5 queries that make the world go round. I was told that this was the best way to create a survey database that would be easy to add additional questions/answers/surveys to...

And Part 3! Here is Part 3!

Part 2... Here is part two. You will have to be sure to keep them in order, as they all have the same name.

That was WORK! It was WORK to shrink that thing down & move all the unneccessary stuff & references to it. At any rate, the best I could do was to get it down to almost 200,000 bytes...still too big! I did find a split-zip feature on my WinZip program. So I will send the 3 parts. Here is...

Hmmm. I will look at it when I get home. It is 5pm here and I am leaving now. I will pick this up at home. Yes, I mean to sync them together. Rather than go thru all the details again, here is the link: http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=60559 Active...

In the meantime.... In the meantime, regarding the survey question, this is what I am struggling with at the moment: Private Sub cboAnswerID_Enter() End Sub Private Sub Form_BeforeInsert(Cancel As Integer) cboAnswerID.Requery End Sub Private Sub cmdNextAnswer_Click() On Error GoTo...

Tried that first! I tried. It's still too big. Even stripped down & zipped it is 2.14 MB. Do you have another address? A Yahoo one like you suggested maybe? The error message says it does not like you or anyone in your domain. Unfriendly thing, that firewall! However, I sent the...

Strange! Very strange. I sent out the response before I sent this post via Road Runner a few hours ago. Maybe there is a delay overseas? I sent it to the address above...dan_cat@btopenworld.com. Maybe there is something about btopenworld.com firewalls don't like? Or mabe btopenworld.com...