Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 363
Search took 1.42 seconds.
Search: Posts Made By: Mihail
Forum: Forms 12-22-2014, 10:57 PM
Replies: 9
Views: 834
Posted By Mihail
Re: Form to add field data to an existing table row

A very useful link:
Database Normalization and Table Structures - Microsoft Access / VBA (http://bytes.com/topic/access/insights/585228-database-normalization-table-structures)

I wish all the...
Forum: Modules & VBA 11-06-2014, 10:57 PM
Replies: 4
Views: 423
Posted By Mihail
Re: list forms subforms and recordsource

http://www.consultdmw.com/access-VBA-list-objects.htm
Forum: Forms 11-03-2014, 06:18 AM
Replies: 8
Views: 1,906
Posted By Mihail
Re: Word to Access Export

Something that I never tray but I'm pretty sure that work: a database in Access (tables, relationships, forms etc) linked to an Word document.
The DB should update the "fields" in Word.
Forum: Forms 11-02-2014, 04:08 AM
Replies: 1
Views: 424
Posted By Mihail
Re: Open form to first matching record?

http://msdn.microsoft.com/en-us/library/windows/desktop/ms677527%28v=vs.85%29.aspx
Forum: Forms 10-29-2014, 10:10 AM
Replies: 11
Views: 911
Posted By Mihail
Re: Record lock

As far as I can think, is not possible to unlock only one record in a form that display more records (a continuos form). I repeat: as far as I know.
On the other hand I'm sure that it is possible to...
Forum: Forms 10-27-2014, 07:49 AM
Replies: 11
Views: 911
Posted By Mihail
Re: Record lock

More condensed, your code can be replaced with:

Me.Form.AllowDeletions = Not Me.Editlock
Me.Form.AllowEdits = Not Me.Editlock
Forum: Tables 10-26-2014, 03:59 AM
Replies: 10
Views: 740
Posted By Mihail
Re: Tables/Fields issue

no No and NO ! Don't do this.
Seems that a Cross Tab query should do the trick.
Forum: Reports 10-25-2014, 11:18 PM
Replies: 2
Views: 491
Posted By Mihail
Re: Template from Word?

I see many times this question. As far as I know the answer is NO.
But, depending of your needs, can be an work around (I think :) ) :
Take a screenshot, use a bit of Photoshop then put the picture...
Forum: General 10-25-2014, 11:06 PM
Replies: 1
Views: 2,281
Posted By Mihail
Re: (MSComCtl2.MonthView.2)

You can find yourself: Do a search in the old computer (only the Windows folder) and find the location. Should be the same in the new one. In my computer the file is in C\Windows\System32 folder.
Forum: Introduce Yourself 10-24-2014, 09:27 AM
Replies: 1
Views: 267
Posted By Mihail
Re: New Member Introduction

Welcome aboard !
Hope you will gain help from us.
Forum: Forms 10-24-2014, 09:07 AM
Replies: 11
Views: 911
Posted By Mihail
Re: Record lock

Not sure what you intended to do but from your explanation the AllowDeletions property of the form should do the trick.
So create a button for record deletion.
When this is pressed ask for...
Forum: Modules & VBA 10-23-2014, 12:30 AM
Replies: 5
Views: 1,048
Posted By Mihail
Re: Code to autofit Excel hangs

Hi.
Not sure but, in my opinion should work from Access. (From Excel work for sure)
http://www.vbaexpress.com/kb/getarticle.php?kb_id=339
Forum: Reports 10-20-2014, 09:30 PM
Replies: 3
Views: 588
Posted By Mihail
Re: Enter parameter value again

A report don't contain fields. Just controls. So, "echEmployee" is the name of the control in your report. So, try the same syntax as in your first code:
="[eEmployeeID]=" & [eEmployeeID]
Forum: Queries 10-18-2014, 05:11 AM
Replies: 2
Views: 1,547
Posted By Mihail
Re: how to calculate current stock

The real answer for you is here:
Database Normalization and Table Structures - Microsoft Access / VBA (http://bytes.com/topic/access/insights/585228-database-normalization-table-structures)
or in...
Forum: Other Software 10-18-2014, 03:59 AM
Replies: 2
Views: 3,381
Posted By Mihail
Re: Silent installation of Access Runtime 2007

While I have no idea about the italic part I have a very good idea (believe me: is VERY good) about the bold part:
Let's simulate a dialog between you (the Programmer) and the User:
P) Why you...
Forum: Queries 10-15-2014, 10:32 AM
Replies: 9
Views: 564
Posted By Mihail
Re: do i need a query or report?

While themurph2000 help you with this certain DB try also to help itself by reading about databases; what are and how it works.
Start by learning about normalization. After you will fully understand...
Forum: Queries 10-14-2014, 07:20 PM
Replies: 3
Views: 307
Posted By Mihail
Re: Building a Query for a Report - Combobox

OK. Maybe my English make a jock with me :) .
Here: Beginner Advice for a Family Database - Access World Forums (http://www.access-programmers.co.uk/forums/showthread.php?t=258024)
you will see a...
Forum: Queries 10-14-2014, 10:49 AM
Replies: 6
Views: 520
Posted By Mihail
Re: Query - export to text file format

Rectification:
You can NOT create the text file. You can EXPORT as text file :) . It is not the same thing.

Here (see the attachment) is how you can really create a text file.
Hope this will be...
Forum: Modules & VBA 10-13-2014, 10:22 AM
Replies: 8
Views: 1,841
Posted By Mihail
Re: Compile Error: Invalid Qualifier

Hm :)
ctrler is a STRING

Dim users As Control
Dim ctrler As String
Dim xx As Long

.and a string can't be visible or invisible.

So, if your text box is named also "ctrler" change one of...
Forum: General 03-20-2014, 04:27 AM
Replies: 3
Views: 680
Posted By Mihail
Re: Setting up a database for dealers

Read, very carefully, this:
Database Normalization and Table Structures - Microsoft Access / VBA (http://bytes.com/topic/access/insights/585228-database-normalization-table-structures)
Forum: Reports 03-12-2014, 06:36 AM
Replies: 6
Views: 695
Posted By Mihail
Re: Adding Text To A Report

Add a LABEL with commas.
Forum: Reports 03-10-2014, 09:31 AM
Replies: 11
Views: 863
Posted By Mihail
Re: Preventing negative numbers in report

Because OURS "<=" is different from YOURS ">="
Take a look to the IIF() function syntax.
Forum: Reports 03-08-2014, 01:13 AM
Replies: 4
Views: 483
Posted By Mihail
Re: Keep two sections together on one page

I think that you have "New Page" activated for the section.
If this is the case then remove this setting. Now you should have a continuos report.
As far as I know it is not possible to say to...
Forum: Reports 03-08-2014, 12:39 AM
Replies: 11
Views: 863
Posted By Mihail
Re: Preventing negative numbers in report

I've edited my previous post. Sorry (should be <=90 as JDraw said).

Yes JDraw. It work as Control Source.
Forum: Reports 03-07-2014, 12:09 PM
Replies: 11
Views: 863
Posted By Mihail
Re: Preventing negative numbers in report

IIF(Datediff("d"[Retest Date],Now()) <= 90, 0, Datediff("d"[Retest Date],Now()))
Showing results 1 to 25 of 363

 
Forum Jump



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


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

Featured Forum post


Sponsored Links


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