Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 6.21 seconds.
Search: Posts Made By: jdraw
Forum: General Yesterday, 04:00 PM
Replies: 7
Views: 77
Posted By jdraw
Re: Limitations

As others have advised the 2GB limit is real. Stored images eat up space; better to store paths to files on filesystem.



I don't see where/how java would be involved. You could move to SQL...
Forum: Queries Yesterday, 02:35 PM
Replies: 16
Views: 199
Posted By jdraw
Re: Match Word in Sentence

mtl021,

???This is what you said earlier
Forum: Queries Yesterday, 04:53 AM
Replies: 16
Views: 199
Posted By jdraw
Re: Match Word in Sentence

Can you show us, based on your sample data, what you want as a final result?
Also, where do you handle the match being 7 or more characters?

Perhaps the following: ( also exposes the length of...
Forum: Modules & VBA 09-17-2018, 03:07 PM
Replies: 15
Views: 181
Posted By jdraw
Re: Add Multiple New Records to a Existing Table

jdlewin1,

Can you tell us about the business behind your proposed database/approach?
Along the lines of a "typical day at the office"?

We need to know WHAT before deciding HOW.

And I don't...
Forum: General 09-16-2018, 04:00 AM
Replies: 9
Views: 414
Posted By jdraw
Re: Shared database with multi users

You may find more info and examples/articles using Google.
Here is some info from FMS1 (https://www.fmsinc.com/microsoftaccess/DatabaseSplitter/), FMS2...
Forum: General 09-14-2018, 05:42 PM
Replies: 4
Views: 398
Posted By jdraw
Re: Created by & modfied by

There is a youtube video here on recording who created or modified a record and when (https://www.youtube.com/watch?v=AnaEZnjfYz4)that may be helpful. It uses data macros.
Forum: Forms 09-14-2018, 04:30 AM
Replies: 7
Views: 108
Posted By jdraw
Re: show a value from another table in a form

@Programming,

I think you are confusing WHAT and HOW. You and readers need a clear description of the requirement in simple English. This is the WHAT (I'm trying to accomplish). With that clear...
Forum: Queries 09-14-2018, 04:14 AM
Replies: 4
Views: 85
Posted By jdraw
Re: Show Xth character in a string

You do check to ensure you have "noreq" or more characters, right?

Len(stringToSearch) >= noReq
Forum: Introduce Yourself 09-12-2018, 12:05 PM
Replies: 3
Views: 97
Posted By jdraw
Re: Good Morning

Welcome Stuart.

This video series by Steve Bishop (https://www.youtube.com/playlist?list=PLYMOUCVo86jEeMMdaaq03jQ_t9nFV737s) is one of the best I've found.

Also, when searching and reviewing...
Forum: Modules & VBA 09-12-2018, 10:14 AM
Replies: 3
Views: 79
Posted By jdraw
Re: Needing to calculate percentage in Form

Please show and/or tell us what Query1 and Query2 represent in your set up.
Forum: Forms 09-12-2018, 05:38 AM
Replies: 11
Views: 167
Posted By jdraw
Re: Goto Random record in forms

I think Rnd will give you a random number between 0 and 1 (my guess).
Since Offset will be an integer/long integer you will need to Fix(rnd) to get a real record offset.
You might want to create a...
Forum: Forms 09-12-2018, 05:24 AM
Replies: 11
Views: 167
Posted By jdraw
Re: Goto Random record in forms

What does this code actually do? What is the result of executing this proc?
Forum: Macros 09-11-2018, 05:07 AM
Replies: 3
Views: 143
Posted By jdraw
Re: Audit Trail With Table Level Data Macro Question

There is a database late in that thread. It is my only use of data and named macros.
There is very limited info on these based on my searching/googling.
Good luck.


UPDATE: I looked at your...
Forum: Macros 09-11-2018, 04:40 AM
Replies: 3
Views: 143
Posted By jdraw
Re: Audit Trail With Table Level Data Macro Question

You may get some insight from this thread on Best Use of Macros (https://access-programmers.co.uk/forums/showthread.php?p=1559127&highlight=data%2Amacro#post1559127)

There are errors in your...
Forum: Forms 09-10-2018, 06:43 AM
Replies: 16
Views: 169
Posted By jdraw
Re: Data entry form / Combo box error

??
a table with a list of projects
..name of the project and time.

You mention Project, but the table is Coop???
Forum: Modules & VBA 09-09-2018, 04:53 AM
Replies: 2
Views: 109
Posted By jdraw
Re: Dim Function

Maas8000,

Further to NG's advice, is the userLogin really an Integer, not text??
Forum: Queries 09-06-2018, 04:41 PM
Replies: 18
Views: 254
Posted By jdraw
Re: Sequential week numbering between dates

Indigo,

Show us the code you ran. The examples Markk provided had the arithmetic inside an INT() function and should not have decimal places in the result.
Forum: Queries 09-06-2018, 05:31 AM
Replies: 12
Views: 142
Posted By jdraw
Re: Query Criteria looking for circa 270 values

I have to go out for a few hours but here is what I'd try (untested but for consideration)

You could have 2 helper tables

SitesReqd and StockItemReqd

where
SitesReqd has 1 field SiteID...
Forum: Queries 09-06-2018, 05:06 AM
Replies: 12
Views: 142
Posted By jdraw
Re: Query Criteria looking for circa 270 values

Ok, give us a sample of the real data with field and table name.


You may find this approach via Bob Larson (https://www.access-programmers.co.uk/forums/showthread.php?t=195749) of interest.
Forum: Queries 09-06-2018, 04:39 AM
Replies: 12
Views: 142
Posted By jdraw
Re: Query Criteria looking for circa 270 values

It seems you would have a structure along the lines of

Site----->SiteStockItem<-----StockItem
Forum: Queries 09-06-2018, 03:49 AM
Replies: 12
Views: 142
Posted By jdraw
Re: Query Criteria looking for circa 270 values

Jason,

Can you be more specific? An example of a few Sites and StockItems might help clarify your requirement. Are your tables "normalized...
Forum: Queries 09-05-2018, 12:13 PM
Replies: 5
Views: 126
Posted By jdraw
Re: Stop access thinking I'm using a wildcard

I mocked up a table as follows

https://access-programmers.co.uk/forums/attachment.php?attachmentid=71869&stc=1&d=1536179964
with this query
SELECT Departments.*, Departments.Departmentname
FROM...
Forum: Queries 09-03-2018, 07:40 PM
Replies: 6
Views: 149
Posted By jdraw
Re: Append Query with mulitple select queries

Wayne agreed.

I was hoping the OP would read these, then try the example.
(from w3schools)
The UNION operator is used to combine the result-set of two or more SELECT statements.

Each...
Forum: Queries 09-03-2018, 07:36 PM
Replies: 4
Views: 150
Posted By jdraw
Re: query snag - help needed

As has been suggested, your tables may not be cover your business requirements.
Here is a link to a data model (http://databaseanswers.org/data_models/customers_and_invoices/index.htm)...
Forum: Queries 09-03-2018, 12:22 PM
Replies: 6
Views: 149
Posted By jdraw
Re: Append Query with mulitple select queries

kobiashi,

Details of union query and example from w3schools (https://www.w3schools.com/sql/sql_union.asp)
Showing results 1 to 25 of 500

 
Forum Jump



All times are GMT -8. The time now is 02:31 AM.


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