Search results for query: *

I have been having a difficult time trying to get the most recent record for a client. Here is the code I am using. The following code give me the results below. SELECT ad.authorization_details_id ,p.last_name + ', ' + p.first_name AS NAME ,av.event_name AS Training ,CAST(av.from_date AS DATE)...

I have a list of users that are assigned or not assigned to a group. A user can be assigned to multiple groups. I am trying to write a query that would show me the groups they are assigned to as well as the groups they are not. Having trouble with the logic and wondering if anyone could provide...

I'm trying to count the number of records in a recordset, but the code I'm using is causing an error. I have used this code in Access 97 but when I convert to Access 2000 I get a type 'Run-Time Error 13 Type missmatch' error. This is the code. Dim recPosition As Recordset Set...

Is there a way to query a list box? For instance, I have a list box that lists a number of employees. But it's a long list. Can I create a search button that will highlight my search results? If it is possible, can you tell me how I can make it happen?

How can I stop Excel from rounding decimals up or down?

I have a textbox that is calculating the value of other textboxes. How can I prevent negative numbers?

Does anyone know if there is a way to suppress action queries through code instead of through the menu bar? I'm installing a database on several computers and don't want to have to spend too much time suppressing action queries.

At startup I get a message that says "Could not find the main class. Program will exit." Can someone tell me why I'm getting this and how to fix it?

How would I go about deleting old data from one table and inserting it into another table? I know I could use SQL but I don't know the syntax. Please help!

How can one create a recordset from a hidden table or system object? It is possible?

I'm trying to capture the name of the forms that are loaded. This is the code I'm using: Public Function IsLoaded(ByVal strFormName As String) As Boolean Const conObjStateClosed = 0 Const conDesignView = 0 If SysCmd(acSysCmdGetObjectState, acForm, strFormName) <> conObjStateClosed...

Does anyone know how I can capture the IP address of a user in VBA code so that I can append it to a table?

Does anyone know the code to open an existing word doc when when a radio button is clicked?

Does anyone know if VB.Net can be installled on WindowsXP Pro operating system? or does it have to be installed on a server? I have problems installing on XP.

I have a database where if someone types in a number and that number already exist in the database I want code to search the table, find the that same number and show a message box saying that number already exists. Is this possible? I hope I'm making sense

Is there any way to force caps in the textboxes. I know you can go to the properties and use the &quot;>&quot; sign. But is there a way in code to force text to be capitalized while entering data?

does anyone know how the code that hides the Access database window?

is there a code where i could set an autonumber without using a recordsource

Could anyone provide me a code that would force a user's password to be case sensitive?

I'm trying to create a form where the user could type in the info they want(for instance account number), query the database and open another form showing the results of the query. Do i set up the recordsource in the form i'm opening or in the click button on the main form?