Search results

Hi Try using the format option in the query that supplies the list box, Right Click on the field and select properties. Hope that helps Chris

Hi dim StrA as string StrA = "AWORD/AA" if mid(stra,len(Stra)-2,1) = "/" then stra = left(stra,len(Stra)-2) else stra = left(stra,len(Stra)-3) Msgbox "It works" end if You may have to mess about with the -Num to pick the correct letter but the ideas there. Chris

Hi B***dy users!. This really isn't how a database works. Forgive me if i'm telling you something you already know but the whole point of the machine table is that you can add as many machines for each user as you need there really is no simple way to start adding and deleting controls on a...

Hi I think what would be better is a main form and a subform. There are loads of posts on here about this subject but in brief: In this case the Main form displays customer data i.e name address etc. This form is almost always columnar (keeping things simple). The subform is tabular or...

Hi Numpty You could try the old msdos longfile name work around c:\sixtyandone\seventyandone becomes c:\sixtya~1\sevent~1 shorten everthing after the root (c:\)to six characters It's a million to one shot but it might just work :) Chris

Hi This should give you some ideas. Basically you ask the query to equate the selection to true or false If a name is entered then the answer = true the data is returned. If the answer is incorrect then a false is returned and no data. If the criteria is blank then all records are returned...

Hi Solved it here I think Chris

Hi I'm having a thick day today. I'm doing a project tracking db and i need help on a query for an update display. Basically i have 4 tables Project: ProjectID ,Desc .... ProjectModule: ModuleID, ProjectIDfk,Desc.... ProjectItem: ItemID,ProjectModuleIDfk,DateID,TimeID,UserID... User...

Hi No apparently you can't do this. I did some more looking around and apparently it's not possible to redim an array with more than 1 element. go figure. Chris

Hi I'm trying to resize an array as i go through a loop. This is how i have dimensioned the array Dim ColData() As Variant then to start the array (ColNow is an unknown value) Find ColNow then ReDim ColData(ColNow,0) then with each iteration of the loop ArrayInty is increased by 1...

Hi Something like this (access2000 you'll need the tools>references>microsoft dao3.6 object library) Not sure where you are running this from, if called from a query as a function in a module then. public function StockCalc (PStock as long, SStock as long) as Long Dim dao.rst as recordset...

Hi How does this sound, You need to display all of the ethnic groups and show the number of delegates in each group also split by sex. So row is sex column is Ethnicity value = count of delegates. I just tried this and the only way to get all the ethnicities displayed is to use a right...

Hi Try using the Nz function thusly, you never know it may work!! Count(NZ([DelegateID]),0) Chris

Hi Don't know about you but when i have this problem 99 times in 100 its a field in the main table set to Required = true. Usually a text field, for some reseason when ever i create a table the text fields are always set to that. Anyway back to your problem. I would double check that; a) You...

Hi Try this example in the attachment Basically the query uses two inbuilt functions mid and len Mid requires 3 pieces of information 1) The data you want to view 2) The position you want to start at 3) The position you want to finish at. You know you don't want the first 2 digits so you...

Hi No 3am inspiration. Rich you are right, in that i wanted to return the controls name. Up to now i just used the click event of the control, as Kristin points out i wanted to do this at form level i.e have an form event fire after the user clicks on the control that returns the name of the...

Hi Fizzio Even if i did the map i still wouldn't have an event to fire it from, if i use any of the forms events they aren't called unless you interact with the form. As soon as the cursor is over a control the form events (at least the click and mousedown ones) won't do anything. Thanks for...

Hi Not easy indeed! :D. I actually did this for the help files, or rather i created a table to store the x and y coords where i want the arrow positioning and then did Public Function createhelp(XAxisVal As Single, YAxisVal As Single, FrmName As String) Dim Db As DAO.Database Dim Rst As...

Hi Thanks for the help, unfortunatley Rich there does not appear to be a .name method for activeobject and when i tried the same thing for the activeform.name, as a test, i got an error saying "you entered an expression that requires a form to be the active window" what ever the hell that...

Hi Does anyone know if there's a way of determining what control the cursor is currently over without using any of the events of the control itself. --more details-- What i have is a help file that is a form with the background set to a picture of part of a complex paper form. The user is...