Search results

thanks pbaldy i will have a gander at it

hey guys i have the following line in my query for removing seconds from a time/date stamp and all works great except one thing if the time is 10:02 it is showing as 10:2 anyway of getting it showing correctly? (Day([HTRXTBL].[HTRX_TIMESTAMP]) & "/" & Month([HTRXTBL].[HTRX_TIMESTAMP]) & "/" &...

thanks rural guy so so y does access 2007 format need that when i had it in an mdb it didnt?

btw i have found what has caused it. i movied from an mdb file to an accdb file format now why has this caused this problem and how do i fix it?

hey guys when i run the following code i get a type mismatch error and i cant c y any help would be nice Option Compare Database Option Explicit '*************************************************************** 'The DoesTblExist function validates the existence of a TableDef...

hey guys its been along day on some very new stuff for me so sorry bout all these posts with the following code i am obtaining the network cards mac address and returning just the numeric value out of this now this works great until i have more than one network card enable and i get an overflow...

hey guys nevermind silly me thought of the obvious solution i just removed the 3 left hand characters to be returned. :)

hey guys i have some code in my form that returns the hard drive serial number which all works fine on my pc and returns alpha numeric one of the guys i work with tested it on his and gets the attached result. the code is as follows. Option Explicit...

thanks for ur advice there adam didnt know that bout strings

paul i am working on something similiar to you atm by the sounds of it i found the below link extremley helpful as a starting point. As im still a newbie at this not sure exactly on ur situation but hope this helps http://support.microsoft.com/kb/210295

hey guys i get an object required on set mac = for the below code Private Sub txtSERIAL_GotFocus() Dim oWMIService As Object Dim oColAdapters As Object Dim oObjAdapter As Object Dim mac As String Dim y As Double Dim z As Integer Set oWMIService = GetObject("winmgmts:" & "!\\.\root\cimv2")...

thanks paul u wouldnt believe it a minute b4 ur answer i found i think another response to this from u on the forum sorry bout that.

ok i have searched the forums first and while there is a fair few on invalid use of null i couldnt really find any like this i have a form where i need the user to enter a number to equal a formula that enables some buttons but if i leave it as null i get the invalid use of null msg is there...

your a great person adam changing it to a double worked a treat thanks for your help on all this greatly appreciated.

No probs mate Dim x As Integer Dim i As Integer For i = 1 To Len(Me.txtHARDWAREID) If IsNumeric(Mid(Me.txtHARDWAREID, i, 1)) Then x = x & Mid(Me.txtHARDWAREID, i, 1) End If Next i Me.txtREGO = CInt(x) / CInt(Me.txtSERIAL) i get an overflow error

adam thanks for ur help with this the only thing in that code i dont understand is the me.text15 field is that meant to be the text field i want to put the new value to or something else? Thanks Mate

yeah mate thats fine if i can do that i will then play around with randomising it after that. thank you

aje what i am trying to do is use the hard drive id which is the aplha numeric string "HardwareID" to be used in conjunction with the serial number "Numeric" through a calculation which atm is just a divide by to give a rego code now the next step will be to make it a slighty more difficult...

hey guys i am trying to convert 2 different strings to integers then divide by each other to return another value (this is just a test at the moment for my rego details) but i keep getting a data mismatch error on the following code. I also should mention the hardwareid contains alpha as well as...

hey guys sorry to reopen an old post but i tried this and everything works fine except when i use the option by bilbo which is what i need as i only want to ditch the seconds from a group by command when i do minutes if the minute is under 10 it is only showing 1 digit e.g 9 instead of 09 in the...