Recent content by Surka

Thanks both

Good day, I am trying to make a filter form: 2 Combo box 1 subform with data to filter Problem: If I use OR in criteria it works, subforms gets populated. But if I use AND it does not work. Attached you will find an example with AND. If you select A and AR result should be A and AR. What...

Yes I need everything. Thanks JHB.

I am migrating my application from VBA to VB.Net, and a new problem appears. Access DB tables and fields: Users: ID_User, UserName Devices: ID_User, Device, WarrantyEnd With a 1 to Many Relationship, by ID_User on both tables. Example, of table and relationship: table Devices...

Dear all, I am working on a VB .Net project, with Visual Studio 2013. Currently I am using Windows Forms with the following design: MainForm with a MenuStrip and a TabControl. newUserForm, with controls in it to create a new user. I want to load the newUserForm on the TabContro, and...

GOT THE ANSWER: On Access 2007: I was trying to get the value from a Form on a Subfrom this ways: Like "*" & [Forms]![MainForm]![NavigationSubform].[Forms]![formSearch]![txtSearch] & "*" But the Query keep asking for an input. And all the different ways: With point and !, "Form" with S...

Any help on this? It seems to be a problem like when you have a path issue. Because the search form as a subform of the Navigation form (main form) pop up a message asking for data for the Query. But the same searchForm, opening directly, works.

So I have made all the necessary forms to start working with my Access, and now I need a main form, a home where I should put all the buttons to enter each form. What do you suggest? I have used the Navigation Control on a New form...

Yes, it makes sense. Employee inputs inquiries from people: Make a form with all the fields needed, which the employee will complete and save them into the table.

When you use the Query Wizard, it asks for a Source, there you should select the object from where you want to feed the Query

Yes, you are right. No need of an Array.

Empty textBox means end of data entry. To save information into an Array, and then work with it (use this information): what do you suggest? Information must enter into the Array one by one, and will exit when textBox is Blank. Thanks CJ

Good day! I want to save input into an Array, and then show this information. To enter data I am using a textBox. After "Enter" it should save info into the Array. If textBox is empty, it should show information. I would like to use a textbox too, that shows all the Array after pressing...

I realized I was adding fields onto the Query, and not on the query based listBox. Now it works, but it is difficult to add as many textbox as field are, and adding the code: =[SearchResults].[column](0) to each textbox. I do not know what column number is for each field. Is there a tidier way...

I tried that option but it did not work. I will try again because you name it.