Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.04 seconds.
Search: Posts Made By: Alc
Forum: Modules & VBA 07-09-2019, 09:19 AM
Replies: 21
Views: 364
Posted By Alc
Re: Access acting as if query is not present, just after telling me it is

Finally, it appears to be working.

The solution was to add a short delay (using a new sub procedure) in between the part that creates the query and refreshes the database and the part that checks...
Forum: Modules & VBA 07-09-2019, 03:16 AM
Replies: 21
Views: 364
Posted By Alc
Re: Access acting as if query is not present, just after telling me it is

Thanks for the feedback.

I was trying to get something to happen. Each time the code fails, I can see that the query does exist so I was experimenting to find out what would happen if it tried to...
Forum: Modules & VBA 07-08-2019, 10:32 AM
Replies: 21
Views: 364
Posted By Alc
Re: Access acting as if query is not present, just after telling me it is

Yes the SQL will run fine if I copy and paste it.


Yep, I can literally run the process multiple times in a row (the queries will be the same until the next day). The first few will work, then...
Forum: Modules & VBA 07-08-2019, 09:35 AM
Replies: 21
Views: 364
Posted By Alc
Re: Access acting as if query is not present, just after telling me it is

Sorry, I missed those.
In order:
1. Yes. The error is definitely at that line.
2. Yes, the debug.print prints what I would expect to see. No spaces, special characters, missing characters, etc....
Forum: Modules & VBA 07-08-2019, 09:16 AM
Replies: 21
Views: 364
Posted By Alc
Re: Access acting as if query is not present, just after telling me it is

Alas, same result.

If the data weren't confidential, I'd try copying a zipped version of the db itself.
Forum: Modules & VBA 07-08-2019, 08:57 AM
Replies: 21
Views: 364
Posted By Alc
Re: Access acting as if query is not present, just after telling me it is

Thanks for the suggestion.

Unfortunately, it didn't work. I made the change and ran the process twice successfully, but on the third attempt I got the same error message as originally (albeit for...
Forum: Modules & VBA 07-08-2019, 07:11 AM
Replies: 21
Views: 364
Posted By Alc
Re: Access acting as if query is not present, just after telling me it is

Thanks again.
This is the whole function. As I mentioned, frustratingly, it will run one minute but if tried a little while later will fail. Since the queries run will only change day-by-day, it's...
Forum: Modules & VBA 07-08-2019, 06:35 AM
Replies: 21
Views: 364
Posted By Alc
Re: Access acting as if query is not present, just after telling me it is

Sadly, this results in the same error at the same point as before

If QueryExists(strSheetNameNew) Then
Debug.Print strSheetNameNew & " exists"

DoCmd.TransferSpreadsheet...
Forum: Modules & VBA 07-08-2019, 05:54 AM
Replies: 21
Views: 364
Posted By Alc
Re: Access acting as if query is not present, just after telling me it is

This is the sort of thing I suspected I might need. I couldn't work out what phrase to search for. Will make the change and retest.


I understand the confusion there, I was trying to keep the...
Forum: Modules & VBA 07-08-2019, 04:27 AM
Replies: 21
Views: 364
Posted By Alc
Access acting as if query is not present, just after telling me it is

The following section of code comes from an Access function.
In brief, it checks if a query is present (using another function) and - if so - exports it to a new worksheet in a previously created...
Forum: Theory and practice of database design 03-07-2019, 06:38 AM
Replies: 16
Views: 735
Posted By Alc
Re: Can an Access db 'detect' when a user locks a PC?

I'm on vacation next week and may not get this resolved before I leave. I'll stay on it, however, and will post back what I find, in case anyone else finds it helpful.
Forum: Theory and practice of database design 03-07-2019, 05:55 AM
Replies: 16
Views: 735
Posted By Alc
Re: Can an Access db 'detect' when a user locks a PC?

Aha! That sounds possible.

In spite of all the laptops supposedly being the same, I do know some people have a much lower connection speeds. If there's a difference in one area, there may well be...
Forum: Theory and practice of database design 03-07-2019, 04:01 AM
Replies: 16
Views: 735
Posted By Alc
Re: Can an Access db 'detect' when a user locks a PC?

Thanks all for the feedback.

This one clearly needs more investigation as, from everything that's said, a locked computer should not prevent the db from being shut. Something, however, is and I'll...
Forum: Theory and practice of database design 03-06-2019, 11:43 AM
Replies: 16
Views: 735
Posted By Alc
Re: Can an Access db 'detect' when a user locks a PC?

What do you mean by modifying table structure?
The back end wouldn't be open, just locked by opening the front.
Forum: Theory and practice of database design 03-06-2019, 10:12 AM
Replies: 16
Views: 735
Posted By Alc
Re: Can an Access db 'detect' when a user locks a PC?

Thanks. I thought I was clutching at straws, but hoped someone might have found a workaround.
Forum: Theory and practice of database design 03-06-2019, 08:14 AM
Replies: 16
Views: 735
Posted By Alc
Re: Can an Access db 'detect' when a user locks a PC?

Thanks for the response.
No, sorry, Access itself is still running, but the event that's meant to fire based in the form's timer property doesn't fire.

One of the ways I shut down the db...
Forum: Theory and practice of database design 03-06-2019, 07:31 AM
Replies: 16
Views: 735
Posted By Alc
Can an Access db 'detect' when a user locks a PC?

In order to prevent the pain that is an unknown user being in a database when I need to make a fix/upgrade, I've built the following into the various databases we use:
1. If a db is idle for 15...
Forum: Modules & VBA 02-04-2019, 04:13 AM
Replies: 15
Views: 254
Posted By Alc
Re: Is it possible to identify the last time an object was used?

Thanks all for the tips.

I've already got various tracking running on anything I built since coming here, it's the old databases that preceded my arrival where the (possible) problems exist.

I...
Forum: Modules & VBA 02-01-2019, 12:06 PM
Replies: 15
Views: 254
Posted By Alc
Re: Is it possible to identify the last time an object was used?

Thanks for that. Is it possible to detect the last time a table was referenced?
Forum: Modules & VBA 02-01-2019, 11:55 AM
Replies: 15
Views: 254
Posted By Alc
Is it possible to identify the last time an object was used?

We have a number of databases that contain many, many queries and I'd like to delete those that nobody has used for a while.

I've eliminated from consideration all those that are a source for...
Forum: Modules & VBA 01-22-2019, 08:31 AM
Replies: 2
Views: 52
Posted By Alc
Re: Controlling IBM DB2 from Access

Thanks for the response.
I wouldn't know where to set them from there. I was hoping to duplicate the steps I'd use for a manual configuration.
Forum: Modules & VBA 01-22-2019, 06:41 AM
Replies: 2
Views: 52
Posted By Alc
Controlling IBM DB2 from Access

A number of our databases connect to remote data sources via ODBC. These connections are configured using the IBM DB2 application. A recurring problem I have is that the department building the...
Forum: Modules & VBA 11-21-2018, 11:08 AM
Replies: 4
Views: 274
Posted By Alc
Re: Order when cycling through form controls

Thanks a lot. I was hoping it was tab order but I guess since the tab order matches the order I added the fields, in most cases, that was just the impression I was getting.

I think I have a way...
Forum: Modules & VBA 11-21-2018, 10:23 AM
Replies: 4
Views: 274
Posted By Alc
Order when cycling through form controls

This may seem like an odd question, but it's puzzling me.

I have the following code behind a button on a form

Dim ctl as Control

For Each ctl In Me.Controls
MsgBox ctl.name...
Forum: Modules & VBA 09-07-2018, 05:00 AM
Replies: 5
Views: 336
Posted By Alc
Re: 'No current record' on dataset with hundreds of records

Yes, they are.


This I've come across before and it was always an empty recordset causing the problem.

Bingo! the function that sets the month number used a recordset that I'd stupidly called...
Showing results 1 to 25 of 500

 
Forum Jump



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