Search results

Hello: Using Access 2003 I need to combine all the records from one field in a table to appear in one control on a report. For example if I have a table with 3 records, and a "Comments" field has the following data: good, bad, ugly on the report I need: Comments: good, bad, ugly In one text box...

Thanks. Either solution appears to do what I needed. Now the last step I need is a query to give me the percentages of each response. For example, from the output of your query I have: Yes 10 No 20 Maybe 10 So I need a query with the result to be: Yes .25 No .50 Maybe...

Hello. I'm trying to use a Query to count customer responses to a survey. For example, Customers can answer: Yes, No, or Unsure to the survey. I would like the Query to count total # of responses, total # of "Yes" responses, total # of "No" responses, and total # or "Unsure". First of all, I...

I don't. The comboboxes all have different values.

I have several combo boxes on a form that have various tables as their row source. What I would like to be able to accomplish is that when a user selects a value from the combo box, it is no longer available for selection on the next record. For example, if my combo box list contains: Hats...

You are correct, in this instance it appears to work with or without quotes. I seem to remember previously where I had a problem getting it to work without using quotes, but it may have been due to my limited knowledge of vba code. Thanks.

That's my understanding of the format of an IIf function. If a field is empty and you want it to insert something, you have to put it in quotes. The function that I used inserts the number 0 into a number field.

What I determined to be the problem was that the TRAVTIME field contained several empty records. Instead of entering a zero when there was no travel time, staff members apparently just left it blank. So I inserted this code: IIf(IsNull([TRAVTIME]),"0",Val([TRAVTIME])) in the 'update to' field...

When attempting to use the val function in an update query as suggested, access tells me it can't update the records due to a type conversion failure. I tried setting "NewField" as both a text and number field but got the same error.

Hello: I have a table in an access database that was developed by another person several years ago. In this table there is a field named TRAVTIME. It is for staff to enter time they spent travelling to and form worksites. Unfortunately the original programmer set it as a text field. And also...

Yep, that's pretty much it.

With a bit of googling other forums I was able to figure out this code myself. I can post it if anyone is interested.

sorry, but I am programming this for a user that will go berzerk if I try to tell her that she has to use the interface to accomplish this task. The only way I will ever get this one through is it she can do it with one mouse click. Or better yet, could the code be applied to the Open event of...

Not sure if this is the correct forum or not, but can some one help me out with vba code to import a table from another database? On a form, I would like to have a command button, that when clicked on, imports a table from another database. Just need some help with the code. thanks

I think I'd like to move down under. Here's what we went through this winter. I had to shovel my roof 4 times. http://http://www.fourwinds10.com/siterun_data/spiritual/pictures/news.php?q=1204920443

Thanks. Couldn't have done it without you. BTW how is the weather down there? It is autumn there, correct? We still have patches of snow on the ground here in Upstate New York State, USA, but spring is finally here.

Yep, I think I got it working, at least on my pared down sample. Now on to the real thing. Thanks again for all your assistance.

I have several reports that pull data from the table that this form populates. Obviously reporting that, for example, in the month of March 2009 there were 3 referrals from ReferralSourceID 3 doesn't mean anything to agency staff. I have to somehow recorrelate the ID# to the referral source and...

RainLover: OK I think with some modifications your code will work for what I want to do. The only remaining issue I have is to populate MyTable with the Referral Source and Referrral Name rather than ReferralSourceID and ReferralNameID. Any ideas?

OK, thanks. I'll take a look at it. Is there a way to do the same thing by using the value lists instead of tables? I really don't want the end users changing the data, and I have already created the two combo boxes using value lists, all I need to do is set up the two so that the first filters...