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

7 replies | 107 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 | 274 view(s)

Today, 04:43 AM

vinaynaran started a thread Do not display column when total is zeo in Access

Hi all, Part Branch1 Branch2 Branch3 Branch4 Branch5

7 replies | 67 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)

Today, 08:42 AM

jlindquist23 started a thread Text field missing carriage returns in Access

I'm pulling data from an ODBC table in Sage 100. When the data is viewed in a report in Access, all the carriage returns are ignored and all the...

6 replies | 36 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 | 102 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 | 84 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 | 51 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 | 150 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 | 76 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 | 37 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 | 47 view(s)

Today, 01:52 PM

jlindquist23 replied to a thread Text field missing carriage returns in Access

I'm using this in my query: Setup Instructions: Replace(Replace(,Chr(13),Chr(13) & Chr(10)),Chr(10),Chr(13) & Chr(10)) Can Grow and Can Shrink are...

6 replies | 36 view(s)

Today, 11:11 AM

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

If you referred to a column in the combo by the control, surely that would be empty as well?

7 replies | 107 view(s)

Today, 11:08 AM

Welshgasman replied to a thread Text field missing carriage returns in Access

I cannot see how that function produced that output? :(

6 replies | 36 view(s)

Today, 10:56 AM

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

I would suggest that you base the form on a query which references the unbound combo box, in the form header section, as a parameter on the PartName...

7 replies | 107 view(s)

Today, 10:38 AM

jlindquist23 replied to a thread Text field missing carriage returns in Access

Adding to Word: Using the function with a control in the report, the output is:

6 replies | 36 view(s)

Today, 10:24 AM

madpiet replied to a thread Do not display column when total is zeo in Access

This is where I like to resort to Excel. (Yeah, I know!) but I can do an unpivot in PowerQuery and it's done.

7 replies | 67 view(s)

Today, 10:21 AM

Ken Sheridan replied to a thread Do not display column when total is zeo in Access

Unfortunately, by having multiple columns for the branches, your table is 'encoding data as column headings'. A fundamental principle of the...

7 replies | 67 view(s)

Today, 09:49 AM

CJ_London replied to a thread Text field missing carriage returns in Access

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

6 replies | 36 view(s)

Today, 09:46 AM

Micron replied to a thread Text field missing carriage returns in Access

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

6 replies | 36 view(s)

Today, 09:25 AM

Welshgasman replied to a thread Text field missing carriage returns in Access

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

6 replies | 36 view(s)

Today, 07:59 AM

mike60smart replied to a thread Do not display column when total is zeo in Access

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

7 replies | 67 view(s)

Today, 06:39 AM

mike60smart replied to a thread Do not display column when total is zeo in Access

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

7 replies | 67 view(s)

Today, 05:51 AM

jojowhite replied to a thread Do not display column when total is zeo in Access

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

7 replies | 67 view(s)

Today, 05:32 AM

Welshgasman replied to a thread Do not display column when total is zeo in Access

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

7 replies | 67 view(s)

Today, 05:10 AM

CJ_London replied to a thread Do not display column when total is zeo in Access

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

7 replies | 67 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 | 37 view(s)