Hi all
Having had such great help from you guys in the past I'm hoping that someone could shed some light on this issue I've been unable to solve.
I have diluted my database down to the objects nescessary to establish the problem which I believe is a relationship/key issue. For your information though, the relationship should be one-to-one.
From the StudentInfo form you can open up the MedicalForm for...
185 results in 0.0088 seconds.
-
Form showing up blank
-
Error message for an indexed field on the Form
Hi,
In my form (with multiple tabs), I have a field which is indexed and does not allow duplicate data. While checking the form I found the following problem:
I entered a value in the field which already exist in the database. I then tried to save it but the database correctly warned to say that same data exists in the database.
I then tried to navigate away from the Form by deleting the value I entered... -
send users activation Email for the new accounts
I have this code (it's a form which will sign up new users and send them an email to active they account).
...Code:<?php if(isset($_POST['submited'])) { $msg=""; $RFname = clean_text($_POST['RFname']); $RLname = clean_text($_POST['RLname']); $USERname = clean_text($_POST['UserName']); $USERpassword = $_POST['UserPass']; -
Forms - How to have many sub-forms in the Detail section of the main form?
Hi,
I have the following Forms:
[Form A] - Main form - Single form type
[Form B] - Continuous form
[Form C] - Continuous form
[Form D] - Continuous form
[Form E] - Continuous form
I want to add [Form B], [Form C], [Form D], [Form E] as sub-form on the mainform [Form A].
The Forms have the following relationship based on the underlying table:
[Form... -
Corwin Moyne started a topic Can I have a form that will allow me which of 2 tables my inputs are for?Access 2010in AccessCan I have a form that will allow me which of 2 tables my inputs are for?Access 2010
OK. I have 2 tables with identical fields. One is called 'External Dies' and the other is 'Internal Dies'. Although the fields in the tables are identical, they have different relationships to another form, 'Product Codes'. The Internal has a one to one relationship to its 'Product Code', where as the External has a one to many relationship as it can be used with many Product Codes. Because of this, I assume I need a separate table for each. I would... -
Search Multiple Data : Textbox and Search Button in Form
Hi! I had a code that can search, just enter any keyword like. If I want to search "Access" I can put Acc only and then it will show me all record that has "Acc" on the database like Access, Accelerate, etc.
My question is. It is possible if I also do that in multiple search? Using comma as a separator?
For example : I will put [Acc, Ex] on my textbox. Is it possible for it to show me the record like.... -
Loop a form to ask for multiple guest the same information
Can someone give an idea or guide to do this:
i have two forms.
First form is used to ask from, to, departure time and how many people we want to book for.
Second form is used to ask for each person that we book what is their name, age, title, phone number.
i planned to use a loop to loop form 2 to ask for their info. However i woner how we can do this?? can a form be an array to loop?? -
Fred Chamberlin started a topic OutputTo: Output the contents of a form or a report without the footerin AccessOutputTo: Output the contents of a form or a report without the footer
I have set up for users to output various forms and reports to either Excel or to PDF format. In both cases, I would like the footer to not be included in the output. The footer area includes the button to output the form or report. Any suggestions? -
Form for entering data into linked Table
I have a linked table called "dbo_tblNot es".
dbo_tblNotes has the following fields:
id (Data Type = Number, Indexed = No)
note (Data Type = Memo)
addDate (Data Type = Date/Time)
uid (Data Type = Text)
private (Data Type = Number)
I am trying to create a form that I can use to enter notes and comments. Any notes that are entered would be stored in the "dbo_tblNot es"... -
Refreshing a parent form
Hi,
I'm a new programmer, and have a small problem. I've been trying to get a form populated with lots of buttons and tabs to be refreshed when its child form is closed. The routine I have is this:
If I understand correctly, the parent form code should pause until NewForm_View is Closed (or should...Code:NewForm_View show_it = new NewForm_View(); show_it.ShowDialog(); Form.ActiveForm.Refresh();
-
Using Javascript variable in HTML Form
I'm sure this is a pretty simple question, so would be amazing if anyone could help me! I'm trying to make an HTML search form which can convert a human date into a UNIX timestamp date and include it in the search, alongside other inputs. Here's what I have currently:
...Code:<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" <html lang="en"> <head>
-
Form with text box for adding Notes using linked table
I have a form called "Problem Records Details" which contains a Text Box called "txtNotes".
The Record Source for the "Problem Records Details" form is a linked table called "dbo_proble ms". However all Notes are stored in a linked table called "dbo_tblNot es". The "ID" field in the "dbo_tblNot es" table references the "ProblemID" field in the "dbo_proble ms"... -
History or archive mechanism in Access
I would like to design an archive system for my access database. I have a Customer table that is quite large and is becoming slow to search for a record. We use an Access form to search for records via a Customer ID. I can reduce the size of the table by archiving old records to another table called History. However, I still want access to the historical records from the Access form when the record cannot be found in the Customer table. We could... -
Auto Increment ID field of Linked table when entering on Form
I have a linked table called "dbo_proble ms". I have a form that uses "dbo_proble ms" as its data source. The linked table "dbo_proble ms" has a field called "ID" which is a Number. This field requires a value and when I enter a new record I want the ID field to use the last record ID + 1. So for example if the last record ID that was entered was "17586", then if a new record was entered the ID... -
Vb.net combobox formatstring property doesn't work
I have a form created in VB.net. It is used to get some information form a user. The form is not bound to any data source.
A combobox on this form is used to enter a cost. I want the value entered by the user to be displayed using currency format. I have used the Format String Dialog that opens from the ellipses button on the FormatString property of the combobox and selected Currency. This put C2 into the FormatString property....
