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 = 'asd@asd.com' 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.