Search results

I've Attached a Beach Survey I created for our field staff. Should give you at least some ideas.

Thanks guys! both tips helped!

Hey Everyone, I was wondering if anyone has come accross an issue with the Format Function in which if you use the Date.now as the date, it messes up the date. Example. If date.now provides the system date as 20/6/2011 Using the Format( Date.now, "mm/dd/yyyy") Gets you a random date such as...

The best thing I can think of that would get you close to the function of Excel would be to create a form with calculated fields and have code populate that into a table. The difficult part is that while excel has a defined location for a value, Access does not. What i mean: In excel, the value...

Hmm, odd, well glad you got it to work!

I ran a quick query in Access 2010 Somefield: [Field1] & Chr$(13) & Chr$(10) & [Field2] Worked perfectly...... vbcrlf didn't. If you go back to your original SQL and change the structure does it work? SiteAddress: [Name] & Chr(13) & Chr(10) & [Address1] & Chr(13) & Chr(10) & [Address2] &...

Glad to see you got it fixed!

ok, so make ALL the fields visible, in your image at the top, you can see that there are only 6 fields visible. However in your query you actually refer to 10 different fields. Once you display all the fields you will be able to see the difference between your first and second record. if you...

OHHH. sorry i was thinking about it backwards! hahaha.. ok that's odd. If i were in your position, i would step through the code. place a stop mark at the start of your code and use F8 to step through. as you get to each line, check the variable value by either placing your mouse over the...

Is this a new query that you have made since your original post? or are you simply outlining the process you have taken thus far? If this is a new query, could you take another image of the results as well as post the design?? If this is just an outline to your process and we are still talking...

When you group by multiple fields.. any fields for any records need to be the same as the other records for that field.. you essentially are saying. "Show me 1 record where field X, Y and Z all have the same values." - in their respective fields, not x = y = z You have fields which you are not...

Are the Office numbers the same? All fields you're not displaying... are they also the same? The group by will work on all fields even if your not displaying them

Sounds like a win win to me! :)

Because it's a string, I would say you may need to get into some if statements. Pull the string appart and if it starts with 00 - 11, append a 20 to the front, if however it's an 76 (Or whenever your data starts) to a 99 then append a 19 to the front. You have to treat it as a string field, not...

What does your query design look like?

A continuous form would yield those results. That's what I would use only because i've always been a believer that the reports should be for printing, and the forms should be for user interaction. If you created a continuous form and had a listbox which populated it's row source with...

Now I could be wrong on this, but i THINK you can have a button on a report that you can have in your details section. you should be able to program that button to open the attachment associated with that detail, but the problem is that it would look really ugly. Does it NEED to be in a "Report"...

You can switch the chr(13) + chr(10) to vbcrlf chr no longer exists for some reason

There was an old lady called Wright who could travel much faster than light. She departed one day in a relative way and returned on the previous night

Title: A Sexual Encounter between a Capacitor and an Inductor One evening, with his charge at full capacity, Micro Farad decided to get a cute coil to discharge him. He went to the Magnet Bar to pick up a chip called Millie Amp. He caught her out back trying self induction; fortunately, she...