Activity Stream - Microsoft Access Forums

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

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...

30 replies | 889 view(s)

Today, 09:36 AM

CJ_London replied to a thread Form to append multiple records in table in Forms

look again

30 replies | 889 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...

30 replies | 889 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

30 replies | 889 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...

2 replies | 49 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?

6 replies | 71 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...

6 replies | 71 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...

2 replies | 49 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.

6 replies | 71 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...

30 replies | 889 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

6 replies | 71 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...

6 replies | 71 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...

6 replies | 71 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}" ...

6 replies | 71 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...

2 replies | 49 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.

2 replies | 40 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...

2 replies | 40 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...

2 replies | 40 view(s)

Yesterday, 05:19 PM

Gicu replied to a thread Get a Next Deposit Date depending on criteria? in Queries

Already done :).... Cheers,

11 replies | 561 view(s)

Yesterday, 04:08 PM

June7 replied to a thread Not in list for unbound combo box in Programming

Advise instead of setting combo to empty string, use Null or mycomb.Undo. I don't like dealing with empty strings if I can help it. Don't really...

3 replies | 61 view(s)

Yesterday, 03:30 PM

lefty2cox replied to a thread Not in list for unbound combo box in Programming

I kept at it and sorted it out. Thank you very much. I think I was stuck in a weird loop. I think that the not in list event would fire and then I...

3 replies | 61 view(s)

Yesterday, 03:18 PM

Emmanuel replied to a thread Shift Bypass key program not working in Access

Great. All the best

27 replies | 1880 view(s)

Yesterday, 02:57 PM

d9pierce1 replied to a thread Get a Next Deposit Date depending on criteria? in Queries

thank you so much! Will do it! Dave

11 replies | 561 view(s)

Yesterday, 02:35 PM

June7 replied to a thread Not in list for unbound combo box in Programming

Yes, should be possible. Post your attempted code.

3 replies | 61 view(s)

Yesterday, 02:21 PM

lefty2cox started a thread Not in list for unbound combo box in Programming

I have a form with a combo box that is unbound. The form itself is bound to myTable The row source for the myCombo is a select statement based on the...

3 replies | 61 view(s)

Yesterday, 11:38 AM

Gicu replied to a thread Get a Next Deposit Date depending on criteria? in Queries

Here you go Dave, you were almost there, took your sub and made it a public function in a standard module so you can call it from a query. Cheers,

11 replies | 561 view(s)

Yesterday, 06:16 AM

d9pierce1 replied to a thread Get a Next Deposit Date depending on criteria? in Queries

Hi all, Know it has been quite a while however I have been shuffeled around the states fixing problem jobs so have not had a lot of time to do this....

11 replies | 561 view(s)

Yesterday, 03:12 AM

June7 replied to a thread Form to append multiple records in table in Forms

Looping multi-select listbox selected items and doing something with each item is a common topic. Here is one example:...

30 replies | 889 view(s)

Yesterday, 02:33 AM

isladogs replied to a thread Draw vertical lines between subreports in Reports

Following on from the last post, Access MVP, Crystal Long, has several articles on this topic. For example Draw Lines and Boxes on Access Reports...

2 replies | 86 view(s)

Yesterday, 01:13 AM

Sam replied to a thread Form to append multiple records in table in Forms

Wouldn't this be a lot easier. I just need to lay my hands on some VB to pick up the multi selected customers and raise that many bills.

30 replies | 889 view(s)