Search results

Well, I am a visual person so it helps me when I can actually see the fields. :D

Hi Mr. B, Thanks for getting back to me so quickly. I was trying to write a query and wanted to look at the tables involved to help me visualize better what I was needing to do. Does that make sense? Thanks!

Is there a way in Access 2007 to open more than one table in Datasheet view so that I can look at them side-by-side? TIA!

I figured it out. When I opened a query, I noticed on the Database Tools tab the Object Dependencies option. When I clicked it a window popped up telling me that I had to turn on AutoCorrect for that feature to work. (BTW - there is a good explanation of AutoCorrect in Help.) It asked if I...

I have a DB that I would like to clean up. Is there an easy way to tell which objects (tables, queries, forms, etc) are being used and which ones are not? TIA!

I came up with a solution that works. I used a subreport. I created a query to count the surveys by location. Then I added a subreport based on the new query. I had to fiddle with it a bit to make it look the way I wanted but I am pleased with the results. A screen print is attached in case...

I have created a report to display data from surveys. The report shows the location the survey was taken and then (by location) the count for every program wanted. I have attached a screen print. What I am trying to do is put the 'Total number of surveys received:' on the report for each...

Thanks Bob. The user decided that she wanted to see all the data so for the time being, I don't need to do a TOP 5 (I appreciate the link though and have bookmaked it for future use). She did thow me another curve which I will post in a new thread.

I have a query that pulls from 4 tables. Here is the select statement it generated: SELECT tblIndividualSurvey.Location, tblQuestions.Question, tblAnswers.Answer, Count(tblQuestions.QNumber) AS CountOfQNumber FROM tblQuestions INNER JOIN (tblIndividualSurvey INNER JOIN (tblAnswers INNER JOIN...

Great suggestions!! I did all the above: tightened up the header of the main form, collapsed the ribbon and maximized the window. It works really well now. The subform scrolls up as I fill up the screen. And an added bonus, it doesn't show the Records bar on the subform which will reduce the...

Hey Bob, I tried to follow your instructions for uploading an image but when I just did the Copy Shortcut and then a paste here, I got the following: http://www.access-programmers.co.uk/forums/attachment.php?attachmentid=36668&stc=1&d=1302034727...

Correction on the scrolling issue: I found that if I just pull down the vertical scroll bar on the main form so that I can see the bottom of the subform window, the subform window does automatically scroll up as I enter the data. So I guess that is probably working like it should unless...

I have a form that also contains a subform. The main form takes up about 1/4 - 1/3 of the window. The subform is a continuous form and takes up the remainder of the window plus continues past the bottom of the window. I have two vertical scroll bars - one for each window. First, as we enter...

Thank you! I did as you said and it works perfectly.

I am trying to control where the cursor lands when the user presses the tab key based on what was entered in the field they are currently on. I looked through other posts to see if an answer had already been posted. What I came up with was to Set the Focus on the field I want to go to. The only...

I got it to work!!! On the AnswerTxt field, I added to the Control Source this: =DLookUp("[Answer]","[tblAnswers]","[AID]=[AIDTxtbx]") I hid the AIDTxtbx field; removed the tab stop for AnswerTxt and shortened the length of the answerID field. I think that is as close as I am going to get. I...

Could you explain why the AIDTxtbx always displays the correct value? If I understood that then maybe I could tap into it some how. I have been playing with the DLookUp function but I get the same result - everytime the value in answerID changes all previous answerID fields in the continuous...

Got one thing fixed. I figured out that I was referencing the wrong column by saying column(2) when it should be column(1) (that 0 = 1 thing bit me again) so now the data in the table looks correct. Whew!!

Thank you so much for breaking it down for me. Here are the changes I made based in my understanding of what you sent. I am also including the db itself (with the changes) in case you want to look at it again. Access 2007 gives the same error message. answerID Format | Column Widths = 3”...

Sorry, I am not fully comprehending what you are saying (remember I am a newbie; you need to speak v-e-r-y s-l-o-w-l-y :)). What are you calling "column"? Is it the first field on the form (ie questionID) or something else? Could you restate the above with more detail? (on a side note: if I...