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 | 543 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 | 266 view(s)

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

5 replies | 75 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 | 142 view(s)

10-07-2025, 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 | 100 view(s)

Yesterday, 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 | 80 view(s)

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

3 replies | 44 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 | 143 view(s)

10-07-2025, 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 | 74 view(s)

Yesterday, 08:25 PM

jojowhite started a thread Cannot enter forum in General Chat

Just today, I cannot enter your forum without using VPN. It seems, you are Blocking my IP address (again). // Ignore this post. I can now enter...

2 replies | 25 view(s)

Yesterday, 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 | 40 view(s)

Today, 02:40 AM

Welshgasman replied to a thread Cannot enter forum in General Chat

Never, ever caught a glimpse of it here. :-) Unlike another site, where it pops up now and again.

2 replies | 25 view(s)

Today, 01:58 AM

Matrix replied to a thread Cannot enter forum in General Chat

No more Cloudflare, ever.

2 replies | 25 view(s)

Today, 01:30 AM

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

Perhaps an easy solution is to set the text box unbound until the combobox is filled. I mean to set the textBox controlsource to Null in dessign mode...

5 replies | 75 view(s)

Yesterday, 08:38 PM

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

On the Load Event of the Form, use DoCmd to GoTo New Record. When a selection is made on the combobox, you Search it on the form: Private Sub...

5 replies | 75 view(s)

Yesterday, 04:42 PM

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

The query is updating via a query. Maybe Qry_TBL_PRODUCTION_SCHEDULE is the problem query. Has that query changed recently, making it un-updateable?

3 replies | 44 view(s)

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

5 replies | 75 view(s)

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

5 replies | 75 view(s)

Yesterday, 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?

5 replies | 75 view(s)

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

3 replies | 44 view(s)

Yesterday, 09:30 AM

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

Woohoo! I got a notification! I did find a few in the spam folder for my previous email.

6 replies | 80 view(s)

Yesterday, 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 | 80 view(s)

Yesterday, 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)

3 replies | 44 view(s)

Yesterday, 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 | 80 view(s)

Yesterday, 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 | 80 view(s)

Yesterday, 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 | 40 view(s)

Yesterday, 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 | 80 view(s)

Yesterday, 02:33 AM

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

Never even saw a request?

6 replies | 80 view(s)

Yesterday, 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 | 100 view(s)

10-07-2025, 02:11 PM

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

Why çan't you step in?

2 replies | 74 view(s)