Difficulty In Opening An Existing Form

Sep 9, 2004

I am having trouble with opening an existing form in ms access. Any idea what could be the problem?
Even if I am not able to retieve the whole form is there a way I can retrieve all the event procedures associated with the form?

Would appreciate any pointers.

Thanks in advance.

GreetInfo

View Replies


ADVERTISEMENT

Pre-existing Form Auto-opening

Oct 31, 2006

There is already a form in the database I'm using that opens automatically when the database is opened. I do not want this form to auto open, but I want a different form that I have made to auto open. How do I turn this on/off?

View 2 Replies View Related

Difficulty Creating Form – Possible Relationship Problems

Jul 26, 2005

Hi, I’m having a problem creating a form for easy data entry. Let me give you a little background. I have a database for a tutor program, students request a tutor for a class, and then I fill out a follow up report to find out if they are being tutored or changed their minds. Next I enter the contact information indicating the date and time of their tutoring session.

Students can be tutored in more than one class but they can only have one tutor for each class.

I have a form where I enter the tutor request info and sub forms for their classes, follow ups, and sessions. Ideally I would also like a form just to enter the session info. I want a combo box to select the tutor and then a sub form to select the tutee with a combo box which will auto fill the Subject, and Course fields, and field to enter the date and contact hrs.

I think the problem is with my relationships. I’m just kind of stuck. I think I need to create a form based on a query but I haven't done that before. Any help would be appreciated. Attached is a screen shot of my relationships and of my current form for your reference.

THANKS!!!!

View 1 Replies View Related

Check For Existing Record Before Opening

Sep 20, 2006

Hi.

I have 2 forms, with a "PNID" field as the link between the 2.
In the 2nd form, the PNID field allows no duplicates. I have a button on the first form to open the 2nd form to add a record.

I need some code to put on the button on the 1st form to check whether a PNID record exists on the 2nd form before opening it.......does this make sense?
What is happening is that I click on the button, try and add a record, then it tells me one exists and I cannot add a duplicate...

I have looked at the threads, and have tried using DCount? Is this correct?

Thanks

Frank.

View 7 Replies View Related

Opening An Existing Project In Access 2003

Aug 14, 2007

Hopefully this is pretty simple.

Have an existing app. When I open it from within Access the app seems to go into some runtime mode ... shows a splash screen, menus, etc.

Okay how do I go into design mode so I can modify it ?

Yeap am a complete newbie with Access and haven't touch since the Office 97 version :o:eek:

Not sure if you are meant to ask multi questions in one thread, or create a thread for each one. Will created a new thread for my other question, so if one of the Mods could point out the correct way of doing this would be appreciated.

View 2 Replies View Related

Forms :: Closing Opening Form With Timer Then Opening Main Menu

Apr 7, 2014

I have a Form opening from Access Options. I would like to close this Form using the Timer. The following is the code I have used but it is not working.

Private Sub Cover_Page_Form_Load()
OpenTimer = Timer
End Sub
Private Sub Cover_Page_Form_Timer()
If (Timer - OpenTime) = 5 Then DoCmd.Close acForm, "Cover_Page_Form", acSaveYes
End Sub

Next question. If I can get this to work can I then use a DoCmd to open new Form within the code above or do I need a new process.

View 5 Replies View Related

Report Difficulty

May 9, 2007

I have a simple database that has in the same record in a table 3 fields of last names that are populated by entering the data in a form. There could be the same last names in each of the 3 fields. (ie; John Doe, Mary Doe, Little Doe) My problem is that I want to make a report by clicking on a button searching by the last name (Doe) and consider each of the 3 last names in my search criteria. Does anyone know how this can be accomplished as not to miss any of the (Doe's in this case)? Please help if you can I know it sounds confusing.

Thanks in advance for any help!

View 5 Replies View Related

Difficulty Answering Questions

Jan 19, 2008

I am finding it more and more difficult to answer questions lately, is it just me or has the quality of the questions gone down?

In some cases it appears that the "question" is more of a request to have something done for them than actually trying to solve a problem that they are having with a learning process.

Has anyone else noticed this or is it just me?

View 11 Replies View Related

Difficulty Creating Code

Apr 8, 2007

I am having difficulty creating code that will compare a date in one table (or query) in the [Expire] field and subtracting two months from the date and automatically placing the newly calculated date into the table (or query) in the [Notify Expiration] second field. For example:

Expire Notify Expiration

01/01/2007 11/01/2006
02/01/2007 12/01/2006
03/01/2007 01/01/2007
04/01/2007 02/01/2007
05/01/2007 03/01/2007
06/01/2007 04/01/2007
07/01/2007 05/01/2007
08/01/2007 06/01/2007
09/01/2007 07/01 2007
10/01/2007 08/01/2007
11/01/2007 09/01/2007
12/01/2007 10/01/2007

Please note that for the month of January and February, the subtraction is minus two for these two months and the subtraction is minus one for the year. All other subsequent months just subtracts two for the months leaving the year intact.
I would appreciate any help that will progmatically accomplish these calculations.

Thanks

Charles Moery
Keypounder2@aol.com

View 4 Replies View Related

Difficulty Connecting ODBC Drivers

Mar 21, 2005

In the Access application that I have developed for a user, the application is supposed to establish the ODBC connection to an external database when the application is initiated. On my PC, the application works. On an older PC, the application works. However, on the User's PC and on the new one that we are building for her the linking to the external tables does not work. I have displays for the tables that she is to link to as the program is doing the linking. Sometimes, on the PC for her use, the first table will not link and the rest will. Sometimes, none of the tables will link. Sometimes, the first half will link and the second half won't. I am stymied. Below is the logic that I use to make the connections at the beginning of the process. Any suggestions?


Dim strTable As String

On Error GoTo Assign_Error

'MsgBox ("Click on OK and Please be Patient as the program links to PeopleSoft tables.")

' NOTE : Do not unlink the tables as you will have to manually relink the tables

strTable = "ps_comp_ratecd_tbl"
Call unlink_table(strTable)
Call link_table(strTable)
strTable = "ps_current_job"
Call unlink_table(strTable)
Call link_table(strTable)

strTable = "ps_names"
Call unlink_table(strTable)
Call link_table(strTable)
strTable = "ps_tl_compleav_tbl"
Call unlink_table(strTable)
Call link_table(strTable)

strTable = "ps_tl_empl_data"
Call unlink_table(strTable)
Call link_table(strTable)
strTable = "ps_tl_trc_tbl"
Call unlink_table(strTable)
Call link_table(strTable)

strTable = "ps_tl_tskprf_detl"
Call unlink_table(strTable)
Call link_table(strTable)

Assign_Exit:
Exit Function

Assign_Error:
MsgBox Error$
MsgBox Err
Resume Assign_Exit

End Function
Function link_table(strTable As String)
Dim dbs As Database
Dim tdfLinked As TableDef
Dim strDatasource As String
Dim strDatabase As String


On Error GoTo Link_Error

DoCmd.OpenForm "Message"
[Forms]![Message].SetFocus
[Forms]![Message]![Message] = "Linking Table " & strTable
[Forms]![Message].Repaint

strDatabase = "HR8PROD"
strDatasource = "PS_Payroll"
strTable = UCase(strTable)

Set dbs = CurrentDb
Set tdfLinked = dbs.CreateTableDef(strTable)

' tdfLinked.Attributes = dbAttachSavePWD
' Check to see if table already exists and if it does then do nothing
' For Each tdfLinked In dbs.TableDefs
' If tdfLinked. = strTable Then
tdfLinked.Connect = "ODBC;UID=sysadm;PWD=sysadm;DSN=" & strDatasource & ";"
tdfLinked.SourceTableName = strTable
tdfLinked.Attributes = dbAttachSavePWD

dbs.TableDefs.Append tdfLinked
DoCmd.Close acForm, "Message"
' Exit Function
' End If
' Next
' [Forms]![Message].SetFocus
' [Forms]![Message]![Message] = strTable & " Not Found for Linking"
' [Forms]![Message].Repaint

' DoCmd.TransferDatabase acLink, "ODBC Database", "ODBC;DSN=PS_Payroll;UID=sysadm;PWD=sysadm;DATABASE =HR8PROD", acTable, "SYSADM." & UCase(strTable), strTable

Link_Exit:
Exit Function

Link_Error:
' if the error is simply that the item to delete isn't actually
' there to delete, we want to skip it.
If Err = 3265 Then
Resume Next
End If
' otherwise we want to show what the error is, and then exit.
MsgBox Error$
Resume Link_Exit

End Function

Function unlink_table(strTable As String)
Dim dbs As Database

On Error GoTo Unlink_table_Error

Set dbs = CurrentDb
dbs.TableDefs.Delete strTable

Unlink_table_Exit:
Exit Function

Unlink_table_Error:
' if the error is simply that the item to delete isn't actually
' there to delete, we want to skip it.
If Err = 3265 Then
Resume Next
End If
' otherwise we want to show what the error is, and then exit.
MsgBox Error$
Resume Unlink_table_Exit

End Function

View 1 Replies View Related

Difficulty Getting External Data In Access 2007

Feb 2, 2007

Hi There,

I have recently upgraded from Office XP to Office 2007. I had an Access database which worked fine in Access XP. In it I had a table linked to an Excel spreadsheet. When I entered data on an access form, it updated the Excel spreadsheet [source document] accordingly. This does not seem to work in Access 2007. The linked table option now does not permit data entry or amendement. The other "Get external data" options create a table in Access which also does not update my source Excel document. The idea is to enter data in Access using a form. This data is placed in an excel spreadsheet. Excel gets some lookup values, and then enters these in a Word mail merge. Without the functionality of a linked table and data entry, I cannot produce new reports.

Can anybody help please?

Regards

Mark M.

View 2 Replies View Related

Difficulty Combining Insert Into Or Select Into With A Union, Please Help!

Jan 23, 2007

I am having difficulty getting a query to work, there's probably something really simple I'm missing. . . I can get the Union function to work but I can't get it to create a table for me. The basic query looks like this:

INSERT INTO test
SELECT * FROM [Design] WHERE (Design.CID Not Like "*-*")
UNION
SELECT * FROM [Release] WHERE (Release.CID Not Like "*-*")

It works fine and shows me the table I want without the first line, but I would like it to input into a new or existing table. Any help would be greatly appreciated!

View 1 Replies View Related

Can I Create A Subform For An Existing Form

Dec 30, 2005

Is it possible and how do i create a subform to an existing form. I'm new to Access and would appreciate any guidance.
thanks

View 1 Replies View Related

Populate A Form From Existing Data

Sep 13, 2006

Hi
I cant get my head around this one,

I have a Form that enters all details for an Order.

On that form is a Tick Box that says Repeatable.

If that box is ticked in the future I am able to repeat on that stock item.

I have created a form with a List boxea that Lists all Suppliers Stock that is Repeatable

I want to be able to double click a Stock Item from that list, then let it populate another Order ( Unique Key ), fill in all the field from the previous order, so all I have to do is enter the Quantity I want to re-order.

How do I do this?

please help

Hightower

View 4 Replies View Related

How To Associate The Request With Existing Form

Jun 25, 2014

how to associate the request with column and rows with an existing form?

View 14 Replies View Related

2 Querries Displaying Data In An Existing Form

Mar 16, 2007

Hi
i have 2 querrys with the same fields but different criteria (one is to search a person throw their id and the other one to search a person by their surname and dob). i can't work out how to display the results of the querries to an existing form i have. Can anyone help me please?

View 1 Replies View Related

Simple Login/logout Form For Existing DB

Jan 11, 2006

hi,

i've completed the whole access DB, but now i need to implement the login form, so each user can access their data + admin access.

what is the simples/fastes way to do this, since i've got working db. I add fields (user-log-id and password)to "userTable" and now i just need simple veryfication to login and logout.

thank you in advance,
t.

View 2 Replies View Related

Forms :: Updating Existing Record In A Form

Mar 19, 2014

I'm having difficulty updating an existing record in my form. I can enter a docket number on my form and when i hit my button (Find Docket) it brings up all the customers info (name, date, invoice, vat, total, etc.) What i want to do then is be able to amend/update the record. Just wondering do i need to put vba code in my save button and how to code it and is it similar to my find data code below.

Here is my save function code:

Function SaveData() As Boolean
Dim db As Database
Dim rs As DAO.Recordset

Set db = CurrentDb
Set rs = db.OpenRecordset("Skips Delivered")

[Code] .....

View 6 Replies View Related

Forms :: Linking Existing Form To New Table

May 1, 2015

Each month I receive a new excel spreadsheet (alpha Roster), Last month I created a form so that I can track certain things off of the Table (spreadsheet), I just received the new Spreadsheet for this month and was wondering if I can use the existing form and how hard it is to link it to the new spreadsheet? Is that even possible? I don't want to have to re create the form every month, I would like to just bring the new alpha roster in and be ready to work.

View 4 Replies View Related

Forms :: Adding Subform To Existing Form

Apr 3, 2014

I'm having a bit of a problem with a database I'm trying to create, what I am trying to do is create a database to handle jobs in an IT workshop. The idea is that you generate the job card and then at the bottom you have a section to enter in the parts that are required for the job, and then have a report that prints out a list of all the parts required for all the jobs under a heading of the job card number.

The problem I am having is how to add this sub form / table to the job card sheet. I tried putting in a sub table, but that wont let me make additions to it, and I tried putting on a form but that wont retain more than one entry per job card (I have put it on continuous form).

View 2 Replies View Related

Forms :: Dragging Existing Form Onto Tab Control

May 2, 2013

I have read where you can drag fields onto the tab pages to create a form or you can place a subform onto a tab page, but can you drag an existing form onto a tab page?

I have done it and it is working, but I just wanted to know if this is ok to do or would it lead to problems.

View 2 Replies View Related

Append Data From New Record In Existing Form

Aug 28, 2012

I have a database where I need to append part of a new record to another table. But when I open the query with the link to the form that is open I cannot see the added record until it's saved to the open form. I tried to re-query the key ID field but that does not work. How do I do a re-query without the form requiring everything and then I am on the incorrect record?

View 3 Replies View Related

Forms :: Opening A Form From Another Form Via Combo And Auto Loading Form Data?

Apr 14, 2015

I have been tasked with creating a tool to analyse mobile phone bill data and present the analysis, and our recommendation, to a customers. Being new to Access (other than basic tuition) this has been a slow uphill task, which is finally nearing completion, however there is a problem which I have not yet been able to overcome.

The requirement is for the DB to open first on a splash screen (lets call it Form A) with fancy picture where our customer is selected from a combo box, the customer is then telephoned, a linked computer screen is established and our staff then click "Go" to proceed to a second form (Form B) showing an account overview and more details.

The problem I have is when "Go" is clicked, the second form loads via on click event, and even populates the correct customer in its combo box. Unfortunately that is as far as it gets - the combo does not look up the information. The customer needs to be selected again for the subforms and subreports to load with the customer overview. To clarify, form B just sits there blank until the customer is re-selcted from the combo box in form B.

View 9 Replies View Related

Selecting Existing Table Name Using Form's Combobox For A Query

Dec 12, 2006

Folks,
can someone help me on this? I am not sure why the select query inside this procedure is not working. Here is the that routine:

Public Sub temp()
Dim strDocName As String
Dim strTableName As String
Dim strTbl As String
Dim aot As Access.AccessObject
Dim strSQL As String
Dim rpt As Report
Set rpt = CreateReport

strTbl = Forms!frmSearchBoilerGuar!cboTypeOfGuar

For Each aot In CurrentData.AllTables
If aot.Name = "strTbl" Then
strTableName = strTbl
End If

Next aot

strSQL = "SELECT tblProjts1.chrProjectName, tblProjts1.chrBlrPropNum, " & _
"strTablename.memGuranItem , strTableName.memLDs FROM tblProjts1 " & _
"FROM tblProjts1 LEFT JOIN strTableName ON" & _
"tblProjts1.intProjectId = strTableName.intProjectId"

rpt.RecordSource = strSQL
strDocName = "rpt"

DoCmd.OpenReport strDocName, acPreview
End Sub


Basically, I am trying to select a table name from the combobox and then use that table name for my query. Then I want to use that query as a recordsource for my report.

Any help is greatly apprecited.

Shan.

View 2 Replies View Related

Forms :: Save Existing Form Data As New Record

Nov 14, 2014

I want to open an existing record via a form and then edit that data but save the form as a new record. Basically a form used for handover/takeover process where most of the data remains the same but the new form is the basis for the next handover/takeover.

View 6 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







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