Recent content by Pcfred

that's sneaky and it just might work! Thanks.

VBA will not allow tabbing to a from a textbox to a label which the scanner automatically does after inputing data. Thanks anyway guys.

how do i set focus to a label so the scanner inputs the data?

I need to disable the ability to paste(Ctrl+V) into a textbox on a form in Excel(VBA). Basically I have operators scanning barcodes into a textbox and I want to force them to scan the barcode and not copy/paste the data into the textbox. any ideas? Thanks in advance, PcFred

I think it needs a defining Dim strTemp strTemp = DoCmd.OutputTo(acOutputForm, New Contract, ("*.xls"))

Thanks guys. Worked like a champ!

Basically it runs throught the whole database and populates the Excel combobox with any row that the contains the TextBoxCust value in the 'BU' column of the database. The database is not mine to manipulate or add queries to. Thanks for the help guys. Here's the portion that fills the...

Currently I'm populating a combobox in excel from a access database. I need to sort the data in the combobox to display in alpha order and the access database is in order of automatic record ID. Can this be done w/o putting the data on a worksheet and then sorting?

I had similar issues and it ended up being the worksheet/workbook protection. If you have protected you sheet, try removing all protection to see if it has anything to do with your issue.

Is there an easy way to display a continuous form horizontally vs. vertically?

When in the "open file" dialog box in any office app, clicking on the browse button results in an indefinite hanging of the app. Any ideas? thanks

I have a multi column combobox with 3 columns on a form. When I select the dropdown box I can see all 3 columns but when I select an entry the result in the combobox only shows the first column. How can I get it to display all 3 columns? thx pcfred

I found the code for it. Thanks anyway. Sub Send_Msg() Dim objOL As New Outlook.Application Dim objMail As MailItem Set objOL = New Outlook.Application Set objMail = objOL.CreateItem(olMailItem) With objMail .To = "name.domain.com" .Subject = "" .Body = "" .Display End With Set...

Just a label with my name on it that when clicked on it launches the mail service an puts my name in the 'To:' box but doesn't automatically send. just like clicking on a mailto: hyperlink on a web page.

I'm trying to create a label on a Excel Userform that is an email hyperlink but I can't seem to figure it out. Any Ideas? thanks PcFred