pietlinden's articles:

Items(20) /2 Next >> Last >|

How to handle a VERY flexible price structure 2 39 (2/8/2007 7:35:47 PM) comp.databases.ms-access I've been given the task of building a database for a manufacturer's representative. He basically imports product and resells it. He currently has this spreadsheet that's fairly complex. (Either that or I'm j... pietlinden

Plan for mass import of Excel files 6 41 (1/23/2007 6:20:06 AM) comp.databases.ms-access I have a large number of Excel files that contain Survey questions and responses (I know the design is awful... I inherited this mess). Basic structure is like this: Demographic Questions | Survey Questions ... pietlinden

Survey databases and distribution to interviewers 12 43 (1/13/2007 10:12:30 PM) comp.databases.ms-access Hi, sorry for the vague subject. I am working for a company that finds respondents for surveys and then sends the respondent list and the survey to another company to perform the actual surveys. In the past, ... pietlinden

Single item inventory? 14 45 (11/30/2005 1:01:37 AM) comp.databases.ms-access Hi, Stupid question, but here goes. Someone wants me to design a database to keep track of fuel deliveries and orders/shipments. Essentially, he'll purchase fuel from some supplier and then resell it. I'm ass... pietlinden

Problems Subclassing in Donors/Donations DB 4 41 (9/4/2005 3:54:14 AM) comp.databases.ms-access Hi, I have the sort of standard Donors/Donations DB. The twist I have is that donations can be time, money (which are easy, because they're additive), but then a donor can make an in-kind pledge, of say 3 chai... pietlinden

Referring to SubForm/SubSubform controls 2 40 (8/14/2005 6:47:32 AM) comp.databases.ms-access I have a hopefully stupid question. First off, I'm trying to follow Keri Hardwick's instructions from here: http://www.mvps.org/access/forms/frm0031.htm I have a main/sub1/sub-subform: Contact/Donation/Donat... pietlinden

Losing Import Specifications - Access 2002 4 56 (8/8/2005 4:29:33 PM) comp.databases.ms-access I almost feel stupid posting this, but maybe someone else understands what's going on here. I am importing a delimited text file, and have saved an import specification so that for the user the whole thing is ... pietlinden

Recursive File Search VBA vs VB 4 191 (8/4/2005 4:18:00 AM) comp.databases.ms-access Hopefully a stupid question, but it doesn't appear that way. Found an example of a recursive file search, which is exactly what I want, at Randy Birch's site (mvps.vbnet), but VBA is just different enough not ... pietlinden

subform name on control tab weirdness 2 54 (7/25/2005 6:29:53 PM) comp.databases.ms-access I have a stupid question (so finish swallowing now... I don't want to be accused of any beverage-related mishaps). I have a form with several subforms, with each subform on a separate tab. I'm trying to loop ... pietlinden

open separate recordsets or just filter? 2 39 (9/20/2004 2:30:17 AM) comp.databases.ms-access The answer to this one is probably "test it yourself and find out!", but I'll ask anyway. Pursuant to my previous question - sending separate recordsets to Word using the CreateTableFromRecordset code from ADH... pietlinden

pietlinden's replies:

Items(2359) /236 Next >> Last >|

Getting only the latest ... how? 1 57 (2/13/2007 1:40:18 AM) comp.databases.ms-access Hello World: I have a new task at work. I have to process a mainframe report (a text file), and put it into an Access 2003 database. When I get the report, it looks like this: Account Sub_Name Sub_Date ... awelane1 (25)

querying all entries in one table that aren't in the other one 3 84 (2/14/2007 8:46:09 PM) comp.databases.ms-access Hi, I have 2 tables linked to each other by a field. I'd like to query all the enteries in one table that aren't in the other one, based on that field. Any suggestions? ... n.berfeld (2)

MS Access Query monitor 2 56 (2/19/2007 4:52:31 AM) comp.databases.ms-access Hi, Is it possible in MS Access to view at a given time how many users are accessing the Access database and gain visibility into which query (s) they are using...? ... DMogadati (1)

Form command 1 65 (9/4/2007 4:15:15 PM) comp.databases.ms-access I have a main form that contains two subforms. The main form has no fields other than the subforms. The purpose of this form is to perform inventory transfers from one program to another of the same program p... ladybug

Insert into question? 1 41 (9/4/2007 10:51:47 PM) comp.databases.ms-access Hi All, I've got a table called tblTransactions. With a couple different forms, I allow users to add/update records in that table. Within the table there's a PK called transactionID. Following suggestions... ronSPAMBLOCKINGwest777 (52)

Question regarding User Login using a table 1 69 (9/5/2007 1:30:00 PM) comp.databases.ms-access I've made a table withing my Access file, that lists all the people that would be allowed to login using the database. The logins and passwords are logged within the table, and are referred to when an automati... rthompson414 (4)

EMail a mail merge letter 2 69 (9/19/2007 11:33:30 PM) comp.databases.ms-access I am using Access 2000 to email invoices to clients as attachments (in PDF format). In addition I want to attach a personalised letter (Word 2000 mailmerge). The email SendTo, invoice details and mailmerge fi... phil (911)

Copy field from 1 subform to another 3 53 (9/26/2007 9:59:27 PM) comp.databases.ms-access Hi all, I have tabbed subforms where I need to copy one field value from one subform over to another subform. Although I can run an update query to accomplish this I would like to do it through VBA. sub table... Richnep (3)

Execute a macro at exit program 2 69 (10/1/2007 3:49:24 PM) comp.databases.ms-access Hi to all! Do you know if i can execute a macro at exit of a program? If yes, how can i do it? Thank to all Femtox ... femtox77 (8)

Requerying Subform Recordsource 12 42 (10/27/2009 11:40:43 PM) comp.databases.ms-access Usually a subform's recordsource grabs ALL records it needs and then the filter established by the Link Master/Child fields is applied. However, the query I use in the recordsource in my subform needs to inco... yates (3885)