Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.74 seconds.
Search: Posts Made By: isladogs
Forum: Tables Today, 04:57 AM
Replies: 11
Views: 121
Posted By isladogs
Re: Using access to store chemistry experiment results

The Excel file format you uploaded is exactly what your Access table should look like. It will be easy to import and you can easily add additional fields such as date when you do so. You can also...
Forum: General Today, 03:09 AM
Replies: 4
Views: 72
Posted By isladogs
Re: Issue with Relationships (I think)

Which field(s) are you using to link your main form & subform?
What is different about the data for ID=3 & ID=4?
Forum: Tables Today, 03:05 AM
Replies: 11
Views: 121
Posted By isladogs
Re: Using access to store chemistry experiment results

No problem
You can certainly do this in Access but with 3600 records for all your data
Forum: Tables Today, 02:29 AM
Replies: 11
Views: 121
Posted By isladogs
Re: Using access to store chemistry experiment results

Welcome to AWF

Whilst you could do this in Access it sounds like you want to create a giant spreadsheet.
Using Access, each temperature measurement (all 3600 of them) should be in a separate...
Forum: Introduce Yourself Yesterday, 11:34 PM
Replies: 6
Views: 61
Posted By isladogs
Re: New Here

Hi Joey
Welcome to AWF. Hope we can continue to help you
Forum: Queries Yesterday, 11:19 PM
Replies: 2
Views: 60
Posted By isladogs
Re: Query between dates on form fields and return all if left blank

There are indeed many threads on this subject.
Try looking at the similar threads at the bottom of this page e.g. https://www.access-programmers.co.uk/forums/showthread.php?t=220927

You could...
Forum: General Yesterday, 02:33 PM
Replies: 8
Views: 90
Posted By isladogs
Re: Unable to open front end

Not familiar with that phrase.
Does that mean you tried each of my suggestions with no success?
Forum: Forms Yesterday, 02:29 PM
Replies: 26
Views: 339
Posted By isladogs
Re: How to make a field mandatory

Yes. Its at the bottom of the Other tab on the property sheet

I really do recommend you look at my example database to understand how the Tag property can be used for various purposes.
The link...
Forum: Forms Yesterday, 01:50 PM
Replies: 15
Views: 153
Posted By isladogs
Re: Retrieve Data from a Subform VBA

Oops. I really should have noticed that MoveNext was missing.

Anyway, congratulations on fixing your problem
Forum: General Yesterday, 01:48 PM
Replies: 8
Views: 90
Posted By isladogs
Re: Unable to open front end

Try each of the following in turn. Hopefully one or more will work
First make a backup of what you have now! Just in case!

1. Hold the shift button down as you open the FE database
2. Decompile...
Forum: Forms Yesterday, 12:57 PM
Replies: 26
Views: 339
Posted By isladogs
Re: How to make a field mandatory

True but unnecessary. See Micron's answer in post #17.
Forum: Forms Yesterday, 12:15 PM
Replies: 15
Views: 153
Posted By isladogs
Re: Retrieve Data from a Subform VBA

That suggests your recordset is incorrect or empty.
What is the name of the subform container control on the main form?
It may not be the same as the subform name but that is what you need to use....
Forum: Forms Yesterday, 06:18 AM
Replies: 8
Views: 192
Posted By isladogs
Re: Form for entering grades for children

I have to agree.
There are many issues with your table structure including
1. It is a bad idea to have spaces or special characters such as - or # in table/form names or field names
2. You have...
Forum: Politics & Current Events 07-14-2019, 09:58 PM
Replies: 394
Views: 22,600
Posted By isladogs
Re: Antarctic sea ice is now DECLINING dramatically

Did you actually bother to read either of the articles I quoted before responding?
If so, please explain where there is bias in either article

Or are you implying that raw satellite data is...
Forum: SQL Server 07-14-2019, 09:48 PM
Replies: 6
Views: 112
Posted By isladogs
Re: Connection to ODBC - DSN issue

Do bear in mind that you will need to setup the ODBC connection on each workstation running your FE.

An alternative approach uses DSN less connections.
Possibly slightly trickier to setup the...
Forum: Forms 07-14-2019, 01:58 PM
Replies: 20
Views: 209
Posted By isladogs
Re: Browse to file location issues

I've added code tags to your last post to make it more readable

Arnel's code suggestion is what I would use for a standard file path.
Hyperlink datatype fields are problematic and in many...
Forum: Politics & Current Events 07-14-2019, 12:36 PM
Replies: 394
Views: 22,600
Posted By isladogs
Re: NASA Study Indicates Antarctica is Gaining More Ice Than It's Losing -

This was mainly a response to posts such as #382 & #383.

The research into changes in Antarctic sea ice over time was pure data and made no conclusions about cause or effect.
Just as the previous...
Forum: Politics & Current Events 07-14-2019, 06:25 AM
Replies: 394
Views: 22,600
Posted By isladogs
Re: Antarctic sea ice is now DECLINING dramatically

Thanks for responding to the research and for doing so without bringing in irrelevant political viewpoints.

I believe that detailed measurements only started in 1979 when satellite coverage made...
Forum: Forms 07-14-2019, 06:01 AM
Replies: 24
Views: 288
Posted By isladogs
Re: Why doesn't the label stay on your Form

Both of those are fairly significant benefits in my opinion;)

Also, in earlier versions, unassociated labels on a tab control were determined to be one of the causes of screen flicker. The advice...
Forum: Forms 07-14-2019, 01:58 AM
Replies: 24
Views: 288
Posted By isladogs
Re: Why doesn't the label stay on your Form

It was added to Access 365 in June 2017.
However you've always been able to associate unattached labels with a control.
Right click the label (or both label & control together) to see the context...
Forum: Forms 07-13-2019, 11:39 PM
Replies: 24
Views: 288
Posted By isladogs
Re: Why doesn't the label stay on your Form

For what its worth ...
1. If you just type a space into a label caption it will not be deleted.
2. To move a radio button label to the left of the button, drag its right border to the left of the...
Forum: Politics & Current Events 07-13-2019, 06:16 AM
Replies: 394
Views: 22,600
Posted By isladogs
Re: NASA Study Indicates Antarctica is Gaining More Ice Than It's Losing -

LOL :D

Interesting how nobody has chosen to respond to my last post stating the Antarctic sea ice has in fact been declining markedly for the past 5 years!
Forum: Forms 07-13-2019, 02:56 AM
Replies: 26
Views: 339
Posted By isladogs
Re: How to make a field mandatory

Hi
I've not got involved with this thread until now as you are receiving such expert assistance from Micron.
However as my approach has been referenced a couple of times, this is just to confirm...
Forum: Forms 07-12-2019, 10:07 PM
Replies: 8
Views: 192
Posted By isladogs
Re: Form for entering grades for children

Use two tables for this (possibly more) with fields similar to this

1. TblChild
ChildID - unique PK field
LastName
FirstName etc

2. TblCase
CaseID -unique PK field
ChildID - foreign key...
Forum: Forms 07-12-2019, 02:33 PM
Replies: 15
Views: 153
Posted By isladogs
Re: Retrieve Data from a Subform VBA

That's the third set of names you've used in this thread and I'm a bit lost.
Have you stepped though the code to see if its actually looping?
If not try adding the line .MoveFirst after the line...
Showing results 1 to 25 of 500

 
Forum Jump



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