Sure Mihail, I understand that. I was hoping it was something that would jump out and smack you in the face. Thanks for your solution. I'll have a play with it if I can't fix this one.
You inadvertently gave me a new lead. In unhiding the System objects you showed me the table MSysObjects which includes a Connect field showing "MS Access;PWD=asdf zxcv;". I'm going to play with the code with this in mind.
...
JayF
Last Activity: Oct 11 '12, 09:58 AM
Joined: Nov 6 '11
Location:
-
Hi Mihail,
An existing table was my first thought, however even on enabling all options, no table by the name of "tblTitlesM S Access" exists. Is there some other way a tabledef could be hidden?
As you predicted, even on commenting out the "On Local Error..." line, the code doesn't throw an error until it reaches line 87. (I had previously tested this, but missed it from my post, apologies Neo).
...Leave a comment:
-
And I just realised I might have completely missed what you were trying to achieve.
My solution above can't be used to display a MsgBox, it just displays text on the form.
Do you have a specific need for an intrusive MsgBox as opposed to a passive text box in red font? If so, I'll get back to you tomorrow if nobody else has. It's bed time.
Remember you can use a concatenation of fields for comparison purposes,...Leave a comment:
-
Hi,
I have the following expression in a text box on my contact details form:
=IIf(DCount("*" ,"[eqryContactsExt ended]","[Contact ID]<>" & Nz([Contact ID],0) & " And [Contact Name] = '" & Replace(Nz([Contact Name]),"'","''") & "'")>0,"POSSIBL E DUPLICATE","")
It displays "POSSIBLE DUPLICATE"...Leave a comment:
-
Dev Ashish's fRefreshLinks with password error
Hi all,
I'm calling a slightly modified Dev Ashish's fRefreshLinks as part of handling an error on opening the switchboard if the backend linked tables are missing. It's Access 2007.
I found a two line tweak online to enable the function to handle passwords, however, after implementing this I'm running into a strange error where the variable strTbl is having "MS Access" appended to it. The exact error message... -
This fixed it. I guess it must have been the split form in the background causing it.
In case anyone needs it, this is the code I used. There might be a better way of doing it, but this worked for me:
...Code:Private Sub Ref_Number_Click() Dim intID As Integer intID = Me.[Card ID] DoCmd.Close acForm, "lfrmCardList" DoCmd.OpenForm "dfrmCardDetails", , , "[Card ID]
Leave a comment:
-
Hi TSC. Thanks for your suggestion. Changing the recordsource to the SQL statement had no impact.
On the version I am working on all the tables and forms are contained within the same DB. I plan to split them before going live.
While writing this post your post led me down a train of thought...
The only two ways for a user to open the form are from a "New Membership Card" button on the switchboard...Leave a comment:
-
Single form slow to load for only one table.
Hi all,
I have an Access 2007 database that is struggling with one particular table only. The table is fairly wide at 49 fields, but I see no way to further normalise it.
On opening the main details form for this table, which is sourced directly to the table and not a query, there is a delay of around 3 - 6 seconds between opening the form window (Popup = Yes) and displaying the controls.
A split form (datasheet)... -
Sure Neo. Understood.
The very nonspecific and unhelpful nature of the error I was getting, as well as very little information I could find online, led me to think that the only way of adequately illustrating it was with an example, which I attempted to make as simple as possible by stripping it down.
As it happens, Mihail's advice that it was related to some kind of circular reference (or similar) in the queries, appears...Leave a comment:
-
Thanks for the info Mihail. I'll have a play with different query configurations and see if I can fix it.
I was under the impression the data was pretty well organised in my DB. I read a similar article to your link before I started developing this DB and have just read the one you linked to. I still don't see how it could be further broken down.
Perhaps with the exception of [Courier] in tblOrders I can't see...Leave a comment:
-
Thanks Mihail. I looked through the dependencies and found one missing (tblCategories) . This was indeed caused by a now redundant LookUp reference which was misnamed. I removed this lookup and retried the report to find that it returns exactly the same error.
All of the objects in this report's dependency tree are included in the sample.
I have reattached the database with the lookup removed.
Thanks...Leave a comment:
-
Hi Migi. All the queries run fine, which is what is puzzling me.
The queries run fine on their own, as does the continuous form, but when you put the two together it squeals. It's almost as if there is a problem with the linked fields, but on one table it is an autonumber field and on the other it is automatically passed across by the entry form subform on which Order Details are entered.Leave a comment:
-
"Expression typed incorrectly or too complex." on report subform.
Hi Guys,
I've hit another frustrating braintwister of a stumbling block.
Please find attached a stripped down version of my project containing a report, a subform and the tables and queries they depend on.
On running the report I get the error message:
"This expression is typed incorrectly, or it is too complex to be evaluated. For example, a numberic expression may contain too many complicated... -
I've been using Excel for years but only recently learned anything about VBA other than of it's existence. I've not had time to really delve into Excel VBA yet - I'm too busy learning Access - but I look forward to first playing with it armed with your tips above.
Thanks Neo. The world is a little better for the 576 people who have read this post. If everybody on the planet shared their knowledge as freely and persistently as you...Leave a comment:
-
I can't help, sorry, I came to this topic for an answer myself. But did you actually mean to say it's producing a 1.7Gb xlsx? Or did you mean 1,790Kb?Leave a comment:
-
Am I right in thinking that you want to remove the block on creating an invoice without completing the shipping details?
If so, try this.
- Click Database Tools > Visual Basic. Microsoft Visual Basic will open.
- On the navigation panel on the left find "Form_Order Details", double click it. The VBA code for that form will appear.
- About 2/3 of the way down you will find the following:
...Leave a comment:
-
One more piece of advice, if I may, just in case you aren't already doing it: Make regular copies of the template to play around with as well as very regular copies of your master version and name them all appropriately (e.g. Hotel Management v1.0.001, ...2, etc.) If you break something and can't figure out how to fix it, you can just skip back to a previous version and not lose too much work.
Also, there are loads of handy videos...Leave a comment:
-
Great stuff, as always.
No further explanation required. It works flawlessly.
Thank you so much for, once again, saving the day.Leave a comment:
-
Hi ADezii. You have understood correctly.
I would like to sequentially number a new [Ref] field in a table of existing live data. The format would simply be PRD000001, ...2, ...3, etc.
No dual formats (as per your last code) apply.
Easy for you maybe, but I am a mere semi-VBA literate mortal. :)
Thank you.Leave a comment:
-
I feel your pain. I was in your situation not long ago, that is; a complete newbie to Access. It's taken me the best part of three months' work to build from scratch a customised database somewhat more complex than Northwind, and it's still not completely finished.
Learning Access and DB Administration is a long, hard task. Even with a number of years experience in Excel, it's not something you can just pick up and crack on with....Leave a comment:
No activity results to display
Leave a comment: