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
Search Forum
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
New Activity (
)
Please reload this page to view the 200+ new activity items that have been created.
Older Activity
Today,
11:14 AM
SusanCoder
started a thread
After Update set focus to the record with the most current date
in
Forms
I'm working with a continuous form we'll call subform1. The underlying query sorts by field DateOfService, descending. After a record updates the...
see more
0 replies | 0 view(s)
Today,
10:54 AM
jmuirman1
replied to a thread
formatting text in report to currency
in
Reports
Thanks for your help. I used your second suggestion but doesn't seem to work. I'm sure it's my mistake. Here's the whole text box: ="After the...
see more
2 replies | 17 view(s)
Today,
10:47 AM
pbaldy
replied to a thread
Dcount with same date stopped working in december
in
Access
What is the value of when it fails? You may have a date format problem: http://allenbrowne.com/ser-36.html#Format
see more
1 replies | 21 view(s)
Today,
10:33 AM
skidawgs
replied to a thread
Indexing Foreign Keys?
in
Access
Thank you for the insight, I am going to do some research on those queries to make sure I am properly searching for my indexed fields. Thank you!...
see more
5 replies | 224 view(s)
Today,
10:30 AM
orange
replied to a thread
formatting text in report to currency
in
Reports
Try format(14271,"$###,###.00") perhaps format(,"$###,###.00")
see more
2 replies | 17 view(s)
Today,
09:21 AM
marcossch
started a thread
Dcount with same date stopped working in december
in
Access
I was using the expression in forms =DCount("*";"Agenda";" = #" & & "# AND = '" & & "'") to count records with the same date and hour. It was...
see more
1 replies | 21 view(s)
Today,
08:52 AM
jmuirman1
started a thread
formatting text in report to currency
in
Reports
How do I display/format currency in a text box in a report? The report shows: (3) Please forward a check to Rose Smith in the amount of 14721,...
see more
2 replies | 17 view(s)
Today,
07:29 AM
RunTime91
started a thread
Trying to Divide the results of one query byt the resuts of another query
in
Access
Greetings ~ I've gone as far as Google will take me on this one... Seems simple - just trying to divide the results of two queries. SELECT...
see more
0 replies | 42 view(s)
Today,
07:16 AM
orange
replied to a thread
Findnext method and End of Recordset
in
Programming
Google/Bing can often be used to find examples of code and concepts. M$oft example here.
see more
2 replies | 79 view(s)
Today,
07:01 AM
skydivetom
replied to a thread
Determine which user(s) is logged into backend (BE)
in
Forms
June7 -- thanks for chiming in... 'appreciate it. Would you mind posting that sample database? Thank you!
see more
6 replies | 112 view(s)
Today,
06:11 AM
khayward
replied to a thread
Help with query criteria - Logic and mathematical comparisons
in
Queries
Thanks for responding, I'll try this out. I may be back with further questions!
see more
2 replies | 102 view(s)
Today,
04:14 AM
Rhothgar
replied to a thread
Newbie - Looking to change field name (somehow) prior to exporting
in
Import/Export Data
OK. Thanks for all your input so far. A web database might well be the way to go in the future once I've learnt Access but I'd rather keep it in...
see more
10 replies | 457 view(s)
Today,
03:13 AM
June7
replied to a thread
Determine which user(s) is logged into backend (BE)
in
Forms
I have a db that does not require user to enter a username/password. Code simply grabs their network username and matches to a record in Users table...
see more
6 replies | 112 view(s)
Today,
02:39 AM
isladogs
replied to a thread
Determine which user(s) is logged into backend (BE)
in
Forms
You are free to modify either of the apps yourself, but a few warnings. The password form is deliberately designed to work with encrypted...
see more
6 replies | 112 view(s)
Today,
01:53 AM
June7
replied to a thread
Run-time error '3464' Datatype mismatch in criteria expression: PLEASE HELP!!
in
Queries
Date/time fields require # delimiter, not apostrophe. & "',#" & Me.Cust_PO_Date & "#,'" & & "',#" & Me.Cust_Requested_Date & "#,'" & &...
see more
1 replies | 39 view(s)
Today,
01:20 AM
Vanita
started a thread
Run-time error '3464' Datatype mismatch in criteria expression: PLEASE HELP!!
in
Queries
Hi, For below code I'm getting Run-time error '3464' Datatype mismatch in criteria expression Error.Please help me to solve this code. Private...
see more
1 replies | 39 view(s)
Yesterday,
11:37 PM
GinaWhipp
replied to a thread
Legend issue in MS Access19
in
Access
Because of issues like this I often set up a template in Excel and export the raw data to it. I just find Excel handles charts better.
see more
2 replies | 149 view(s)
Yesterday,
10:54 PM
June7
replied to a thread
Create New Record and Update another table based on form results
in
Forms
I can't open your db because I only have Access 2010. There must be features used that are not backward compatible.
see more
4 replies | 218 view(s)
Yesterday,
09:41 PM
CascadeDog
replied to a thread
Create New Record and Update another table based on form results
in
Forms
On my ReceivablesFrm, I'd like a button that creates a record in the depositstbl with the date and amount total and then updates the accountingtbl...
see more
4 replies | 218 view(s)
Yesterday,
07:47 PM
Micron
replied to a thread
Findnext method and End of Recordset
in
Programming
Not much there to go on, but I think you want Do Until rs.EOF do stuff Loop
see more
2 replies | 79 view(s)
Yesterday,
07:31 PM
Micron
replied to a thread
Newbie - Looking to change field name (somehow) prior to exporting
in
Import/Export Data
I'm afraid I can't really comment on anything you're asking about Access that involves eCommerce because I have no experience with that. Have to...
see more
10 replies | 457 view(s)
Yesterday,
06:10 PM
Thompyt
replied to a thread
Unbound control into report
in
Reports
Makes perfect sense. Thanks
see more
2 replies | 61 view(s)
Yesterday,
05:41 PM
Gicu
replied to a thread
Send and SAVE outlook .msg email from Access VBA
in
Programming
Maybe try to search for the message id:...
see more
3 replies | 86 view(s)
Yesterday,
05:33 PM
Ajax
replied to a thread
Report text box for date(=Date()) fails in Access 2007 Runtime. Perfect in AC2007 Full version.
in
Reports
presume you mean the control name?
see more
5 replies | 81 view(s)
Yesterday,
05:29 PM
Gicu
replied to a thread
Changing Data Type of Linked Excel File
in
Access
You're welcome. When linking Excel files the wizard looks at the data in the first few rows to determine the "appropriate" data type for the linked...
see more
4 replies | 96 view(s)
Yesterday,
05:18 PM
pbaldy
replied to a thread
Report text box for date(=Date()) fails in Access 2007 Runtime. Perfect in AC2007 Full version.
in
Reports
I'm curious if it works with Date() now, since you said it worked with Now() anyway. I didn't notice that the control had the same name, which...
see more
5 replies | 81 view(s)
Yesterday,
05:15 PM
Edward_
replied to a thread
Report text box for date(=Date()) fails in Access 2007 Runtime. Perfect in AC2007 Full version.
in
Reports
I changed the field name to txtDate and the control source to: =Now(). All is well. Thanks
see more
5 replies | 81 view(s)
Yesterday,
05:13 PM
skydivetom
replied to a thread
Determine which user(s) is logged into backend (BE)
in
Forms
isladogs - your "Check Database Users" form looks much cleaner. WRT the 2nd database, I changed the scrambled PWD to another password (not...
see more
6 replies | 112 view(s)
Yesterday,
05:08 PM
isladogs
replied to a thread
Nested union query
in
Queries
Just use order by after the final union
see more
1 replies | 66 view(s)
Yesterday,
04:46 PM
JAPA1972
started a thread
Nested union query
in
Queries
I have a union query attached to a combobox with a query field called LASTNAME. Unfortunately the records are not sorted by LASTNAME as the UNION...
see more
1 replies | 66 view(s)
More Activity
No More Results
No Recent Activity