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

2 replies | 23 view(s)

Today, 02:33 AM

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

Never even saw a request?

2 replies | 23 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 —...

2 replies | 23 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 | 58 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 | 47 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 | 47 view(s)

Yesterday, 01:44 PM

xps35 replied to a thread Forms that add records to a table but also pull records from a different table? in Forms

As others explained, tables CableParts and tblQuality are joined by PartNumberID. The combobox stores a PartNumberID (that is the foreign key) and...

7 replies | 226 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 | 47 view(s)

Yesterday, 11:34 AM

Welshgasman replied to a thread

Problems attempting to add new record to table in Programming

My tip for requerying and NOT moving from current record is to requery the recordset NOT the form

34 replies | 471 view(s)

Yesterday, 11:30 AM

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

Also mentioned here previously. https://www.accessforums.net/showthread.php?t=75879 @June7 the link I posted has an AI explanation.

5 replies | 58 view(s)

Yesterday, 11:01 AM

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

I can't find that file on my computer either. It would be interesting to know what library reference is missing.

5 replies | 58 view(s)

Yesterday, 10:39 AM

Micron replied to a thread

Problems attempting to add new record to table in Programming

Thanks for that assistance. This thread is marked as solved, so am I just confusing things by chiming in? Or is there still a problem? I made a...

34 replies | 471 view(s)

Yesterday, 10:37 AM

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

you can download the missing dll from: offowc.dll free download | DLL‑files.com

5 replies | 58 view(s)

Yesterday, 10:14 AM

pbaldy replied to a thread

Problems attempting to add new record to table in Programming

Bill is having difficulty posting and asked me to post the following thoughts: Would you point out to him (Micron) that the two forms involved use...

34 replies | 471 view(s)

Yesterday, 08:04 AM

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

Go into the VBA IDE and then Tools/References. What comes up as missing? I have 2019 myself and do not have that file on my computer. What...

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

Yesterday, 02:05 AM

Welshgasman replied to a thread

Problems attempting to add new record to table in Programming

I would have thought the requery would be needed to see if a new record had been added? I would probably requery regardless but stay on current...

34 replies | 471 view(s)

10-06-2025, 06:55 PM

Micron replied to a thread

Problems attempting to add new record to table in Programming

OK, but doing a move first or last is not a requery. Or am I not following? Me.RecordsetClone.MoveLast lngCount = Me.RecordsetClone.RecordCount...

34 replies | 471 view(s)

10-06-2025, 05:56 PM

GraeagleBill replied to a thread

Problems attempting to add new record to table in Programming

Because form "frmItemDescriptor" might create a new item and the record count would increase as a result. If so, I need to Requery so the user can...

34 replies | 471 view(s)

10-06-2025, 05:35 PM

Micron replied to a thread

Problems attempting to add new record to table in Programming

You're assigning recordsetclone.count to the variable lngCount then asking if one is greater than the other. How would that be possible? I don't see...

34 replies | 471 view(s)

10-06-2025, 04:06 PM

GraeagleBill replied to a thread

Problems attempting to add new record to table in Programming

No, still does not Requery: Private Sub cmdNewItem_Click() '*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=* ' ...

34 replies | 471 view(s)

10-06-2025, 03:37 PM

Welshgasman replied to a thread

Problems attempting to add new record to table in Programming

I would expect you would need to MoveLast for the first count?