Recent content by SirStevie3

Thanks for explaining Doc! I'll read that one a few times and hope I absorb some of your expertise! I'm still researching append queries, but I have some ideas on how i'll work this out. I'm hoping I can append things in a certain order to avoid these key violation errors. Thanks...

Actually I think my issue is more about key violations than anything else. My research on append queries leads me to believe my "foreign key"/"primary key from another table" issue would still be present with an append query. When I use this.... sometimes I get this. foreign key.... an error...

IT would be all the rows except for the top row which just holds the column titles. I was afraid an append query would be the answer. Ok, I'll have to do some research and learn about them and how to implement them. Thanks for the suggestion CJ! Much appreciated.

I have a form that is used in datasheet mode. It is based on a query that pulls fields from table A that has a foreign key (pointing to table B). I'm using this form as a way to quickly copy and paste data from an excel spreadsheet and get it into the database. The problem is for a specific...

Thanks JHB, I saw in your picture that you had the DM_Approval Checkbox on the actual form (instead of just the query the form is bound to), and once i did that it worked. Im not sure why it wouldnt work the other way... oh well. Thank you VERY much!:)

I am trying to get the text in a couple text boxes to turn green if a certain Yes/No field is left blank. I know the conditional formatting is working, because condition 1 and 3 are working fine (those expressions are referencing text fields). I would like to have Condition 2 look at...

Hey all, I'm looking for a way to have a text box auto fill based on the selection of a combo box on the same form. I cannot use the method i find all over the internet of using multiple columns in the combo box and basing the text box on that because the combo box already has multiple columns...

ok, after reading your advice and thinking i went with formatting the union query via SQL statements. worked well!! now my numbers look better, thank you for that. but still, i would like to move some things in the detail section around a bit to make the report more visually appealing. is...

thanks for the input. as far as i can tell (from experimentation) the formats of a query do not carry through to the union query, nor to the report. not sure how that would help me individualize the items of the detail section...

forgot to attach pics.

so i have a report based on a union query. i set up the query so that it can be grouped by month on the report. (see pics) The problem is that each detail section in the design view just shows one row of text boxes, a "Num" and a "Label". i'd like to be able to seperate this in design view so...

thank you Mihail!

I'm setting up some analytical reports and i'm having a hard time with some date criteria. I've gotten monthly averages already and what i want to do is take those monthly averages, and average them throughout the year. (the year being from the specified date on a form control back one year)...

guess i had the SQL statements in the wrong order. I got it!! thank you guys!

tried changing it to Date1 and Text63 but neither worked. what is a syntax error anyway?