Search results

Here is another. Still in beta but should be up soon. Krugle

With VB.NET you can use any type of database you want. As long as you point to it in your code. Then you can compile your project and copy the executable to the users machine and they can run it. you don't need to run an installer with vb.net apps unless you have some custom stuff.

To create a Database Diagram here's what you do: Open the Enterprise Manager Open your SQL Server Instance Right-click the database y ou want to diagram. Select New->Database Diagram. Select what tables you want to show in the diagram Voila your done. This diagram will show all relationship...

I use .NET so all you have to do is create a new WindowsApplication and under the project properties put the Output setting to a ClassLibrary. This will compile your project as a DLL file. Which you then can import into another project for use.

Unless you wish to use Query Analyzer and do it for each record your gonna have to do it using a query. Here is an example you could use: UPDATE table_name SET table_field = 'A' I prefer to use nvarchar instead of varchar. This will update every record in the table and set the field to the...

What programming language do you plan on using?

Wouldn't you think it migh be better to do the program over in C++ ov VB. Just my opinion but that seems to be an awful lot of forms and such to be trusting to one Access Database.

If you have a button that the user presses you can add the code the the OnClick event Datefield = FormatDateTime(Now(), vbShortDate) or if you don't have a button you can add it to one your text boxes OnChange event.

If this is a multiuser db I strongly recommmend using a mdb backend. If not then no one will have to same data. And remember that if you don't use a backend for data and the database gets corrupt you lose all the data.

It's not like he using your code. So your telling me you don't use anyone elses buttons, styles, themes, icons or anything else in your programs or databases. I highly doubt it.

This may sound really stupid but have you tried scolling down. I have been fooled by this before. What happens is sometimes the DB window Will go way off screen and you will have to scroll to see it.

First of all ifyou want it to be between 1 and 10 it must be >=1 AND <=10. The way you had your rule before wouldn't allow numbers between 1 and 10

Firstly when the user clicks the Time Called button you get a Type Mismatch. This is because you are trying to format a variable that contains no value. So in the code for frmReturnTime I added pstrTime = Format(Now(), "h:nn AM/PM") Now frmReturnTime Opens no problem. I take it that you...

Why would you use Cancel in your if statement. If the if statement returns false the record won'd be added anyway. Take out your Cancel

Glad I could help :cool:

Try this article out. It may work for starting it at 0 Autonumber

Check to see if autoresize is true or not.

I haven't had any problems. I'm using some 2000 databases in Office 2k3 and haven't had any problems.

This might help you out Convert Number To AutoNumber

Strange. I can change a key in one of my tables.