Posts
 
Reputation
Joined
Last Seen
Ranked #161
Strength to Increase Rep
+12
Strength to Decrease Rep
-3
97% Quality Score
Upvotes Received
149
Posts with Upvotes
134
Upvoting Members
81
Downvotes Received
6
Posts with Downvotes
6
Downvoting Members
3
48 Commented Posts
18 Endorsements
Ranked #77
Ranked #100
~353.88K People Reached
PC Specs
Intel i7-3770, 8GB RAM, GeForce GTX 650, Windows 7 64-bit
Favorite Tags
Member Avatar for vegaseat

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

Member Avatar for Reverend Jim
15
13K
Member Avatar for almarionoah

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 …

Member Avatar for adam_k
2
4K
Member Avatar for omi4u

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 …

Member Avatar for adam_k
0
327
Member Avatar for Sam_49

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 …

Member Avatar for Reverend Jim
0
410
Member Avatar for kugan80

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 …

Member Avatar for Neena_3
0
5K
Member Avatar for SRI SAI

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 …

Member Avatar for adam_k
0
209
Member Avatar for garyrichard

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 …

Member Avatar for Shivraj_1
0
631
Member Avatar for renegade082208
Member Avatar for Ahmed_99

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 …

Member Avatar for adam_k
0
297
Member Avatar for san_gwapo19

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.

Member Avatar for JamesCherrill
-1
4K
Member Avatar for SyncMaster170

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)

Member Avatar for allensmith2
0
170
Member Avatar for morfious90

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, …

Member Avatar for pclfw
0
415
Member Avatar for M.I.Sahil

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 …

Member Avatar for adam_k
0
219
Member Avatar for amishraa

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 …

Member Avatar for adam_k
0
166
Member Avatar for Vb.Netter

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.

Member Avatar for adam_k
0
191
Member Avatar for HunainHafeez

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 …

Member Avatar for adam_k
0
192
Member Avatar for Satyam_1

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.

Member Avatar for Satyam_1
0
456
Member Avatar for akkbkht

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?)

Member Avatar for deletedaccount
0
3K
Member Avatar for ryklon

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 …

Member Avatar for Alosh
0
764
Member Avatar for serkan sendur

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 …

Member Avatar for Reverend Jim
0
331
Member Avatar for Doctor Inferno
Member Avatar for Dili1234

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.

Member Avatar for sharls
1
589
Member Avatar for skran

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 …

Member Avatar for eldarzeynal
0
1K
Member Avatar for bigzos

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)

Member Avatar for k.prabhu
0
741
Member Avatar for ComputerFirstAde

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"`

Member Avatar for BigFatMama
0
406
Member Avatar for PriteshP23

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 …

Member Avatar for PriteshP23
0
1K
Member Avatar for UKnod

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.

Member Avatar for UKnod
0
159
Member Avatar for Leodumbi

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 …

Member Avatar for luvprogram
0
216
Member Avatar for nelsonjayac

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.

Member Avatar for RMoralesj
1
160
Member Avatar for gbhs

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.

Member Avatar for jelly04
0
167