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...

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...

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...

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...

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

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...

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...

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...

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

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...