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:
Forums
Clear All
New Activity (
)
Please reload this page to view the 200+ new activity items that have been created.
Older Activity
Today,
12:30 PM
Welshgasman
replied to a thread
Using Cutom Functions in a Query (form recordset)
in
Queries
Yes, there appears to be rounding errors. Add them up, and I get 119.1 and 11:17 That is why I was asking if it that would cause you any issue?...
see more
16 replies | 196 view(s)
Today,
12:08 PM
Salty Mariner
replied to a thread
Using Cutom Functions in a Query (form recordset)
in
Queries
I'm not sure what you mean, I added up the distance with a calculator and got a 0.1 difference. I used the Round Function on the decimals in the...
see more
16 replies | 196 view(s)
Today,
11:59 AM
Welshgasman
replied to a thread
Using Cutom Functions in a Query (form recordset)
in
Queries
The totals diaplayed do not add up to the values being displayed.? Is that going to cause you an issue?
see more
16 replies | 196 view(s)
Today,
11:51 AM
Salty Mariner
replied to a thread
Using Cutom Functions in a Query (form recordset)
in
Queries
I did just that this morning. Working like a champ.
see more
16 replies | 196 view(s)
Today,
11:42 AM
Gicu
replied to a thread
unable to empty text boxes
in
Programming
Usually it is preferred to use Null instead of zero length string "" so your line will simply become: Forms!frmAmainMenu.Controls(strBox)=Null ...
see more
3 replies | 24 view(s)
Today,
11:37 AM
June7
replied to a thread
Using Cutom Functions in a Query (form recordset)
in
Queries
Can't you use Sum() in footer?
see more
16 replies | 196 view(s)
Today,
11:16 AM
Welshgasman
replied to a thread
Error when using WIA library and doing auto document feed scanning
in
Programming
No idea TBH, but this link says he got it working before trying duplex? http://www.vbaexpress.com/forum/archive/index.php/t-67022.html
see more
1 replies | 25 view(s)
Today,
11:08 AM
Welshgasman
replied to a thread
unable to empty text boxes
in
Programming
It ia called a language for a reason. :( You cannot just go and make your own names up without doing something like davegri mentions in post #2
see more
3 replies | 24 view(s)
Today,
10:54 AM
davegri
replied to a thread
unable to empty text boxes
in
Programming
Looks like 'Empty' is undefined. So, Dim Empty as string : Empty = "" or just Forms!frmAmainMenu.Controls(strBox) = "" If you have the...
see more
3 replies | 24 view(s)
Today,
10:29 AM
RickSanchez
started a thread
Error when using WIA library and doing auto document feed scanning
in
Programming
Why am I getting this error when trying to use the Transfer method? The line that causes the error is below. I can provide more info as needed so...
see more
1 replies | 25 view(s)
Today,
10:08 AM
lawdy
started a thread
unable to empty text boxes
in
Programming
The following function works good to make the text boxes visible on my form. But, when I add the line *shown in bold text below) to 'Empty' the...
see more
3 replies | 24 view(s)
Today,
08:05 AM
ranman256
replied to a thread
item not found in collection, error cdoe 3265
in
Modules
normally you just run a query(s) rather than write code to cycle thru the recordset.
see more
2 replies | 143 view(s)
Today,
04:52 AM
ArviLaanemets
replied to a thread
Importing Excel into Access
in
Import/Export Data
Generally, it is a bad idea to insert data from Excel table(s) directly into MS Access (or any other relational database program) table, which is...
see more
9 replies | 457 view(s)
Today,
02:57 AM
isladogs
replied to a thread
msaccess.exe remains open
in
Access
There is a very lengthy thread at Microsoft Tech Community which may relate to your issue. Unfortunately, as yet there are no definitive causes or...
see more
3 replies | 87 view(s)
Today,
12:13 AM
CJ_London
replied to a thread
msaccess.exe remains open
in
Access
What bitness of access 2016 did you install? 32 or 64?
see more
3 replies | 87 view(s)
Yesterday,
11:44 PM
Welshgasman
replied to a thread
msaccess.exe remains open
in
Access
My bet would be on an update TBH. Are you unable to remove the update and see if it works again?
see more
3 replies | 87 view(s)
Yesterday,
11:41 PM
Welshgasman
replied to a thread
Old Access Database Conversion
in
Programming
Been there since the 2007 version.
see more
39 replies | 2986 view(s)
Yesterday,
11:03 PM
Salty Mariner
replied to a thread
Using Cutom Functions in a Query (form recordset)
in
Queries
I got it working. I created a query and ran DLookup against it and all of my other functions are now working inside of the forms recordset. I...
see more
16 replies | 196 view(s)
Yesterday,
09:57 PM
June7
replied to a thread
Using Cutom Functions in a Query (form recordset)
in
Queries
Have to concatenate variables to construct SQL. & "WHERE tblVpLegs.VP_ID = " & intVpID & " AND tblVpLegs.LegNo = " & intLegNo
see more
16 replies | 196 view(s)
Yesterday,
08:58 PM
Salty Mariner
replied to a thread
Using Cutom Functions in a Query (form recordset)
in
Queries
The Forms recordset is: SELECT tblVpLegs.VLeg_ID, tblVpLegs.VP_ID, tblVpLegs.LegNo, tblVpLegs.Wpt_ID, tblWaypoints.WptName, tblWaypoints.Latitude,...
see more
16 replies | 196 view(s)
Yesterday,
08:37 PM
June7
replied to a thread
Using Cutom Functions in a Query (form recordset)
in
Queries
So what is the form's RecordSource? You can use the same SQL in code to construct Recordset, just add WHERE clause to open with only the one desired...
see more
16 replies | 196 view(s)
Yesterday,
08:30 PM
Salty Mariner
replied to a thread
Using Cutom Functions in a Query (form recordset)
in
Queries
Hello June, I had an opportunity to look at your comments and while I love the simplicity of the methods you provided my thoughts are that these...
see more
16 replies | 196 view(s)
Yesterday,
06:56 PM
katjoe
replied to a thread
Importing Excel into Access
in
Import/Export Data
OK, I will try this, thanks.
see more
9 replies | 457 view(s)
Yesterday,
06:53 PM
katjoe
replied to a thread
Importing Excel into Access
in
Import/Export Data
Ok, thank you for this guidance
see more
9 replies | 457 view(s)
Yesterday,
06:42 PM
katjoe
replied to a thread
Importing Excel into Access
in
Import/Export Data
Thank you so much for your guidance. I will try this!
see more
9 replies | 457 view(s)
Yesterday,
05:34 PM
Cosimo
replied to a thread
Old Access Database Conversion
in
Programming
Thank you. I will do that. I had a feeling there was a new way to do it.
see more
39 replies | 2986 view(s)
Yesterday,
04:49 PM
Cosimo
started a thread
msaccess.exe remains open
in
Access
Last Friday, I installed MS Office Professional Plus 2016 on a Windows 10 PC, after first using an MS tool for removing other Office versions. I...
see more
3 replies | 87 view(s)
Yesterday,
03:59 PM
RickSanchez
started a thread
Error when scanning with Microsoft WIA and using the top tray feeder instead of the glass pane
in
Programming
I'm trying to set up pull scanning from Access to a scanner on the network. I am using Color Network ScanGear 2 as the middleware. I need to figure...
see more
0 replies | 55 view(s)
Yesterday,
02:02 PM
skydivetom
replied to a thread
Form/data locked
in
Forms
Ah, that makes sense.... thank you for this valuable information. That solved the issue.
see more
2 replies | 104 view(s)
Yesterday,
01:11 PM
Welshgasman
replied to a thread
Old Access Database Conversion
in
Programming
You can set a form to open in options. No need for an auto exec macro.
see more
39 replies | 2986 view(s)
More Activity
No More Results
No Recent Activity