Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by sparkbyte

  1. sparkbyte

    Looking up a GUID with DLOOKUP returns ?????????

    Finally got it after fighting with it for 3 days!!!!! Private Sub Form_Current() 'On Error Resume Next Dim strCaseLoginID As String Dim varActiveDirID_FK As Variant varActiveDirID_FK = StringFromGUID(Me.txtbx_ActiveDirID_FK) varActiveDirID_FK = Right(varActiveDirID_FK...
  2. sparkbyte

    Looking up a GUID with DLOOKUP returns ?????????

    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...
  3. sparkbyte

    Combining 2 columns

    I guess I was being silly. I will have to use the COALESCE in an update statement and create a new column to put the combined result set into. Thanks Thanks John Fuhrman
  4. sparkbyte

    Combining 2 columns

    That is perfect. Now how do I insert the result set into a new column? THANKS!!!! Thanks John Fuhrman
  5. sparkbyte

    Combining 2 columns

    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...
  6. sparkbyte

    Access Front end that can work offline??

    This is a general response to the running conversation. I am familiar with the old 'Replication' feature, but to my knowledge this was supported only by using local Access DBs. This is not what I am looking for because I have an Enterprise Microsoft SQL Server that the databases will be on and...
  7. sparkbyte

    Access Front end that can work offline??

    Regretfully, All the above. But for the most part it will be used to store new data and when the primary back-end becomes available use the new rows to perform several select statements to run a QC process. There is also another pre-existing application that I would like to add this...
  8. sparkbyte

    Access Front end that can work offline??

    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
  9. sparkbyte

    Parameter query with date picker and SQL Server backend.

    OK, this runs without any errors, but I need it to open the result set in a datasheet view. What am I missing? Private Sub btnOpneNatSecQuery_Click() Dim strSQL As String Dim dbs As DAO.Database Dim qdf As DAO.QueryDef Dim rst As DAO.Recordset Set dbs = CurrentDb strSQL = "SELECT [ID], [Login...
  10. sparkbyte

    Parameter query with date picker and SQL Server backend.

    Well I might agree with that but, I commented out the entire WHERE clause and ORDER BY, and get the same invalid argument. Thanks John Fuhrman
  11. sparkbyte

    Parameter query with date picker and SQL Server backend.

    Took the where clause and order by out as well and still get the invalid argument. I am at a loss. Thanks John Fuhrman
  12. sparkbyte

    Parameter query with date picker and SQL Server backend.

    Nope, took memo out and still have the same issue. Thanks John Fuhrman
  13. sparkbyte

    Parameter query with date picker and SQL Server backend.

    SQL code SELECT Activity.ID, Activity.[Login ID], Activity.SEIPrint, Activity.[Start Time & Date], Activity.[Closed Time & Date], Activity.[Program Name], Activity.[Contact Name], Activity.[RPC Code], Activity.NatSecButton, Activity.FRCFileButton, Activity.[Digitized File], Activity.[Afile...
  14. sparkbyte

    Parameter query with date picker and SQL Server backend.

    A straight copy and paste from the debug.print runs the query just fine. SELECT ID, [Login ID], SEIPrint, [Start Time & Date], [Program Name], [Contact Name], [RPC Code], NatSecButton, FRCFileButton, [Digitized File], [Afile Number], Memo, Login1, [Reason for call], [Status of Activity] FROM...
  15. sparkbyte

    Parameter query with date picker and SQL Server backend.

    Just a regular datetime field. (not datetime2) Thanks John Fuhrman
See more

Part and Inventory Search

Back
Top