Recent content by Rebel7

Thanks Gizmo, I made the changes, but the problem is still there. I believe that my code isn't complete or I am missing some important scripts that need to be there for the query to work. I don't know.

Hi Guys, I am trying to figure out how to query an access database table called Phone Numbers from a webpage. Basically I have textbox (called phn) and a search button (called submit). The value entered in the textbox is queried to the table and if found a msgbox pops up saying "Found" and...

Hi Nigel, The database would be local. So far I have tried using the following script template: <SCRIPT language=vbscript> <!-- Private Sub Button1_Click() Dim sql1 As String Dim sql2 As String Dim Conn As ADODB.Connection Dim RecSet As ADODB.Recordset Set Conn = New ADODB.Connection...

Hi DCrake, The data entered in the textboxes is actually being added to the table and not updating the records in the table The reason is because I want to keep all the records that were entered and add to those records rather than update them. The status update simply means that they need...

Hi Guys, I have a form with textboxes that the user manually enters information in and submits the information to a database table in access with the click of a button. The listbox is to display a list of SINs for that day that need to have information entered on the form. However, I have...

Hi Nigel, I'm actually trying vbscript as I find it easier to work with but I haven't really figured it out yet. If you are familiar with vbscript, your assistance would be appreciated. Thanks,

Hi Guys, Basically I have a form with some textboxes that you enter information in. The form has a listbox that runs off a query with a list of items displayed in the listbox from the table. These items in the listbox need information entered which the user does manually in the textbox. To...

Thanks. I'll look into that.

Hi Everyone, I am trying to do a DBlookup with an access page using javascript. What I would like to have is a textbox that queries the entry in the textbox against the database and pulls a msgbox saying "Entry in Database" and if not found "Entry not in Database." I am very rusty with...

Hello, I am trying to create an access page. I have created the page but the problem I have encountered is that people who do not have Access on their computers who need to use this Access page get a "Data provider cannot be initialized" error and then the "could not use;' file already in...

Hi Brian, Thank you for your help. I figure it out and now that part is working. However, my main concern is that because the Date column in the database has the time included, the sql query looks at the time when considering <Date() because I am pulling results older than now but that is...

Hi Brian, What I noticed with my last post query is that now when I action the SINs on the form, the date column of my table is no longer automatically populating with the current date as it did before I put this new query in. The query was: SELECT MAX(Table1.Date) AS [Last Date], Table1.SIN...

Hi Brian, Thank you so much for your help. I am almost there. What I have so far is: SELECT MAX(Table1.Date) AS [Last Date], Table1.SIN FROM Table1 WHERE (((Table1.Date)<Date()) AND ((Table1.[Phone Number]) Is Null)) OR (((Table1.[Phone Number])="555-555-5555")) GROUP BY Table1.SIN; This...

Hi Brian, Thanks that removed the error but I am still getting duplicate SIN records showing. The query is meant to look at the most recent record for each SIN older than today that fall under the other guidelines (ie. phone number = blank or "555-555-5555", etc.) and to ignore the older...

Hi Brian, I tried that and got an error saying "You tried to execute a query that does not include the specified SIN as part of an aggregate function." I played around with it but still got the error. I don't know what to do. Thanks,