Register
Help
Remember Me?
Forum
What's New?
Activity Stream
New Posts
Today's Posts
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:
Last 30 Days
Clear All
New Activity (
)
Please reload this page to view the 200+ new activity items that have been created.
Older Activity
Today,
08:44 AM
Stokecpa
started a thread
Replacing Open Twebst Code
in
Access
Hopefully someone can point me in the right direction. I have code in my Access 2007 application that was written with the help of the Open Twebst...
see more
0 replies | 15 view(s)
Today,
05:41 AM
twgonder
replied to a thread
See if a Hwnd is active in Access
in
Programming
@moke123 post#5 Okay, that seems more complete but I still get the same RTE if an instanced form is opened, when I say instanced form I mean the...
see more
5 replies | 140 view(s)
Today,
05:04 AM
mike60smart
posted a
visitor message
on
All Thumbs's
profile
Hi Welcome to the Forum If you can send me a zipped copy of the Excel Files you currently have then I will take a look for you. Send to me at:-...
see more
Today,
03:00 AM
DMT Dave
replied to a thread
Renaming Different Files In Same Folder
in
Access
Hi Guy's thank you for responding, Can I apologize, i have slightly changed the goal post here, what I thought of afterwards is changing MkDir...
see more
4 replies | 115 view(s)
Today,
02:25 AM
Welshgasman
replied to a thread
Selecting Records by VBA in a continuous form
in
Forms
Whilst it would be by CF, I believe you would need to invoke the CF by VBA, so Google that as well. ...
see more
2 replies | 46 view(s)
Today,
02:23 AM
Minty
replied to a thread
How to debug docmd.openquery
in
Queries
A simple select query won't give you an error with a null value. What will is the use of a function that doesn't accept a null value as a valid...
see more
3 replies | 44 view(s)
Today,
02:14 AM
Welshgasman
replied to a thread
How to debug docmd.openquery
in
Queries
A little hard really. :( How big is the query? You could get the sql and then inspect each of the fields in the immediate window perhaps? I'd...
see more
3 replies | 44 view(s)
Today,
12:11 AM
AccessHelp23
replied to a thread
How to debug docmd.openquery
in
Queries
I mean how do I know which table and column are returning the null and causing the runtime error .
see more
3 replies | 44 view(s)
Today,
12:10 AM
AccessHelp23
started a thread
How to debug docmd.openquery
in
Queries
Hello. I have a statement docmd.openquery that displays a Table successfully every time except a few times. I see an error runtime error 94-...
see more
3 replies | 44 view(s)
Yesterday,
09:59 PM
kd2017
replied to a thread
Selecting Records by VBA in a continuous form
in
Forms
It sounds like you want conditional formatting https://www.google.com/search?q=microsoft+access+continuous+form+conditional+formatting
see more
2 replies | 46 view(s)
Yesterday,
09:27 PM
Peter5164
started a thread
Selecting Records by VBA in a continuous form
in
Forms
I have a Continuous Form which displays all the sections of a document. What I want to do is have a function that Cycles through all the records and...
see more
2 replies | 46 view(s)
Yesterday,
06:47 PM
journeyman
started a thread
Prevent edit to an Outlook mail item field
in
Modules
I know this question is not strictly an Access issue, however, I am opening an MS Outlook mailitem from Access. It's function is to display only...
see more
0 replies | 43 view(s)
Yesterday,
05:44 PM
Perfac
replied to a thread
Form displays no controls when source have no records.
in
Forms
The query is updateable. I am studying Micron's reference, and preparing a sample which I will post. As you know sometimes things just get fixed...
see more
12 replies | 130 view(s)
Yesterday,
05:34 PM
CJ_London
replied to a thread
Form displays no controls when source have no records.
in
Forms
with allow additions set to yes, then the 'new entry' should appear for the user to complete. However if your recordsource is not updateable, it...
see more
12 replies | 130 view(s)
Yesterday,
05:19 PM
orange
replied to a thread
Renaming Different Files In Same Folder
in
Access
Dave, Can you show some examples -what you have -what you need - and the issue of multiple depots?
see more
4 replies | 115 view(s)
Yesterday,
05:14 PM
Perfac
replied to a thread
Form displays no controls when source have no records.
in
Forms
"q06PrgmmngSbjcts" is the name I gave to the applicable query, the source for the form applicable here. I just opened a new DB in Access, created...
see more
12 replies | 130 view(s)
Yesterday,
05:14 PM
moke123
replied to a thread
Renaming Different Files In Same Folder
in
Access
Personally I like using fso when dealing with files and folders. Much easier to work with the methods like FileExists, getBaseName, BuildPath,...
see more
4 replies | 115 view(s)
Yesterday,
05:12 PM
orange
replied to a thread
Query to return only the Key values where joined values match multiple values in a another table.
in
Queries
I tend to agree with June --a table for each project is rarely a good design. I recommend you review "stump the model". A bit of testing of...
see more
2 replies | 49 view(s)
Yesterday,
05:04 PM
orange
replied to a thread
Form displays no controls when source have no records.
in
Forms
What is q06PrgmmngSbjcts? I agree with Micron's advice.
see more
12 replies | 130 view(s)
Yesterday,
05:01 PM
Micron
replied to a thread
Form displays no controls when source have no records.
in
Forms
Perhaps review this to see if it will help http://allenbrowne.com/casu-20.html
see more
12 replies | 130 view(s)
Yesterday,
04:46 PM
Perfac
replied to a thread
Form displays no controls when source have no records.
in
Forms
I will, it may take a while.
see more
12 replies | 130 view(s)
Yesterday,
04:42 PM
pbaldy
replied to a thread
Form displays no controls when source have no records.
in
Forms
Can you attach the db here, or a representative sample?
see more
12 replies | 130 view(s)
Yesterday,
04:37 PM
Perfac
replied to a thread
Form displays no controls when source have no records.
in
Forms
Hi Paul. Some people on forums do believe setting Data Entry to No will make a difference. I do not experience that. Yes, I can add a record in the...
see more
12 replies | 130 view(s)
Yesterday,
04:22 PM
pbaldy
replied to a thread
Form displays no controls when source have no records.
in
Forms
I would bet that the source query won't allow additions. It doesn't matter what the form setting is if that's the case. Edit: open the source...
see more
12 replies | 130 view(s)
Yesterday,
03:51 PM
Perfac
replied to a thread
Form displays no controls when source have no records.
in
Forms
Hi CJ. If a new user starts using the app from starters and want to capture the first record, the controls must display to be able to capture the...
see more
12 replies | 130 view(s)
Yesterday,
03:47 PM
June7
replied to a thread
Form displays no controls when source have no records.
in
Forms
Why does this happen? Is AllowAdditions property set to No?
see more
12 replies | 130 view(s)
Yesterday,
03:39 PM
CJ_London
replied to a thread
Form displays no controls when source have no records.
in
Forms
So what do you want to do if there are no records?
see more
12 replies | 130 view(s)
Yesterday,
03:31 PM
June7
replied to a thread
Query to return only the Key values where joined values match multiple values in a another table.
in
Queries
I vote against individual table for each project. The queries you describe can be complicated. Suggest you build a db schema and post it here for...
see more
2 replies | 49 view(s)
Yesterday,
03:25 PM
Perfac
started a thread
Form displays no controls when source have no records.
in
Forms
If the source table or query have no records, the controls on the form display in design view, but do not display in form view. Somebody probably...
see more
12 replies | 130 view(s)
Yesterday,
02:33 PM
All Thumbs
started a thread
Query to return only the Key values where joined values match multiple values in a another table.
in
Queries
Context- I have experience building basic databases to capture, query and report mostly text based data. I have recently started a new role and...
see more
2 replies | 49 view(s)
More Activity
No More Results
No Recent Activity
