Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 299
Search took 0.02 seconds.
Search: Posts Made By: Tera
Forum: General 11-19-2019, 05:00 AM
Replies: 23
[SOLVED] Single form
Views: 309
Posted By Tera
Re: Single form

I will use the queries suggested by June7 in #6 & #21 posts for a while to see the difference in performance.

Million thanks to June7 and Plog for putting their time on this and sharing their...
Forum: General 11-19-2019, 04:53 AM
Replies: 4
Views: 148
Posted By Tera
Re: Access new bug: Query '' is Corrupt.

Fix is available now. Opening Office on one of our pcs, I received a new update is ready to install.
Installing the update, fixed the error.

The other Pc didn't show this message. I simply...
Forum: General 11-19-2019, 12:11 AM
Replies: 4
Views: 148
Posted By Tera
Access new bug: Query '' is Corrupt.

I'm receiving the following error:

https://www.access-programmers.co.uk/forums/attachment.php?attachmentid=77520&stc=1&d=1574150034

The same FE is running on 12 PCs. Only two of them are...
Forum: General 11-18-2019, 10:32 PM
Replies: 23
[SOLVED] Single form
Views: 309
Posted By Tera
Re: Single form

Million thanks for your effort.
I edited above post too.

No error at all. it worked. But your last warning Be aware that Cartesian query can perform slowly with very large dataset. made me...
Forum: General 11-18-2019, 09:48 PM
Replies: 23
[SOLVED] Single form
Views: 309
Posted By Tera
Re: Single form

As far as I know, reports are used for printing the result. At this stage, I need a form to show when users search for an order to see which processes has been done, what's the next, if there's some...
Forum: General 11-18-2019, 03:21 PM
Replies: 23
[SOLVED] Single form
Views: 309
Posted By Tera
Re: Single form

This form is not meant to be for editing data. It's just a search result form to show the situation of orders. There are other forms for adding or editing data.


It's only a matter of formatting...
Forum: General 11-18-2019, 05:19 AM
Replies: 23
[SOLVED] Single form
Views: 309
Posted By Tera
Re: Single form

I'll follow your steps tomorrow as soon as I'm back to work just to learn something. But I don't think I'll use it. even if it could be used for forms. As I said we have more than a hundred thousand...
Forum: General 11-18-2019, 05:09 AM
Replies: 23
[SOLVED] Single form
Views: 309
Posted By Tera
Re: Single form

@vba_php
Thanks for your input. But June7 is correct about my needs.
As I explained I'm open to any suggestion as long as the result is similar to my forms shown above.

I'm at home and can't...
Forum: Introduce Yourself 11-18-2019, 03:33 AM
Replies: 6
Views: 135
Posted By Tera
Re: Hi folks

Welcome to AWF.
Forum: General 11-18-2019, 01:03 AM
Replies: 23
[SOLVED] Single form
Views: 309
Posted By Tera
Re: Single form

This is exactly why I was using a 1:1 relationship and didn't normalized the data. Because adding unnecessary records to tblRecProcess, will cause more than a million unnecessary records per year.
...
Forum: General 11-17-2019, 11:55 PM
Replies: 23
[SOLVED] Single form
Views: 309
Posted By Tera
Re: Single form

They want it to work like a check list.
Later a report like this will be printed and passed to the customer.
They want each order and it's details in above, and a list of all processes, which is...
Forum: General 11-17-2019, 10:21 PM
Replies: 23
[SOLVED] Single form
Views: 309
Posted By Tera
Single form

This is a simplified version of a database:

https://www.access-programmers.co.uk/forums/attachment.php?attachmentid=77500&stc=1&d=1574054982



tblOrders is used to register incoming orders....
Forum: General 11-14-2019, 03:02 PM
Replies: 31
Views: 502
Posted By Tera
Re: Useful links

isladogs, A while back I saw a link in one of your posts as an answer to someone.
I don't know if it's worth being mentioned in your site or not, but it kept me reading most of the articles.
I just...
Forum: The Watercooler 11-11-2019, 07:02 PM
Replies: 24
Views: 339
Posted By Tera
Re: usage of 1 to 1's and many to many's

Plog,
Thanks for your advice. When I was working on this database, I couldn't find a way to print a report that contains the necessary info as an output.
I'll give it try once again and will be...
Forum: The Watercooler 11-11-2019, 03:33 PM
Replies: 24
Views: 339
Posted By Tera
Re: usage of 1 to 1's and many to many's

I'm not a pro programmer, not even as good as most of members here. But I think you're wrong about 1-1 relationships.
A 1-1 relationship is used to break down a table with too many fields into 2...
Forum: The Watercooler 11-11-2019, 03:18 PM
Replies: 24
Views: 339
Posted By Tera
Re: usage of 1 to 1's and many to many's

Doc, not always true.
I've asked others to do things for me, just because I've been too busy to do it myself. And despite the fact that I could do it better, I had to ask someone to do it instead...
Forum: Introduce Yourself 11-09-2019, 05:34 AM
Replies: 3
Views: 69
Posted By Tera
Re: Back to MS Access

Glad to have you here.
Forum: Modules & VBA 11-08-2019, 03:08 PM
Replies: 7
Views: 132
Posted By Tera
Re: Recipient.Resolve method

Sorry, I had seen the post but didn't bother to test the code. My bad.
I think it works for me now.
I'll come back again if I find any problem concerning it.

PS: I owe you a beer. :)
Forum: Modules & VBA 11-08-2019, 07:28 AM
Replies: 7
Views: 132
Posted By Tera
Re: Recipient.Resolve method

Doc, I hope you don't mind adding one more question:

Is it possible to do the opposite?
I mean I give an address to .To and outlook resolve it to a name?


The reason:
I have a database which...
Forum: Modules & VBA 11-08-2019, 07:16 AM
Replies: 7
Views: 132
Posted By Tera
Re: Recipient.Resolve method

If I don't use this resolve method, outlook sends the mail anyway and my friend receives it. (As long as the same name exists in my address book). I've tried it several time. Is there any reason to...
Forum: Modules & VBA 11-08-2019, 06:43 AM
Replies: 7
Views: 132
Posted By Tera
Recipient.Resolve method

It may be a stupid question. But what does Recipient.Resolve method do when sending an email using outlook?

Thanks.
Forum: The Watercooler 11-08-2019, 03:26 AM
Replies: 16
Views: 254
Posted By Tera
Re: The global fertility crisis

The last time we had it in our news, it was 2 kids maximum. But there will be no limitation in near feature.

The next country that chasing China is India. They have a very high growth in...
Forum: The Watercooler 11-07-2019, 11:32 PM
Replies: 16
Views: 254
Posted By Tera
Re: The global fertility crisis

There was a time when over-population was thought would outpace economic development and imbalances environmental and natural resource. At school, we were taught how the population growth should be...
Forum: The Watercooler 11-07-2019, 05:47 AM
Replies: 15
Views: 362
Posted By Tera
Re: Microsoft Access is Dead!

Sorry for out of topic question. Can you post a link to the thread? My search doesn't bring it up.

thanks.
Forum: Queries 11-06-2019, 10:57 PM
Replies: 9
Views: 178
Posted By Tera
Re: Wildcard has me stumped

Sorry, it was a typo. I corrected it.
Showing results 1 to 25 of 299

 
Forum Jump



All times are GMT -8. The time now is 12:31 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