Search results for query: *

One small edit to the code shown... The fp_sDEfault line should read fp_sDefault="User=" to match how I currently have it configured.

Sorry....let me try to explain this a bit better and provide some code... Here is what I have going on.... I have a MS Access Database that I am querying. I have it setup with a connection called "DATABASE1". There is a table in the database called "Favorites" I used MS Frontpage to create...

I have setup a reslts page in MS Frontpage from a MS Access database. I would like the page to automatically load all records associated wiht the current logged in user when the page loads. I have a field in the DB that stores the user name -- it is called user. How do I modify this line of...

THANK YOU!!!!

I am trying to create a hyperlink such as <a href="#">Click Here</a> and have the value that is displayed, in this case "Click Here", copy to a text box on a form. I am doing this because I have a table with a list of mutliple ID's and I would like each to be a hyperlink and when the user...

You are awesome!!!! The first one worked perfectly -- thank you so much for your help! Best Regards!

Thanks for your help! The SQL your provided returns the highest revison tied to each different different PODescrip. So it shows...given my example above... test1 1 test2 2 test3 3 I just want it to show the record tied to the highest revision number...so... test3 3 since 3 is the...

lars7... I have the following SQL now... SELECT CO.PODescrip, Max(CO.Revision) AS MaxOfRevision FROM CO GROUP BY CO.PODescrip HAVING (((CO.PODescrip)>"max")); However it returns nothing? :-/ My Data in the table is as follows: PODescrip Revison test1 1 test2 2 test3...

When I remove all the group to in the SQL I get an error that says "You tried to execute a query that does not include the specified [field 1 in query] as part of an aggregate function." Any thougts on what is causing this?

I know this is a simple fix, but I just can't seem to get it work this AM :) I need a Query to show only the highest (max) record. So I have records as follows for example in a talbe I am querying... TABLE1 Descript ID test1 5 test1 6 test2 7 test1 8 test3 9 QUERY...

I have a table setup with a field for [startdate] and [enddate] that specifies a period in which somone is out of the office. I have designed a form where a user will enter a stardate and enddate (unbound) on a form and in the subform it needs to look in the table to see if anyone 'off' during...

Is there anyway to not have the first record automatically displayed when an MS Access form is opened? I would like the user to be able to move between records on the table, but would like it if it was just blank when the form was opened, instead of the first record. Thanks!

YOU ARE AWESOME!!! Thank you so very much!

Thanks so much.... The problem I has having is gone, and here is my code, however, now I keep getting this Run-time error '91': Object variable or With block variable not set Private Sub Combo62_Change() Dim db As DAO.Database Dim rst As DAO.Recordset Dim intSmartNum As Integer Set rst =...

Hey, Sorry to bother you with this again, but despite my knowledge of VBA I have not worked with recordsets in quite some time. Hoping you can help me out a bit more towards my goal here... I have the following... Dim rst As Recordset Dim intSmartNum As Integer Set rst =...

Thank you for your help. I am familiar with VBA and know exactly what you mean. My only thought, though, is that I belive this will number as follows... First Record -- listindex = 1 -- textsmartnumber: 1100 Secoond Record -- listindex = 2 -- texsmartnumber: 2101 Third Record -- listindex = 1...

Here is what I am trying to accomplish and have tried and tried without resolve to create.... On an Access Form I will have a drop down of 9 different options (for example, 1 Year, Blanket, Legal, etc...). Then I want to have text field 'smart number' based on this selection. In other words...

Thank you so much! It workes perfect now!

Thanks for your help! I did this and no error, however, no effect... this is my code now... Private Sub Command56_Click() Dim selectedcomment As String Dim varx As Variant selectedcomment = Me.Combo54.Value 'get comment selected in combo54 drop down menu varx = DLookup("[CommentText]"...

I tried this without any luck...anyone see anything wrong? Private Sub Command56_Click() Dim selectedcomment As String Dim varx As Variant selectedcomment = Me.Combo54.Value 'get comment selected in combo54 drop down menu varx = DLookup("[CommentText]", "BidComments", "[CommentName] = " &...