Thank Linq.
I had the help desk replace the DLL with a copy I took from another machine. Still shows as missing so I copied it to my Dbase development folder on my network drive and selected that one through the references dialogue and it works fine now. Go figure.
Thanks again.
FireMedic
Last Activity: Apr 30 '08, 05:33 AM
Joined: Mar 4 '07
Location: Fort McMurray Alberta, Canada
-
Sudden DLL Errors
I tried to continue a development project on a workstation in our satellite firehall tonight and suddenly am getting a "ERROR LOADING DLL" message when I try to open my main form. If I klick OK it takes me to Break Mode in the VBA editor but any attempt to write or edit code is met with the same error. This is new and hopefully just on this machine as I used my normal workstation last night without any difficulties. I have used this one... -
Hi sierra7
Thanks for the info. Unfortunately I work in a locked system with the exception of my work station in my office in our main firehall which is an unlocked developer machine. Any changes,install s,updates etc have to be pushed from a central authority and scripted for GI in many cases. This takes a long long time and requires the sacrifice of your firstborn and royal assent if you catch my drift.
Which brings me to my new thread...Leave a comment:
-
Thanks ADezii.
I've parked that block of code for now due to time constraints and have gone to having the Suppliers or Manufacturers form open if the user opts too add the newData. Im using the New data as a variable and inserting it into the name field through the OpenArgs event of the Sup/Mfg forms. I did find that on some of the forms the data was actually added to the table numerous times but was not appearing in the cbo and the Default...Leave a comment:
-
Well Gents I don't know. I've put it back as a private sub in each subform and it still fails to add the data and requery itself. I get the default notInList warning right after my custom message box and no satisfaction. . Sigh
...Code:Private Sub MfgID_NotInList(NewData As String, Response As Integer) On Error GoTo MfgID_NotInList_Err Dim IntAnswer As Integer Dim StrSql As StringLeave a comment:
-
Sigh... I was afraid of that...There are eighteen subforms and this routine will have to be repeated twice on each .. once for supplier and once for Mfg. Well so be it then. Onward and upward.
I've just gotten back to this after many months of busy work expanding our department responsibilitie s to include ARFF response at our new on-site aerodrome so I'm still behind the curve on where I left off. Hmmm did someone say commenting your code...Leave a comment:
-
Forgot to mention that the visible column in the cbo box is a text field while the bound column is an autonumber ID field.
Thanks againLeave a comment:
-
NotInList making me crazy(er)
Hello all,
Having a bit of grief with a NotInList code block that has quit working properly.
I have set it as a public sub in a module so I can use it in multiple forms. I t worked ok in the form module but seems to be a bit glitchy in the public mode.
The new value does not seem to be taking and in spite of "acdataAdde d" it continues to pop up the standard warning telling the user to pick an item from the list... -
You Sir are a prince among PuppyDogBuddies .
Works like a charm.
Thanks a millionLeave a comment:
-
Lt. Butler,
I'm no Access genius myself but I can think of two good ways of doing this.
1. Instead of basing your forms on the tables, create queries with only the fields you want from your main demographics table and all of the fields from the table that is the main topic of the particular form. Or...
2. Create your main Demographics form and add the others to it as subforms using a subform control...Leave a comment:
-
Calling NotInList event code for multiple forms
Hello all,
I am creating an application that has an equipment inventory and maintenance form that has numerous subforms that are displayed depending on the category of equipment selected.
I have two common combo boxes on each subform - "Supplier" and "Manufactur er". I use the following code for the "NotInList" event and it works fine. (This is the version for the "Supplier" cbo)
... -
Hi Carol,
If I understand this right (and my apologies if I don't) why not just set the record source of your form to be your customers table and just add new record to add a new customer. That way you have no need of an append query at all. Again that is if I understand the situation correctly this would be the least complicated method.
Let me know if I'm out to lunch on this.Leave a comment:
-
Yes Indeed ... Like my own..Yikes... His assistance is much appreciated....Leave a comment:
-
I would suggest using an "If/Then/Else" or a "Select Case" ie.:.Code:If [tbl_value] is < 7 Then [MyDate] = DateAdd("yyyy",2,[OriginalDate])
It might be more elegant to declare your interval as a string and use the IF or Select Case to set the value..Code:DateAdd("yyyy",MyString,[OriginalDate])
I hope I'm not being to vague. It's 0530 at the tail end of a night shift for me.
...Leave a comment:
-
Aha!!
Thank you, that worked great.
I'm not as concerned with having a lot of near-duplicate forms in the Dbase as I am with having to load a pile of them at once and make them visible one at a time. I'm sure that would be a real drag on the speed of the app. Thanks again....Leave a comment:
-
Multi-Use Forms
In my current project I would prefer to save space by reusing an equipment inventory form to display, edit and enter data for several different categories of equipment. Data is stored in several tables with some variation in number of fields and data types.
Essentially I know how to set RecourdSource through VBA but am not sure of the best way to set corresponding control labels and data types etc.
For that matter is...
No activity results to display
Leave a comment: