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
New Activity (
)
Please reload this page to view the 200+ new activity items that have been created.
Older Activity
Today,
12:18 PM
Minty
replied to a thread
How to keep global variables from being stomped on by NEW instance or other form?
in
Programming
I understand having multiple instances of a form. My point was that no matter how many forms you have open you are only running code in one of them...
see more
7 replies | 62 view(s)
Today,
12:06 PM
twgonder
replied to a thread
How to keep global variables from being stomped on by NEW instance or other form?
in
Programming
Here is an example, if we're talking about the same thing, of P1 (MyForm2_3) running two instances at the same time.
see more
7 replies | 62 view(s)
Today,
12:05 PM
Minty
replied to a thread
How to keep global variables from being stomped on by NEW instance or other form?
in
Programming
DP - but this might link might help: https://www.reddit.com/r/vba/comment.../async_in_vba/
see more
7 replies | 62 view(s)
Today,
11:45 AM
CJ_London
replied to a thread
Form to append multiple records in table
in
Forms
what does the error message tell you? edit - a simple google will tell you all about listbox properties...
see more
34 replies | 920 view(s)
Today,
11:37 AM
mike60smart
replied to a thread
Form to append multiple records in table
in
Forms
Hi CJ How am I supposed to Declare itm? Tried this Private Sub cmdInsert_Click() Dim db As Database Dim RS As Recordset Dim Itm As...
see more
34 replies | 920 view(s)
Today,
11:22 AM
CJ_London
replied to a thread
Form to append multiple records in table
in
Forms
why do you think that when you said itm was highlighted? as far as lngitem is concerned, you are not using it, so doesn't need to be declared. But...
see more
34 replies | 920 view(s)
Today,
11:17 AM
Minty
replied to a thread
How to keep global variables from being stomped on by NEW instance or other form?
in
Programming
If you reset the code anywhere it will destroy any global variables. Access is (as far as I am aware) completely synchronous within it's own...
see more
7 replies | 62 view(s)
Today,
11:14 AM
tortiman
started a thread
Calculated fields in subforms
in
Forms
Hi everyone, I am making a database for profits or loses in stocks. I have a table called tblOperational and this table is related with another...
see more
0 replies | 7 view(s)
Today,
10:38 AM
mike60smart
replied to a thread
Form to append multiple records in table
in
Forms
Hi CJ This is where my lack of VB knowledge lets me down I thought that the Variable Item is the BookingID Do I need to Dim lngItm at all ? as...
see more
34 replies | 920 view(s)
Today,
10:18 AM
moke123
replied to a thread
Clear the immediate window in VBA
in
Programming
While poking around to see if there is a way to do it with VBA extensibility, I noted a post from Chip Pearson basically saying he has tried...
see more
7 replies | 81 view(s)
Today,
10:17 AM
twgonder
replied to a thread
How to keep global variables from being stomped on by NEW instance or other form?
in
Programming
Okey, this is my third attempt to write something legible to your post. I'm with you, up to a point. Trying to figure out if Access isn't...
see more
7 replies | 62 view(s)
Today,
09:44 AM
orange
replied to a thread
Form to append multiple records in table
in
Forms
Suggest you add Option Explicit at the top of your module as a standard practice. Then, Access will point to your error. As CJ said you have...
see more
34 replies | 920 view(s)
Today,
09:36 AM
CJ_London
replied to a thread
Form to append multiple records in table
in
Forms
look again
see more
34 replies | 920 view(s)
Today,
09:22 AM
mike60smart
replied to a thread
Form to append multiple records in table
in
Forms
Hi CJ I tried this but it gives the same error? Private Sub cmdInsert_Click() Dim db As Database Dim rs As Recordset Dim lngItm As...
see more
34 replies | 920 view(s)
Today,
08:59 AM
CJ_London
replied to a thread
Form to append multiple records in table
in
Forms
error message is telling you the problem - you have not declared itm
see more
34 replies | 920 view(s)
Today,
08:07 AM
twgonder
replied to a thread
How to keep global variables from being stomped on by NEW instance or other form?
in
Programming
Okay, so after hours of revisiting this ancient problem, I decided to make a hand-drawing (my apologies, I'm not a graphic artist nor great with...
see more
7 replies | 62 view(s)
Today,
08:00 AM
Welshgasman
replied to a thread
Clear the immediate window in VBA
in
Programming
Colin, I just downloaded the 32bit version and tried to run it and AVG reported as below?
see more
7 replies | 81 view(s)
Today,
07:49 AM
isladogs
replied to a thread
Clear the immediate window in VBA
in
Programming
Personally, I avoid any solution based on SendKeys as these are notoriously unreliable, particularly after version changes. As well as the...
see more
7 replies | 81 view(s)
Today,
07:27 AM
Minty
replied to a thread
How to keep global variables from being stomped on by NEW instance or other form?
in
Programming
In my opinion if more than one process can set the same Global and have different consequences, it's no longer suitable for use as a Global, it...
see more
7 replies | 62 view(s)
Today,
07:19 AM
Minty
replied to a thread
Clear the immediate window in VBA
in
Programming
If you have MZ-tools there is a command button for that. Very useful.
see more
7 replies | 81 view(s)
Today,
06:51 AM
mike60smart
replied to a thread
Form to append multiple records in table
in
Forms
Hi June I am trying to help Sam in resolving this issue and in the On Click Event he has the following Code but when he runs it he gets the...
see more
34 replies | 920 view(s)
Today,
06:04 AM
twgonder
replied to a thread
Clear the immediate window in VBA
in
Programming
If someone else is in the same boat someday, this video might help: https://youtu.be/qc-7uYr7kHE
see more
7 replies | 81 view(s)
Yesterday,
11:26 PM
twgonder
replied to a thread
Clear the immediate window in VBA
in
Programming
I'll have to try that again, if I recall correctly, it left the cursor way down there, so then we need a trick to get it back to the top. There...
see more
7 replies | 81 view(s)
Yesterday,
11:09 PM
moke123
replied to a thread
Clear the immediate window in VBA
in
Programming
I never use send keys so couldn't tell ya. Since the immediate window is limited to a couple hundred lines Dim i As Integer For i = 0...
see more
7 replies | 81 view(s)
Yesterday,
09:58 PM
twgonder
started a thread
Clear the immediate window in VBA
in
Programming
I ran across several sites that propose this solution (mostly for Excel) to clear the immediate window: Application.SendKeys "^g ^a {DEL}" ...
see more
7 replies | 81 view(s)
Yesterday,
08:54 PM
twgonder
started a thread
How to keep global variables from being stomped on by NEW instance or other form?
in
Programming
I started thinking how I'm going to port part of an old design to Access, which allows for more than one process to run in a "workspace". I'm not...
see more
7 replies | 62 view(s)
Yesterday,
06:58 PM
GEG
replied to a thread
Create a dropdown list from each row with multiple columns from a query.
in
Programming
That did it, I knew it was probably something simple. I just couldn't find anything telling me that.
see more
2 replies | 44 view(s)
Yesterday,
06:18 PM
Gicu
replied to a thread
Create a dropdown list from each row with multiple columns from a query.
in
Programming
I think you'll need to provide a bit more specific info on where this desired dropdown is to be used; in a combo box control (which is what is...
see more
2 replies | 44 view(s)
Yesterday,
05:28 PM
GEG
started a thread
Create a dropdown list from each row with multiple columns from a query.
in
Programming
I'm new to this and it may be a simple question, but I can't find it and I have been trying to figure out how to create dropdown list from column...
see more
2 replies | 44 view(s)
Yesterday,
05:19 PM
Gicu
replied to a thread
Get a Next Deposit Date depending on criteria?
in
Queries
Already done :).... Cheers,
see more
11 replies | 570 view(s)
More Activity
No More Results
No Recent Activity