Search results for query: *

Hello, I've been playing around with a soundex function that I found in this forum that compares the last name in a textbox with those in a table. So, in the BeforeUpdate event I put the following, but I get "Error 3464 - Data mismatch in criteria expression". Any help is appreciated, as...

I'm using the TransferText method to create a .csv file from the results of a query. If there are any empty fields in the table there has to be double-quotes between the commas in that .csv file. Anybody know how I can add the quotes in the query? The file has to look like this...

Hello, I have eight comboboxes on an unbound form. You can select person's names to assign them spots in an indoor cycling training facility. These names come from "tblRiders". You might not assign all the spots, but you shouldn't be able to assign more than one spot to the same person. Is...

Hi, I'm working on a database that uses linked tables. For starters, I'm only linking to one table called "Material" that is in our enterprise database (JobBoss). It's a list of all the part numbers we manufacture. I noticed that some of the parts are missing from the table. But if I use...

Hello, I don't know if I'm going about this the right way, but I'm working with a form based a recordset that comes from a different database. When the form loads I'm getting the list of materials in a combobox. Now, what I'd like to do is populate a textbox on the form with a field from the...

I'm trying to learn how to use a recordset on an unbound form. Here's what I have and the the first record shows up in the two text boxes. Now all I want to do is to add command buttons to navigate through the records as if this were a bound form. I've added one button with "rs.movenext" in the...

Hello, Is there a way to format the week so that on weeks 1-9 there will be a zero preceding the week number? Like "01,02,03..." I'm using "Format(week,"ww")" currently. Thanks, Mike

Hi, I'm trying to count all the yellow cells from all the sheets in a workbook. The code I have so far adds the three test cells on the first sheet three times, but not any from the next two sheets. The msgbox returns "9". Hmmmm, I know I'm close. Any hints? Public Sub CountYellow() Dim...

Hello, I'm using an inputbox to move a form to the desired record. If you "cancel" out of the inputbox, the form moves to the first record. How can I stop that? Private Sub cmdGoTo_Click() Dim rst As DAO.Recordset Dim strDev As String Set rst = Me.RecordsetClone On Error GoTo...

Hello, I'm trying to use the FileDialog property to allow a user to select one or more files to "attach" to a record in a database. The paths to the files would be stored in a table. So far, I can select files and concatenate them in a string. How would you go about storing these file paths in...

Hi, I'd like to use the example in thread702-827975, kindly given by Bob Scriver, in my project. The only difference I need to work out is the format of the year part of the string. I'd like it to be YY-000, instead of YYYY-000. I should be in a VB class right now, but instead I'm beating my...

Hi, I have a form where the user will enter a description of a dimension on a blueprint. I would like to add command buttons that will insert characters such as a "±" or a "°" at the end of the text that the user inputs. So, they would type in something like this, "145.02mm" hit the spacebar...

Hello, I'm trying to make a command button on a form disappear if the user selects "CONT.TEV" from the list. The combo box list values are from this query in the combobox properties / row source: SELECT [CUSTOMER NAME].[ID], [CUSTOMER NAME].[CUSTOMER CODE] FROM [CUSTOMER NAME]; The code I've...