Search results

I've got a crosstab query that other queries depend on, unfortunatly I run into problems if the crosstab query returns less columns than the other queries are expecting! Crosstab is: TRANSFORM Count(EmpLevel.EmpNo) AS CountOfEmpNo SELECT EmpLevel.EmpNo FROM EmpLevel GROUP BY EmpLevel.EmpNo...

heh, i do the same which is why the crappy ball mice and naff monitors that can't display a decent black or be ran at 1280x960 really bug me at work. oh access's stupid bug where if you align controls that are touching it screws it up.

if its a shared database you need to make sure your the only one in it if your making code changes!

for the shelling part: Private Type STARTUPINFO cb As Long lpReserved As String lpDesktop As String lpTitle As String dwX As Long dwY As Long dwXSize As Long dwYSize As Long dwXCountChars As Long dwYCountChars As Long dwFillAttribute As Long dwFlags As Long...

I prefer the way you've done it, although you might have problems if you have a long field description.

yea, i've given up on it:) I realized that even providing the add/save/delete type buttons wasn't really useful...oh the joys of UI design.

I have a sub form and I want to put add/delete/save record buttons on the parent form that work with the subform. Is this possible?

Thats the format I have (which is forced upon me because its imported from SAP) And in the query thats what i did, cept I added it 7 times to get the full chain of management. If this is wrong (and I knew it probly was but couldn't think of another way of getting to the result) how do I look at...

huh? I've got 7 possible levels of management. The data starts out as a single list, of everyone and their immediate manager (who's also in the list), I've done a query that expands this across providing a manager trail for each employee.

I have a organizational list of people and the people they report to. I've expanded it across so you get the manager trail ie person1, 1st mgr, 2nd mgr person2, 1st mgr, 2nd mgr, 3rd mgr, 4th mgr person3, 1st mgr, 2nd mgr, 3rd mgr Now I really want to know how many managers each person has...

linked tables shouldn't make a difference, dunno if using odbc would, doubtful though. Does it compile? are all the references correct?

I would normally, but I thought there was an availability issue with date? ie you can always use Now, but not always Date.

ok but then you say: then surely autonumber is fine, if your not bothered by the missing 56, then why does it matter that a few canceled records occur. Also are you sure thats the behaviour?, i thought that if you undo before the record is written no autonumber will be missed?

just use datediff("yyyy","01/01/" & BirthYear, Now) or maybe 01/06 would be more exact ish:)

there should be a four digit number too, and if you hold alt (or alt gr) and type the number (using the number pad) the character should appear.

more exactly: Set dbsNorthwind = currentdb at least I think thats what rich meant:)

I think I might, you want to know how much data you've yet to fill in. a simple way would to have a query that just selects the fields that are null then count the records in that query. the total systems - the total from the query would then be the number of systems with missing info. For...

Set dbsNorthwind = OpenDatabase("Northwind.mdb") wouldn't you need the full path to the northwind.mdb file in there?

just a curiosity question...but what is FoxPro? I know its a ms app, and from what I've seen it seems to be access but more 'developery' :) What would you use it for?

I've knocked up a very simple current user system, it aint nowt special but does it's job: Public Sub InDB() 'adds user to text file Dim sLines() As String, sLine As String, sFileName As String Dim iFNo As Integer, iC As Integer Dim bIn As Boolean sFileName = CurrentDb.Name sFileName =...