Search results for query: *

Trying to figure out why DLOOKUP is not returning the GUID. The GUID displays properly in the txtbox field but DLOOKUP is not returning the GUID value. From the VBA Editor window ?DLookup("[ActiveDirID_FK]", "Activity", "Activity_PK = " & 76) ????U??? How can I get the GUID Value?? Thanks...

I need to combine 2 columns in the same DB and table. (MS SQL Server 2008 ent.) If columnA has a value AND ColumnB isNull Then use ColumnA value If columnB has a value AND ColumnA isNull Then use ColumnB value If both ColumnA AND ColumnB have values then use ColumnA value This query...

I need to create a MS Sql front end application and would like to use Access because it is what I am most familiar with. but, I need it to be able to work with data Offline. is this possible? How would I go about setting it up?? Thanks John Thanks John Fuhrman

I am trying to run a query from a form with 2 date picker fields for start and end dates and having some problems. I am getting a datatype conversion error. Am I missing something? The parameters in the query are defined as Date/Time. Here is the VBA code. Private Sub...

Does enyone have an example of an after delete trigger that copies the deleted row(s) into an archive table and adds who deleted it and when?? I have an activity table (schema.Activity) and the archive table (Archive.Activity). Thanks John Fuhrman

I am using a transform script (VB.Net) to migrate data from an old inherited DB. I need a way to get user properties from AD. In the Contacts table the ContactName field is the DisplayName from AD so I can use this to search for the user. Something like. If Not Row.ContactName_IsNull Then If...

I am pulling my hair out!!!! I have tried verything I know to try. I had a table called Contacts_Table that became ContactsTable . (NO Problems) started migrating multiple Access DB into one SQL DB on the backend so I created schema's for each front-end. dbo.ContactsTable became...

I cannot figure out how to set the name of a label control to the name of it's parent ControlSource. here is then code I have for setting everything. For Each ctl In frm.Section("Detail").Controls ' Debug.Print ctl.Name, ctl.ControlSource...

I need a query that will give me avg call durations on a per/day. I have a query that will give the call times but not sure how to get it to get the rest of the way. select --s.seconds / 3600 hrs, --s.seconds / 60 - (seconds / 3600 ) * 60 mins, --s.seconds - (s.seconds / 60) * 60...

I found a SQL script the get me 99% of the way to what i need, but I am having problems converting it into either an Update or a Merge Into. Here is the Code. /*create table #temp ( FULLNAME VARCHAR(100), ID INT ) INSERT INTO #TEMP VALUES ('TUCKER, KEVIN G'...

I am trying to split apart names in an OLD contacts list in a DB I inherited. I can get close but not what I want. Names are like this in the DB Fuhrman, John F Fuhrman III, John F Fuhrman, Bradley Fuhrman, Laura F (G555) what I have been able to get so far is like FirstName...

I have a form that I need to have check three controls for data when the form is closed and if any of them are not filled in prompt the user for what they want to do. This is because Access is adding rows to the DB that are incomplete on the main input form. Here is what i have so far. It...

OK I'm stumped. The variables are gettng the correct values. (I think) But is still erroring out on the Aplication.Printers(strValue) in the Select Case. Can someone look at this and let me know what I am missing. Private Sub Printbtn_Click() On Error GoTo Err_Handler Dim strCurrentForm As...

I have tried several ways to do this but here is a copy of the T-SQL script. EXEC sp_addlinkedserver @server = N'ACCESSDB', @provider = N'Microsoft.ACE.OLEDB.12.0', @srvproduct = N'Access 2010', @datasrc = N'D:\Access_BE.MDB' GO -- Set up login mapping using current user's...

I have three forms for entering data that all need to be able to print a particular form. Only problem is that the printer needs to change depending on which form called the report. Can sonmeone point me to an example?? Thanks John Fuhrman

I am having a problem getting a script running. declare @dbName as VarChar(max) if exists(SELECT * FROM sys.databases WHERE name LIKE 'ErrorLog_%') IF Not Exists(SELECT * FROM sys.databases WHERE name Like 'ErrorLog_%') BEGIN Set @dbName = 'ErrorLog_' + CONVERT(VARCHAR(max)...

I am having a problem with VBA on a Print Button on a form. I originally posted this in the VBA forum but have not gotten any responses. Here is the posting thread705-1664242 Thanks John Fuhrman

Everything seems to work except the form does not print. I have paused all the printer defigned on my workstation and no print jobs go to any of the queus. Am I missing something?? Private Sub Print_Click() On Error GoTo Err_Print_Click Dim strDefaultPrinter As String Dim...

OK What have I done wronge? Set objSQLDataBaseCat = New ADOX.Catalog cnn.Open "Provider = SQLNCLI10;" & _ "Data Source = strServer;" & _ "Initial Catalog = strDatabase;" & _ "Integrated Security = SSPI;" Set objSQLDataBaseCat.ActiveConnection =...

If @ID_Number = N'' Begin CASE When @ID <> N'' Then (SELECT * FROM [NSC_SQL].[dbo].[fn_IDLookup] (@ID) Order By [ID],[CREATED_ON]) When @A_Number <> N'' Then (SELECT * FROM [NSC_SQL].[dbo].[fn_IDLookup] (@A_Number) Order By [ID],[CREATED_ON]) When @Reciept_Number <> N'' Then...