Activity Stream

pass your string to this function and see results in the immediate window Function AscChar(s As String, Optional startpos As Long = 1, Optional...

To find out what those characters are, you might need to paste the original content into Word. I think it's Show/Hide in the paragraph group on the...

I would look to see what characters are meant to be the linefeed/carriage return. Then replace those with vbCrLf

In my example database you would need to run the "qryAllFields_Crosstab" to show the desired output. To get the Totals for each Column you would...

Hi Vinay Attached is an example of how you should construct your tables.

what you will be needing is a VBA to build your query. then you need a form to display the resulting query (see SampleForm on the demo). see the...

I would create a count for each branch for each record. If a branch count of zero for a branch equals the record count, then omit that branch. So...

If your data was properly normalised, it would not be a problem- you would simply use a crosstab query to display the data. As it is you would need...

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.