Search results for query: *

Could you help me modify it PHV?? Thanks. Really appreciate it.

Hi PHV, I'm really useless at SQL. I've tired editing it several times but I can't get it to work. This is my current SQL for my report: SELECT tblStore.RefDate, tblStore.StoreID, tblStore.PartsID, tblStore.[BalanceAtStore(8AM)], tblStore.BadPartsReceived, tblRepaired.TechID...

Hi PHV, Still can't get the thing to work. Is there a way I can send you my database so that you can look for it? Or do you know how to open a report using a combo box with the record source tblDate.RefDate??? Thanks!

SELECT * FROM (tblDate D LEFT JOIN tblRepair R ON A.RefDate=R.Date) LEFT JOIN tblStore S ON A.RefDate=S.Date WHERE D.Date Between [Forms]![name of form]![txtDateFrom] And [Forms]![name of form]![txtDateTo] Just want to know whats : D , R ,A, and S. Sorry about that. Thanks PHV

To dhookom, Is there another way to link the dates without creating a table for dates? Thanks To PHV, Where do I write the code in?Thanks

HI All, Now I'm trying to link the dates for 3 tables tblDate, tblStore and tblRepair. So far I've tried this approach: tbl Date tblRepair RefDate Date Date RepairID PartsID Repaired TechID 1 1/26/2005 1 1 cable 3 John 2...

Hi, Just want to find out how to create an autonumber field from 1 to 100. Any ideas??

Hi All, This is basically what my database looks like. It's a bit messy. Just wondering whether anybody could give any advice on how to improve it. Basically what I want to see is who repairs(TechID) the parts(PartsID) and on what date and later link the TechID,PartsID and...

Hi All, This is basically what my database looks like. It's a bit messy. Just wondering whether anybody could give any advice on how to improve it. Basically what I want to see is who repairs(TechID) the parts(PartsID) and on what date and later link the TechID,PartsID and...

Is there a way I can clear the data in a textbox without coding???

It's okay guys. I got it working already. Thanks fiep, GingerR,PHV and RoyVidar for all your advice. It really helped me.

Okay I think I managed to fix the problem. But now its not saving it into the field Findings. Do I need to make an update command button to update it?? And if so, how do I do it??

Is there an example for this type of problem? Sorry I confused all of you.

Oh that was what Finding was. I thought it was a field where I saved the data in. But after I changed StrFound to String it says "The value you entered isn't valid for this field" Hmm is there any way I can share my Access file with you all? So that everybody can see it???

Now it keeps on saying "Type Mismatch". I thought it was because I referenced the findings as follows RefFind Findings 1 part A stuck 2 part B not working (etc) and it only reads the RefFind. So I changed StrFound to an Integer. But its not working. Any ideas...

Hey Fiep, Can you explain to me how your code works. Thanks.

Does anybody know how a variant works. Because I think thats what varItm is.

Thanks RoyVidar and GingerR, I think I'll stick to my initial plan. But can anybody explain to me fiep's code, like where they are all linked to. Especially 1.varItm 2.Me.SelectionList.ItemsSelected 3.Me.SelectionList.ItemData(varItm)

To RoyVidar, Using your way I have to key in the problems one by one and that will be very inconvenient for the user. (Eg. Machine1 - part A not working Machine1 - part B stuck Machine1 - part C not working What I want to do now is combine all this problems together. eg. Machine1 - partA...

Do you mean I have to create a listbox and store this code into it??? Thanks.