Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 2.51 seconds.
Search: Posts Made By: pbaldy
Forum: Modules & VBA Today, 12:19 PM
Replies: 6
Views: 215
Posted By pbaldy
Re: Automated addition of days in a duration field

I assume you're replying to MajP so I'll get out of the way.
Forum: Queries Today, 11:13 AM
Replies: 5
Views: 112
Posted By pbaldy
Re: import multiple text files into 1 access table

I'd expect the specification and import type to control that. Is that your specification?
Forum: Queries Today, 10:53 AM
Replies: 5
Views: 112
Posted By pbaldy
Re: import multiple text files into 1 access table

At a glance, I'd expect strTable to contain the name of the target table, not a path.
Forum: Reports Today, 10:50 AM
Replies: 1
Views: 164
Posted By pbaldy
Re: New record after report preview

Untested by try adding that line after OpenReport, but add the acDialog argument to the OpenReport. That will make the code pause and wait for the report to be closed.
Forum: Queries Today, 07:10 AM
Replies: 3
Views: 266
Posted By pbaldy
Re: Union query help

Happy to help!
Forum: Queries Yesterday, 03:46 PM
Replies: 3
Views: 266
Posted By pbaldy
Re: Union query help

If the files are all in the same folder, you can programmatically loop the folder and either link to or import them.

http://allenbrowne.com/ser-59.html
Forum: Modules & VBA Yesterday, 08:35 AM
Replies: 6
Views: 215
Posted By pbaldy
Re: Automated addition of days in a duration field

Try

If me.expirydate=Date() then me.duration = me.duration + 14
Forum: Modules & VBA 12-07-2018, 04:29 PM
Replies: 5
Views: 157
Posted By pbaldy
Re: Filtering Recordset

I'd do this:

Set rs = CurrentDb.OpenRecordset("SELECT * FROM qry_employeeAttendance WHERE EmployeeID = " & [Forms]![FRM_Main]![FRM_Welcome]![user], dbOpenDynaset)
Forum: Introduce Yourself 12-06-2018, 08:45 AM
Replies: 10
Views: 2,064
Posted By pbaldy
Re: Feedback form added

I'm not either, and I'm curious how anybody other than the site owner could have added a feature...
Forum: Queries 12-06-2018, 08:44 AM
Replies: 26
Views: 4,123
Posted By pbaldy
Re: Multi-Select Listbox as filter for Query field

Or simply open the report with no wherecondition if a checkbox for "All" is checked, or a listbox value is added that denotes all.
Forum: Queries 12-06-2018, 08:38 AM
Replies: 3
Views: 176
Posted By pbaldy
Re: Update fields

This should give you some ideas:

http://allenbrowne.com/casu-14.html
Forum: Queries 12-05-2018, 01:25 PM
Replies: 14
Views: 345
Posted By pbaldy
Re: Save query count to variable

Wouldn't it need to be:

select Count(*) as TotalCount from yourQuery
Forum: Queries 12-05-2018, 10:02 AM
Replies: 14
Views: 345
Posted By pbaldy
Re: Save query count to variable

Well, it won't add to the time it takes the query to run. I'm saying that running the DCount() will run the query. If the query takes 2 seconds to run, the DCount() will likely take 2 seconds to...
Forum: General 12-05-2018, 09:19 AM
Replies: 31
Views: 887
Posted By pbaldy
Re: Creating a table similar to word in access form

It seems simple to you because you have the concept in your mind. To us it sounds confusing. Why don't you lay out textboxes in the grid you're imagining plus the combo and attach the db here. ...
Forum: Queries 12-05-2018, 08:18 AM
Replies: 14
Views: 345
Posted By pbaldy
Re: Save query count to variable

VariableName = DCount("*", "QueryName")

though that will run the query behind the scenes.
Forum: General 12-04-2018, 05:09 PM
Replies: 31
Views: 887
Posted By pbaldy
Re: Creating a table similar to word in access form

Well, you could have many rows of textboxes and hide them. Make the appropriate number visible based on the drop down. It's odd that this is all to be unbound (data not going anywhere), but you...
Forum: General 12-04-2018, 04:10 PM
Replies: 31
Views: 887
Posted By pbaldy
Re: Creating a table similar to word in access form

Then a grid of textboxes in whatever pattern you want. The "totals" textbox would refer to the others.
Forum: General 12-04-2018, 03:28 PM
Replies: 31
Views: 887
Posted By pbaldy
Re: Creating a table similar to word in access form

Presuming you mean to display some data, perhaps a subform?
Forum: Queries 12-04-2018, 02:33 PM
Replies: 8
Views: 273
Posted By pbaldy
Re: Query for last month, yyyymmdd

2 points. Plog is correct that the HAVING clause would be more efficient as a WHERE, but it can't just be changed. It also needs to be moved ahead of GROUP BY. Second, while using the function...
Forum: Modules & VBA 12-04-2018, 02:30 PM
Replies: 20
Views: 904
Posted By pbaldy
Re: Hello Everyone

If the password field is numeric, the DLookup is treating it as text. You don't want the single quotes:

http://www.theaccessweb.com/general/gen0018.htm
Forum: Queries 12-04-2018, 10:45 AM
Replies: 8
Views: 273
Posted By pbaldy
Re: Query for last month, yyyymmdd

The data type of the field is text, not date/time? That will certainly complicate matters, but something like this should work:

Between "20181101" And "20181130"

without the quotes if it's a...
Forum: Queries 12-04-2018, 09:02 AM
Replies: 26
Views: 4,123
Posted By pbaldy
Re: Multi-Select Listbox as filter for Query field

No problem, glad it worked for you.
Forum: Queries 12-04-2018, 08:38 AM
Replies: 26
Views: 4,123
Posted By pbaldy
Re: Multi-Select Listbox as filter for Query field

After I take the territory criteria out of the query, the code works fine for me.
Forum: Modules & VBA 12-04-2018, 08:27 AM
Replies: 20
Views: 904
Posted By pbaldy
Re: Hello Everyone

A type mismatch typically occurs when you mix data types, like trying to put a string value into a numeric variable. Where exactly does the error occur? Are passwords really integers?
Forum: Introduce Yourself 12-04-2018, 08:25 AM
Replies: 6
Views: 467
Posted By pbaldy
Re: Hello from Virginia

Welcome to AWF Becky!
Showing results 1 to 25 of 500

 
Forum Jump



All times are GMT -8. The time now is 08:58 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 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World