That's fine. I've found a reasonable, although not ideal, solution. Thank you for the attempt, however.
Just to clarify, yes, users will be adding forms to the database at a later date. I think the confusion comes from there being two different kinds of forms I am refering to. I tried to keep them distinct, but let me clarify.
First, there are forms that are database objects that users can interact with (the ones...
fauxanadu
Last Activity: Oct 14 '08, 04:31 PM
Joined: Mar 13 '07
Location:
-
-
There are about 100 forms I am going to impliment in a database. Each form has a save function. This save function will do the following:
- Loop through each control on the form
- When it finds a textbox or combo box, get the value
- Record the text/combo box value, the controls item number to the table
- Record the location of the control to the database (Was it on the main form or one of the subforms? If subform, which one?)
...Leave a comment:
-
Here is a solution that does what is needed, although in a rather ugly way:
...Code:Private Sub cmdTest_Click() Dim objControl As Control Dim intRecordsLeft As Integer DoCmd.GoToRecord acDataForm, Me.Name, acLast intRecordsLeft = Form.CurrentRecord DoCmd.GoToRecord acDataForm, Me.Name, acFirst While (intRecordsLeft)Leave a comment:
-
Continuous Form Question
I have a continuous form and a button in the header of the form. When I click the button, the following code is executed:
[code="vb"]
Private Sub cmdTest_Click()
Dim objControl As Control
For Each objControl In Me.Controls
If (objControl.Con trolType = acTextBox) Then
Debug.Print objControl.Valu e
End If
Next
... -
This depends on the structure of the CSV file. There are easy ways and hard ways to do what you are asking and whether you use an easy way (dumb data into excel, import into access, done) or the hard way (write a VBA function to iterate through the file and put the information into a database) depends on how the file is formatted. Here is an example of how to explain the format of the CSV file:
...Code:The first column contains the headings
Leave a comment:
-
That is a preference. Where I work, using defines is part of the code format standard, so it is what I use on a daily basis and that is what I am used to. Therefore it will show in what I code. Where I work, it is also not standard to use 0 as NULL for all procedures since some procedures use 0 for other things (I work with alot of legacy code).
I've already stated that I see little problem with using stdio.h....Leave a comment:
-
I'm not aggitated at what you said Laharl. It was a good point (and a good name to boot. Disgaea is a wonderful game!). I just responded that I don't like templates (it is a personal preference). I am aggitated at the fact that this other person comes along and starts in with the attacks against my character acting like I don't know jack about programming. Especially when i'm merely attempting to be helpful.Leave a comment:
-
A) That code was written in about 5 minutes. Do better in less then we'll talk about structure. (You did mean structure, right? Because there is nothing wrong with the syntax.)
B) Each person has their coding preference. Mine is against templates. They are, to say the least, ugly and make the code far more difficult to read. There are many paths to produce the same result.
C) My job description requires that I produce...Leave a comment:
-
Despite it being depricated, it is still in rather common use (<stdio.h> that is).
And as for templates, bleh. It makes all the code ugly with all those damned angled brackets and even longer names. You save time on the front end by not copying and pasting the code a few times for each type, but then you lose it on the backend having to type all those damn <double>s, <int>s and <whathaveyou> s on the backend...Leave a comment:
-
Array Class
You could use vectors or you could just create a class to wrap the type of array you want. For instance, for an integer array you could use:
IntArray.h
...Code:#define NULL 0 #include <stdio.h> class IntArray { private: protected: //This stores the array int* iArray; //This stores the size of the arrayLeave a comment:
-
Word was defaulting into a sort of non-layout. I figured out it had something to do with the printer when I tried to do a print preview. I reinstalled my print drivers and low and behold the issue was fixed. It is odd still, however, since I have no changed any print settings recently and all of a suddent word didn't like those settings and acted like I did not have a printer.
As an aside, I've been working on this problem for about...Leave a comment:
-
Word Layout
I have a new document open in print layout. Then I attempt to insert an autoshape into the document. As soon as I click on the shape I want to input, word swaps into web layout and does nothing futher (i.e. it won't let me actually input the shape).
Any document that already has an 'autoshape' in it somewhere automatically opens in web layout when I open the file. When I choose 'Print Layout' from the 'View' menu, the screen flickers... -
One of those aha moments just hit me. I've been trying to write the Outlook VBA in a separate module. The issue is that Outlook treats the module code as external to Outlook itself so one cannot call the macro from within Access or Word or any other application.
However, if you put the code in the default "ThisOutlookSes sion" module created by Outlook, it is possible to call the vba functions using the MAPI interface....Leave a comment:
-
Thank you for the response, NeoPa. However, I've practically written the book on Application Automation^.^ (No seriously... note that I wrote the code in the post you linked too:-)
The problem I am running into is that whenever access attempts to send an e-amil through outlook using an object reference to the outlook application, a dialog box pops up and takes about 4 seconds before it will allow one to click yes to send the e-mail....Leave a comment:
-
Access/Outlook Automation
Is it possible to run a macro in Outlook from Acces and if so, how (link, explination, or book suggestions)? I've tried MAPI to no avail although i'm open to trying it again with new information. -
It is actually initialized to null. (on line 28.):
28. struct Animal* zoo[ZOO_SIZE] = {NULLP};
With NULLP being equal to 0.
In the main function I can set zoo[0] = 0; just fine and it works. Once I pass the address of zoo to a function, inside that function the exact same assignment stops working. That is the problem. I need to know why as I cannot figure it out. I've been working on this problem for three...Leave a comment:
-
I have read the lecture notes quite throughly and this part of the program is actually a direct copy of what the professor has in his notes. I cannot figure out why it will not work in this context.Leave a comment:
-
I have to use an array of dynamically allocated pointers. I can't figure out why:
zoo[0] = 0;
is causing the program to crash. zoo is defined as
struct animal* zoo[4];
and is sent to a function via
somefunc(zoo);
Once in somefunc, the assignment mentioned at the top of this post causes the program to crash.Leave a comment:
-
I'm sorry I was not more clear. I meant, in Excel is there a way, via VBA, to find out what page a cell will print on.Leave a comment:
-
Array of pointers
Hello:
I've been working on an assignment and I have hit a stumbling block pertaining to an array of pointers.
If I am correct in my assumptions, the array
should have its address passed to a function when calling it like this:Code:struct animal* zoo[4]
Once I am in somefunc, if I call the line of code:Code:somefunc(zoo);
causes...Code:free(zoo[0]); zoo[0] = 0;
No activity results to display
Leave a comment: