Search results

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 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.

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

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()...

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...

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...

I'm building my third Access database and I'm still learning. One thing I wonder about from "real" developers is how much effort do you put into naming conventions and other standards. Do you name every tab, label, and combo box? Do you comment every line of VB code? Do you add only the...

I have a subform showing a single record from a related table. I want to prevent the user from tabbing through the last control to create a new record. Thanks, DJ

OK, so I've come across the "combo box background color" bug in Access 2007 and I'm wondering if there's a quick and easy way to disassociate a label with a control. It seems that solves it. Thanks, DJ

I have a main form, frmMemberships referencing a subform fsubSearch. The container for the subform is named subSearch. On fsubSearch is a control, txtOrgIDSearch. txtOrgIDSearch is an unbound combo box that users can select a Organization from. I am trying to reference the control in the...