Recent content by patrickcre8

Date: Date...............Item...................Status 200601............A........................OK 200602............A........................Not OK 200601............B.......................OK 200602............B........................OK 200602............C........................OK I...

if CustomerID = "" Then MsgBox "Please Select a Company Name", vbInformation, "Warning" Else DoCmd.OpenForm stDocName, , , stLinkCriteria End If

Use after update event and use Len() to check the no. of character entered. and regarding your second question, there are so many way to do that. you can use SQL command, openrecordset addnew....etc but the easiest way for u is to insert the table and create an after update event to update...

Use the PDF Active X Control or simply use "print to pdf" is easier

DCount Dcount could help?

Parse Dir: This is what you need. Option Compare Database Private Const MAX_PATH& = 260 Private Const INVALID_HANDLE_VALUE = -1 Type FILETIME dwLowDateTime As Long dwHighDateTime As Long End Type Type WIN32_FIND_DATA ' 318 Bytes dwFileAttributes As Long ftCreationTime As...

well...that's why I am writing. And you are correct, this is the report from my customer which I want to import into my database.

Hope this could help.

Your table structure is wrong. Name should not be a key

You can link all the tables in the form or report by ID as well.

maybe you can use the onload event and hardcode the control to goto record 1 by default

Dlookup You can use Dlookup and DSum to do the job. The price should be another field on the table.

Excel sheets: Item Item Desc Price Price Out Date 11040 MIRR SHUTTERED 38.5 69.99 P.O. # Status 52334 280 53074 280 53075 280 11041 MIRR SHUTTERED 38.5 69.99 P.O. # Status 52334 280 53074 280 53075 280 And I want to make it like: 11040 MIRR SHUTTERED 38.5 69.99 52334 280 11040 MIRR...

But the field is blank one.....any idea? Excel sheets: Item Item Desc Price Price Out Date 11040 MIRR SHUTTERED 38.5 69.99 P.O. # Status 52334 280 53074 280 53075 280 11041 MIRR SHUTTERED 38.5 69.99 P.O. # Status 52334 280 53074 280 53075 280 And I want...

I have an Excel: Item 1 .....detaila .....detailb Item 2 .....detailc .....detaild And I would like to import into Access. Question: can I transpose the record so that it will be in a better format, like: Item 1 detail a Item 1 detail b....etc