Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 1.77 seconds.
Search: Posts Made By: jdraw
Forum: Forms Today, 11:05 AM
Replies: 6
Views: 15,449
Posted By jdraw
Re: Move existing objects into tab control

For anyone landing here--this is a "continuation" of an 8 year oldpost...
but 'linq has a solution.
Forum: Reports Today, 10:10 AM
Replies: 13
Views: 269
Posted By jdraw
Re: Report from filter form

I am glad you are grateful and have a solution.
I am also orange on the access net site.

Good luck with your project.
Forum: Reports Today, 09:39 AM
Replies: 13
Views: 269
Posted By jdraw
Re: Report from filter form

tihmir,
No problem. We are all learning.
Good luck with your project.

Did the answers on the cross posted site not provide a solution?
Forum: Reports Today, 08:05 AM
Replies: 13
Views: 269
Posted By jdraw
Re: Report from filter form

Cross posted at http://www.accessforums.net/showthread.php?t=74885

tihmir,
I realize you are new here, welcome.

However, there are some general points of netiquette on all forums. And one of...
Forum: General Today, 05:49 AM
Replies: 7
Views: 149
Posted By jdraw
Re: Multidimentional const ???

Glad you have a solution.
Forum: General Today, 05:06 AM
Replies: 7
Views: 149
Posted By jdraw
Re: Multidimentional const ???

ksor,

Perhaps you could give us some details surrounding your request. It seems you're working with some format (??json??), but we know nothing of your requirements other than
.

I suggest you...
Forum: General Yesterday, 07:09 PM
Replies: 7
Views: 149
Posted By jdraw
Re: Multidimentional const ???

Why not a table?

TblXXX
id
fld1
fld2

where records are like
id contains 1
fld1 contains "BILLEDE"
Forum: Forms Yesterday, 04:20 PM
Replies: 4
Views: 96
Posted By jdraw
Re: Converting Database to French

Pallem,

You may find a sample or an approach here (https://www.microsoftaccessexpert.com/Microsoft-Access-Multi-Language-Database.aspx). I am not familiar with the vendor; found it via Google.
...
Forum: General Yesterday, 02:17 PM
Replies: 11
Views: 191
Posted By jdraw
Re: Linking ComboBox colums to Labels/Images

Shadoz,

Has your employer given you any details for this floor tool?
Do you need real floor plan, or could a generic grid for each floor suffice?
Can you add on to the existing 911 system? A...
Forum: Macros 12-14-2018, 12:15 PM
Replies: 4
Views: 177
Posted By jdraw
Re: Printout steps within a macro?

I don't use macros generally. I did some experimenting with named data macros (https://access-programmers.co.uk/forums/showpost.php?p=1559242&postcount=14) and here is what I used to see the source...
Forum: General 12-14-2018, 07:51 AM
Replies: 9
Views: 132
Posted By jdraw
Re: Database Structure

moodhi,

I think you are confusing table structure, user interface and outputs (forms/reporting).
These are separate things and do need to be considered, but there is a sequence/cycle to...
Forum: General 12-14-2018, 06:09 AM
Replies: 9
Views: 132
Posted By jdraw
Re: Database Structure

moodhi,
Further to plog's comments I suggest you write a description in plain English based on a "Day at the Office" to give readers (and you) a reference to all of the "things/entities" in context....
Forum: Modules & VBA 12-13-2018, 07:50 AM
Replies: 8
Views: 208
Posted By jdraw
Re: Alter a table's Data Type based on the data within the field

gblack,

Can you describe in simple terms why you need this? It seems you could concoct a table- and MajP seems to have a solution -- but that table could have a different structure every time you...
Forum: Tables 12-07-2018, 10:18 AM
Replies: 19
Views: 1,583
Posted By jdraw
Re: SUM does not return a value

I'm not sure what you are tying to do nor what you have tried. I changed the format of fields to Double rather than Decimal (after a warning that the field was too small)

SELECT Sum([Copy Of...
Forum: General 12-07-2018, 10:08 AM
Replies: 10
Views: 370
Posted By jdraw
Re: Project Database Design

jjake,

Here are a few questions that may help in scoping your project and designing the database.

What equip do we have currently
What equip do we need to purchase
What equip have we...
Forum: General 12-07-2018, 07:36 AM
Replies: 10
Views: 370
Posted By jdraw
Re: Project Database Design

jjake,

It seems you are working with physical database and user interface options. As plog has suggested, you really have to get your tables designed to meet your business needs.
Here is a link...
Forum: Tables 12-07-2018, 07:14 AM
Replies: 19
Views: 1,583
Posted By jdraw
Re: SUM does not return a value

Nancy,

See this from Allen Browne re Calculated Fields (http://allenbrowne.com/casu-14.html)

Also, Pat's recommendations on naming convention are important.

Good luck.
Forum: Tables 12-07-2018, 04:03 AM
Replies: 19
Views: 1,583
Posted By jdraw
Re: SUM does not return a value

Nancy,

Can you provide some sample data, or a database with a few records so readers can review the issue?
Forum: Modules & VBA 12-06-2018, 05:01 AM
Replies: 8
Views: 263
Posted By jdraw
Re: Custom cancel button not quite working

Bloodlvst,

Can you explain why you want an explicit Save button? I'd like to see the requirement for it.
In most cases the form BeforeUpdate event is the last spot to check for "valid values"....
Forum: Queries 12-05-2018, 09:59 AM
Replies: 17
Views: 366
Posted By jdraw
Re: Performance Question - name search

Thanks. Good luck with your project.
Forum: Queries 12-05-2018, 09:29 AM
Replies: 17
Views: 366
Posted By jdraw
Re: Performance Question - name search

I don't mean to wander off topic here, but your intro said
..
which makes me wonder how a user can identify which record they need when the spellings and formats may differ and be...
Forum: Queries 12-05-2018, 08:51 AM
Replies: 17
Views: 366
Posted By jdraw
Re: Performance Question - name search

I' sure it's primarily the 4 Ghz processor that's accounting for the speed.
No indexing when using leading wildcard.

For clarity, you are searching names and addresses, but what do you do with...
Forum: Queries 12-05-2018, 08:07 AM
Replies: 17
Views: 366
Posted By jdraw
Re: Performance Question - name search

???2 million records with leading wildcard???
How do you resolve duplicates/replicates?
What processor etc are you using?
Forum: Queries 12-05-2018, 06:54 AM
Replies: 17
Views: 366
Posted By jdraw
Re: Performance Question - name search

Independent of the initial search strategy, I would suggest devising a "standard method" for storing such names if you plan on using this database in future. Having an ad hoc name formatting and...
Forum: Tables 11-29-2018, 10:28 AM
Replies: 19
Views: 1,583
Posted By jdraw
Re: SUM does not return a value

??? Not following...
Here is a link to syntax and examples of SQL SUM (https://www.w3schools.com/SQl/sql_count_avg_sum.asp)
Showing results 1 to 25 of 500

 
Forum Jump



All times are GMT -8. The time now is 08:47 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 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World