Search results

Happy Bday!! Yeah, yeah, I'm the new guy here ;) :D Feel free to kick me around and call me bad names! ;)

I would just do an update query. For an example on how to do this, I posted a sample db here: http://www.access-programmers.co.uk/forums/showthread.php?t=153950

Is the main form data populating the subform? A command button won't work in the subform if it's in datasheet mode. The last question is: "Is the data from the main on a new record in the sub?"

I agree, that make the most sense. You can export data, but linked tables makes the best sense.

Well, I guess for the default value, you can put something like this: =DFirst([YourField], "YourTable")

Ok, I think I'm tracking in on what you're trying to do; well sort of. Let me start off by saying, storing calculated values in a table is a big "NO NO!" :) Calculations should be done at the time of render, meaning, the calculation is done exactly when it needs to be displayed. Ok, now that...

will it always be "Last Year"? I'm assuming that you are wanting grouping by customer name and just one record to show the total, correct?

are you doing a requery after update on each combo box?

First of all, let me start by saying "Date" is a reserved word, do not name fields the same as reserved words. The easiest way would be to make a query with parameter criteria: Assuming 3 fields: MyDate, Acct, Amount (In the criteria for mydate): Between [Starting] And [Ending] Then base a...

Can you explain what the expected output is, and what you're getting? Also, this video explains cascading combo-boxes fairly well: http://www.datapigtechnologies.com/flashfiles/combobox2.html

I blame me :) It's this Attention Deficit Disorder thing. :p Sometimes I get ahead of myself. :D

Gee..... ya think? LOL!! I have a hard time believing that she'll get through the approval process, if that's the case. :D

Nixon pulled us out of Vietnam, if you remember. I do think that presidents that have served in the military tend to be more attuned to national security. Look at Clinton. I'm not saying that having never been in the military makes you a weaker president. I'm saying, having served in the...

Please..... being a former POW has no bearing on being president. I don't think we have to worry about our president being held in captivity, and even if he was, the VP would assume the responsibilities. Now, on the other hand, military experience has quite a bit of relevance to the job of...

well, for a union query to work, you have to have the exact number of fields and the same field types.... instead of Select * try selecting the desired columns (fields) Also, you might want to stay away from having spaces in field names and table names

actually, that's european format.... US format is mm/dd/yyyy so cdate will work there as well

why not just use the cdate() function? cdate([yourtextdate])

Correct..... I did that on purpose, so he could run the append query, and then update the missing email fields in the updatetbl, and then run the update query. The update query does, however work..... I just erased the updatetbl info so he could run the append query, fix the missing emails...

Well, actually, the U.S. was primarily settled by people wishing to have religious freedom, not by people looking for a government without religion. The intent was so no one religious group would be held above all others; which of course, worked. The 1st amendment secures the right for...

there are rulings on both sides..... Heck, some lawyers bring up law suits in certain parts of California just to get their mandate through. Regardless, the constitution does not say there must be a separation of church and state; it states that the Government cannot endorse a religion, nor...