Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 41
Search took 0.01 seconds.
Search: Posts Made By: Surka
Forum: Queries 07-15-2014, 01:14 PM
Replies: 6
Views: 561
Posted By Surka
Forum: Queries 07-15-2014, 12:14 PM
Replies: 6
Views: 561
Posted By Surka
Question Criteria: OR works, AND does not works

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....
Forum: Queries 12-31-2013, 03:49 PM
Replies: 3
Views: 471
Posted By Surka
Re: 1 to Many Query

Yes I need everything.

Thanks JHB.
Forum: Queries 12-29-2013, 10:18 PM
Replies: 3
Views: 471
Posted By Surka
Question 1 to Many Query

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...
Forum: VB.NET 12-26-2013, 09:49 PM
Replies: 0
Views: 5,534
Posted By Surka
Question Load form on TabControl

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.
...
Forum: Forms 11-24-2013, 11:27 PM
Replies: 2
Views: 1,369
Posted By Surka
Re: Navigation Form - Main Form buttons - Problem with Query

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] & "*"...
Forum: Forms 11-24-2013, 12:31 PM
Replies: 2
Views: 1,369
Posted By Surka
Re: Navigation Form - Main Form buttons - Problem with Query

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....
Forum: Forms 11-23-2013, 07:43 PM
Replies: 2
Views: 1,369
Posted By Surka
Question Navigation Form - Main Form buttons - Problem with Query

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...
Forum: Forms 11-23-2013, 07:30 PM
Replies: 6
Views: 590
Posted By Surka
Re: Basic Form questions

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.
Forum: Reports 11-23-2013, 07:25 PM
Replies: 4
Views: 849
Posted By Surka
Re: Pass Listbox parameters to pull multiple separate reports

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
Forum: Modules & VBA 11-23-2013, 02:02 PM
Replies: 4
Views: 757
Posted By Surka
Re: Save info into an Array and show this Array - Using Form

Yes, you are right. No need of an Array.
Forum: Modules & VBA 11-23-2013, 12:01 PM
Replies: 4
Views: 757
Posted By Surka
Re: Save info into an Array and show this Array - Using Form

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,...
Forum: Modules & VBA 11-23-2013, 09:28 AM
Replies: 4
Views: 757
Posted By Surka
Question Save info into an Array and show this Array - Using 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...
Forum: Queries 11-22-2013, 10:17 PM
Replies: 4
Views: 874
Posted By Surka
Re: Get information from selected item of ListBox

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:...
Forum: Queries 11-22-2013, 10:03 PM
Replies: 4
Views: 874
Posted By Surka
Re: Get information from selected item of ListBox

I tried that option but it did not work. I will try again because you name it.
Forum: Queries 11-22-2013, 09:09 PM
Replies: 4
Views: 874
Posted By Surka
Question Get information from selected item of ListBox

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....
Forum: Theory and practice of database design 09-15-2013, 07:27 PM
Replies: 4
Views: 881
Posted By Surka
Re: Doubt: 1 table per device or a single table?

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...
Forum: Theory and practice of database design 09-15-2013, 05:16 PM
Replies: 4
Views: 881
Posted By Surka
Exclamation Doubt: 1 table per device or a single 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...
Forum: Forms 09-14-2013, 11:19 PM
Replies: 2
Views: 595
Posted By Surka
Re: Update subform - Recordset error

I found this info:



I am using a Union Query, is there a workaround with VBA? Check the code inside the db please
Forum: Forms 09-14-2013, 10:59 PM
Replies: 7
Views: 2,538
Posted By Surka
Re: Form Appearance - Get rid of navigation bar from Subform

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...
Forum: Forms 09-14-2013, 10:39 PM
Replies: 2
Views: 595
Posted By Surka
Question Update subform - Recordset error

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...
Forum: Queries 09-14-2013, 10:13 PM
Replies: 8
Views: 856
Posted By Surka
Talking Re: Run a second query on 1 Subform

:banghead:My bad , now I read the query again and understood it. WHERE statement with the AND is the key. It searches for data which is ok with both conditions (txtSerial and txtUser).

Thanks!
Forum: Queries 09-14-2013, 11:54 AM
Replies: 8
Views: 856
Posted By Surka
Re: Run a second query on 1 Subform

And why the results are from the user searched before and not from every user?
Thanks.
Forum: Queries 09-12-2013, 08:56 PM
Replies: 8
Views: 856
Posted By Surka
Thumbs up Re: Run a second query on 1 Subform

You did understand. At least it does what I need. Could you explain it to me?

I do not understand the following:
SELECT ALL Monitor.User, "Monitor" AS Devices, Monitor.Serial
FROM Monitor...
Forum: Forms 09-12-2013, 10:48 AM
Replies: 7
Views: 2,538
Posted By Surka
Re: Form Appearance - Get rid of navigation bar from Subform

But as you can see, the subform is blank. I added the subform from control>subform (without assistant).
Showing results 1 to 25 of 41

 
Forum Jump



All times are GMT -8. The time now is 05:48 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World