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

10-04-2025, 02:49 PM

GraeagleBill started a thread

Problems attempting to add new record to table in Programming

I have a form with RecordSource "tblInvNew", which is empty and is identical in structure to table "tblInv". All of the controls in the form, where...

34 replies | 509 view(s)

10-01-2025, 08:08 PM

lawdy started a thread

Don't know how to make an update query in Queries

I am having trouble learning queries. The sub following runs, but it don't update the table. Please help. #Sub modQue_addNewLocation() ' ...

20 replies | 599 view(s)

10-01-2025, 05:12 PM

Noek started a thread Adding text field to form issue, control source not listed in property sheet in Access

I've created a form based on a table. Everything works fine. Now I am adding a text field to the table and form, I create a text field on the form...

6 replies | 740 view(s)

10-03-2025, 06:41 AM

maax555 started a thread Forms that add records to a table but also pull records from a different table? in Forms

Hi, been struggling with this for a while and would really appreciate some help. I have a table called CableParts. I use the form frmAddNewParts...

7 replies | 246 view(s)

10-05-2025, 05:12 PM

kgash started a thread Access locks up after error message in Queries

I'm in the middle of a QBE and when I start entering a Criteria I get the following message: The expression you entered contain invalid syntax and...

4 replies | 137 view(s)

Yesterday, 07:41 AM

Gary Frechette started a thread Searching for reference OFFOWC.DLL in Access

I'm a newbie, so please forgive me if I sound confused... We have migrated from our old Win 10 PC to a new PC running Win 11. The old PC was...

5 replies | 83 view(s)

Today, 02:24 AM

Matrix started a thread Opted Out of Cloudflare in Forum Suggestions

We’ve stopped using Cloudflare because it was causing login issues and other inconveniences for our members. Everything should work as usual now —...

6 replies | 45 view(s)

10-04-2025, 04:55 PM

JonathanT started a thread

Counting folders in Reports

Thought this would be simple but I can't seem to find an answer. I want to count the number of unique values in a field and show that number on a...

3 replies | 135 view(s)

Today, 11:11 AM

Carmine started a thread Open form with text box blank in Access

THE SITUATION: I have a form that contains a combo box and a text box. The purpose of the form is to correct data misspellings or inaccuracies in a...

3 replies | 22 view(s)

Yesterday, 01:06 PM

TOPSie started a thread Limit to list - slow second time in Access

I have just discovered that an application I inherited uses a combo box with "limit to list". So if you start typing it homes in on an entry from the...

2 replies | 60 view(s)

Today, 08:35 AM

jlgray0127 started a thread Sudden "Operation must use an updateable query" error in 5 year old query in Queries

Very unsure of what is happening here? I have an update query which updates two fields to a calculated value if one value is null UPDATE...

2 replies | 19 view(s)

Today, 07:43 AM

isladogs started a thread Access Europe User Group - Wed 1 Oct: High impact – Custom dialogs and mini-notifications (Marcus Di in Access

Oops - it appears I forgot to post this prior to the event! This is what you missed! The video is now on YouTube - see post #2 ...

1 replies | 16 view(s)

Today, 12:09 PM

madpiet replied to a thread Open form with text box blank in Access

Neither here nor there answer, but if you can find all the misspellings and add them to a table, you can add a column to it and add another column...

3 replies | 22 view(s)

Today, 12:06 PM

davegri replied to a thread Open form with text box blank in Access

You will need to make the textbox unbound. The after update event of the combox can populate the textbox. The after update event of the textbox...

3 replies | 22 view(s)

Today, 11:28 AM

mike60smart replied to a thread Open form with text box blank in Access

Hi Carmine Can you upload a copy of the Database with no confidential data?

3 replies | 22 view(s)

Today, 11:01 AM

Welshgasman replied to a thread Sudden "Operation must use an updateable query" error in 5 year old query in Queries

Check for any office update. Roll back until you can find the issue.

2 replies | 19 view(s)

Today, 09:30 AM

isladogs replied to a thread Opted Out of Cloudflare in Forum Suggestions

Woohoo! I got a notification!

6 replies | 45 view(s)

Today, 09:26 AM

Matrix replied to a thread Opted Out of Cloudflare in Forum Suggestions

No, it's mostly causing login problems. I just checked your email, the server log shows emails were sent to you successfully, please check your...

6 replies | 45 view(s)

Today, 08:40 AM

ranman256 replied to a thread Sudden "Operation must use an updateable query" error in 5 year old query in Queries

you cannot use a query with SUM TOTALS on, AND do an update. are any of those sub queries listed using SUM? (sum,count,max, etc)

2 replies | 19 view(s)

Today, 07:58 AM

Welshgasman replied to a thread Opted Out of Cloudflare in Forum Suggestions

Let us try and see what might be different, and fix it?

6 replies | 45 view(s)

Today, 07:52 AM

isladogs replied to a thread Opted Out of Cloudflare in Forum Suggestions

@Martrix Out of interest, was this anything to do with e-mail notifications not being received I did eventually change my forum email at your...

6 replies | 45 view(s)

Today, 07:44 AM

isladogs replied to a thread Access Europe User Group - Wed 1 Oct: High impact – Custom dialogs and mini-notifications (Marcus Di in Access

Marcus Dieterle gave a very impressive presentation to the Access Europe User Group on Wed 1 Oct where he demonstrated how his custom dialogs and...

1 replies | 16 view(s)

Today, 02:51 AM

Matrix replied to a thread Opted Out of Cloudflare in Forum Suggestions

Some private messages. I know Cloudflare was causing problems, but it made my job much easier. Now we're going to see huge amount of spam visits.

6 replies | 45 view(s)

Today, 02:33 AM

Welshgasman replied to a thread Opted Out of Cloudflare in Forum Suggestions

Never even saw a request?

6 replies | 45 view(s)

Today, 12:16 AM

June7 replied to a thread Searching for reference OFFOWC.DLL in Access

I opened mdb from that older thread. Get that missing reference error when opening VBA editor. Tools>References shows: MISSING: Microsoft Office XP...

5 replies | 83 view(s)

Yesterday, 02:11 PM

Welshgasman replied to a thread Limit to list - slow second time in Access

Why çan't you step in?

2 replies | 60 view(s)

Yesterday, 02:04 PM

Micron replied to a thread Limit to list - slow second time in Access

IIRC, limit to list does not do what you describe (filter as you type). That can occur if you have Auto Expand set to yes. It is also often done with...

2 replies | 60 view(s)