I am new to using MS Access and I am having a difficult time trying to do one particular thing. What I am trying to do is represented in the Contacts database template in Access 2007. When that database is opened, there is a link labeled as New displayed on the table that opens a form to enter a new record. I cannot figure out how to do that, can anyone help?
Also, is there a way to automatically open a particular form when the database is opened?
I have a form (frmAddManifest) with a subform (subfrmManifestTransporters).
When creating a new record, I can enter data into frmAddManifest, but the subform doesn't update to link with the record - I presume it's because the record from the main form hasn't been completed yet.
Is there a way to requery the form and/or subform so it stays on the record I was working on, and link the subform properly?
I currently have a form in Access 2003 which is filled with quite a lot of data. Each new form need to be approved by some people, and I send them an email through Access to ask it. Is it possible to have a direct link to the form filled with the particular data they need to approve without creating a website?
I have a Summary report and a detailed report in MS Access. Upon clicking one of the records in the Summary report should open the detailed version for that record only. Lets say the Summary report has a list of employees. Upon clicking an employee record/link in the summary report should open the detailed report containing the details for that employee alone.
I am a newbie in Access. I am running Access 2003 and would like to be able to create links to Visual Foxpro9 tables using the VFP OleDB provider and not the ODBC drivers.
A few of my clients want to use the VFP9 tables in their reports but so far I have not been able to find a way to do it using OLEDB (except in a module with VBA code which I don't want).
I can do it using the ODBC but the problem is that ODBC driver does not recognise the VarChar fields in the tables.
I tried creating an Access project and then 'File --> Connections' but it does not display the 'Provider' tab to select which provider to use and by default assumes that SQL Server is the source database.
How can I get Access 2003 to allow me to select the OLEDB Provider? Any help will be appreciated. Thanks.
I am a newbie when it comes to Access and ASP but I am trying. I am in the need for some help. I have a large table in Access 2003 and need to break it into smaller tables (not using a query) where the fields are the same except each of the smaller, new tables will hold info for a specific person. These smaller tables would need tro be linked to the larger. Is there an easy way to do this? I need to keep it in tables due to the ASP software I use to generate the asp pages. Is this possible? My goal is for each user to be able to only view/edit their data and for the large table to reflect any changes made to the smaller table. Thanks, Dan
I am trying to set up something to be able to take me to a folder that holds various forms for personnel. I have a query that generates the link for each person. I have tried to set it up as a hyperlink in ACCESS 2013 and it displays as one but doesn't act like one.
I want to be able to click the link and have it open up a personnel folder for that individual. I can't find a MACRO that I can create to do it. Example of my query is that it creates a link K:Main BreakdownSection BreakdownPersonnel FoldersName and the name is the variable part.
My next problem will be to have it create that folder when we have new personnel arriving.
I would also note that I have not worked with ACCESS in many years and much of what I was able to do with 2002 and 2003 doesn't work with the newer versions of ACCESS.
I am trying to create a form to enter data in a table. I would like to make it pull in info from a switchboard. If the record already exists I would like it to find it and allow me to edit the info. If the record doesn't exist I would like to be able to add a new record with the data input. What is the best way to accomplish this?
I have a form (frmAddBeaterToShootDay) with a subform (frmChooseBeaters). I want the subform to show all the records of all the beaters in the contact list, which it does. I then want to be able to tick the box (AddToShootAsBeater) and associate that person with that record on the form (frmAddBeaterToShootDay).
When I go to the next record on the form (frmAddBeaterToShootDay) again I want to show all the beaters on the subform but all the tick boxes in (AddToShootAsBeater) should be blank until I tick the required ones.
I think I should be doing this as a Many to Many relationship which I have done from (tblContacts) (tblShootBeaters) (tblShootDates).
The problem is when I put all three tables in the query I get no results in the subform!
I am testing the security of my DB X on Acccess 2007. I could create a new database Y and linked to the database X. Unfortunately i could change the records on the tables. I don't want other DB that make connections to my DB to change my tables!
I have a form displaying records. I would like the user to be able to select a button, browse for a file on a shared drive and link it to that record.
I have been exploring hyperlinking, which works for the most part, although I need it to display the share name rather than the drive assignment for that user. Such as drive1folder rather than C:folder.
Hyperlinking also unfortunatly requires the user to right click on a field select edit hyperlink then browse.
I am new to Access and I am trying to make a Database. However, I have an attachment with each record and I would like to know if there is a way of making a button/link that will allow the user to navigate from each record to its respective attachment.
I created a query that shows everyone who has a specific date field blank. Now want to make those names clickable so that it opens a specific form with a certain record related to that individual in the query. Each line with a different individual should open a different person on the form and their corresponding record.
The plus indicates a night shift worker eg started at 19.18 and finished at 5.37 on the 12th
so for every record I have staff id , date, and clock time ( I have stripped out the + ) and created a yes/no field to identify the records where field2 should actually be field2+1
I have sat in query design screen for ages and cant think how on earth I am going to calculate hours worked for a given staff member and date combination.
for every combination of staff id and date there should be 2 records - a clock in and a clock out
I thought about creating new fields clockin and clockout but struggling to see how I can link the 2 "paired" records together
I think I know the answer to this, but thought I'd see if anyone had any ideas... I was asked if there was any way to know when a record was created in the database. When the table for these records was created, a field for "Enter Date" (i.e. the date the record was enterd into / created in the database) was not a part of the structure. I know that for going forward, we can create this field in the table and have it populate with Date() behind the scenes so we can track the actual enter date. But, for the records that are already there, is there anything that Access keeps somewhere as to when the record was created in the table?
i think this must be easy but im new and despite reading lots just cant figure it out. i have 2 tables
job details:
autonumber customer location time
picking list:
autonumber, equipment1 equipment2 equipment3
both the autonumber are primary and linked in a relationship. when i create a new record in the job details table i need it to automatically create the coresponding blank line in the picking list table with the same number. If I enter something in the picking list table then it creates the matching number and everything is ok but if i dont then it throws my numbers out.
I have a program that you can search all or a specific record. Once you find the record, you can double click on it and another form will open up with only that record's information.
What I need is to have a button that will copy this record's name, address, phone number, contact info, and etc --> and create a new record with a new Record Number using the current record. This will allow the user to avoid entering in the same information again. For confirmation purposes, I would like to have a SAVE button to verify and save to the DB.
Does anyone have any inputs on how I can do this? If you would like to see the program, please let me know.
Thanks in advance for all your help and suggestions!
How do I create a new record (in the table to which the form is bound) automatically if, when the form opens, there is no record in the table that meets the criteria in the form filter?
I am unable to create a new record due the the following error "The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. " I have looked everything over and can't find how the duplication is occurring. I am pretty sure it is the primary key of a table called Squad, but it's set to autonumber. I have uploaded the database hoping an experienced or fresh set of eyes could spot the problem. The goal of the database is to track squad inventory along with officers assigned to the squads. The main form is generically called "unit_Numbers" which uses "Squad Subform". Everything else seems to work correctly except for creating another squad.
I would like to create a button with a macro that will bring up a blank form to create a new record (as opposed to going directly to the datasheet table). There are options to Save a Record, Refresh a Record, Search for A Record, Delete a Record and Show All Records, but I don't see a macro to create a new record.
I need to make Access automatically create new records in a table for me.
Just for example:-
Table #1 has 2 fields
PersonID (autonumber) PersonData (text)
Table #2 has 3 fields
ID (autonumber) PersonID (number) MoreData (text)
The database user creates a new record in Table #1 using a form.
I need the database to automatically create a field in Table #2 and fill in PersonID, taking the value from the autonumber field of the same name in Table #1.
The MoreData field can be left blank. I don't need that filled in automatically. I just need a new record to be created automatically in table2 with the PersonID field filled in with the most recently created autonumber.
I have a main form called FrmCalls with a button on, which when pressed brings up a pop up form called FrmSurround, within which is a subform in datasheet format called FrmContacts. This has 3 fields within it. I want the system to tak a value from Frmcalls (numeric value) when the button is pressed and place it as a new record in one of the fields on the datasheet (FrmContacts).
I have the following code on a combo box in a form that creates a new record in the table Products if it doesn't already exist:
Code:Private Sub comProduct_NotInList(NewData As String, Response As Integer) Dim strSQL As String 'Exit this sub if the combo box is cleared If NewData = "" Then Exit Sub strSQL = "Insert Into Products ([Product]) " & _"values ('" & NewData & "');" CurrentDb.Execute strSQL, dbFailOnError Response = acDataErrAdded End Sub
It creates a new record and inputs the appropriate value into the Product field, however then it goes to the next record and when I try to edit other fields, it does so on a new record.
So, for example, I wanted to set the Product field to ProductA and the Brand field to BrandB and the Size field to 200, it produces two separate records like this (code box used for formatting):