Confirm Data Source

Jun 14, 2007

I am automating a mail merge with Access to Word. Does anyone know how to stop the Confirm Data Source dialog window from coming up and just except the default (orginal) data source? I have users that do not know they should just click the OK button, some are clicking NO and then I lose the connection because they dont know where the table link is. I dont know what else to do but tell them to always click the Yes button when confirming but not everone listens and then i have to do it all over again.:mad:

View Replies


ADVERTISEMENT

Changing Data In Query Results Changes Data In Source Table

Dec 17, 2012

I have a table and a simple query that pulls results from the table. Nothing too crazy. But, if I were to go in and change some of the data/values in the query results it will change the respective data in the table. I know that this cannot be right. What do I have to do to either prevent the ability to change query results and/or prevent any changes in the query from altering the original data in the table.

View 2 Replies View Related

Getting Data From More Then One Source

Jul 14, 2005

In my contacts datababse I have a main table where all the is stored for my contacts.

I have a form that I use to enter and display the information from, Because I have more the one contact at a given company I have created a seperate table that contains all of the contact details for each office.

What I would like to be able to do is when I select a office on my form Access will populate the the rest of the fields in this section with the relevant information.

How do you do this?

View 2 Replies View Related

Data Source Change

Nov 21, 2005

If the data source changes for an Access database, do I need to recreate all the tables, queries, and reports? I am having quite a time with this issue. Thanks for any assistance you can provide.

View 1 Replies View Related

Confirm Logout!!!!!

Jul 21, 2005

hi,
can any i tell me how to create a form or a simple messege to show the user, whe click to close the db???

for eg, show a messege like " Are you sure you want exit" Yes for Exit and No for carryon.

thanx

View 2 Replies View Related

Confirm Record Changes In VBA

Aug 29, 2005

I have a bug in Access. Despite having turned off the confirm record changes (Tools>options>edit>Confirm) the prompt still appears in the app after it is converted to MDE and packaged for distribution.

My solution will be (if I can find it) to set the 'confirm record changes' setting to off in VBA code immediately prior to my update.

My problem is how to do it. I have looked everywhere without success.

Can anyone suggest the necessary code.

Thanks .

View 1 Replies View Related

MDB....underlying Changing Data Source

Dec 1, 2006

Hi!

I have an MDB file that points to a postgres database. What I'm trying to do is to redirect it to another datasource. The database is exactly the same, but I just need to point it to a different location. I tried doing this with linked table manager by refreshing the table and enabling the "always prompt for new location". I was able to point to my new location but what happened was my MDB became readonly, I am unable to edit anything after I changed the datasource.

View 2 Replies View Related

Complicated Form Data Source

Mar 18, 2005

Well I find it complicated.

I have a table of people, each with an ID, and I have a table of events, each with an ID.

I want to design a form in such a way that when you look at each person it gives a row of event fields, one for each event, into which you can put a Number for the number of tickets that each person wants (each person will only want to go to a few events).

If you enter a number, I want the form to generate new record in a separate table (tickets) with three fields - the Person's Id, the Event ID and the number of tickets.

I only want one ticket record per person per event (so if the numer of tickets changes I want the form to amend the number, not create a new record.

So, I want the Form to show "page" for each person, with "fields" for each event, the info being stored in a separate table, which the form is able to cycle through, despite the fact that there will not be records for every person.

I am a bit flummoxed as to how to design it.

Can anyone give me any guidance, please.

View 4 Replies View Related

Data Source Field Is Read Only

Jun 13, 2006

Hi, I know this has to be simple, but when I test a Data Access Page on my local machine I get an error that says "data source field is read only". I've made these pages before and never had a problem with writing to the database using a DAP. The database is not read only. Any ideas?

Thanks...Doug

View 2 Replies View Related

Dynamic Link To Source Data

Nov 22, 2005

Hello


I have a log which is updated by users in a spreadsheet. I have a front end which allows others members of the team to view the information being entered. What i want to know is if there is a way to link the spreadsheet to the database frontend which can automatically update the informationd daily.

I know you can do a SQL link but you have to pay for licences is there any way of doing this? We can not use a schudules job either??

View 2 Replies View Related

Reports :: Finding Source Of Certain Data

Oct 30, 2013

I have a report that is pretty complicated in the page numbering, since it's grouped by Aisle Number (it's a report of hazardous products in a store), and the Aisle Number and the "Page x of x" is in the header.Someone here actually created all of the logic for me last year.how a particular table is being populated with the information.Here's the Event Procedure for the "On Open" event of the report:

Code:

Private Sub Report_Open(Cancel As Integer)
'when the report opens the temporary table needs to be cleared
CurrentDb.Execute ("Delete * From ztblAislePages") 'delete records from table
' the recordset object needs to be opened so it can be used and accessible in the group footer and header sections
Set GrpPages = CurrentDb.OpenRecordset("ztblAislePages", DB_OPEN_TABLE) 'open the ztblAislePages recordset
GrpPages.Index = "Aisle" 'set the index so procedure knows what field to search

[code]....

ztblAislePages is a permanent table that holds temporary information...it's populated with information only for this report, and as you can see from the code above, it's cleared at the beginning of the process.where this information is coming from to populate the table, however.

Code:
Set GrpPages = CurrentDb.OpenRecordset("ztblAislePages",DB_OPEN_TABLE)

The table itself has no source data that I can find, unless I'm not looking in the right place.I've done a search for dependencies and can't find anything.
All I know is that when I choose a store, the table IS being cleared, and it IS being populated with new information.

View 1 Replies View Related

Changing ODBC Data Source?

Jul 23, 2014

I am having difficulty with my Access database, when I run a particular query. The query is linked to a table in SQL Server, but I keep getting a "ODBC -Call Failed" error message. After some research I understand I might need to change the ODBC Data Source, but this is something I have never done and am unsure of how to do it so my query will work!

View 2 Replies View Related

Change Source Of ODBC Data

Jul 15, 2013

I have an Access 2013 database that includes among its tables 4 externally linked ODBC tables in a SQLServer DB. They are linked tables, not imported. There are also relationships between these tables for some of the queries and reports in the Access DB. I need to make a copy of the database and change the source of the ODBC links to a different SQLServer DB. I have not been able to figure out how to do that without rebuilding the links with a new source definition created from scratch.

View 1 Replies View Related

Run MakeTable Query Without Confirm?

Apr 3, 2006

I have "unchecked" all the confirm options under tools, but when I run the make table query it still displays "The existing table will be deleted before you run the query, do you wish to contiue? I would like it to just run without this message, or at least give a message of my choosing. Is this possible?

Thanks!

View 3 Replies View Related

Confirm Update Message Box

Apr 2, 2005

I would like to have an update (requery) button on my form, that when clicked opens a message box that asks "ARE YOU SURE YOU WANT TO UPDATE?", if yes, a yes button is pushed, which requeries the record and closes the message box. If a no button is pushed, the message box is closed without requerying the record.

Can someone walk me through the process?

View 4 Replies View Related

Pop-up To Confirm Running Query

Nov 29, 2004

I already turned off all the checkboxes for running query confirmation (in the tool/option/Edit&find) but the users of my database still receive the pop-ups every time they run the queries. How can I fix this problem? (My database is for multiple-user environment.)

Thanks in advance,

View 1 Replies View Related

External Data Source Password Help Required

Jun 9, 2005

I have a database sitting on my server for which individual users login to over the network with their own User name and password.
Within my database there are links to data from external sources (SQL based).

My query is, if the database remains open at all times, once the link to the data has been established after keying the SQL database password, how do I stop it from asking each user that logs in to enter the password again each time they dip into the database? (If Possible).

(Access 97 by the way)

Thanks :confused:

View 3 Replies View Related

How To Link Additional Data Source To A Form

Mar 22, 2006

Hi All,

I have a db with three linked (related) tables. I have a form that has, at present, only one of these tables as a data source. Now I want to bring a couple of fields from another table into that form.

I know how to link a table to two data sources when first creating a table. But how do I do it when the table already exists?

I tried Table Design View | View Properties | Data source,
but that allows only one data source. If I link to another, the first disappears.

Thanks.

Adrian

View 2 Replies View Related

How To Link Additional Data Source To A Form

Mar 22, 2006

How to link additional data source to a form

Hi All,

I have a db with three linked (related) tables. I have a form that has, at present, only one of these tables as a data source. Now I want to bring a couple of fields from another table into that form.

I know how to link a table to two data sources when first creating a table. But how do I do it when the table already exists?

I tried Table Design View | View Properties | Data source,
but that allows only one data source. If I link to another, the first disappears.

Thanks.

Adrian

View 4 Replies View Related

Changing Data Source (table) For A Query

Jul 18, 2006

Hi,

I have two Tables TA and TB. I have a set of queries based on TA. I want to substitute TB for TA (i.e. TB will stand in place of TA). I want the old TA queries remain unchanged but now be based on TB.

If I delete TA and then rename TB into TA, I will lose the queries. Therefore I want to 'point' the queries (in the most efficient way) to TB instead of to TA.

Then I can delete TA. Then I can rename TB into TA and the queries will follow along, I expect.

I have been trying in vain to find a way of pointing the queries to TA instead of TB? How do I do it?

I have done it with Forms (Design Views, Properties), where I can select a datasource. But where is the corresponding thing enabling me to select a datasource for Queries?

Thanks.

Adrian

View 13 Replies View Related

Data Entered In Form To Record Source

Aug 26, 2005

I have a form where users enter data in various ways - combo boxes with drop down selections and text boxes where users manually enter some data. I also have several text boxes that return "answers" based on calculations from user entries mentioned above. The form is bound to a table where all the entered data is stored. I'm having trouble saving the calculated information to the bound table. It's easy in all the non-calced boxes, I just put the column name of the bound table in the control source, but in the calculated fields, I already have the formula in the control source. How can I identify the proper column to save the data in this case.

Thanks!

View 5 Replies View Related

Delete Query Using External Data Source

Dec 20, 2004

Hi,
I want to create a delete query that uses information stored in an external excel file. This file is constantly being updated so it isn't ideal to keep loading it into the access database. I need to use the excel file to remove any records appearing in my access table that are matching with the excel file. Make sense? Can anyone out there help - it this at all possible? Thanks,

View 5 Replies View Related

General :: Validate Headers Of Source Data

Jan 17, 2014

I'm working with several different source datasets. Mostly this are TXT files.

When I import the data in a new table with a specification, I want to validate if the dataset is the correct dataset be validating the headers in the source data.

I have created a table with the headers, that consists of 92 columns. Below 3 example columns of the header data:

tbl_Tickets_Headers
Field1 Field2 Field3
StagnationId TicketTypeId SequenceNr

Now I want to check during the import of the imported data has a line in it that is equal to the data in the table headers. If not, the import stops and informs the user that the data set is not correct. This to prevent that incorrect data will be inserted into the database.

Some extra information: The data is import into the database via VBA DoCmd.TransferText into a new created table, using an inport specification.

If the data is okay, it will be appended to an existing table that is being used to process the data further. After that the import table is being deleted.

View 14 Replies View Related

Tables :: Source / Reference Of Different Data Points

Apr 24, 2015

I want the user to be able to see the source/reference of (many of) the different data points in my database, so I need to store sources/references in the database itself. I want to have all references in one single/common table (list of references). Each reference may be the source of many data points, in different columns in a given table, and in different tables. Is this possible, and can it be done in an elegant way?

View 2 Replies View Related

Modules & VBA :: Data Source Name Not Found Error

Mar 31, 2015

i recieved error on the following connection string in the combo box change event code as follows,

Private Sub LotNo_Change()
Dim conn As New ADODB.Connection
Dim sConnString As String

[Code]....

View 6 Replies View Related

Confirm Action Queries In Runtime

Mar 3, 2008

I use the Access 2007 runtime to run my Access database on a few client machines. How do I turn off the confirmation of Action Queries? On clients that are also running MS Access, I can simply open Access, go to Access Options and uncheck the box. When I make this change in Access, the same settings apply for the Runtime on that computer. Which makes me think perhaps there is a registry entry I can modify someplace? If anyone has an idea as to how to turn this off for the runtime please let me know.

Thanks!

View 3 Replies View Related







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