Recent content by M8KWR

ok.... create a module and copy the code below Function CountSpaces(ByVal AlphaNum As Variant) Dim SpaceCount Dim Pos, A_Char$ Pos = 1 SpaceCount = 0 If IsNull(AlphaNum) Then Exit Function For Pos = 1 To Len(AlphaNum) A_Char$ = Mid(AlphaNum, Pos, 1) If A_Char$...

i think i understand what you are tryin to achieve.... i have a module that i have created to remove space and characters from a string to leave myself with only numbers.... i will alter this for your appliations to basically to look at each characters from the right of the string, and to count...

If you are taking data from a text box and then from a combo box, why do you need this information shown in another combobox!!! why can you not show this within another textbox.... is this data been stored in a fields, or just for display purposes, and is the user able to alter this information...

The only way i can thin of doing this is to create a new column and work out how many leading spaces each string in the first field has..... I am taking from the data you copied into the post, it does not show this spaces!!!!! I think i may have a function that i can modify to do what you...

fantastic, many thanks

I have created a report, but would like the line number next to each records, so if the report shows 9 records then obvioulsy 1 to 9, or whatever this may be..... So what i have done is but this code within the detail_format Public Count123 ' i put this above the private sub for...

Trying to find the name of program, that i beleive monitor the web activity on a computer, but all i get out of the person who is using the computer is that the icon/logo is a pink bloke holding a torch. Would anyone be able to tell me what program this is, i would very much appreciate it...

in the event properties of the fields that you update, goto the afterupdate properties, and then you would need to write a small amount of code. Basically you would need to say Me.datefield = Date Me.timefield = Time hope this helps

you problem lies with using list box's well that my thought anyway. If you used general text boxes then this would work ok. I'm a bit confussed by when you say the users selects 4 dates. You do some code to automatically put the correct date into each hidden text box, and make sure they are...

Have you tried using the wizards to create the reports for you... I found it the best way to learn, let access do it for you, then go into the design mode and mess about with the layout and the data that it is pulling in. Then you should be able to modify it to the way you wish. I would be...

you can use a iif inside another iif statement, i think that should solve it, but i could do with know more information, table and field names etc so i can write it for you if yo have not used iif statements before.

quite simply need to do this backwards to get your results instead of looking for null values you need to look for entered value. you can either go into your design window drag a drop all fields, and then under the first field in the criteria enter Is Not Null, then under the second field, but...

in your design window

in your design window

in your query use expr1:left([table name]![company field name],5) this will extract the first 5 characters of the company field. In the criteria use left([other table name]![company field name],5) then this will cross reference the 2 company name fields on the first 5 characters. Do not link...