Search results

That's a whole lot simpler than what I was trying. Thanks.

I'm trying to use a simple Select statement to get data into a variable to set a field and I have two questions. Is this possible? What am I doing wrong? 'Start Code Dim strCodeID as String strCode ID = Me.CodeID Dim SQLCmd as String SQLCmd = "SELECT Description FROM tblCodes WHERE CodeID = "...

I've googled around and haven't found much. But Google doesn't index people's brains, yet, so I thought I'd ask. I'm not looking for a CRM (though that is an aspect of the app), or really samples of databases. I'm looking for something specifically geared towards Economic Development. If it...

And I was in a stressful mood and overreacted. Thanks for the example, I haven't had a chance to look at it yet though I'm sure it'll do the trick.

I was approached by my city's Economic Development Department to build them a database to track the help they provide businesses. Has anyone heard of an already existing application that does that? It doesn't have to be Access.

Do you truly not understand what I need to know? Or you don't know the answer and like to be clever? How do I export a query to a tab delimited file with a dynamic file path?

I want to export a query as a tab delimited file to the desktop of whichever user is accessing the database. To get tab delimited, it seems I need a specification but then I have to specify a filepath. I'm capturing the users desktop path and want to push the file there. Thoughts?

What's the difference between opening a recordset as dbOpenDynaset and dbOpenDynamic? Thanks, DJ

Thanks dcb, that's an easy enough command. But I like your other idea too. I'm still new to using recordsets, but I think to do that I'd have to load the recordset using a SQL statement to find other records with the same MembershipID and then Loop through them updating each individually. Is...

I don't know. I have a table of Memberships and a form to show the Membership data. I have some unbound text boxes that I want to use to filter the records shown: by Company name, Contact Name, Renewal date. I've set an AfterChange event on those text boxes to Requery the form. To make...

I have a subform that shows Email addresses. Email addresses have the option of being marked "Newsletter". Users can enter as many e-mail addresses per contact as they want, but only one can be selected as "Newsletter". I'm trying to enforce this by using an event trigger on the field. I'm...

I have a query as the basis for a form. I'd like to include another query in that query in order to narrow down the found set of records. I don't need any data from the subquery on the form. The recordset is now not updateable which doesn't work for me. The recommendation I've seen is to...

I'm trying to create a routine that will export query results to a csv. This is the code I have so far, but the TransferText command isn't working. DesktopPath() is a function returning the, surprise, Desktop Path. Dim strQueryName As String Dim strFileName As String Dim strDir As String...

I've got a table of People and a table of PhoneNumbers. PhoneNumbers can have a Type (Office, Fax, Mobile, etc) and be marked specifically as "Publish". People can have as many phone numbers as they like on record, but only one of the Type Fax and that is marked "Publish" and one of a non-Fax...

I'm trying to parse an e-mail address in query (to filter out duplicate domain names for a one time debugging routine). My code is Mid(Email.Address, InStr(Email.Address, "@"), 100) I'm getting an "Invalid procedure call" error. Why is that? The InStr() part works on its own and the Mid()...

That's close. I really want the values as separate columns for export. Basically converting a relational to a flat file with a max of 3 rows. I suppose I can use that and use a special delimiter and load the values into separate columns. But if I just wanted to pull a single value, say the...

I tried passing it first, but couldn't get the query to parse, it would give up an error. How would you parse it?

This is a simplification of my problem, but if I can get an answer to this I think I'll be good to go. I have a table of Memberships and one-to-many relation to a child table, MembershipCodes. There's 0-3 children for each parent. I need to export and/or build a report that shows each...

Thanks for all the comments. You all touch on the issues I'm dealing with. I'm coming from a Filemaker Pro background where I'm comfortable with my "style" and trying to figure out my Access "style" which includes both my personal concepts of development, but also the Access "culture". I've...

I built a custom function that takes a date and determines if 5 months have passed since that date, returning a boolean result. The issue I'm having is that some records have a null value (which I want to return as a false). And those records are preventing the query from running. My...