adam_k

Please show your code, so that we can help you with it.

Try [CODE]select @flag=dbo.RegExpLike(@tt,@ttT)[/CODE]

This might be just silly, but have you verified that her username/password is active (not locked, not expired,etc)?

I believe you can do it by clearing the Form.text (Form caption), setting the form's controlbox to false and the formborderstyle to none. This will remove the title bar and the border.

For some reason I would create 1 table for all 4 of yours and include a type to determine if it's a coordinator or a candidate. Now for the null values: If you treat null then you'll be just fine. And by treating null I mean using the ISNULL() function …

Read here: [url]http://www.codeproject.com/KB/custom-controls/schedule.aspx[/url]

You can always join the 2 tables when quering the db and treat them as 1 afterwards

You need to join the 2 tables in the query to the database. This will get you your result. HINT: You'll need either LEFT or RIGHT join. INNER won't work for you. Read here: [url]http://msdn.microsoft.com/en-us/library/ms191517.aspx[/url] and here: [url]http://msdn.microsoft.com/en-us/library/ms191472.aspx[/url]

You should tell us the error as well.

Well you forgot to run the cmd2. Just before the Catch enter: [CODE]cmd2.ExecuteNonQuery [/CODE]

If you create the table manually, then it is much easier to link that table to Access and create an Append Query. This way doesn't need export or bulk insert.

You can copy the Project Folder from your documents\Visual Studio xxxx (xxxx = the version you are running. I don't have VS installed on this computer, but if I remember correctly it should be under Visual Studio xxxx\Projects

Read here: [url]http://www.access-programmers.co.uk/forums/showthread.php?t=116652[/url]

What db are you using? If it's MS SQL you can use OUTPUT when inserting. Read here for OUTPUT: [url]http://msdn.microsoft.com/en-us/library/ms177564.aspx[/url] Another way to do this, if you can't use OUTPUT is to add a datetime field (like date_added) and pass a datetime value to that field that you've stored in …

[QUOTE=Walahh;1629423]If I use the Import and Export wizard then I have to create a whole NEW database in SQL server. But our project already has an existing database. I am looking for a way to convert/marge that one single Access table to SQL table....without creating a new database. Thank you!!!![/QUOTE] …

[QUOTE=jingda;1628014]Are you promoting the website?[/QUOTE] Only in all his posts.

I am curious why you can't filter your data in the SQL. It's not a good idea to send useless data to the client and have the client filter them out.

I'm guessing that your field is EventSummary.[Event Information - Event Status], so I'll suggest [CODE]isnull(EventSummary.[Event Information - Event Status],'ACTIVE') [/CODE] This in SQL will instruct the server to check if the field is null and if it is return ACTIVE. If the field is not null the it will return …

If I remember correctly (it's been ages since I've setup a serial modem) serial modems don't get detected as they are not plug & play. Go to Control Panel / Phone and Modem and install the modem there. If the auto-detect doesn't find your modem don't give up. Install it …

You should check for command line parameters passed to your program. Read here for an example on cmd line params: [url]http://www.daniweb.com/software-development/vbnet/threads/120418[/url]

What are you doing with the Company_ID or with any other data in your form ? Are you saving them in a db? If you do query the database : [CODE]select max(right(Company_ID,len(Company_ID)-3)) from table[/CODE] and you'll get the last number used. Add 1 to this and you've got your new …

Your join doesn't have enough keys, so you are getting a kartesian product. Either use more fields to make the record from table PaymentToDealer uniquely match the appropriate record from table DealerTransaction or create a common key with a unique value for every record in both tables. PS: Why are …

Read here: [url]http://social.msdn.microsoft.com/Forums/en/vbgeneral/thread/b5e3ccb8-c137-48e3-84c5-85bb6478703b[/url]

[QUOTE=RenanLazarotto;1625875]Hello guys. I have an integer that is storing the result of a division between two numbers. I usually recieve an result that looks like [ICODE]5,2496874654[/ICODE]. How can I limit the variable length so it looks more 'approximated', like [ICODE]5,25[/ICODE]? Thanks in advance![/QUOTE] If you are using an integer, then …

If I remember correctly Access doesn't support case (which would make this a walk in the park). Do you want to update the table, show the calculated column on a form / report or what? If you just want to update the table you can create 2 update queries. 1 …

Perhaps this post will give you a hint:[url]http://www.daniweb.com/software-development/vbnet/threads/374318/1611907#post1611907[/url] With a few limitations you could possibly do the job with int or numeric for the time, but I don't see how you can handle the next day without datetime (Date part can be 1/1/1900)

Why is it not possible to put the sequence in the same query you are populating your DataGridView? Please show us these 2 queries.

I guess that dtAsia is a dataset you've filled using the username as a criteria, so 0 rows means you've got to insert the user in personal_information. unfortunately you are not providing what goes on when filling the dtAsia, so my only suggestion would be to step through the code …

How many cells are you writing?

Are you sure you don't mean SSIS?

Or query the db using a join. What are you building? With some more info, we might be more helpful

Let me see if I got this straight. You want to retrieve data from a stored procedure and display them using a list view. Show us what you've done already and we'll help you get it done.

[QUOTE=denmarkstan;1621603][ICODE] 'To executescaler means to execute the above instructions i.e to insert only one row of data Dim Id As Integer = Convert.ToInt32(cmd.ExecuteScalar()) [/ICODE][/QUOTE] To executescalar means to query the db and return only the first result. Try cmd.ExecuteNonQuery Also your program will always return the message for success, even …

Read here: [url]http://msdn.microsoft.com/en-us/library/system.diagnostics.process.getcurrentprocess.aspx[/url]

Why do you need sqlsearch when comparing data in two forms? Perhaps you are not explaining this correctly?

I am betting that you can register the same user, but not with the same password. You shouldn't include the password in the query that checks if the user exists. Usernames should be unique, not username/password. If I were you I would enforce this from the db.

Read here: [url]http://msdn.microsoft.com/en-us/library/aa903372(v=VS.71).aspx[/url] or here: [url]http://msdn.microsoft.com/en-us/library/system.string.indexof(v=VS.90).aspx[/url] or here: [url]http://msdn.microsoft.com/en-us/library/8460tsh1(v=VS.90).aspx[/url]

Try to reproduce the error with a profiler running. You can also make sure that there are no triggers firing. Sorry, but for better ideas I'll need more data and from what I can tell you can't be more specific.

Are you sure it's not using a connection string? Have you changed the existing DSN or created a new one?

You type 333 characters per minute You have 58 correct words and you have 1 wrong words :D

Either your graphics card driver has a corrupt file, and the latest driver didn't replace it or your graphics card is dead and it is not starting properly. To find out which one it is uninstall ALL ATI software from your PC, reboot and then install the latest driver. Reboot …

I would do it a bit different if I were you. Since you've got field identifiers (Document Name, Number or whatever) I would read the next line, check the type of the field and assign it's value to a var. When all 3 vars get a value, then append the …

[QUOTE=ClimaxBeetle;1614878][CODE]SQLstr = "INSERT INTO TableTestEmployes VALUES('" & TextBox1.Text & "','" & TextBox2.Text & "','" & _ TextBox3.Text & "','" & ComboBox1.Text & "')" [/CODE] ^ Is this the right one? or is there a more organized way? I have like 16 items asked to the new employee on that form.[/QUOTE] …

May I point out that it's bad practise to keep the data in RAM? PS: It's also bad practise to hard code the 60 seats into the program. It would be easy enough to use application settings to hold this info without hard coding it.

If tabletoread is a datatable, then sort before getting the records

This of course is a security nightmare, but if you ask for it: For 1 field and 1 value, I find it easier to use application settings. You'll need a simple form to see and change the password and a setting created in application parameters. Here's an example about settings: …

1st of all, you do realize that a text file can be edited by hand and offers next to no security, right? (If the user running the program doesn't have access to the file, then neither will the program). We use text files for logs only for debugging or tracing. …

You can try USING, but if your program crashes due to StackOverflowException it won't do you any good. Read here for details: [url]http://msdn.microsoft.com/en-us/library/htd05whh(v=vs.80).aspx[/url]

Word is not exactly the correct tool for this job. Do you have documents filled in or are you still creating this? I'm not sure that you can do it the way you have in mind, but with some VBA, you can get it done.

There are pros and cons to both ways. I can't answer without any details and the small apps is pretty generic. What does applications mean? Do they share data (not that you can't share cross-db), share users, share DBAs, share naming standards?