Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.27 seconds.
Search: Posts Made By: pbaldy
Forum: General Yesterday, 02:26 PM
Replies: 22
Views: 347
Posted By pbaldy
Re: The Surface Go 10" and Access Office 365

I appreciate your thoughts, I'm going to suggest she check it out. If I remember correctly it had a smallish hard drive too, but I don't think she stores a lot anyway.
Forum: General Yesterday, 01:36 PM
Replies: 22
Views: 347
Posted By pbaldy
Re: The Surface Go 10" and Access Office 365

I believe CF was introduced with 2000.
Forum: General Yesterday, 01:34 PM
Replies: 22
Views: 347
Posted By pbaldy
Re: The Surface Go 10" and Access Office 365

Interesting that you find the performance good. My wife is thinking about a new laptop and I discounted the Go because of the Pentium processor, which struck me as antiquated. Maybe I need to take...
Forum: Modules & VBA Yesterday, 08:22 AM
Replies: 6
Views: 69
Posted By pbaldy
Re: Wits end trying to get VBA code to work

Do you really have a "B" drive? That would be pretty unusual in my experience. More here on debugging:

http://www.baldyweb.com/Debugging.htm
Forum: Modules & VBA Yesterday, 08:11 AM
Replies: 6
Views: 69
Posted By pbaldy
Re: Wits end trying to get VBA code to work

What exactly goes wrong? Where is the code (what event)? Have you set a breakpoint to see if the correct value is pulled with the DLookup?
Forum: Queries Yesterday, 07:20 AM
Replies: 78
Views: 9,029
Posted By pbaldy
Re: Multi-Select Listbox as filter for Query field

You could requery the subform after executing the UPDATE query.
Forum: Queries Yesterday, 07:18 AM
Replies: 23
Views: 736
Posted By pbaldy
Re: Access error -query is corrupt

The page has been updated for

Access for Office 365 Monthly Channel/Access 2016 C2R/Access 2019 (Version 1910)

Use File/Account/
UpdateOptions/UpdateNow
within an Office application
Forum: General 11-18-2019, 08:21 PM
Replies: 6
Views: 126
Posted By pbaldy
Re: Linking

I must not have said it well enough.
Forum: General 11-18-2019, 08:00 PM
Replies: 6
Views: 126
Posted By pbaldy
Re: Linking

As a back end? It shouldn't be a problem.
Forum: Modules & VBA 11-18-2019, 02:45 PM
Replies: 4
Views: 98
Posted By pbaldy
Re: Empty ADODB Recordset - not making sense

What's the SQL that fails? ADO wants % as a wildcard rather than *.
Forum: Queries 11-18-2019, 09:01 AM
Replies: 78
Views: 9,029
Posted By pbaldy
Re: Multi-Select Listbox as filter for Query field

I didn't say you were using a query, I said you could. To reset all records:

CurrentDb.Execute "UPDATE TableName SET FieldName = False", dbFailOnError

perhaps more efficient if there are a lot...
Forum: Introduce Yourself 11-17-2019, 03:17 PM
Replies: 4
Views: 124
Posted By pbaldy
Re: Hi from Denmark

Welcome Niels!
Forum: Forms 11-17-2019, 07:44 AM
Replies: 5
Views: 120
Posted By pbaldy
Re: webpage postback confusion

I wonder if it's ASP, which looks VBA-ish.
Forum: The Watercooler 11-16-2019, 11:04 AM
Replies: 25
Views: 439
Posted By pbaldy
Re: why do IT people insist on internet communication?

I don't know, I'm afraid to ask again. :eek: ;)
Forum: The Watercooler 11-16-2019, 10:40 AM
Replies: 25
Views: 439
Posted By pbaldy
Re: why do IT people insist on internet communication?

No, my wife assures me that women aren't moody. :D
Forum: Queries 11-16-2019, 10:33 AM
Replies: 78
Views: 9,029
Posted By pbaldy
Re: Multi-Select Listbox as filter for Query field

Since it sounds like you're using a field in the data, run an update query that sets that field to false.
Forum: General 11-15-2019, 04:29 PM
Replies: 32
Views: 390
Posted By pbaldy
Re: Need access help...

Sounds like you've got it organized properly then!
Forum: General 11-15-2019, 04:23 PM
Replies: 32
Views: 390
Posted By pbaldy
Re: Need access help...

You never need them for reporting or anything? Most of us wouldn't delete the records, we'd flag them as "archived" or whatever. Then you'd base the form on a query that excluded archived records.
Forum: General 11-15-2019, 04:18 PM
Replies: 32
Views: 390
Posted By pbaldy
Re: Need access help...

No problem, post back if you get stuck. If you accumulate a lot of records, you may want to go a different direction. That requery may start taking too long, as might loading the form.
Forum: General 11-15-2019, 04:16 PM
Replies: 32
Views: 390
Posted By pbaldy
Re: Need access help...

Yes, whatever the existing code is put

Me.Requery

before it.
Forum: General 11-15-2019, 04:14 PM
Replies: 32
Views: 390
Posted By pbaldy
Re: Need access help...

No, if they search with a button, I'd put it there. Basically you want to requery the form before they search.
Forum: General 11-15-2019, 04:11 PM
Replies: 32
Views: 390
Posted By pbaldy
Re: Need access help...

So try putting the requery in that button.
Forum: General 11-15-2019, 04:07 PM
Replies: 32
Views: 390
Posted By pbaldy
Re: Need access help...

How do they search, with the listbox? If so, you could try a requery in its got focus event.
Forum: Site Suggestions 11-15-2019, 03:45 PM
Replies: 43
Views: 432
Posted By pbaldy
Re: session timeout

Wouldn't it be "eats" the cookies? :p
Forum: General 11-15-2019, 03:42 PM
Replies: 32
Views: 390
Posted By pbaldy
Re: Need access help...

Depends on how you're searching, but if it's on a form that was loaded with data before the record was added, a requery should resolve it. You'd requery the form, not each button. Depending on the...
Showing results 1 to 25 of 500

 
Forum Jump



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