Recent content by snirben

you right, Thanks for the idea. about the system of orders and idea?

Hi Guys, Need your help. I build in access Program for my parents small company. And they want it to be in the way they works. So first let me explain a little bit, i have 3 tables 1. FirstRequest(Before it became a project it need to be a FirstRequest) 2. Project 3. Items i need to build...

Question You are subscribed to this thread Applies to Office Access Windows 10 Office 2016 3 views need help in data on access SYSnirben yossef asked on January 3, 2017See post history Hi guys, Problem 1: i have a form with TabControls inside one of the Tabcontrol i have other Tabconrol. and...

can you be more specifec on how i do that?

yes but the user dont know all of the products i have more then 1500 Items, i just want to open a popup form with the list and when the user duble click the item the id will copy to the ID Field in the Subfrom can it be possibale?

Hi Everyone, Need your help. i have a form with tabs and in one of the tab (page 41 index 1) there is a subform. the subform view is a spreadsheet, when i click on the "ID" in the Spreadsheet it opens up a another form as Popup with my list of Proudcts. here comes my question: i want to do...

Sry can you be more specific, i am new to access. you want me to add =Openargs to the code? or change the default value of the control you are looking to populate. you mean the "ID" in the Subfrom? but how can i make him take the ID from the form and past it on the ID in the open curret form...

Hi Guys, i need your help. I have a form with my products, Sort By ID,Maintype,Subtype,Kgm so i make in macro on "Dblclick" to take the id that have been chosen and past it to another form, The problem is , first it doesnt paste the ID in the subform of a form. Second my form is a subfrom...

still not working good, when i choose materials its changeing everything, and the subtype is allways the same,

i upload it. ok so i will try to explain what i am trying to do so i have a 3 tables Materials FirstRequest FirstRequestMat so i build a form with: NumberBid(from FirstRequest-FirstRequestMat) IDmat(IDMAT Linked to ID in Materials) MainType(From Materials) SubType(From Materials) kgm(From...

I have changed it to "MainType" i still get the same name as result and not the 2nd field can someone make a table with 3 things 1. Maintype 2. subtype 3. Kgm ID|MainType|SubType|kgm 1 IPE 100 10 2 IPE 30 3 3 IPE 5 1 4...

i did that, but still it opens a blank combobox. look it the code :

sry for driving you crazy, what should be in the Row Source in the Subtype combo? because that line of code didnt work.

this code worked for me : SELECT DISTINCT Materials.[Type], Materials.Type FROM Materials; but the subtype i cant get it to work, can you try to help me? (i have changed the table1 to my table)

Sry but i am new to access where do i put the "SELECT DISTINCT [Type] FROM Table1" in the combobox 1? like that?