Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.30 seconds.
Search: Posts Made By: isladogs
Forum: General Today, 03:55 AM
Replies: 1
Views: 7
Posted By isladogs
Re: Import csv with US regional settings

Import the data to a buffer or staging table as an intermediary step.
Process it to convert the data to your local setting.
Import the processed data to your final table
Empty the buffer table...
Forum: Forms Today, 03:38 AM
Replies: 10
Views: 123
Posted By isladogs
Re: How to populate a text box and field based on combo box value?

Minty guessed correctly.
You should never have lots of similarly named fields.
Your design gives few records, lots of fields and lots of problems.
If you ever need a Staff8 the table needs...
Forum: Modules & VBA Today, 03:29 AM
Replies: 1
Views: 18
Posted By isladogs
Re: Editing tables but also keep original data

Do not allow any user access to the tables or queries. Hide the navigation pane.
All interaction should be via forms.

Up to you whether you let admin add or edit existing records.
Don't allow...
Forum: Queries Today, 03:19 AM
Replies: 5
Views: 53
Posted By isladogs
Re: Include al records from- but limit to linked table

You're welcome but an even simpler solution may be to change the outer joins to inner joins and remove all the Is Not Null filters.

SELECT [SB/AD Master].Category, [SB/AD Master].[Aircraft Type],...
Forum: Queries Today, 02:18 AM
Replies: 5
Views: 53
Posted By isladogs
Re: Include al records from- but limit to linked table

That's what I thought & my suggestion should give you exactly that

SELECT [SB/AD Master].Category, [SB/AD Master].[Aircraft Type], [SB/AD Master].Series, [SB/AD Master].Index, [SB/AD...
Forum: Forms Today, 01:47 AM
Replies: 10
Views: 123
Posted By isladogs
Re: How to populate a text box and field based on combo box value?

As already stated use the Column property of your combo which should have 3 columns : StaffID (bound); StaffName; HourlyRate.
Make the column widths 0cm;2.5cm;0cm or similar so the StaffName is...
Forum: Queries Today, 12:50 AM
Replies: 5
Views: 53
Posted By isladogs
Re: Include al records from- but limit to linked table

Your description is a little confusing
Sounds like you need to change filter criteria to: Is Not Null.

As mentioned in a previous thread, you really need to sort out your table structure. Add PK...
Forum: Queries Yesterday, 07:35 AM
Replies: 10
Views: 244
Posted By isladogs
Re: sql syntax for delete query

Just one final thing in case its helpful to you / anyone else:
I have updated my website article on synchronising data with a lot of additional information and corrections to a couple of errors
...
Forum: Queries Yesterday, 03:47 AM
Replies: 10
Views: 244
Posted By isladogs
Re: sql syntax for delete query

Have you tried it (on a backup)
The best way to find out is often trial and error
Forum: Queries Yesterday, 02:57 AM
Replies: 10
Views: 244
Posted By isladogs
Re: sql syntax for delete query

Trying to work with NULLS isn't easy.
You may remember that I wrote the following in another thread



If that doesn't help, please post your database with both tables including some records...
Forum: Tables Yesterday, 02:37 AM
Replies: 28
Views: 622
Posted By isladogs
Re: Repeated Autonumber Gremlins

Sorry about that. I made a complete pig's ear of this .... :o

Going back to the article by Allen Browne, I've since been trying to replicate his comments about negative autonumbers. I've no idea...
Forum: Queries Yesterday, 02:25 AM
Replies: 19
Views: 300
Posted By isladogs
Re: iff issue with Like "*"

It rarely helps to try and simplify the code used and I think this proves that point.

Perhaps JHB has already given you the info you need. If not, we need more info
I've no idea what your...
Forum: Queries Yesterday, 01:57 AM
Replies: 19
Views: 300
Posted By isladogs
Re: iff issue with Like "*"

Congratulations.
That is the most convoluted and pointless WHERE filter I've seen in a long time
The IIf statement has three parts: IIF(Condition to check, result if true, result if false)

Your...
Forum: Forms 01-14-2019, 04:46 PM
Replies: 2
Views: 137
Posted By isladogs
Re: Conditional Formatting Rows 'highlighting'

Yes you can highlight just one row in a continuous form using the sort of approach you were describing
For example, see this emulated split form ...
Forum: Tables 01-14-2019, 02:40 PM
Replies: 28
Views: 622
Posted By isladogs
Re: Repeated Autonumber Gremlins

Well this has certainly been an 'experience' for me....
Forum: Tables 01-14-2019, 01:11 PM
Replies: 28
Views: 622
Posted By isladogs
Re: Repeated Autonumber Gremlins

OK - I managed to confuse myself completely in my earlier explanation
Attached is what I hope is a correct explanation! I have also edited my earlier attempt in #19

In summary....
Method 1 -...
Forum: Tables 01-14-2019, 11:12 AM
Replies: 28
Views: 622
Posted By isladogs
Re: Repeated Autonumber Gremlins

Hi DBG
Oops - Sorry - I'm still making stupid mistakes! :banghead:
Just about to sign of for a while but will correct my earlier explanation later this evening!
Not sure if my brain was working at...
Forum: Tables 01-14-2019, 10:34 AM
Replies: 28
Views: 622
Posted By isladogs
Re: Repeated Autonumber Gremlins

Congratulations to Frothy for working out how I did this.
He said he knew as he'd also done the same dumbass method himself!!!! :eek:

The issue with repeat autonumbers came about when I created...
Forum: Modules & VBA 01-14-2019, 08:49 AM
Replies: 26
Views: 600
Posted By isladogs
Re: Variables instead of controls?

True but the networked Access apps sold to schools use SQL Server BE for improved security and stability.
As a result, they work fine with 200+ simultaneous users.
Prior to upsizing the BE to SQL...
Forum: Modules & VBA 01-14-2019, 04:16 AM
Replies: 23
Views: 428
Posted By isladogs
Re: Public functions

PMFBI but a couple of additional points:
1. The output from the Environ function can be 'spoofed' i.e. falsified
If that might be an issue you are better off using another method.
See these links...
Forum: Queries 01-14-2019, 01:37 AM
Replies: 7
Views: 228
Posted By isladogs
Re: SQL update from an empty value textbox by vba

You're welcome. It's the simple mistakes that are often the hardest to find in our own work.
Forum: Queries 01-14-2019, 01:19 AM
Replies: 8
Views: 202
Posted By isladogs
Re: Update Query does duplicates

I suspect doing it the hard way is the only solution for you now.

Whilst it would take time to fix table and field names, Access does have tools to assist with doing so.
First make a backup. This...
Forum: Queries 01-14-2019, 12:50 AM
Replies: 8
Views: 202
Posted By isladogs
Re: Update Query does duplicates

Is that field unique in the master table. If so reinstate it as PK.

Could you make a composite PK in the History using that field and frequency?
Or add an autonumber PK field and use a combined...
Forum: Forms 01-14-2019, 12:35 AM
Replies: 1
Views: 90
Posted By isladogs
Re: Filter form records based on unbound combo box

As it's a text field, you need text delimiters

Me.Recordset.FindFirst "PlateNo = '" & Me.cboPlateNo & "'"
Forum: SQL Server 01-14-2019, 12:24 AM
Replies: 2
Views: 267
Posted By isladogs
Re: There is a writing conflict issue.

I don't really understand what your pictures show but the problem may be with bit fields in sql server.
See this article on my website Write Conflict Errors...
Showing results 1 to 25 of 500

 
Forum Jump



All times are GMT -8. The time now is 03:58 AM.


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