Search results

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...

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...

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...

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...

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...

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...

Attached you will finde the db. How it works: You search for a User, and then you search for a Serial (thanks to a danish guy). Now, what if I want to edit the table? (inside the subform, the results). I added an openRecordSet, and Parameters, but I still get the error saying that Recordset...

Working with the attached mdb. I am trying to search inside the subform. First you should search for a "user", e g: a on the second textbox, for a serial number: m1 Using a second query, I would like to search the input from the secondbox (Like I did with the first textbox). Problem is...

[SOLVED] Form Appearance - Get rid of navigation bar from Subform I cannot get rid of the navigation bar from the subform. Navigation bar property from the subform is not appearing at Properties. Also, how do I remove the left column? Attached is a picture. Thanks, Surka.

Attached you will find an example with the problem. The query is only searching identical data between both tables. I want it to show results from all users, with all the devices each user has. What am I doing wrong with the query? Thanks, Surka.

I am new into Access, and was wondering how big an Access DB can be. Any information about that? Which was the biggest Access DB you know? How many records? Tables? I mean Access, not external Data Base connections. Thanks, Sur.

Dear all, I have multiple tables (Desktops and Telephones) A search form, to search into those tables (It searches by "User") The search form contains a listbox that shows results (listPC) And the following code: Option Compare Database Dim strUserPC As String, strUserTel As String Dim db As...