Recent content by grizzlyjdw2

i had the enable property of the graph set to false. didn't realize that a disabled object couldn't be on top.

Ok, I have a graph object I want to display on a form, which is easy enough. The issue I am having is that I want the graph to appear on top of other items in the form. whenever I move the graph to the location on the form where I need it to be, whatever is behind it is showing though my...

basically what I am wanting is as follows: I have questions listed down the left hand side of the page and I want to print everyone's answers to the questions. the questions are the same for all records, just the answers are differrent. ex: QUESTION ANSWER question one...

I have a report that i am trying to email out in word, which is working fine. My question is, is there any way to specify a certain file to add the report to? For example i have a word docuemnt already created that i want to add the report to the bottom of. Thanks in advance :)

still getting the too few parameters error message. if i take out the form reference and just use Set rs1 = db.OpenRecordset("SELECT main.*, main.offshore_analyst FROM main WHERE (((main.offshore_analyst)='userID'));") it works, but i want the querry to run with either prompting or reading...

ok, basically what i am trying to do is open a recordset based off of a query, here is what i have Dim db As DAO.Database Dim rs1 As DAO.Recordset Set db = CurrentDb() Set rs1 = db.OpenRecordset("Select * from main where offshore_analyst = Forms![main_form]![offshore_analyst].Value;")...

ok, that makes sense. how would you do that in SQL though?

that isn't going to go back and pick up the previous days in the week is it? like if i run it for jan 27 i want it to pull 1-24-10 -- 1-30-10 is that possible?

is there a way to automate a querry to run for the current week? for example if i ran it today it would run for 1-24-10 -- 1-30-10

just figured out i can use List0.value i was trying to use .SelectedItem oh well live and learn :)

Here is what i am trying to do: i have a listbox named List0 i am trying to convert the selected item to a string and can't seem to get it to work. any help would be appriciated. thanks

i had a situation where i had 2 seperate tables and needed to write the same data to both tables in some cases. the only way i could find to do it was link one table with the form directily (this was the table i always needed to write to) then write to the other table using vba (given certain...

cool, i was wondering about the second character, ill have to do a check (just for my own personal curiosity) to see about the line feed. im use to c++, so playing with strings in vba seems a lot different to me. i'm getting there though :)

i found out what it was doing. it was reading in 2 characters for the return into the string. for example if the text file contained: abc def the string would contain 8 characters. the actual return started on the first of the 2 characters between the abc and def. i was checking the...

ok, here is what i am up against: i am reading in a txt file into a string. so for example i get the following abc def now i am searching through the text for def, which works fine, but i am putting in error handling cases (ie if network is a word and i am searching for work, it should...