Search results

Hi All, I have a query that i use to generate and XML document from an access table. I have just been asked to update the query so the user is prompted to select a start and end date so the results are between start and stop. Problem is I keep getting a "too few parameters" error. Can someone...

gees, I thought it was a stupid question and boy was I right. I recreated the query in the wizard and used <Date() and it worked perfectly. Thanks for all the help guys, much appreciated! :D

I'll give it a shot, thanks!

Hi all, Probably an easy question but in a query I need to convert a text field (expires) into a date in order to do a comparison to todays date. My text field in my table is already formatted as mm/dd/yyyy but when I try to compair to todays date, I don't get the proper result. Can anyone...

Hi everyone, I hope someone can give me a hand with a problem I'm having. How can check to see what field number I'm in of a recordset and add additional formatting as needed? I am using the following code (found in the forms here) to write the table to a text file but in the for each loop, I...

Namliam, Thanks for the help. Greatly appreciated! Brad

Hi all, I am having a problem with one of my forms. Basically, I need to check whether a form value exists already in my table. If the value does exist, the user continues on through the form, however, if the value doesn't exist, I am trying to have a message box alert that no match was found...

Hi All, I have looked everywhere for documentation on this but cannot find any. I have read that you can open IE in an access form by using the Microsoft Web Browser Control and the Navigate2 command. Can anyone point me in the right direction on where the navigate2 command is used and/or how...

Thanks Chris, Appreciate the help!

Ok, so I think I have figured out my problem. If I switch from dates to strings and use the code below to get values and do the math, everything seems fine. myday = Mid(last, 4, 2) myMonth = Left(last, 2) myyear = Right(last, 4) Thanks Guys!

Hi All, I have a strange situation going on with one of my forms. I have tried everything I could think of to solve it, to no avail. On my form I have a calculated date field. the date field is calculated by a set review period and a last updated date which is typed in manually as a short date...

Here is my full code. 'Now query to add the page_file_name into HTML STATS TABLE Dim page_file_name As String page_file_name = Me.page_file_name Dim strSqlSelpg, strSqlApp2 As String Dim PG_Name As String strSqlSelpg = "SELECT page_file_name AS PG_Name from HTML_stats...

page_file_name is a variable containing a URL. In the query window, if I run SELECT page_file_name AS PG_Name from HTML_stats where page_file_name = 'http://mydomain/etd/html/wr_micro/index.htm' The result is one row with the column heading PG_Name and the one record of...

Can someone please tell me why my NumResults variable, after running the below query, is always equal to 0? It shouldn't be and I can't figure it out. strSqlSelpg = "Select count(page_file_name) AS NumResults from HTML_stats where page_file_name = '" & page_file_name & "'" Thanks Brad

OMG you're a saint! I put the #'s back and it picked up the proper records using the BETWEEN clause. Thank you soooo much for the help! Brad

That does clean up a lot of unnecessary code, but it still doesn't retrive any records. If I remove the date comparisons, the report retrieves information so I'm wondering if there's a format problem with one of the date fields... I have also tried the BETWEEN clause and cannot retrieve the...

This report is run every friday and the start date is actually today - 4 so is should display all records between monday and friday. startDay = day(Date) startMonth = month(Date) startYear = year(Date) startDay = startDay - 4 Dim startDate As Date startDate = startDay & "/" & startMonth & "/"...

ya, definitly something to do with the comparing date values. Is there a better way to compare dates than the format I am trying? WHERE ((date_due < " & startDate & ") And (date_due > " & endDate & ")) Cheers Brad

Hi Bob, Thanks. That seems to bring up some results if I remove the where clause from the sql query. I have tried the query as you stated with #" & endDate & "# format but it won't return my desired records. Is there a trick to compairing dates that I'm missing? Really appreciate the help! :)...

Yes, Exactly, I just don't know how to do it. Sorry, I should have been more clear. I am putting the sql into a message box to check that it's correct, which it is. The problem now is that I can't seem populate the report from the sql query.