Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.47 seconds.
Search: Posts Made By: gemma-the-husky
Forum: General Today, 12:09 AM
Replies: 14
Views: 760
Posted By gemma-the-husky
Re: error 3340 ‘Query is corrupted

@MrHans.

@Colin/Isladogs indicated elsewhere that MS have already released fixes for some builds of Access/Office
Forum: General Today, 12:08 AM
Replies: 22
Views: 318
Posted By gemma-the-husky
Re: Duplicates that have no value

With regard to the issue I mentioned, I ended up using datevalue of zero for an "any date", but then had to test for the special case of zero. Instead of users then seeing a blank for the "required...
Forum: Queries Yesterday, 06:14 AM
Replies: 27
Views: 946
Posted By gemma-the-husky
Re: Access error -query is corrupt

re version numbers

I reverted my O365 back to 12130.12272
The suspect version was 12130.20344
A newer version is now 12130.20390

...
Forum: Theory and practice of database design Yesterday, 06:06 AM
Replies: 27
Views: 965
Posted By gemma-the-husky
Re: The pitfalls of VBA proficiency

Just a thought.

! was told, in general, the answer is a query.

I use queries wherever possible. I use code, when I can't do it with a query - perhaps the query is non-updatable.

It's hard...
Forum: Modules & VBA Yesterday, 05:33 AM
Replies: 7
Views: 188
Posted By gemma-the-husky
Re: Array - testing neighboring elements

depending on the number of iterations required you might be able to come up with a recursive solution.
If you only want to examine one word either side this is probably not a worth doing.
However,...
Forum: General Yesterday, 05:21 AM
Replies: 9
Views: 164
Posted By gemma-the-husky
Re: Not-able-to-print puzzle

Sometimes its genuine. A lot of records and a complex query. One solution is to "stage" the process. Write temporary data to a table, and continue the process with the table. That might work.
Forum: General Yesterday, 05:16 AM
Replies: 22
Views: 318
Posted By gemma-the-husky
Re: Duplicates that have no value

Just as a nasty little catch related to this. If you have a mutli-field unique index, you can "duplicate" records if part of the index is null.

eg, an order item file with key something like.
...
Forum: Queries Yesterday, 05:07 AM
Replies: 27
Views: 946
Posted By gemma-the-husky
Re: Access error -query is corrupt

btw, for us old timers, A2003 was not affected at all!

Although A2003 databases "running" in later versions were affected.
Forum: General Yesterday, 05:01 AM
Replies: 14
Views: 760
Posted By gemma-the-husky
Re: error 3340 ‘Query is corrupted

I had the issue. and was able to restore O365 to the previous version, until its safe to resume automatic updates. There was a worse problem last year.

I thought my users also had a problem...
Forum: Modules & VBA 11-11-2019, 04:50 AM
Replies: 32
Views: 495
Posted By gemma-the-husky
Re: Editing an external text file is it possible?

I dislike editing raw files.

What you could is read the text file in a row at a time, and make any necessary changes after reading in each line.

You would then have to process each line...
Forum: Forms 11-11-2019, 04:39 AM
Replies: 17
Views: 205
Posted By gemma-the-husky
Re: OpenArgs not evaluated in Current event

Obviously your problem is trying to refresh the data in an open form, where the form has been opened to show different data.

I would be inclined to find a way to force the popup form to close...
Forum: Modules & VBA 11-11-2019, 04:28 AM
Replies: 4
Views: 189
Posted By gemma-the-husky
Re: Database cannot open, because VBA-project cannot be read....

It sounds like you are getting a serious corruption.

Are you sharing a single copy of a database, maybe not split, and then trying to change the database (new queries, edit forms etc) while both...
Forum: General 11-11-2019, 03:46 AM
Replies: 11
Views: 367
Posted By gemma-the-husky
Re: Access: The DB that will not die

@Pat

I am sure the reason Jet/Ace back ends get conflated with Access is simply because MS ship Access as an integrated solution. Users (eventually) realise they can split a database into an...
Forum: General 11-11-2019, 03:37 AM
Replies: 20
Views: 299
Posted By gemma-the-husky
Re: Moving Access Database to OneDrive

I think management would be interested if it worked, because an off site user could then connect to the one-drive, rather than need to connect to an office based terminal server.

The point that...
Forum: Forms 11-01-2019, 10:36 AM
Replies: 5
Views: 155
Posted By gemma-the-husky
Re: Don't want to "Have to" enter a zero in a time value

can't you just enter the time with the colon

format text box as short time

enter 1:40 or 1.40
and get 01:40

mind you enter 1:4 or 1.4
and get 01:04
Forum: Modules & VBA 11-01-2019, 10:32 AM
Replies: 10
Views: 203
Posted By gemma-the-husky
Re: If .eof not excecuting

@paul.
I would do what you suggested, but its worth knowing the syntax to iterate a recoordset, depending on exactly what you want to do.
Forum: General 11-01-2019, 10:26 AM
Replies: 11
Views: 367
Posted By gemma-the-husky
Re: Access: The DB that will not die

Yes, but with SQL Server you need an additional skillset that you don't need with Jet/Ace,
Forum: Reports 11-01-2019, 05:32 AM
Replies: 10
Views: 174
Posted By gemma-the-husky
Re: Page Header and GroupHeader being repeated

what about - do away with the page header, but get the group header to repeat, I think just set repeat to yes.
...
Forum: Forms 11-01-2019, 05:15 AM
Replies: 14
Views: 334
Posted By gemma-the-husky
Re: Check boxes to become visible when two values match

As an alternative, could you have two forms (or a filter/group option of some sort) on the form to allow the user to select between open orders and fully supplier orders.

then your filter checks...
Forum: Modules & VBA 11-01-2019, 04:58 AM
Replies: 10
Views: 203
Posted By gemma-the-husky
Re: If .eof not excecuting

I only use while/wend.
I would have this sort of code.

set hdrst = openrecordset (whatever)

while not HDRrst.EOF 'this won't execute if there are no records in the recordset.
With HDRrst...
Forum: Modules & VBA 11-01-2019, 04:52 AM
Replies: 28
Views: 308
Posted By gemma-the-husky
Re: Looping through folder with DIR ???

dir() is not recursive, so you can't read a sub directory, and then return to carry on testing the main directory.

However you said there were no subfolders - so either there were subfolders, or...
Forum: General 11-01-2019, 04:38 AM
Replies: 23
Views: 411
Posted By gemma-the-husky
Re: Whats the best approach too??????

@isladogs

Ockham's razor in action.

I think you are right, it's just another example of a clockin/clockout application.
Forum: General 11-01-2019, 04:31 AM
Replies: 9
Views: 202
Posted By gemma-the-husky
Re: Access vs. Oracle

coincidentally, this post appeared yesterday. It's worth looking at the underlying article.

https://access-programmers.co.uk/forums/showthread.php?t=307672
Forum: General 11-01-2019, 04:06 AM
Replies: 11
Views: 367
Posted By gemma-the-husky
Re: Access: The DB that will not die

The thing is, the same people who dismiss robust carefully designed access databases, never see the parallel with allowing a proliferation of poorly designed mission critical excel spreadsheets...
Forum: Theory and practice of database design 10-25-2019, 07:03 AM
Replies: 27
Views: 965
Posted By gemma-the-husky
Re: The pitfalls of VBA proficiency

I think another issue in larger applications is keeping track of code, and making it re-usable

Sometimes, although you know you have written something to deal with your current problem, it's...
Showing results 1 to 25 of 500

 
Forum Jump



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