Search results

Hi, I guess it's something stupid, but I can't get through this. I get error wrong brackets .... Here is a code SELECT TAB_Wyroby.Indeks_wyr, [Wyr1]+[INQ_Czasy_wszystkie]![INQ_Czas_Ciecie.Wartosc] AS Wyr5 FROM ((((TAB_Wyroby LEFT JOIN INQ_Czas_Kontrola ON TAB_Wyroby.Indeks_wyr =...

Can I also ask you guys to help me with this problem? Thnx in advance Mark

Thanks Ken Preciate all your help, Regards Mark

Fair enough, thnx anyway, just for curiousity is there a way? or you just don't know Rich how did u guess? :p Regards

That's clear, but is it possible with combo and VBA, it's just that I always like to chalange with something and I reckon this looks better with combo. I might be subjective. :rolleyes:

hi, I am working on Project Database, The thing I want to achieve is to have a combo with a employees name for expample and be able to pick one and automaticaly store it in table, clear the combo and do the same with another employee. I'm getting something close with this code: Private Sub...

yep that's a good remark, I haven't thought about this, luckily I'll only use about 8 employees so you can pay attention who you pick ;) but it's not an option. It would be nice to worry about this having the first step. Mark

Ken, I'm at this stage already, I have a joined table with ProjectID and EmployeeID, I have also a subform with combo to pick Employee (source is set to Employee Table) When I have a form type set to continues I can have one than more employees per project, so that's the result I wanted to...

Hi Ken, Yep, name will be fine

Can I use something like that, or am I in completely wrong direction? Private Sub Employee_Click() Dim db As DAO.Database Dim rs As DAO.Recordset Dim lngCounter As Long Set db = CurrentDb Set rs = db.OpenRecordset("tblProjectEmployee") With rs For lngCounter = 1 To CLng(Me.Employee)...

back to a subject, I have found a thread that suits my situation almost 100%, http://www.access-programmers.co.uk/forums/showthread.php?t=19085&highlight=search+based+combo+box, my idea was to have the results back in the combo, I reckon I should have something like Me.myCombo.Requery in...

Hi, It works, but there is one more thing, when I have a sub form with employees working on specific project I have to use "continous form" in order to add more than one person per project. Is there a way to have "single form" and a piece of code or some sort of "save" button to pick somebody...

I'll test it tomorrow, I'm off home, Thnx for your help mate, I'll keep in touch tomorrow. Regards

The idea with one table is fine, however I still can't put more than one name under one projectID, I'm picking names from a combo. I reckon I should use some code to save value in a table and clean it afterwards to allow me to pick another name. No idea, how to do this, though. :confused:

I'll give it a go, let you know what happened :) Thnx

hi, I do have an employee table, but I haven't post it. I'll briefly describe the situation, the db that I am working on, suppose to be a project db, my idea was to have to table one with general info about the project containing: project id, description, company, who is in charge, start date...

sure, any help would be great ;)

Back to the subject, am I getting this correctly? Should I put a subform which will be linked with my querry?

I got some more idea about that, but still I would like to have the results in the third combo, I've read about similar case http://www.access-programmers.co.uk/forums/showthread.php?t=56018&highlight=InStr, but I don't get completely. Any help on that would be appreciated :confused:

Here is a piece of database that I have problem with :rolleyes: