Recent content by Jimmythemadman

i have created a form for my database where i intend to give the user the option of searhing my more than one criteria but not all. i have used a system of combo boxes for the user to enter thier choises leaving the combobox blank for any criteria they dont know. the user then clicks th button...

i have created a form for my database where i intend to give the user the option of searhing my more than one criteria but not all. i have used a system of combo boxes for the user to enter thier choises leaving the combobox blank for any criteria they dont know. the user then clicks th button...

ok ive got it all working now here is the code what i ended up with ---------------------------------------------- Private Sub Form_BeforeUpdate(Cancel As Integer) If Me.hardwareid = 0 Then Me.hardwareid = DMax("[hardwareid]", "tblhardware") + 1 Else End If End Sub...

i now have got it to do it right e.g when a new entry is made however if you edit a preexisting record it add to the number if there a way to stop this (im thinkng putting an if funcion which only runs the dmax code if the value is null)

aha by entering it in the form_load area ive got it to add 1 to the value however its adding 1 to the first value of the table thus messin up the records is it possiable o got th form to go straight to a new record when its loaded

i am not bothered with using continus numbers in the id would it not be easier to use a random autonumber to go after the 3letter code. i do not see how using an autonumber to create a wholey random number can be a problem. i would be interested in any responce

ive given it a try but it wont work ive got Option Compare Database Private Sub hardwareid_BeforeUpdate(Cancel As Integer) hardwareid = DMax("[hardwareid]", "tblhardware", 0) + 1 End Sub in the form for the field of hardware id (which is where i want the number to appear help please

right i think i got it now i was trying to do everything in the tale but doing it in the form will be easier. i may dissapear for a while to contemplate and attempt. (I havent got much of the database created yet its still in the ideas stage)

ok then maby not all of the code stuff, more like bits which i have found usefull and taught myself/ asked others about. im vaiguly familliar with the DMax() +1 from some work with vb but am unsure how to use this in the specific situation.

ok i now see the error of my ways. however im am unsure of ow to use dmax in the design of the table how would i impliment this and would i still be able to use the 3 letter abreviation (taken from a field in the same table) at the begining of the number?

im useing the autonumber for the hardware id this will be on the side of whe computer/ printer etc im using an autonumber sothat the sticker can be produced and printed automaticaly without the user haveing to make up a number fot it this wil save a lot of time as the system is to be implimented...

im creating an error reporting database. for this the hardware/system items need entering they will have a unique id to assist identification i would like the unique id to start with a 3 letter code refering to the type of hardware/system/periferal followed by the number e.g a printer will ahve...