Activity Stream

Or, when you refer to indexing, are you referring to the indexes on the back end, the MariaDB database? We do have a situation where the same...

Thank you for the reply. Linked to MariaDB tables. Single user app. Access is on a Windows 2016 Server and the database is on a separate server,...

I opened the form, then I clicked the i button. It throws an error telling me Openword is not a sub. Then you post the code for that function in post...

Need more background information tables are linked to what? a .accdb or .mdb? sql server? something else? Is this a multi user app? if so, is the...

Edgar. Years ago someone helped me with this code, preceding the opening of external word documents. It works well on my forms, but this post is all...

Thanks CJ. When I searched the Internet I found that reference with the words you suggest. I learn more when you say it is to do with the table and...

Edgar 1.In the long post at post #21 you helped me with the code. See form f6FieldNames. 2.Apologies if I misunderstand. Ignore anything else in...

the link also says Access also creates a new field (increasing the internal column count by 1) for every field whose properties you modify. and...

Do bear in mind that password retrieval from old MDB files is trivial but the same methods do not work on ACCDB files. For ACCDB files, the only...

What the reference states, is that even when fields are deleted it stays in the count of 255. The two queries that brought up the issue is large and...

I suspect there is a reference somewhere to the wrong drive. This could be just about anywhere. One way to find such references might be to use the...

It is the same with the switchboard. I just did this Function OpenCommonForm(pOpenArgs As String) ' Open a form for Reports & Queries...

I never encountered that error either. Compact & Repair should fix. Limit is 255 fields pulled into query. Total fields for all tables pulled from...

I found that reference before you sent it but thank you. It is a tragedy. I think Mr. Bill Gates must work overtime and fix that. I wonder in a query...

Other thoughts, it has to be a public function in a standard module, and the function can not have the same name as a module.

well, i tried the online formatter. It's definely better :p

thanks for the online formatter and.... what you see like madness is purely wisdom, but your small soul cannot recognize it :D stop joking, i...

not enough information to advise., but so far as I am aware the only way to clear the memory is to close access. I doubt memory per se is the...

See attached example. Notice the column count and column widths property values for the listbox. This is how you set how many columns your listbox...

Should be very easy if you join the two queries on the purchasing categories field (you should probably make the join a left outer join with the...

You probably didn't check the Save Password checkbox in the linked table manager (you will get prompted for every table). I would suggest to use a...

I often move my db between home and office and links are obviously broken in doing so. I use JStreet's relinker which can be found here ...

Raddle, You have attached your post to a 10 year old thread???? This works for me.

Hi Karin, Here's a demo of Albert's Super easy word merge that works in both 32 and 64 bit.

Do bear in mind that password retrieval from old MDB files is trivial but the same methods do not work on ACCDB files. For ACCDB files, the only...

Raddle, You have attached your post to a 10 year old thread????