Search results for query: *

Hi elmorro, I found a little program to manipulate the MsgBox some time ago, but lost all my Favourites due to a hard drive crash. I searched again and found it here; http://www.vbexplorer.com/VBExplorer/viewcode.asp?SendText=files/messageboxdemo The original code was written by Bryan...

Hi Peter, I have set KeyPreview=True in the Form Properties. This code works: Private Sub Form_KeyPress(KeyAscii As Integer) Select Case KeyAscii Case vbKeyReturn SendKeys ("{tab}") KeyAscii = 0 End Select End Sub but if I use; Private Sub...

Hi Bob, Is this code in the Form_KeyPress sub? I tried the code and it won't move to the next field. Regards, Marcus

Thanks Swi, I too did a search. (After I posted...sorry. It's gettting late here). Found this; Private Sub Form_KeyPress(KeyAscii As Integer) Select Case KeyAscii Case vbKeyReturn SendKeys ("{tab}") KeyAscii = 0 End Select End Sub Thanks to waytech2003, I've...

I have a Visual Bsic project with several text fields on a form. When I type text in a text box I Tab to get the focus to the next text box. I am trying to do this using a barcode scanner for some of the fields, but need to have the scanner set for CrLf at the end of the text, because the...

Thanks Chipper. That clears it up. Regards, Marcus

I'm really confused now. My title is showing up as bold, but I don't know why. I see most posts show as bold when listed, and a few don't. So how is this done? any help would be appreciated. Cheers, Marcus

I'me not sure if this is the right place for this, but I can't find any references. I want to have my post display as bold when listed. Can anyone help me with this? Regards, Marcus

I have a DataGrid control which displays selected data from a datsbase. I would like to make the data eaiser to read by alternating the back color of the DataGrid. Can anyone help me with this? I have seen posts for Visual Basic 6, but that requires setting the DataGrid property to transparent...

Thank you to all those who have replied to this thread. I have been considering the options suggested by you all and am looking towards SQL Server 2005 Express, possibly with Visual Basic Express (if I can get it to download!), or MySQL, with a VB (again, possibly VB Express) front end. I know...

johnwm, One other thing. I am trying to develop a 'desktop' type program/application suitable for installation on a laptop computer, as well as a desktop computer. Would these applications be suitable?

Hi johnwm, Thank you for your reply. I've had a quick look at both Microsoft SQL Server Expres and MySQL. Both of these appear to be free. Would you consider one is preferable to the other? Also, can I use either or both of these with Visual Basic 5 as a front end? I know I will not be able...

I have developed an Access database and have a company interested in distributing it as an .exe program. I don't have the Developers Edition of Access, so creating an .exe from Access is not an option. The road I am loking to take is to start again with Visual Basic 5 (I don't have Visual Basic...

Hi Rob, Thanks for your reply. I believe that my plan is quite flexible. The Customer ID is determined by the person adding the customer to the database, and is four characters, all in uppercase. Even if an operator enter the CustomerID in lower case, it is stored as upper case. Organizatiios...

Hi Rob, I fully understand your database structure and my structure is essentially the same. This is my database structure' tblAssetRegister AssetNumber PrimaryKey CustomerID ForeignKey Location Manufacturer EquipmentType ModelNumber SerialNumber AssetNotes tblCustomers...

Hi Bob, It is never likely that I would reassign an asset to a diferent customer. The assets are owned by the customers, so that if as asset were to transfer from one customer to another through a sale or whatever, I would add the asset to the new customer as a new asset. The old asset for the...

Hi Remou, Yes, I think you are right. I've had a re-think and will go back to my original table. In the table I have the AssetNumber like; MBHS-0230, where the numerical part repesents the Customer ID and the numrical part the Asset number. I have written code to increment the numerical...

Hi Remou, Thanks for your reply. I was using only one table for Assets, and was using a combination of Customer Code and Asset Numbers, and incrementing the numerical part only each time an Asset was added. If I revert to numbers only, and keep a separate "Master" Assets table, I will have...

Hi, I have a database that records assests for a number of customers. Each time a new customer in created I want to create a new Asset Table for that customer. I have worked out how to create the tables, and think I can create the relationships, but am not sure how to set the field properties...

Thanks Sweep for your reply. I figured I would have to rework the forms and reports in VB. Can I also use queries in VB? Can I finish up with an executable programme suitable for distribution to users without Acces or VB? Regards, Marcus