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?
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?
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.
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?
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.
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.
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.
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.
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:
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.
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
End Function Function link_table(strTable As String) Dim dbs As Database Dim tdfLinked As TableDef Dim strDatasource As String Dim strDatabase As String
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
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
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.
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!
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.
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?
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.
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")
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.
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).
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.
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?
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.
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
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.
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.
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.