Search results

]We have some progress! Thanks, Michael for your pointer. I have added it to my DBTool template, and it now allows me to manipulate a form in the Target database from within the Host database. (See attached DB). The critical code is: Public Sub ListTargetForms() Dim obj As AccessObject Dim...

Hi tb5038, You're providing some confusing information here. Let me see if I can show you where the confusion arises, and then ask you some questions. I hope that the two steps will help you ask a more instructive question - for what sounds like a fascinating application! You say: I don't...

Well - 6 months seems a like a long enough time for people to forget about this, so let's see if we can whack the sleeping giants! I'm trying to get access (sorry about that ;-) to forms, modules and tables in another database. I can list them, but now I need to gain access to, for example, the...

Here's an update on my problem. I considered several possibilities; 1) Some Form_Load event handler was screwing me up 2) The problem was volume related (ie after 28 forms being opened, the whole thing just hiccupped) 3) The problem was form-related (ie there is something about the form that...

Hmm Does the expression normalized database mean anything to you? Reason I ask is that if you have Time1 and Time2, then Time1-Time2 is only a calculation away. If you change either value, then Time1 - Time2 is still only a calculation away. Now imagine that an Evil User manages to change...

Would you please share some code, so we can get a better idea of what you're trying to do? If you already have a command button on the form, you can add an image of a red exclamation point by setting the value of the button's Picture property to the name of a file that contains the image you...

Hi Manish Starting point is how Access manages dates and times internally. Dates are the integer part of a floating point number, and Times are the fractional part. So a time is represented internally as a fraction between 0 and 1. It's actually the fractional part of 24 hours that the time...

Hi SupCom Without wishing to cause any offence, may I suggest that you not use abbreiviations like POD and SOW in a problem statement like this? My mind does not work the same as yours, and I had images of you throwing female pigs at a client.....;) However, if I am interpreting what you want...

Thanks, Rx and jdraw The environment is a local database (Access) that was used to construct a proof-of-concept tool for pitching to an organization in the UK. I now need to create the tool that will build at least the framework of the new environment (XAMPP). The easiest part, of course, is...

You probably want to use one of the Office FileDialogs. You'll need to establish a reference to the most current Microsoft Office Object Library. A quick check on the FilePicker dialog (Google msoFileDialogFilePicker to see how it's used) should give you exactly what you're looking for. The...

Hi I'm working on an application that will export and translate an Access database into a web-based (PHP/MySQL/Javascript) application. Small tests are going well, but when I try it on the 'production' scale database that is the true source for conversion, I repeatedly get the following error...

Thanks, CJ I've already done that, and there's absolutely no indication (from simply listing out Control Properties Name/Value pairs) that provides a clue. (Of course, one zero can have multiple meanings, but nothing that I could find leapt out and said "Ta!Da!") Tony

I'm getting waaaay to deep into Access' internals, but I have a nagging question - how does Access relate a label to a control? We can delete the label, and then re-'attach' it, but there seems to be no visible property that retains this information - in either the label or the control (only...

Thanks for the pointer, Spike. I haven't yet had a chance to see if a database opened other than as CurrentProject can have the AllForms (or indeed the AllAnything which sound delightfully useful ;-) object. However, it's a good start. Tony

I have a need to scan and analyze form properties - including controls - for an arbitrary form in an arbitrary database. Getting to the database is fine, and I then scan MsysObjects, to locate and identify the forms. This is where the trouble begins - if the form were being loaded from within...

Ain't that the truth! Tony

I'm a little puzzled: Huh? I should be able to get the value of a property by simply referencing it, right? (I suppose that a Get Property is already a function - that's the argument I used to defend the use of Name as a property!) THe actual code for the Project class is: Option Compare...

CJ! It's 0325 in London! When do you sleep! T

Thanks, CJ; Working from the bottom up: My bad. I have three Classes: Project; ProjectSource and SourceType. The class definition of ProjectSource includes a SourceType object; the Project Source table (obviously) goes through a painful enumeration of the SourceType again! (Wouldn't it be nice...

Re: How to go from Intermediate to Advanced What a silence......! At the risk of being flamed, let me offer some suggestions: Beginner: Uses (primarily) the built-in tools to create apps. Little or no VBA; Tables may or may not be normalized (Huh? What's...