Search results

Hi everyone, I wrote the below codes to filter subform by date and product code, this work correct, but I want to add nz to date for get all the dates. querydate = "[CDate] = #" & Me.txtDate & "# " If Me.cmb01.ListIndex = 0 Then pSQL = "select * from tblProducts where " & querydate & ""...

Thanks isladogs, yes I Checked it out, but as I said in my first post, serial of drive "c" is not stable, because it changes with the change of windows.

Your first function is great, is it possible to get only serial of PHYSICALDRIVE0 in the first function? for example : For Each obj In wmi.InstancesOf("Win32_PhysicalMedia") if obj.Name = PHYSICALDRIVE0 then ..... ..... ..... Next

Hi arnelgp, with your first Function (GetPhysicalSerial), it gives the right serial of hard : WD-WX71A1425422 , but the second function returns : 2020202057202d44585731373141323434353232 Of course, two functions returns single serial on my system, but I have the problem on another system. I...

Thanks a lot arnelgp, is the serial (hard disk serial) unique for every computer?

Thank you arnelgp, It works well, but it returns several serials, that are USB serial, my external hard and HDD serial. is there a way to get only Hard disk serial and not the other (flash memory, hard external) serials?

Gasman, actually I want to lock my excel program so that it only works on single system, I used drive C serial, but it has a problem that the serial of drive C is not fixed and it changes with the windows change., so I need a permanent serial on system, after searches I figure out HDD serial or...

Hi all, I need to extract hard disk serial number by vba, but I don't mean serial of drive "c", because this serial changes with the windows change, I mean the serial of hard disk. Can someone give me a solution? Thanks in advance.

hello everyone, I'm have been working with access for 5 years and I have written many programs with vba & sql commands in access, and now I need to create database by sql server in my new program and I have to connect access form with sql server database, but I have never worked with sql server...

Thank you buddy, the code was great.

I knew this before, is there a way to do this without any massage?? i'm sure is a way with vba code.

Hi guys, I have many text boxes and they should accept only numbers, it means no one can type letters on text box. can someone give me a function to put on text boxes event?? Thanks in advanced.

Thank you very much buddy, the problem is resolved by theDBguy way. thanks to all friends.

Thanks Cronk, but it still doesn't work. T_Age is string field.

Thanks nhorton79 for your code but I already knew this way and I used it before and I'm looking for a way to do it without IF and Elseif. you are right, I have to use appropriate names to text boxes, I will fix it next time.

Thank you buddy, your code is great and it works well but I have some records in table that age field is empty or not typed and your code didn't show them because it show only between 0 and 999 on report. have you any solution fr this problem?

Hi all, I wrote the blew code to create report based on "age" and "career" , the code is working right when the text boxes is filled but it gives blank report (without any records) when Text57 and Text74 is empty and I want to consider all ages when text boxes of age is empty, for ths reason I...

Hi arnelgp, thank you so much for spend your time for me.

Hi, Thank you arnelgp, sorry for delay in replying, I checked it but list box query doesn't work right, as shown in the images isn't product "c" in box 2 or there is not product h , k in box1. can you correct it? Thanks in advanced.

Thank you again arnelgp, can you do it by list box? it means I select multiple boxes from listbox in form and query work with selected boxes in listbox.