Recent content by Corticus

Okay, This API provided by NateO about wraps up what I need: Public Declare Function CreateFile Lib "kernel32" Alias "CreateFileA" _ (ByVal lpFileName As String, _ ByVal dwDesiredAccess As Long, _ ByVal dwShareMode As Long, _ ByVal lpSecurityAttributes As Long...

a little progress Hmph... Well I guess I'm on my own on this one. ;) What I'm doing is having Access append a table with a list of filenames from a directory that is currently explicitly defined in the code, but I'll have to work on that. This is what I've got so far: Option Compare...

Hi all, I'm trying to import my media playlist from Windows Media Player into tables. I tried 'get external data'|Import|ODBC|Machine Data Source|ECDCMusic, but I get this error: You cannot use ODBC to import from, export to, or link an external Microsoft Jet or ISAM database table to your...

Okay, I figured it out, 8 hours later :( This works: SFTab2 is the subform on tab 2 Chk1_Click() Me.Parent.[SFTab2]![List2].Requery End sub peace, Corticus

Hi, How do I refer to a listbox on one tab of a tab control from an event on another tab. I'll use these names: FrmMain TabMain (on first tab) Chk1 List1 (on second tab) Chk2 List2 I want Chk1_Click() List2.requery and Chk2_Click() List1.requery Please help, my head hurts... Thanks...

one solution, more to come Okay, Here's one considerably faster solution all in one SQL expression: SELECT A.Component FROM TblItem AS A WHERE A.Part=[ENTER PART] OR A.Component In (select B.Component from TblItem as B where B.Part in (SELECT C.Component FROM TblItem as C WHERE C.Part=[ENTER...

Thanks for your reply, I'm getting disheartened that there isn't a better way to do this. Unfortunately, there isn't one field that is a primary key, it would be a combination of both the part and component field. There is only one table of interest. I agree that indexing would offer an...

Hi all, I've got a twisted question for you. I made a query that does what I need, but its really slow, so there must be a better way. I'm interested in 2 columns of data. One is a part number, and one is a component number. You might see data like this: Part 10A 10A 10A 10B 10B 1034...

Hi all, I am helping design a chat room database such that users can have nicknames, search for chattext by nickname etc. While I don't have a specific question, I was hoping someone could point me in the right direction to as where I could find some good information on creating web-based DBs...