Recent content by Textatello

The only company type that we have in the finance reports table is Ltd or Limited. So in a hypothetical sense, is it possible?

Is it possible to tell the database that "Ltd" and "Limited" are the same thing? That would solve me a lot of hassle!

EDIT: It's working now! Thanks for that!

Hello guys, I have a relatively simple question but I am an amateur when it comes to VBA. I'll try my best to make this as simple and straight to the point as possible. I have two tables. One is tblMain and the other is tblFinanceReport. Both tables contain a field Customer Name. When the...

Apologies for the confusion. When creating an IF function in the Macro Designer. Normally, as you input an Object or Field name, before completing said name, Access 2010 will automatically finish the rest of the expression. Let's say I have a fieldname called "Brand". When inputting the...

It was automatically setup like that. Default open mode: SHARED Default record locking: NO LOCKS This is very frustrating as I need to access the extra action commands as I am yet to learn VBA. For now I am forced to deal with Macros. I'm aware that you are able to use SetProperty which...

I mean no harm in saying this but... I'm sure I have seen this message before when searching this error. I have successfully split the database but am still interested in knowing 'why' the error occurred. Also, a quick question... "Show All Actions" is greyed out in the Macro Designer...

Good afternoon guys, So, I am currently working on a project with a fellow colleague and we are close to completion but have just encountered a strange error. Please take into consideration that we are both learning and fairly new to Access. Only now is my knowledge starting to broaden outside...