Search results

thanks Bob, The SQL seems to be ok. when I display the query in a message box, it's right. I'm just not sure how to execute the sql in the VBA window of a report and have it display properly. I thought using the openQuery with the sql query would display properly but it doesn't seem to...

Hi all, I have an issue with a report I'm working on. The report is to display all records between two dates. These dates are determined by the date() function and stored as variables. When my code runs, the dates populate fine and my SQL looks right but I don't know how to get the results to...

Thanks for the help Bob. I figured out the problem. When using Left() and right() the variable needs to be a string. What was happening is that I was trying to do come calculations based on the mymonth and myyear variables and with them being strings, it errored. I used the cInt() on the...

I have tried this method and it still gives me a mismatch error.:( my variable "last" holds a short day format such as last = 10/10/2008. when I use myday = left(last, 2) I get 10 when I use myyear = right(last, 4) I get 2008 but when i use mymonth = mid(last, 4, 2) I get the mismatch...

Hey all, should be a pretty simple question but I am having problems breaking a variable which holds a short date (dd/mm/yyyy) into seperate parts. I get a mismatch error. Anyone know what I'm doing wrong here? Dim last As String Dim today As Date Dim myday As Integer Dim...

Thanks WR, I didn't realize that onchange was for a keyboard event. I'll give this a try. Thanks for the help! Brad

Hey everyone, I have a pretty good question this time. I have a combobox on a form that lists serveral different content types (categories). These content types have different review periods and when the content type changes in the combobox, I am trying to requery and update the text box with...

OMG, I knew it was something really dumb. I was looking at details from the pallette. Thanks GW and everyone for the help!

I cannot locate it. I right click on the form background and select properties and there's no "Picture" property listed in any of the tabs. Sorry, I know this is really dumb...

Ok, so this is possibly the dumbest question ever... I have a form which was made with a background image. Problem is that the image makes the text very hard to read but I cannot seem to be able to remove it. Any ideas? Thanks

Thanks Rookie, I'll give that a shot and see if it clears up the issue! Brad

Hi all, Hope this isn't too "nub" of a question but I'm a little stuck. I have a form which is used to add or view records. When viewing a record, I have a control button that, when clicked, copies the values in the text fields and dropdowns and inserts them into an update table. I have 2...