Activity Stream

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

No more Cloudflare, ever.

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

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

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?

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

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

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

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

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

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

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)

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

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

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

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.

Never even saw a request?

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

Why çan't you step in?

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

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

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

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

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