Search results

ya, I know you did lol...I just couldnt figure out what you meant hehe. So what do you mean by format in the strsql...you mean, in my case, DateStr?

thanks for the link! ok, it works perfect now!! i changed my code to: Dim lbDate As Date Dim dtReportDate As Date Dim newDate As Date lbDate = Me.DateListBox.Value dtReportDate = CDate(Format(lbDate, "mm/dd/yyyy")) newDate = lbDate - 6 newDate =...

Thanks, I will leave my dates as they are then :) And i format my dates because I the month and day seem to be switching...so I was trying to force them to all be in the same format (failed there). here are 4 screens showing you the process I take: First showing you my form...so I have...

still not working...It might be because of the name of my date field, but like I said, it would be a HUGE mess to try to rename the field...is there a way that with an OCDB connection, I can change the name of a field without it changing in SQL? Because right now it is querying between...

err..it will be a pretty huge mess to change my Date field, since it is coming from SQL, I would have to change a LOOOOOOOOOOOOOOT of code in a lot of files to have the name changed...cause this code is being used by php/c# and now Access...is it that crutial that I change the name? i know...

Hi everyone, I am having this problem when trying to call a report from within vba... pretty much what is happening, I am getting my data from sql via an ODBC connection, and I am querying that table to get the necessary parameters for my report... When the data comes in, the dates are...

wow, that was a great help, got it working perfect. very good, clear tutorial! thanks Paul

ok, so is that link (and you) saying that I should not have my combo box populated from values in a table? Im not really understanding what you mean by "You can do this on a FORM with a combo but not in a table." My combo box is on a form... so what do you suggest I do? because this table is...

Hey guys. I am trying to populate a combo box with values from a table.. So using the wizard I create a combo box and then a box pops up asking if i want to link its values to a table or if i want to type them in manually. so i select from a table, then i select the table...except it only...

mm. i will see if it causes any errors down the line :) this particular file isnt going out to the masses, just kept between a few of us at work, so i wont worry about it for now! thanks again

Lol. i have never heard that word before. so i looked it up, and you made me second guess whether or not it is good enough! haha. Is this way really bad?

I think i found a way around it. I just put SELECT DISTINCT so that only one (All) shows. thanks tho! :)

Hey. So I looked around on the forum for how to do this and came across a link to this page: http://www.mvps.org/access/forms/frm0043.htm (i use the 'table/query' option) and So I copied that, and it works great for one of my combo boxes: SELECT [tblProjects1].[ProjectID]...

Hi :D So I am using a syntax something like: DateStr = "And [Date] between #" & Me.datePickStart.Value & "# And #" & Me.datePickEnd.Value & "#" criteria = "ProjectID = '" & frm_button.Text_ProjID.Column(0) & "'" & DateStr more code... .... .... DoCmd.OpenReport "rptsql", acViewReport, ...

perfect! thank you everyone for your help!! I made all the changes you suggested namliam. it has been a while since I used access, I am a bit lost :P but I think I am mostly back on track now

nope, sorry :( but it is ok, the way I have it set up, you look at the form only, and then when you click the button, it will just open the report in a new tab...good enough :) thanks everyone for trying tho!!

Ok...so this is gona be a hard one to explain...BUT DONT LEAVE :P So I have a line: DoCmd.OpenReport "rptsql", acViewReport, , criteriaand although the code is a lot more complex than this, i will just show you the part of it that is called (in this exact situation...when this elseif statement...

still not working ugh >.< might try remaking the form with different settings when i get home

thanks! hehe, got half of it working :D. hid all the ugly crap around the sides but i still cant change comboboxes (i added a textbox just for testing purposes, and it wont let me enter ANY text into it)...i checked all the properties a few times, and they all seem to be good (none jumped out...

Hey, So I have a form that I would like to tack onto the top of a report that I have...it looks good, just a few problems. 1) (most important) i lose the functionality of the form...the code for the form looks like this: Option Compare Database Private Sub Command2_Click() Dim criteria As...