Register
Help
Remember Me?
Forum
What's New?
Activity Stream
New Events
Mark Forums Read
Quick Links
Today's Posts
How to Post a Question
How to Mark Thread Solved
How to Attach Files
Advanced Search
Home
Activity Stream
AccessForums.net is a forum dedicated to Microsoft Access, if you want to ask any Access related questions or help other members out, please
join our community
, the registration is free and takes only one minute.
Activity Stream
Filter
Sort By
Time
Show
Recent
Recent
Popular
Popular
Anytime
Anytime
Last 7 Days
Last 7 Days
Last 30 Days
Last 30 Days
All
All
Photos
Photos
Forum
Forums
Filter by:
Clear All
New Activity (
)
Please reload this page to view the 200+ new activity items that have been created.
Older Activity
Today,
10:27 AM
Grimjack
replied to a thread
Select Records by Most Recent Date
in
Queries
Oh man...why is it that sometimes the answer (not always the 'right' answer) is right in front of your face? Looking at my results I realized I...
see more
17 replies | 291 view(s)
Today,
10:23 AM
Micron
replied to a thread
Select Records by Most Recent Date
in
Queries
Those two files have different tables, at least by name. I was going to ask if you tried post 7 but I guess that's based on the wrong tables also.
see more
17 replies | 291 view(s)
Today,
09:48 AM
Grimjack
replied to a thread
Select Records by Most Recent Date
in
Queries
I made so many alterations on the db, based on the suggestions here...I cannot recall which one I posted here. I will add the version I am using now.
see more
17 replies | 291 view(s)
Today,
09:06 AM
Micron
replied to a thread
Select Records by Most Recent Date
in
Queries
You are trying this in the same db copy that you posted, or in your original db? If in the original, that is not what I have to play with. That might...
see more
17 replies | 291 view(s)
Today,
05:33 AM
Grimjack
replied to a thread
Select Records by Most Recent Date
in
Queries
I used your entire code and still received the prompt. Weird though, I could not switch to Design View after I entered the SQL code.
see more
17 replies | 291 view(s)
Today,
04:46 AM
Bob Fitz
replied to a thread
Structure for inventory with multiple allowances
in
Database Design
You're welcome. Can you confirm my suspicions regarding the trust issue.
see more
13 replies | 275 view(s)
Today,
04:42 AM
Soupy8728
replied to a thread
Structure for inventory with multiple allowances
in
Database Design
Thank you. Appreciate your help!!
see more
13 replies | 275 view(s)
Today,
04:38 AM
Bob Fitz
replied to a thread
Structure for inventory with multiple allowances
in
Database Design
No. I very seldom use macros. I prefer to use vba code which I have done in three event procedures in the form. I googled the error message and...
see more
13 replies | 275 view(s)
Today,
04:14 AM
Soupy8728
replied to a thread
Structure for inventory with multiple allowances
in
Database Design
Hello Bob, is there a macro in your database? I'm trying to open it at work but I get an error "macros in this document have been disabled by your...
see more
13 replies | 275 view(s)
Today,
12:24 AM
Lhoj
replied to a thread
Change event and input masks
in
Programming
The idea behind using the change event is giving the user a more clear indicator of when the data is ready to be sent. If they're typing on the ...
see more
2 replies | 164 view(s)
Yesterday,
11:51 PM
Bob Fitz
replied to a thread
Structure for inventory with multiple allowances
in
Database Design
Always glad to help, if I can. Post back if you have any questions about the db that I posted.
see more
13 replies | 275 view(s)
Yesterday,
10:53 PM
Middlemarch
replied to a thread
Filtering 1-based array
in
Access
I was trying to avoid IFs for speed but this is all I can think of. I send in the filtered array and return the first item, or empty string. Seems...
see more
7 replies | 171 view(s)
Yesterday,
10:32 PM
June7
replied to a thread
Filtering 1-based array
in
Access
Didn't know data was not in table. In my test, second array is always 0-based when it has elements, which seems odd with Option Base 1 in header....
see more
7 replies | 171 view(s)
Yesterday,
09:24 PM
Middlemarch
replied to a thread
Filtering 1-based array
in
Access
It's a collection of Filenames and the Function that builds it returns a 1-Based Array. I can't easily change that as other things use it....
see more
7 replies | 171 view(s)
Yesterday,
08:52 PM
June7
replied to a thread
Filtering 1-based array
in
Access
How are you building first array? Why use 1-based array? Why use array instead of recordset?
see more
7 replies | 171 view(s)
Yesterday,
07:36 PM
davegri
replied to a thread
Filtering 1-based array
in
Access
You can refer to the array values via the index: if array(0) = if array(1) =
see more
7 replies | 171 view(s)
Yesterday,
07:21 PM
Middlemarch
replied to a thread
Filtering 1-based array
in
Access
I've made this complicated. I'm using a routine that puts some filename into a 1 based array. Then I filter the array to include (or remove) items...
see more
7 replies | 171 view(s)
Yesterday,
06:48 PM
davegri
replied to a thread
Filtering 1-based array
in
Access
How about >= 0
see more
7 replies | 171 view(s)
Yesterday,
05:59 PM
Middlemarch
started a thread
Filtering 1-based array
in
Access
If I filter my 1-based variant array it becomes 0-based. But I have a situation where it's not always needing filtering so my check for Ubound > 0...
see more
7 replies | 171 view(s)
Yesterday,
05:42 PM
June7
replied to a thread
How do i reference fields from a query with two tables and field names are the same?
in
Access
Could use alias names in query and refer to those with VBA then the table qualifiers would not be an issue. Really should not use spaces nor...
see more
1 replies | 83 view(s)
Yesterday,
05:09 PM
SilverDevil72
started a thread
How do i reference fields from a query with two tables and field names are the same?
in
Access
Objective: Using the Prod file as the master to match to the BOB file. Then because there are duplicates, update with an update sql call, update...
see more
1 replies | 83 view(s)
More Activity
No More Results
No Recent Activity