Search results

This is from the Access Help file with the added line to check for TOTAL. Dim InputData Open "MYFILE" For Input As #1 ' Open file for input. Do While Not EOF(1) ' Check for end of file. Line Input #1, InputData ' Read line of data. If Instr(InputData,"TOTAL") <> 0 Then Exit Do...

1. Yes 2. No. You just have to understand the Excel Object Model. It is not very complicated. Rather intuitive, actually, if you have ever worked in Excel past the basics. Here is a snippet of code that I have used: 'Count the number of fields or column MyFieldCount = rs.Fields.Count...

Interesting problem. You will need to re-install SQL Server as the registry would have been wiped out with the C: format. Copy the data & log (*.mdf & &.ldf) files to another location. Delete the SQL Server folder on the D: drive. Install SQL Server. Copy *.mdf & *.ldf files back to the...

Just put this in a new query. When you create a new query, don't add any tables (hit close on the table listing), then select View ... SQL View and paste this: SELECT * FROM dbo_Committment WHERE seq_no NOT IN (SELECT seq_no FROM dbo_Committment WHERE commitment_user_group_cd = "SRG")

Even better. Update the link to the location of the new file. That way, you can have a static name within your Access DB and have queries written to reference it. There are many posts on this forum to get a filename, so search for that function. Public Sub UpdateLinkLoc(FileLoc As String)...

Link the Excel workbook as a linked table and then create an Append Query where you get the unique values. File ... Get External Data ... Link Tables ... File type = Excel

Access is only going to import the data stored in cells in Excel. If you have check boxes, then you need to see if they are linked to a cell in your workbook. Check boxes are not data, just a way of displaying the data. You may have to move the source for the check boxes to an adjacent cell...

get rid of the parenthesis and add another 9 to the beginning.

Since this is a calculated field, Date() > Expiration, this should be done in a query. SELECT FirstField, SecondField, Expiration, Status: GetExpStat([Expiration]) FROM YourTable Public Function GetExpStat(ExpDate As Date) As String Select Case DateDiff("d", Date, ExpDate) Case...

There is a Wizard that starts when you add a combo box which allows you to select an option to have the result look up a record on a form. Use this. You can then change the recordsource to only return DISTINCT results, so you wont get the duplicates. PBaldy, you beat me to it. :D

What was the problem and the fix. Please post so the next person searching for connection string issues can perhaps use your research. That is what we are all about here. :D

Well, here are my thoughts. Change this function to a SUB and call it from your form. Don't add the records in another routine, do it in your SQL Statement and add a BatchAddNum field to your AssignedBatches table: Dim LastAdd Long LastAdd = DMAX("BatchAddNum", "AssignedBatches") strSQL =...

Shouldn't that be [Name]?

Wow, I've been looking at your code and it is confusing. Is the end-goal here to return the BatchNums that have been newly entered into the AssignedBatches table? It appears you first are getting #n of the batches in the MasterBatch table that are not in the AssignedBatches table. Then, you...

MDAC = Microsoft Data Access Components Go here: http://www.microsoft.com/downloads/details.aspx?FamilyID=8f0a8df6-4a21-4b43-bf53-14332ef092c9&DisplayLang=en This will allow you to check the version that you are currently using as well as check the version of some other components. It also...

Spanish title. No difference. I'm guessing your user had an MDAC change ...? Reload the version of MDAC you company currently uses.

I've always found setting the Tag property useful.

Try changing: s.OrderID FROM Orders p To p.OrderID FROM Orders p in both places Just to let you know, this will give you customers who have placed orders in 1996 AND 1997 ... not OR ...

Hmmm ... why are you using DLookUp? UPDATE Table_A SET Address = Table_B.Address FROM Table_A INNER JOIN Table_B ON TableA.ID_Number = TableB.ID_Number

You can leave the BE in 2002, but it may be easier to maintain going forward if both are in the same version. Setting a password for the MDE is optional and can be done in the MDB or the MDE.