Recent content by coryt

I got it by using the ySplit option you gave me. I forgot I had to create a module that contained the ySplit function.

I am using Access 2002. the code you provided did not work ("sub or function not defined") so I took the y off split. I am now getting a Type Mismatch error on this line: strDefault = Split(Me.FilePath, ".", True) This is my code: Dim strTableName As String Dim strDefault As String...

Thought it might be good to post my code. Private Sub cmdDialog_Click() Dim strPath As String CDSearchString = MakeFilterString("Excel Files (*.xls)", "*.xls") CDCaption = "Select Excel File" If IsNull([FilePath]) Or Me.FilePath = "" Then CDInitDir = "C:\" Else...

Here goes nothing... I have a form which the user can specify (or choose) the path to an excel spreadsheet they wish to import. They then click a button and an inputbox appears asking them what they want to call the table. Since the excel spreadsheet is already named I thought it might be a...

That worked flawlessly. Thank you so very much!

Can someone help me please. I am trying to figure out a way to import file names into an access table without having to copy and paste. I have many files (100 +\-). Any help would be appreciated. Thanks.

Well. I will be using this table to produce labels. So if say Cory needs 5 labels. I need a table that has 5 records containing Corys information. If Betty needs 7 labels, there needs to be 7 records containing Bettys information. Right now I have a table with one record saying Cory gets 5...

Hey folks. Can someone help me with this scenario? I have a table that has 1 record per person. There is a field called "Quantity" for each record. Is there a Query or something I can create that will take the value for "Quantity" and list 1 record for each. ex. If the quantity is 5. I...

I got it!!! You need to replace any spaces with ~. It worked great!

Will do. Thanks so much for your help today.

Ok, I may have been wrong about the fact that I am using code39. The barcode font that I am using came from Bartender. The font name is exactly this. "Bar Code 39 f HR". Which is why I thought it was "Code39" (Im such a freeking novice). I know it is not the standard windows barcode font because...

I got it to work with the * but when the barcode is scanned, the * is included in place of the space (ex: Yes*Sir).

Did I mention this is a text field and not a numeric field?

No go with the = sign. Same problem as before.

I am using a text box with the control source set to the table field I wish to be displayed as a barcode. I set the font of that text box to code39. I will try the = sogn though and see if that works. Thanks again.