adam_k

Optimism is an occupational hazard of programming: feedback is the treatment. Kent Beck

If you have the system backup(s) and the data in a partition of the system HDD, effectively you are only securing yourself from user error. If the drive goes bad or if you get ransomware/virus you still have no solution. Unless the drive with the backup is offline or in …

Usually unless we act on something, nothing happens. I'm guessing that you have already binded the datagridviewer to your dataset, from the VB GUI. Instead, just place an empty datagridviewer and connect it to your dataset whenever you wish programmatically. Also, share what you've already done to see your approach …

I believe you are closing one parenthesis from the "FROM" clause in your where. Try this : sqlQuery = sqlQuery & " INNER JOIN Barangay ON Borrowers.BRGYNO = Barangay.BRGYNO)) " sqlQuery = sqlQuery & " WHERE (LOANS.RELEASED >= @d1) and (LOANS.RELEASED <= @d2) " sqlQuery = sqlQuery & " ORDER …

1st of all this is a very old thread. You should have opened a new one. 2nd I see you closing the Conn but never open it. Try to open it before or after you assign it to the command. If this doesn't solve it, open a new thread, post …

Because you are not giving a lot of information, I cannot provide a specific solution. Try to use a case when inserting or a trigger or use a stored procedure that handles this to insert . Alternatively post your insert code, the db type and what is the program that …

Create a table (or with a cartesian it can be done in a query) with the series of numbers from your smaller one to the greater one and left or right join it to your table. You'll get the missing ones when you add for criteria where your column is …

Please share your code. The portion you are sharing doesn't show much

Generally the update will not update 3 tables at once and your syntax is wrong. I assume that you are trying this because you don't know which of the 3 tables holds the record that you need to update. Why don't you try to update all 3 tables in their …

We don't give ready made programs here, we help people develop their own. Despite this the links provided by waynespangler contain the sample code.

It has to be the font. Uninstall (delete) it and reinstall it. If that doesn't help then it has to be an option of the printer (font substitution comes to mind)

I believe that you problem doesn't lie with the if, but with how you give values to @Ucount and @Ecount: select @Ucount = count(Username), @Ecount= Count(Email) from userdata where Username=@nameUsername = @name and Email=@emailadd If I give Username = aa and Email = '[email protected]' and neither exists then it's OK, …

This is a bad design / idea / report and the solution won't be really nice. It's been a while since I've done anything with Access, but since nobody else is replying I'm going to give you a general idea and hope you can figure it out. As you said …

I'm not sure why you group by "Avg Completion Duration". That means that you want a separate record for each completion duration. If you want the average to include results from several weeks then you also need to remove the week from the group by AND the select list. The …

Assuming that you only need Mytime1 to Mytime10 (10 pivoted columns) only: http://technet.microsoft.com/en-us/library/ms177410(v=sql.105).aspx If it's a dynamic pivot, one where Mytime can be anything from 1 column up to whatever, then you need dynamic SQL. Let me know and I'll provide.

I'm not sure what you are trying to do, but try something like this: Declare @msg as varchar(20) SELECT @msg = '2014/9-1' declare @slash as int declare @minus as int select @slash = charindex('/', @msg), @minus = charindex('-',@msg) DECLARE @yyyymm varchar(6) select @yyyymm = convert(varchar(4),left(@msg,@slash)) + convert(varchar(2),substring(@msg,@slash +1 ,@minus-@slash-1)) select …

In the Else part of the if..end if you are only setting the com, you are not executing it. Try executing the command you've just set.

Jim is right, but even as administrator you can't access some pretty hiden folders as C:\System Volume Information You need your app to work with SYSTEM priviledges, but I don't think my AV runs under these, so perhaps there is another way (some system function perhaps?)

If this is over LAN or WAN (VPN or leased line), then you can just use the computername. Your DNS or WINS will take care of the name resolution to the IP. If you plan to connect over the internet then perhaps you've got to search services like dynDNS or …

I have tried Openoffice, but decided it would have to be an emergency solution only. Especially after Office 2007, where Excel and Access go seriously better (although I can't figure out what is where in Access nowadays, but I haven't used it that much). I think that Excel can't be …

1944

You are declaring a dataset, initialize it and then proceed to use it as a datasource without ever filling it with data. It shouldn't populate your combobox as it holds no data.

I've seen this error when the date passed as criteria is not in the same format as the server expects (SQL profile with regional settings MM-DD-YYYY and client passing date with format DD-MM-YYYY). Try to [iCODE]SET DATEFORMAT DMY[/iCODE] (replace DMY with the appropriate format as you datetimepicker's format) in the …

You know, you are welcome to contribute to your own program. pixma showed you the way. Try adapting your code, using the example pixma provided and let us know if you are having problems (with your code and the point that you are having difficulties)

1st of all this isn't a word file, but a text file with .doc extension. If you open one in notepad you'll see it's contents. to save it with tbox_Inv_Date.Text as filename you should: `Dim New_Doc As String = "C:\Users\ComputerFirstAde\Desktop\" & tbox_Inv_Date.Text & ".doc"`

Try this: update Users set NW ='1' from Contacts left join Users on Users.code = Contacts.code inner join Contacts.Country = Location.Country where Users.NW = Location.City But be warned that it might contain errors or other typos, as it was written in the reply box and hasn't been tested. Good luck …

try to do it with `selection` instead of `content`. Make sure you start with `selection.collapse` if you don't want the search to be within the selected area only.

If the db is SQL then : [CODE]SELECT CONVERT(varchar(10), GETDATE(), 112) + '/'+ convert(varchar(10), max(substring(id,charindex('/',id) + 1 ,len(id) - charindex('/',id))) +1 ) from #test where left(id,charindex('/',id)-1) = CONVERT(varchar(10), GETDATE(), 112)[/CODE] assuming id is your field and #test your table. If it's not SQL then the logic should apply but the …

Are they on the same hard drive? Same partition? Is format an option? The question why comes to mind, but I guess it was an accident.

Can you share the code that you load the saved info? If the combo list has the values it should, then there is nothing wrong with this sub.

When you say boots for a sec, do you get past POST (BIOS) ?

I've got a feeling that this will end up in a "Build Windows or Office" type of thread, where even if you do build a basic Excel type of thing with formulas and everything they will still argue that Excel has VBA or that you don't have macro security and …

I disagree with IIM. The `select into` is used when you want to select records into a new table (it is created by the into). If you want to insert into an existing table, your syntax should be like: Insert into table1 (field1,field2,field3) select field1, field2,field3 from table2

I'm not sure about php, but I'm sure you'll find a couple of threads about resource availability in here (Databases category). About inserting to more than 1 table, use a stored procedure.

I'll be honest, I didn't read everything. But what I did read, makes me think that you are replacing null with 0 in your columns but not in your formulas. Also it would be easier to read and create to use isnull() instead of case. To make it easier for …

Each and every one of us has his/hers way of doing things and for various reasons. Others be because that feels right, others because they carry habits from one language to another and others because it helps us read our code now or it will help us understand our code …

Inside the triggers you get access to 2 "special" tables. Read here: http://msdn.microsoft.com/en-us/library/ms191300.aspx for info and how to use them.

It would help a lot to tell us what db you are using. A couple things come to mind, which would work in MS SQL or MySQL, but not access and can't even tell if it would work on oracle. Also, is this a one time thing or is it …

SELECT Field1, dateadd(m, num, TrailStartDate) AS date_due FROM table CROSS JOIN (SELECT a.id + b.id AS num FROM (SELECT 1 AS id UNION SELECT 2 UNION SELECT 3 UNION SELECT 4 UNION SELECT 5 UNION SELECT 6 UNION SELECT 7 UNION SELECT 8 UNION SELECT 9 UNION SELECT 0) AS …

Read here: http://www.daniweb.com/web-development/databases/threads/422523/sql-date-question It's similar to what you are doing, but the it deals with dates and not dates and times. The same logic should apply. Also, is there any chance the check out time is on a different date?

Just requery your db, instead of adding it manually.

In a typical WMS things are like this: Order info goes to order tables, header and details. In details you probably need 2 qties, 1 ordered and 1 remaining. Price info goes to item master, together with part number, description, product category (Finished goods, raw material, packaging supply), lot and …

Assuming a lot, this could work: select sum(non_pay) as non_pay_leave, sum(pay) as pay_leave from ( select 1 as non_pay, 0 as pay from table where employee= @employeeid and description = "Sick" and leavetype = "Yearly" and (monthlymaxleave > 1 or yearlymaxleave > 10 ) union all select 0, 1 from …

You need to read about AT commands and how to listen to a comm port. Good luck with that.

Usually you debit the cash account and credit the proper account when you receive money. Since you are not really building an accounting system I suggest you debit your cashier (keep track of the money you've collected) and credit the student. You can keep track of what the student has …

Up to 99 copies you can use: select id, name, total_copies from contacts inner join (select a.id + b.id as copy_count from (select 1 as id union all select 2 union all select 3 union all select 4 union all select 5 union all select 6 union all select 7 …

@pritaeas: Aren't you making this too complicated? `LEFT(LEN - PATINDEX(REVERSE))`

Since you are only asking about the part to print a barcode, no it's not that hard. But like deceptikon said you should go with the barcode sticker printer. It will solve a lot of problems. You can print a barcode by installing to your computer a barcode font (ie. …

Try this: select fieldname + ';' from tablename --where criteria for xml path ('')

I have never used this and haven't tested it, but you should be able to get MRN in your app with OUTPUT clause: INSERT INTO PATIENT_INFORMATION ( MRN , FIRSTNAME ) OUTPUT INSERTED.MRN VALUES( [dbo].[Generate_MRN]('00001', '00001') , @FIRSTNAME ) SET @PATIENT_ID = SCOPE_IDENTITY()