Recent content by bcooler

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

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

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

2010

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

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.

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

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

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)...

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

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

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")...

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]...

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

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