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 Rhinorhino 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 bcooler

  1. bcooler

    Combo Box Errors

    Actually, I just talked to an admin for the data coming out of the external source. We found the primary key from that source and included it into the Excel export. That seemed to fix things. Thanks for your help! Brian
  2. bcooler

    Combo Box Errors

    Duane- Thanks for the response. Can you tell me how I would do that on a linked spreadsheet? This spreadsheet is exported from an external software on a daily basis. Brian
  3. bcooler

    Combo Box Errors

    Hello all- I have created a combobox which shows 7 columns when the user clicks it (bound column=1). The Rowsource is based on an automated Excel Export that I have some control over. There is NO primary key on this Excel spreadsheet (if that's even possible) and the bound column I've chosen...
  4. bcooler

    Picture Storage Strategy

    2010
  5. bcooler

    Picture Storage Strategy

    Hello all- I have a form where I am asking the user to add serial number information located in 4 places on the product. For user clarification, I thought I would try to show a serial number locating picture when the GotFocus event fires in each serial number textbox. Now, in the past, I...
  6. bcooler

    Convert table information to binary

    ok, I found this, but not sure if it will be useful... http://support.microsoft.com/kb/151335 The first thing I notice is I must have fixed byte lengths for each component, not variable as shown in the example.
  7. bcooler

    Convert table information to binary

    Hello and thanks for reading! I was asked to create a database to contain a library of information coming out of a piece of equipment we use. I worked on that a while and have it importing the .CSV file that is produced by the equipment. No problem.... Now I am asked to push some portion of...
  8. bcooler

    Date Criteria in Query

    Ok, not sure why, but I've got it working.... Other posts say that if CDATE finds something that doesn't look like a date, it will give this type of error. I verified that all my queried results do not have this issue, but...... if I add the "((IsDate([Comments]))=-1))" criteria, the problem...
  9. bcooler

    Date Criteria in Query

    Here's the code: SELECT qryNameCreation.CombinedName, tblFileProp.FileName, DateAdd("yyyy",2,CDate([Comments])) AS ReviewDueDate, tblFileProp.Title, tblFileProp.Author, tblEmployee.Email FROM (tblEmployee INNER JOIN qryNameCreation ON tblEmployee.Employee_ID = qryNameCreation.Employee_ID)...
  10. bcooler

    Date Criteria in Query

    Thanks for reading! I have a field called "Comments" where, oddly enough, I am keeping text that looks like a date (long story, just laugh and keep going...). Now, I want to create a query that looks for records whose [date + 2 years] is older than today. In other words, if this field is the...
  11. bcooler

    Convert imported column into row

    Ok, got it. http://www.pcreview.co.uk/forums/error-3061-a-t3665097.html This site suggests that the parameters in a crosstab query must be explicitly assigned in DAO. The important part here is: Dim prm As DAO.Parameter For Each prm In qdf.Parameters prm.Value = Eval(prm.Name) Next prm...
  12. bcooler

    Convert imported column into row

    ok, I found this article which says I must explicitly declare the form reference in a crosstab query: http://support.microsoft.com/kb/209778 Now the queries work outside the VBA code (manually). However, when I run them using: Set qdf = CurrentDb.QueryDefs("qryHeaderDataMove")...
  13. bcooler

    Convert imported column into row

    Ok, as best I understand, I tried the following by replacing "HeaderID: 1" with what you suggested: TRANSFORM Min(tblImport1.Field2) AS MinOfField2 SELECT [Forms]![frmLibrary]![txtID] AS MyID FROM tblImport1 WHERE (((tblImport1.Field1) Between "A" And "V")) GROUP BY [Forms]![frmLibrary]![txtID]...
  14. bcooler

    Convert imported column into row

    Ok, I did try that when you suggested it. However, since I am only using tblImport1 as a temporary table, its primary key is not important to me (right?). I want to connect tables tblHeader (foreign) and tblLibrary (primary). As the above append query executes, it copies data from the...
  15. bcooler

    Convert imported column into row

    Ok, having difficulty with the foreign key.... Let me explain what I am doing (in greater detail). I have a table (tblLibrary) where I am keeping manually entered user information. I am trying to link the above .CSV text file information to the tblLibrary table. The thought is that the user...
See more

Part and Inventory Search

Back
Top