Search results

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.

I am using code39 and I did try that. When the barcode prints, there is a small box in the barcode where the _ is, and the barcode wont scan. Thanks for the suggestion though.

I have created a report that shows the barcode for a given text value. I can make it work only if the text has no spaces (Ex: YesSir). However, when the barcode is scanned, I need it to display the text with the spaces (Ex: Yes Sir). Can this be done? Thanks in advance!

Not a problem

Look under the properties of the button. Click on the "Event" tab. Click the drop down box next tho the "On Click" event and choose "Event Procedure". This will fix your problem.

In order to be able to do that, you will need to change the Forms record source to allow the use of that new field. Then you will be able to set the text box controll source to that field.