Search results

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.

Dear Santa, from a search form example I got from this forum I made the following: A listBox which shows results as you type, using a query. This listBox has 1 column, I need it that way. What I need is to show the information from the selected item of the listBox on a textBox, getting...

Yes, that confirms what a friend told me: to have one table, and as much as forms needed. Forms to Add, Modify, View, Delete. Knowing that Desktops have one column more than others, does it still better to have them in the same table?

For a DB for device stock, e g: Telephone, Desktop, Laptop: Is it better to have a table per type of device or one table for all devices with a Type column? This is an example of what field would be needed: Telephone: User, Serial Desktop: User, Serial, Name (name of desktop) Laptop: User...

I found this info: I am using a Union Query, is there a workaround with VBA? Check the code inside the db please

I created a new subform using the assistant. This way I have 2 forms: 1 main, the other one as a subform (with its properties showing up). If I just create the subform without assistant and without creating the form itself, then it wont show the subform properties.