I Don't Know What To Call My Problem... Adding Another Field In A Form???

Dec 28, 2004

Hi, it's me again. I hope everyone's holiday season is just fantastic!

I need to figure this out and I don't know quite how to explain it. In a form, I have five fields named "Primary Objectives 1" , 2, 3, 4, and 5. Each is numbered consectively. I am trying to figure out how I can add another "Primary Objective" field to the form, if I need it, without adding the field to my parent table. Is this clear? Is it possible??? Thank you!

View Replies


ADVERTISEMENT

Call A Function From A Field On A Form

Aug 8, 2006

Is it possible to call a function from a field on a form, ie, in the
control source put = FunctionName(abc)? Then I want to concantenate
it to another variable so it would look like:

=FunctionName(abc) & TextVariable

I tried this and got the ?Name on the form, like it couldn't find the field
name, which is really a function I'm calling.

Is this possible and if so, what am I doing wrong?

Thanks in advance for any help.

View 1 Replies View Related

Modules & VBA :: Static Shell Function Call Works But Dynamic Call Fails

Sep 4, 2013

I'm having to recode some old MS Access DBs so they will run in the following environments:

Office 2000 on WinXP
Office 2003 on WinXP
Office 2010 on WinXP
Office 2000 on Win7
Office 2003 on Win7
Office 2010 on Win7

When I wrote my code for Office 2000 on WinXP things were simple because directory paths were the same across all computers and I could hard code pathing when using a shell command to launch other files.

My new approach is to make a function call to the Windows registry to determine the default executable and path for opening a file based upon its extension (see apicFindExecutable in basWindows API module).

I'm able to use code to create a shell call and debug print it to the immediate window. If I put my cursor in the immediate window at the end of the shell call and hit [enter] the external file will open as desired. If I try to open the external file directly through code, I get a file not found error.

To recreate the error take the following steps:

(1) browse to files that are accessible from your computer
(2) click the PREPARE DATA AND OPEN MAIL MERGE DOCUMENTS command button

Shell function call is made by the fnOpenFile function located in the basOpenFile module. There has to be a trick here that I'm missing.

View 5 Replies View Related

Adding Field To A Form

Jul 13, 2005

I am using a Microsoft Access Form and would like to add some new fields and have no idea where to start. Any step-by-step help would be greatly appreciated.

I am an amateur and would need step by step so minute details would be greatly appreciated.

Thanks!

View 2 Replies View Related

Form Adding In A Field

Dec 1, 2006

Hi

Can somebody help me with forms. I have not used Acecess for sometime and have created a form and realised that I had not included another field in the form. Can somebody help me I have forgotten how to add in the additional field. Simply please:eek:

View 1 Replies View Related

Form Adding In A Field

Dec 1, 2006

Hi

Can somebody help me with forms. I have not used Acecess for sometime and have created a form and realised that I had not included another field in the form. Can somebody help me I have forgotten how to add in the additional field. Simply please:eek:

View 3 Replies View Related

Adding A New Field Into A Form

Dec 4, 2006

Hello

I have created a form and now realised that I have forgotten to put in a field. I have forgotten how to add an additional field to the form. Help in plain terms please. Thanks:eek:

View 2 Replies View Related

Adding New Field To Query And Then Form

Mar 6, 2005

I have created a form from a query. I have then at a later date added a new field to the query. I have returned to the form and attempted to add it to the form but it doesn't show the new field within the control source options. Does anyone know why? Do I really have to start all over again with my form?

Thanks
Just1

View 3 Replies View Related

Adding Field To Form And Table - Please Help

Nov 18, 2006

hi,
I added a field to a table in the backend
I also addded the same field to show up in the form

Now the problem I am facing is that in a new record I can type my values for all fields but an error(2465) is thrown when i try to save it

I suspect that when this field is added in the form it is not getting committed/saved into the table

how do i go about doing this?
thanks

View 1 Replies View Related

Adding Multiple Records For A Field In A Form

Nov 18, 2004

Hi forum, I have this database with a main form and 5 subfoms. For the Address Subform, I need to add multiple addresses for each person I add. How we currently do it is enter the multiple addresses per person, one at a time. Is there an easier way to do this.

For eg: Id Last Name First Name

Then Address 1
Address 2
Address 3

View 1 Replies View Related

Using A Calulated Field For A Call Back Date, Any Help On This Would Be Appreciated.

Nov 3, 2007

I have designed a query with the following fields.

Date;
NumberofDaystoCallBack;
CallBackDate: [Date]+[NumberofDaystoCallBack]

I have created a formated field called DateToCallBack, which is the calculated field.
For example when I enter say today's date 03/11/07 in the Date field
and enter 10 as the number of days to call back in, the calculation field
works just fine and gives me the correct call back date which in this example
would be 13/11/07.
The problem I am having is,
I am trying to set a criteria on the calculated field for a
Between [Start Date] And [End Date], but when I run the query it gives me
all the day dates in the range I specified properly, but it gives me that in every month, when I only wanted one specific month.
For example,
I select between 1 Nov 07 and 8 Nov 07
It gives me all the 1st to the 8th of every month, when really I only wanted Nov.

Any help or suggestions? :confused:

View 13 Replies View Related

Modules & VBA :: How To Select Current Field For Module Call

May 29, 2014

I'm trying to monitor a few fields and record who updated them together with the old and new values, so far, I have this;

This does work ok, I was just wondering if there's a way of referring to the current field, rather than having to specify 'me.NPW.oldvalue' etc.

Code:
Private Sub NPW_AfterUpdate()
Call LogFieldUpdate(Me.AppNumber, "NPW", Me.NPW.OldValue, Me.NPW)
End Sub

[Code] ......

View 3 Replies View Related

Adding A Field To A Form Using Multiple Tables (And A Combo Box)

Jun 15, 2006

Hello!

It's been a while since I've asked a question here, but I can't seem to figure this problem out.

I am setting up a form using data from 4 different tables, all related, and I can't figure out how to add fields that I didn't initially add during the wizard set-up. I used the wizard because it's easier for me to do that and then go in and make the changes I want to make.


When I get data from just one table, all of the available fields from that table are in the "Field List" no matter what fields I chose to include in the wizard process. That's good. But when I get data from more than one table, only the fields I initially chose in the Wizard process are showing up in the field list. I can't figure out how to add a new and different field from one of those tables.

The way I "solved" this problem the first time was to start over, creating my form from scratch--but now that I've done a lot of work, it just occurred to me that I will need to add 2 more fields. (I actually don't even have those fields in a table yet, but I will add them later.) So, this will be an ongoing problem. Since this form will get much use, by several people, I don't want to have to re-create it every time I want to change something.

So, is this possible? How can I add another field?

Also, while I am at it... A combo box was working beautifully to look up specific records when I was gathering information from only one table. It isn't working anymore.

Thanks in advance!

-Siena

View 8 Replies View Related

Forms :: Adding Multi-valued Field In A Form

Oct 9, 2014

How to add a multi valued fields in a form for example a student may have multiple hobbies, access can do this using using lookup option, but access stores multiple values in one field which is difficult to analyze, looking for efficient way of adding multiple option.

View 8 Replies View Related

Forms :: Adding Date Field To Query From Form

Sep 23, 2013

I have a date picker field in my form that is used as part of a criteria in a query. I also add it as a result field in the query being that it is appending data to a table. But when the query runs it puts weird characters into the query field with expression.

The Expression is as follows:

BillWk: [Forms]![Invoice Form]![WkEnd]

My Criteria is:
Between [Forms]![Invoice Form]![WkEnd] And [Forms]![Invoice Form]![WkEnd]-6

The Criteria works but the expression does not.

I have attached a png of the field.

View 5 Replies View Related

Adding New Field To Existing Table And Form - Getting Error

Jun 8, 2014

I'm trying to add a combo box field to an existing table and form. I added the new field to my existing table and set it up as an combo box added my row sources. Then added the new field to an existing form and now am getting a error stating "The record source "Table name and added field here" specified on this form or report does not exist. When I just make the new field a text box instead of combo box it works just fine.

View 2 Replies View Related

Adding Calculation Field (text Box) To Assets Template Form

Apr 3, 2013

I am trying to add a calculation field "Status" (text box) to Assets template form i.e

IF Asset item = X
Status = present

But am getting #name? in the text box

View 3 Replies View Related

Modules & VBA :: Inserting Field Value When Adding Record Using Data Entry Form?

Dec 14, 2014

I have a form for entry and some fields are computed or result of a query from another table. I have a function that looks up a value from another table like so

************************************************** ********
Public Function GetTargetType() As Variant
GetTargetType = DLookup("type", "tblFormulations", "[tblFormulations!formulation]=Forms![frmNmsConsumptionEntry]![formulation]")
End Function
************************************************** ********

Which works fine when I test in the immediate window.Then I have this form event. This however does not insert this value when I am adding records using my continuous form.

************************************************** ********
Private Sub Form_BeforeInsert(Cancel As Integer)
Me!target_group = GetTargetType()
'Forms!frmNmsConsumptionEntry!target_group = GetTargetType()
'[tblNmsConsumption.target_group] = GetTargetType()
End Sub
************************************************** ********

making sure I can insert this value once retrieved.

View 7 Replies View Related

Call Procedure On A Different Form

Aug 30, 2006

Hi,

Is it possible to call a procedure that exists in one form on another form please?

Regards,
B

View 13 Replies View Related

Forms :: Adding Field To A Form Breaks Entire Database Record Source?

Sep 26, 2014

I am building a database where one Form displays records from 14 different tables. For some reason, when I recently try to add a field on to a form from a new table, the ENTIRE form loses the record source, and every single field that is already on the form gets that green dot in the corner with errors surrounding a record source that cannot be found. What am I doing wrong? Am I exceeding some limitations with forms?

View 4 Replies View Related

How To Call Form Values In A SQL Query

May 14, 2007

Hi,

I need to build a query where upon form input a different table gets queried.

SELECT *
FROM ((Forms!DCL!PortDropDown))
WHERE ((Forms!DCL!DestinationList=(Reg_Dest.Destination) ));

The "FROM" is my problem. The "WHERE" is working. I am getting a "SYNTAX ERROR IN JOIN OPERATION" error message. Please help.

Thank you:confused:

View 6 Replies View Related

Call Command On A Diferent Form

Feb 22, 2005

What code would i use to say:

on click
goto the form "datalookup" (which is already open)
and run command "cmdupdate_click" (which is a private sub on that form).

do i have to change it to a public sub? or can i just run it? what code would i use?

View 1 Replies View Related

Call A Button Click On Another Form

Feb 6, 2006

Hello everyone!I need to call the button_click procedure for a button on a form (button1), from another form, if you see what I mean!.Basically the user opens form1. They click a button which opens form2. Once they have finished on form2 they press the close button, which is the point where I need to call the button1_click procedure on form1.I imagine it's something like this:Call Forms![frmForm1]![button1]![Click] orCall Forms.[frmForm1].[button1_Click()]But no matter what syntax I try it just won't work! They're very basic forms, with only 2 buttons on and basic commands.Any help appreciated! Thanks

View 5 Replies View Related

Making A Form To Call Up Information From A Table?

Jan 27, 2005

I'm making a customer survey database. Also be aware I'm not proficient with access.

All the customer information is being imported from an excel spreadsheet. That will include ServiceRecordID, ServiceDate, TechID, CustName, ServLocation, PhoneNum, and DeptID.

Another table will include records for answers to 5 questions that will be asked by a manager on the phone. That table is called TblQuestions. This table will also have ServiceRecordID to go with the answers.

What I'm trying to do is create a Form that at the top has a box for ServiceRecordID. I'd like to be able to type in the Number for that ID, and then all the information shows up on the form for that specific ID. And below all that, fields to add the answers to TblQuestions for that specific ServiceRecordID.

The reason I'm doing this is because the manager will get a report with the customer information that needs a follow up call. So I want them to be able to call up that information on the screen with the ServiceRecordID number, and also be able to add in the information that they get back from the customer with the questions that will be asked.

I don't know why I'm having so much trouble with this. But I'm not experienced with access or VBA both.

View 2 Replies View Related

How To Call A Procedure From A Subform In Main Form

May 10, 2006

I have a sub form which has the Save Button. In case the user keys in the details in the sub form, but then directly clicks the Payment command button of the main form, I want to call the Save button in the sub form if the form is dirty, and do the save, otherwise, proceed with the payment command button.

Every time I try to call the save procedure from the main form's Payment button, I get this error that "object does not support this property or method"

I am calling the save button's code in the subform as

forms.MainForm.SubForm.Save Producedure

Exact Code is : Forms.newpatients.InvoiceHeader.Command7_Click

How do I call this command7_click, which resides in the sub form, in the main form, and invoke it only if the data in the sub form has changed.

Please help.

Thanks,
Vinai

View 1 Replies View Related

How To Call A Written Function That Are In DLL File In A Form?

Jan 16, 2007

With the script in the form that is part of MS-Access. I wonder how do I access/call the written function that are in the DLL file I made. I appreciate your help on this one...

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved