Search results

How can i use the code created in a query (sql view) into a sub procedure. I know you can cut and paste it , but it needs to be altered?. Would appreciate your help! Thanks Milan

Hey!Thanks for that - Works a treat! I have made some minor modifications to suit my form! Thanks Again!

Hi People!! How can i import file names with their extenstions i.e Test.mdb into a unbound list box on a form. I would like to import from a specific folder which has many access mdbs. I need the form to list these mdb's with their names & file ext. Would appreciate any useful advice!

Thanks for that !! Much clearer!!!

Hi People, I have the function below that rounds up or down . Code works fine, but i want to be clear in my head of what the function is actually doing?. Public Function MyRound(Byval YourNumber as Double, Places as Integer)as Double Myround = Yournumber * (10 ^ Places) Not sure about this ...

Thanks for that!! Also works fine!!! Milan

Hey!! Thank you very much for that !. It Works perfect. I converted back to integer once i have tested the decimal value! . Nice to be able to get expert help when stuck in difficult situations!. Thanks Again! Milan

i need to be able to test the decimal first!!!. and then decide to round!!! how do i test for a decimal value!!

The Previous solutions that were suggested have not worked!!. It was probably because i did not explain my self properly, hence re-posting the problem but this time explained a bit more clearly!. I could do with some help on this if poss!. Milan

Hi People I have a field that has decimal numbers. 1.5, 1.6, 1.7 1.3 and so on. However i need to test the decimal value and then either round down or up depending on the decimal value so for example, if the record value was 1.7 in the first field and 1.8 in the 2nd field i want to round up...

how do i pass a value from a sub procedure in a form, to a function in a module and get the result back into the procedureQ Thanks

I need to able to round up if > then >0.5 or round down if <0.5 would appreciate your help here!! Milan

Code Not Working!!!!Can You Help!!! Hi, I have a little problem -: this part of the code is coming up in red text showing and invaild code. Any ideas what might be wrong!!! Thanks Milan 'If Not IsNull(rst.Fields("Sequence" & IIf(intCounter = 1, "", intCounter) Then...

Hey!!! Thank you very much for doing that for me!!!! I really appreciate it!!!you have saved me lots of brain ache!!!! Thanks again!! is always really nice to have you wounderful people about to help out!!!! Milan

Can you help out here People!!!!!! Dim rst As Recordset, FieldID As Variant, FieldID1 As Variant Dim strtest As Variant Set dbs = CurrentDb Set rst = CurrentDb.OpenRecordset("QRYBAJCLASSPROCESS", dbOpenDynaset) strtest = rst!Sequence Do Until rst.EOF With rst FieldID = strtest...

Work's Great!!!! Thanks!!!! Milan

Hi People! I have an Access Query which I have go into design view/ SQl View : SELECT TblComplianceLine.ComplianceNo, TblComplianceLine.Description, TblComplianceLine.Comments, TblComplianceLine.AuditDate, TblComplianceLine.PointsLost FROM TblComplianceLine WHERE...

Hi People!! I need some of your expert guidance!!!!. I have an Access 2000 database which has some Vb code. I need to secure the forms and protect the code from being tampered with. However i do not want to make it an MDE file. How can i set up user group security in a Access. I have never...

Thanks Ian

Hi People, I have been using VBA in Access for about 8 months, but i regard myself a novice. However i need to get to intermediate level within the next 2 weeks . I will be looking to be spending 10hrs a day learning code writing for 12 days solid. However i need some advice on where to start...