Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.24 seconds.
Search: Posts Made By: gemma-the-husky
Forum: Modules & VBA Yesterday, 04:38 AM
Replies: 15
Views: 260
Posted By gemma-the-husky
Re: Billing ethics for managing access database

Hi.

It's not clear what your employment status is. If you designed this as part of your employment the dbs probably belongs to your employers, not you, even if you built it in your own time. It...
Forum: General 07-23-2019, 12:45 PM
Replies: 14
Views: 255
Posted By gemma-the-husky
Re: 'invalid argument' Error, when preforming a search (ctrl+f) in a form

it was just a thought. I was surprised at your result, but there's no way of knowing what effect badly formed data would have. The fact that coming from an external file makes it more likely rather...
Forum: General 07-22-2019, 05:10 AM
Replies: 14
Views: 255
Posted By gemma-the-husky
Re: 'invalid argument' Error, when preforming a search (ctrl+f) in a form

maybe the copied text somehow includes a non-visible control character? Would that prevent "find" working correctly?
Forum: General 07-19-2019, 04:08 AM
Replies: 31
Views: 573
Posted By gemma-the-husky
Re: Validation Key for DB - hash email and exp date

How do you put a count-down? ...


IMO, the best way in general, is to have an autoexec macro, rather than a start up form. The autoexec macro fires, and in the autoexec code you use, you can do...
Forum: Forms 07-18-2019, 08:18 AM
Replies: 15
Views: 169
Posted By gemma-the-husky
Re: Show Button Only for Admins

that would work but given this

If UserAccess = "Admin" Then
Me.DeleteBtn.Visible = True
Else
Me.DeleteBtn.Visible = False
End If


UserAccess would need to be a function in a...
Forum: General 07-17-2019, 09:38 AM
Replies: 31
Views: 573
Posted By gemma-the-husky
Re: Validation Key for DB - hash email and exp date

The hard bit is the expiry date.

you can't really do this with a hash (I don't think), as a hash is a one-way function.

if the expiry date is 31/7/19 (say) then you can't know whether the...
Forum: Modules & VBA 07-15-2019, 04:26 AM
Replies: 13
Views: 196
Posted By gemma-the-husky
Re: Variables

I would nest the case statements You aren't going to have to do this very often.
If there's another syntax that works, then fine, but this layout is easy to deal.

select case frame1
case 1:
...
Forum: Tables 07-15-2019, 04:02 AM
Replies: 9
Views: 244
Posted By gemma-the-husky
Re: Forcing A Field's Data Type To Be Currency In Dollars ($) Instead Of Regional Set

I would use currency. It's just a column of numbers. You can format it for display with a dollar symbol, or with no symbol.

The only issue would be if you weren't happy with the accuracy of the...
Forum: General 07-15-2019, 03:52 AM
Replies: 48
Views: 697
Posted By gemma-the-husky
Re: Can't assign Value to this object

I can see your last post was a couple of days ago. I just don't understand how your record is getting locked without the indicator changing. Can you put record selectors on the subform? Is this a...
Forum: Theory and practice of database design 07-11-2019, 03:03 AM
Replies: 8
Views: 197
Posted By gemma-the-husky
Re: Check to ensure all imports done

The easiest way will be to download the 134 reports with a standard naming structure.

Then develop a routine that imports each of these, and moves the processed reports into a different folder....
Forum: Tables 07-10-2019, 06:37 AM
Replies: 5
Views: 145
Posted By gemma-the-husky
Re: Autonumber question

I imagine you want to start the prefix from scratch each year, so you need a slghtly different solution to have 2019-nnn, then next year 2020-nnn, etc.

Rather than have one field, have 2 fields....
Forum: General 07-10-2019, 01:18 AM
Replies: 48
Views: 697
Posted By gemma-the-husky
Re: Can't assign Value to this object

if you temporarily add record selectors to your forms (even if there is only one record) the record selector triangle/arrow will change to a different symbol indicating the status of the record.
...
Forum: General 07-07-2019, 03:36 AM
Replies: 48
Views: 697
Posted By gemma-the-husky
Re: Can't assign Value to this object

This is not to do with the ldb file

if you have two forms open, with the same record and you try to save one, you will see a message something like "another user has edited your record", when in...
Forum: General 07-04-2019, 01:39 PM
Replies: 14
Views: 4,567
Posted By gemma-the-husky
Re: Unusually Large .accde File

I have databases around 100Mb, but they are massive. Thousands of queries, and hundreds of forms and reports.

I am never unduly bothered. They also grow a little as temporary queries get created....
Forum: Tables 07-03-2019, 01:35 AM
Replies: 1
Views: 147
Posted By gemma-the-husky
Re: Linked table manager and UNC paths

do the table connection in code.

look at createtabledef


you might need to create the connect string, in which case, it needs to look like

;database=full-path-to-databasefile
Forum: Modules & VBA 07-01-2019, 10:21 AM
Replies: 6
Views: 152
Posted By gemma-the-husky
Re: PERMISSION DENIED ON .CopyFolder

what is the precise error message you get?

should it be this (as theDBGuy suggested)
objFSO.CopyFolder "C:\Windows\System32\Tasks\Databases\*.*"

rather than this, which looks wrong. ...
Forum: Forms 07-01-2019, 04:03 AM
Replies: 19
Views: 439
Posted By gemma-the-husky
Smile Re: Sequential Number in Access form(invoice box)

@UncleGizmo

You can lead a horse to water, but a pencil must be lead.
Forum: Forms 07-01-2019, 04:02 AM
Replies: 19
Views: 439
Posted By gemma-the-husky
Re: Sequential Number in Access form(invoice box)

In passing, for an invoice number, I would be tempted to store the NextNumber in a separate table, and increment it in the table after issuing a number. That way, you can re-seed the number to a...
Forum: Tables 07-01-2019, 03:56 AM
Replies: 4
Views: 212
Posted By gemma-the-husky
Re: Carry Data to a new record relating to specific ID

The reason @Cronk's idea is the one to use is the issue you have if someone cancels a holiday.


If an employee has booked 4 separate breaks, and then cancels or amends the first one, you need to...
Forum: Modules & VBA 06-26-2019, 04:29 AM
Replies: 10
Views: 292
Posted By gemma-the-husky
Re: VBA as a language, how "deep" can we go?

I use access to write some things that are not really database related, because I don't need to get to grips with another language. Even VB is different enough to imply a learning curve.

yes, it...
Forum: Forms 06-21-2019, 01:30 AM
Replies: 5
Views: 303
Posted By gemma-the-husky
Re: Re-positioning fields on a tabbed form moves all fields.

The control needs to be placed on the tab AFTER the tab page has been selected. Otherwise you have a single control on THE FORM that is either behind the tab control and therefore never visible, or...
Forum: Modules & VBA 06-19-2019, 02:57 AM
Replies: 26
Views: 734
Posted By gemma-the-husky
Re: Progress Bar in MS Access

I have some processes that will take several minutes to complete, so I use an hourglass, a progress meter, and a auto-clearing msgbox to advise users to be patient at times.
Forum: Modules & VBA 06-17-2019, 07:30 AM
Replies: 10
Views: 236
Posted By gemma-the-husky
Re: How to close specific excel file from access?

out of interest, you used workbooks (plural) in the working code. - In #4, you had workbook (singular)
Forum: Modules & VBA 06-17-2019, 01:10 AM
Replies: 10
Views: 236
Posted By gemma-the-husky
Re: How to close specific excel file from access?

that might well be because the workbook index is zero based.

try
workbook(n-1).Close or
workbook(0).Close or
workbook("name").Close
Forum: Theory and practice of database design 06-16-2019, 12:34 PM
Replies: 5
Views: 353
Posted By gemma-the-husky
Re: Backend database is suddenly getting inconsistent stat

maybe this

https://www.devhut.net/2018/06/13/access-bug-database-is-in-an-unrecognized-format/

If it should work, but then started to produce this error …..
Showing results 1 to 25 of 500

 
Forum Jump



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