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?

I don't want just the integer part to be shown. For instance, I'm doing accounting spreadsheets and if i have a value of 1,754.987. I don't want Excel to round it to 1,754.99. I want the value to be 1,754.98.

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.

The user is entering new data in unbound textboxes. The textbox I am validating is the &quot;TagID&quot; textbox. I have SQL code behind a Save button, and if the TagID matches what's in the table, I get a message saying the records cannot append. By the way, the TagID is the primary key!

The user is entering new data in unbound textboxes. The textbox I am validating is the &quot;TagID&quot; textbox. I have SQL code behind a Save button, and if the TagID matches what's in the table, I get a message saying the records cannot append.

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

Thanks Dre313. That works perfectly!!!!

I tried the code but I'm not able to type anything! Am I doing it right? This is what I have: Private Sub txtFirstName_Change() Me!txtFirstName = UCase(Me!txtFirstName) End Sub