adam_k

Shouldn't create_date be greater than or equal to now - 24 hours?

It would help if we knew the structure of the tables (or the key they share). Anyway, your syntax will create a cartesian product, as you haven't set any criteria for the join you are performing (you are performing a join, but with the old syntax and without the on.. …

I think you need to share more info before any answer you receive is really helpful. What is your system (web, windows), what is your db (MS SQL, MySQL, Oracle, Access, Excel, flat file) for starts. By rent monthly do you mean you've got amount of rent, account and number …

On the top of my head (and with MS SQL in mind) it is possible, but a) it won't be nice and b) I don't know how much use it'll be to anybody. If you create a set of days from beginning until end of period, you can count(*) group …

Are you building this in Word VBA or are you calling Word from your application or you got your string in your app and need to handle it? Please any code you've got, for us to see how you've got this far.

I never needed to hot swap disks, but you could try to go to computer management/Disk management and right click the disk and select offline. I don't know if windows will find your second disk and make it online or if you will have to make it online yourself. If …

I agree with JorgeM, the symptoms described show that explorer.exe is not responding. This can be due to a virus or a driver misbehaving or some other software "glitch". If it was overheating then mouse would be also frozen and it wouldn't only cause explorer.exe to stop responding (browsers tend …

Since this is application specific, I'd suggest you start your quest here: http://wiki.videolan.org/Developers_Corner

Look at it this way: select a.column1, b.column2, c.column3 from tablea a left join tableb b on a.id = b.a_id right join tablec c on a.id = c.a_id and b.id = c.b_id Keep adding tables and changing directions. If we only had left or right it wouldn't be possible.

To help you find out the problem change the error msgbox to display the exception you've caught, instead of the generic "Sorry Cannot open Server Connection". Also, since you are using Trusted Connection, I assume windows user from the client machines have been granted login to SQL and access to …

Read here: http://stackoverflow.com/questions/3003719/hresult-0x80040154-regdb-e-classnotreg It also let's you know how to register a dll. You are probably using something that's missing from the windows 7 pcs. If that's the case you either need to manually copy and register it or make sure your installer does the job.

I agree with Ancient Dragon, always make it resizeable. I've have the bad luck to work with a program designed around a standard resolution (as Begginnerdev) suggests and it's always causing me troubles because the programmer disabled the scroll bars (!) for some reason and if your resolution isn't at …

Could it be that your laptop doesn't give enough power through USB to properly power the disks up? Try an external powered USB hub - make sure it's powered or it's only gonna make it worse.

You need to go with a separate thread (or background worker) for your upload. This will keep your main thread free to update your progress bar and make your form responsive.

Read here: http://sqlandme.com/2011/04/27/tsql-concatenate-rows-using-for-xml-path/

You should join all 3 tables and only select from the 2 you need to: select directives.comments, para_comments_sect.comments from directives inner join para on directives.para_id = para.id inner join para_comments_sect.para_id = para.id where para.id = 15 -- replace the where clause with whatever you need to select directives.comments, para_comments_sect.comments from …

Welcome to Daniweb.

You are assuming that the field exceeding the field size is filebytes. It doesn't have to be, so check the length of filetype,filename, etc.

Try this: SELECT A.AccountID, A.LastName, B.Paid FROM A, (SELECT AccountID, SUM(InvCurrency) as 'Paid' FROM B WHERE B.BillingPeriodStart Between '2012-01-01 00:00:00.000' AND '2012-12-31 23:59:59.000' AND StatusID = 1 AND (ServiceCode=13 OR ServiceCode=14) AND (ServiceCode=15 OR ServiceCode=16) AND (ServiceCode=17 OR ServiceCode=18) AND (ServiceCode=19 OR ServiceCode=20) AND (ServiceCode=21 OR ServiceCode=26) Group By AccountID …

Yes it is: http://nibblesec.org/files/MSAccessSQLi/MSAccessSQLi.html

Oracle isn't my strong suite, but: 1. No. 2 & 3: Find your connectionstring here: http://www.connectionstrings.com/oracle

You can obtain the password with an inputbox and decide from there. Private Sub Command0_Click() Dim answer As String answer = InputBox("Enter password", "Admin") If answer = "admin123" Then MsgBox ("Administrator access") Else MsgBox ("Wrong Password") End If End Sub Be warned that applying this all over your db will …

You can also specify parameters on CR and filter your results with that, directly in the report.

Make and model will help us help you.

You can only use Integrated Security when in an active directory. I don't think you've set that up in your laptop, so visit http://www.connectionstrings.com/ and choose a connection string with user id and password, like: `Server=myServerAddress;Database=myDataBase;User Id=myUsername;Password=myPassword;`

I really don't understand what you are trying to do. Can you please explain what you mean by table and probably what you are trying to do?

Google does wonders: http://stackoverflow.com/questions/2446764/oracle-update-statement-with-inner-join

Read here: http://www.codeproject.com/Articles/5131/COM-port-made-simple-with-VB-NET or here: http://msdn.microsoft.com/en-us/library/system.io.ports.serialport.aspx Your picture doesn't help us. Next time try including source code and the point you are having problem.

Isn't this the same as `right([ID] + 10000;4)` ?

Just make sure you store all the data that are possible to change in the invoices tables, so that you can retrieve the same data as your invoice. A good example is price, another is customer's info (address might change or whatever).

Create a separate db with your data (you can password protect this) and link the tables from your environment db to that. Password protect your VBA and when you are done developing go to Database Tools and use the option Make ACCDE. This will create a copy of the db …

Welcome.

Case won't work in Access. Try a statement like `select * from table order by closing Is Not Null, Closing`

SELECT * FROM pages INNER JOIN users ON pages.page_author=users.users_id WHERE page_status='".$type."' WHERE clause has to go to the end. Think of it as JOIN produces a single table with the combined contents of the 2 tables specified.

Depending on what you want to store your options might change. Since you look new to this I'd suggest you look into My.Settings for storing a few values. Read here for a short tutorial: http://www.daniweb.com/software-development/vbnet/code/296812/storing-and-retrieving-application-user-settings

Try something like: Dim last_value As String = "" Dim last_color As Color = Color.LightBlue If DataGridView1.Rows.Count > 0 Then For Each row In DataGridView1.Rows If DataGridView1.Item("houseno", row.index).Value <> last_value Then If last_color = Color.LightBlue Then DataGridView1.Rows(row.index).DefaultCellStyle.BackColor = Color.LightGray Else DataGridView1.Rows(row.index).DefaultCellStyle.BackColor = Color.LightBlue End If Else DataGridView1.Rows(row.index).DefaultCellStyle.BackColor = last_color End …

If it was MS SQL I'd do it like this: declare procedure dbo.sales (@startdate datetime, @enddate datetime) as begin select Category, Date, Location, Amount from (SELECT 1 as 'sortnum', 'Cash Sales' as 'Category', Date, Location, Sum(SubTotal) sa 'Amount' FROM data WHERE (Date between @startdate AND @enddate) and Account_Number like '%cash%' …

Usually we try to get the client connected to the server. How are you trying to connect to your server? Also what you are trying to do you help us get a better picture.

I know that I'm a bit late for this discussion, but: > Everyone who replied prior to the thread being marked as solved gets credit for participating in a solved thread. We're aware that unhelpful people will still get an increment on their solved threads metric, but things tend to …

I totally agree with Reverend, that timer won't work, but I also want to point out a couple of things: a) If you design a solution that would extend the "license" x days then you need to make sure that your key expires or just go with the much simpler …

To add a comboboxcolumn in a datagridview use the following: 'set up the combobox properties : Dim column As New DataGridViewComboBoxColumn column.DisplayStyle = DataGridViewComboBoxDisplayStyle.ComboBox column.Name = "Name" column.HeaderText = "Title" column.DataPropertyName = "Database column here" column.DataSource = "A binding source goes here" column.ValueMember = "Value member name here" column.DisplayMember = …

This might be silly, but if it's VB.NET shouldn't you use "&" instead of "+" for concatenation?

Read here: [[http://msdn.microsoft.com/en-us/library/ms177410(v=sql.105).aspx]](http://msdn.microsoft.com/en-us/library/ms177410(v=sql.105).aspx) on a second thought it could be as easy as: select datename(m, invoicedate) as month, sum(qty) as qty from invoice group by datename(m,invoicedate)

A cursor is the tool we've got to iterate through records. You can loop through the results of your query and do whatever you have to do with each record. I've got to disagree with pritaeas on the sp or triggers part. You use a cursor when you need to …

By disconnect you mean the phone from the computer (vs losing connection to internet), right? If not could it be a fair usage policy thing? If it is disconnecting from your computer, how and what is connected in the first place (is it a cell or land line, do you …

This should return the siblings: "select b.studentname,b.class from vw_admissionform a inner join vw_admissionform b on a.familycode = b.familycode and a.regno = '" & txt1.text & "' and a.studentname <> b.studentname" you can include in the select all the fields from your query - if you want them in the same …

I believe you are thinking sequential here, and dbs are powerfull only when they process bulk data. What you should do is join the tables in an update statement with id_product as key and a where that will filter only the records where ps_product_shop <> id_category_default. It should look like …

You just need a new var to hold the number of years and increment that by 1 before your Loop

Can you explain the excercise and what you don't understand a bit ?

We'll probably need more info on your project before we can offer any assistance, like what is your db, what have you done already (either in the purchase voucher details or the stock update) and what your tables look like. Usually we prefer to keep 2 seperate stocks, the on-hand …