Search results for query: *

i have a Computer with a USB keyboard and a USB barcode scanner is there a way I can capture what input device was used to type in the keyboard the keyboard or barcode scanner Thank You Pwise

This is what the Boss ordered Open a word doucment in a access form No problem -- Put a WebBrowser control on a form and Navigate to the word document Works like o Charm But this is my problem if I edit the document andd i try to save it i get this message error 5356 Word cannot save...

Can Something like this be done? I have an UDF that takes a parameter returns a table Create function dbo.Somefunction (@Somedate DateTime) RETURNS @SomeCalendar Table(Somedate DateTime,Dateplusx Datetime,Dateplusz Datetime) AS Begin Insert into @SomeCalendar (Somedate )values (@Somedate)...

Dim mydb As Database Set mydb = CurrentDb mydb.Execute "CREATE TEMPORARY TABLE Students(StudentName text)" What is wrong with the above code? I get this error

is there an that i can check if extended selection (same as hitting the F8 key)mode is on or off and perhaps toggle it on or off Thanks in advance

Is there A way Resize/Move the Access Application Window thru Api/Code? Thanks Pwise

Dim Mydb As Database Set Mydb = CurrentDb With Mydb.OpenRecordset("Select * from Students", dbOpenDynaset, dbSeeChanges) Do Until .EOF With Mydb.OpenRecordset("Select * from Sessions Where Studentid = " & !Studentid, dbOpenDynaset, dbSeeChanges) Debug.Print...

Select FirstName into #TestRank From ( Select 'Tom' FirstName Union Select 'Dick' Union Select 'Harry' )Students order by FirstName Alter table #TestRank add Ctr int IDENTITY --Why does it Work if I use Select * Select * from #TestRank -- When I use...

If I have A Multi-statement table-valued function can I somehow join it to a regulear table Select * from Tablename inner join dbo.functionname(Pramname) on ????=???? or perhaps pass a fieldname as a prameter Select Tablename.*, dbo.functionname(Tablename.Fieldname) from Tablename

This is my data Date Place 1/1/8 Home 1/2/8 Home 1/5/8 Home .... Home 1/15/8 Home 1/20/8 School 1/21/8 School ... School 1/25/8 School 1/27/8 Home 1/31/8 Home I would like it displayed like this StartDate EndDate Place 1/1/8 1/15/8 Home 1/20/8 1/25/8...

I have A simple form to add records to a table. The table has A trigger for Insert. The Trigger inserts A record in a log table. After each record I add I get this error message The record source for the is either A tablename or A "Select Tablename.* from Tablename". If I requery the for the...

See my privious post http://www.tek-tips.com/viewthread.cfm?qid=1497960&page=1 I would like to create a function for the OnKeyPress Event for many controls and have the value of the of Keyascii passed to the function On Key Press =ReplaceSpace(KeyAscii) Function ReplaceSpace(KeyAscii) If...

I have A search as you type form that that works fine until I want to search form a name that has a space in it. What happens is that after I reset the forms recordset with the new critria Access trims the space off the end of the text box. So I have no way to type in a word with a space.

I am trying to write a SP Select Statement to select distinct rows that contains concatenated fields and to sort depending on a parameter value Select Distinct A +','+ B As Field1 ,C + ',' + B As Field2,..... From TableName inner join ...... Order by Case @OrderBy when 1 then A +','+ B end...

How can i change the Outlook Calendar Color Label Dim ol As Outlook.Application Dim olns As Outlook.Namespace Dim olappment As Outlook.AppointmentItem Set ol = CreateObject("Outlook.Application") Set olns = ol.GetNamespace("MAPI") Set olappment = ol.CreateItem(olAppointmentItem)...

I am trying to run this code from a Vba module ..... cmd.CommandText = "Insert into ProvidersSelect(Providerid,newguid) Values (655," & me.TxtGUID & ")" cmd.Execute .... where me.TxtGUID ={94FB6132-8812-48A3-8997-DDA311DE23AF} this is the error I get any help will be appreciated Pwise

This is the code that I am using Application.FollowHyperlink "mailto:SomeOne@SomeDomain.SomeExt?subject=Something or Other&body=John" & vbcrlf & "Some Text" & vbcrlf & "Some More text" this works but the line brakes dont work I tried Vbcrlf,Vbnewline,chr(13)+chr(10) and the whole body is one...

Can A recordset be returned from a Stored Procedure that starts with a Insert or Update Statement? Public Cnn As New ADODB.Connection Dim cmd As New ADODB.Command Function ExecuteAdoRS(AdoString As String, adoCommandType As Integer, ParamArray AdoPrams()) As ADODB.Recordset 'AdoPrams must have...

I am inserting date into a Sql table from a excell Spread sheet That I receive from The BOE with a OpenRowSet Query This Code Works insert INTO Tablename ( [Year], School, OSIS, .....,Voucher) SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0; Database=FolderName\FileName.XLS'...

Database MSAccess .mdb with linked Sql Server Backend. Problem Using this Syntax mydb.Execute "insert into TimeClock (Empid,ClockTime,Status) values (" & Me.Empid & ",#" & Now() & "#," & Me.TimeStatus & ")" inserts the to the ClockTime field in this format mm/dd/yyyy HH:MM:00. I need it in...