Data Source Change
Nov 21, 2005If 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 Replies
ADVERTISEMENT
Change Source Of ODBC Data
Jul 15, 2013I 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 RelatedGeneral :: Can't Change Listbox Column Header Name When Data Source Is A Share-point List
Jul 30, 2013The following code works to change the column header name for a listbox in form view when the data source is a local table, but not when the data comes from a sharepoint list.
Code:
sqlstatement = "SELECT ID, PONum as [PO Number], ActDate as [Date], VendorName as [Vendor Name], Service, BuildingNumber as [Building Number], ReservationDescription as [Description], POAmount as [Amount], QuoteType as [Type of Quote], Comments" & _
" FROM ActivityLog" & _
" WHERE (Activity = 'AcceptReservation') AND (PSCName = '" & Me.PSCCombo4.Column(0) & "')" & _
" ORDER BY ActDate;"
'MsgBox sqlstatement
Me.EditPOListBox.RowSource = sqlstatement
sqlstatement = ""
Also it appears that there is no such thing as a caption property for a sharepoint list column.
How To Change The Source Of A Colom
Jun 6, 2006hi there first to start of im dutch so chances are you wont understand everything of what im saying;).
For an assignment for school i have too make an acces database.
im doing pretty fine except a couple of things. the assignment is too make an database for a hotel.
i made 3 tables 1 for customer data 1 for the booking 1 for the appartment data.
now im making a booking form.
but i ran in to this problem: the customer data table has customer number as main key. if i make a form all the coloms customername, customer adress, customer streetname, ect get their data from looking up what the customer number is and then getting it from the right colum.
but on the booking form i need to have the data for the companions who are staying at the hotel with the customer too.
the companion has the same coloms as the customer the companions are staying at the hotel too they too are registert in the customer table.
but if i try to copy the customer coloms like customername, customer adress , i dont know how too make it that they look up the companion number and not the customer number.
thanks in advance for the reply's, if anything is unclear please say so
kasper
Change The Sub Form’s Record Source
Nov 16, 2005I have a main form that has 10 sub forms Each sub form’s record source is link to a different Query.
It takes more then a minute to open the form, (because it’s running the query for all sub forms). So I changed the sub forms source to SELECT * FROM tblTest WHERE false;
I also changed the main form. When the button on the main form is clicked, it’s adding the following:
Me.SubMySub.Form.RecordSource = "select * from qMyQuery"
Me. SubMySub.Form.Requery
However, after I close the main form, the sub form’s record source stays linked to
SELECT * FROM qMyQuery;
And will take the same long time again to open the main form.
Does anyone have any solution?
Change Source For Linked Table
Jan 24, 2008I have a linked table and want to change it's data source to another table entirely -- ie: different file name.
Can this be done with linked tables, or can you just link to another file with the same name but in another directory? If linked tables have this limitation, how would you accomplish what I'm trying to do. I want to keep the same name for the linked table.
Ultimately, I want to populate a listbox with the different files in a directory and change tblSource to point at the chosen data source.
Thanks,
Randy
Control Source On Report Won't Change
Sep 10, 2004I have a report with subreports contained in it. Each subreport gets it's data from a different table.
I noticed subreport 1,2,3,4 are pulling the data from their corresponding tables. However, subreport 5,6, and 7 are pulling their data from the table relating to subreport 1.
I've checked the subreports themselves. They are referencing their own tables if I open them individually but not when opening the main report.
The report names all seem to be correct.
I've never seen anything like this before. Does anyone have some ideas??
Thanks.
Change Record Source On Report
Jan 14, 2005OK. I have a report that I want to use as a master and use with about 4 different querys. In the report properties I've bound it to a query. I've tried for ages to change the record sources with on click command bottons on another form. I think things have become complicated because there's a subreport on the report I AND a there's bunch of code to make things invisible in the on page event of the report.
anyway, here's what I'm using:
DoCmd.OpenReport "rpt_master", acViewPreview
Me.RecordSource = "qry_rptPrintRollClass"
Is this the right way to do it??
Any ideas on how I can clean it up??
Thanks
Damon
Change Report Query Source
Dec 19, 2003I have designed a report that took ages to do the layout etc for.
Now I just want to use that as a template and just alter which query it gets its parameters from.
I can't for the life of me figure this one out
Any help would be very much appreciated
How To Change The Record Source Of A Report From A Form
Sep 22, 2005I'm looking to change the record source of a report and then print the report depending on what button the user clicks on.
Is there some way to do this?
Modules & VBA :: Change Row Source Of Combobox By Clicking On Checkboxes
Jun 28, 2014I have a Form with a combobox and 3 checkboxes now i want to change the Rowsource of the Combobox by clicking on the checkboxes. When i click the Checkbox the Rowsource gets Changed as i want it but i can not use the new Values cause its giving me the error "The value you entered is not valid for this field"
The Funny thing is its always bound to the type of data i choose first. When i first select the Week i can select only Weeks (17,18,19 etc)
When i choose Day first it only accepts Dates (01.01.2014 etc)There is no Control Source set . And the Bound Column for all Sources is 1
Here the Code
DD_Zeitraum is the Combobox
CB_Day CB_Week CB_Month are the Checkboxes
Code:
Private Sub CB_Day_Click()
If Me.CB_Day.Value = -1 Then
Me.CB_Month = 0
Me.CB_Week = 0
Me.DD_Zeitraum = ""
Me.DD_Zeitraum.RowSource = ""
Me.DD_Zeitraum.RowSource = Dist_Datum
Else
Me.CB_Day.Value = -1
End If
End Sub
[code]...
How To Change Source Of Linked Tables After Compiling Frond End
Oct 12, 2015Suppose I have a front end and backend (tables) database which I want to deploye. Currently Access tries to find the backend in the same absolute location (rather than relative position). This causes a problem as drive letters change and sometimes I would want it in a specific location on my computer and another place on deployed computer. Is there anyway to change source of linked tables after compiling to ACCDE
View 3 Replies View RelatedForms :: Duplicating Tabbed Form And Change Record Source
Aug 7, 2014I have a navigation form that has a tabbed form on one of its tabs. The tabbed form has a 'current client' query record source and allows one to choose from a list of current clients and when a client is selected - details relating to client are displayed on various tabs on tabbed form.
I want to duplicate tabbed form and change record source to a query selecting 'exited clients' so I can see same information but for exited clients.
I have created a new tab on navigation form for my new exited clients tabbed form and changed record source by creating a new exited client query but when I change record source on exited client tabbed form it automatically changes record source of current client tabbed form to the exited client query and visa versa.
Forms :: Change Records Source And Run Query - Onclick Event Of Command Button
Apr 8, 2013I have a tabbed form in a navigation form with a chart on it. The records source of the chart is a query. The query runs when you click the tab and takes a long time. I changed the Row Source of chart to "" and that eliminates the query running on form load. I've read many posts on changing that row source when a command button is clicked. I tried
Code:
Me!Suspend_Trending_Dashboard![chart].RecordSource = suspend_trend_CHART
in the onclick event of the command button. This doesn't work. I've tried many variations of the syntax. I don't know if I have to tell the query to run after the row source is changed.
On a side note, the query criteria is based on beginning and end dates entered into text boxes on the form. This all works if the query loads when the form is opened.
How To Change Item Source For Multi-valued Field From A Linked Table To A List
Feb 16, 2013I am using MS Access 2007.
I have created a multi-valued field "Product Category" that lookups data items from a linked table. So, the Data Type for the multi-valued field "Product Category" is Number.
Now I want to change the Data Type of "Product Category" from Number to Text, and make a value list that I can type values in and can provide the same data items as the linked table.
How to change item source for the multi-valued field from a linked table to a list that I can type in values? Is there a feature provided by MS Access 2007 can enable such a conversion?
Tables :: Change Item Source For Multi-valued Field From Linked Table To List?
Feb 16, 2013I am using MS Access 2007.
I have created a multi-valued field "Product Category" that lookups data items from a linked table. So, the Data Type for the multi-valued field "Product Category" is Number.
Now I want to change the Data Type of "Product Category" from Number to Text, and make a value list that I can type values in and can provide the same data items as the linked table.
How to change item source for the multi-valued field from a linked table to a list that I can type in values?
Is there a feature provided by MS Access 2007 can enable such a conversion?
Forms :: Change Button Color After Data Change
Apr 5, 2014I am trying to change the button color on a subform if a related form data changes.Main form is products with a continuous subform with serial numbers of products i.e, serial number, location, price and a button to add addtional issues if there are any for this particular serial number (this will open up another form related to the serial number so I can add an issues if there are any).The reason I would like the button to be a different color is so I can quickly see if there are any additional notes been added to the serial number. Just in case you may ask why not add the field to the continuos form is that the issues and be quite lengthy and there may be lots of serial numbers on the form
2346 location warehouse price 29.99 (button - green)
2347 location shop price 29.99 (button - red)
Changing Data In Query Results Changes Data In Source Table
Dec 17, 2012I 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 RelatedForms :: Change Record Source Of Combo Box On Form Based On Another Combo Box
Mar 31, 2014I have a form that currently uses a "catch all" table for listing available equipment to choose from for an equipment field. I call it tblEquipment. What I want to do is to make it so when I type a name in (1 of 35) in one field of the current record, the record source for the equipment field immediately looks at a different table that has equipment available only for that name. To do this I plan on making 35 different tables with limited data originally found in tblEquipment. I would call these tblEquipment1, tblEquipment2, etc. I do not use a sub form, nor do I want to.
So my questions are:
1) can this be done
2)If it can be done, how can I do it?
Getting Data From More Then One Source
Jul 14, 2005In 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?
Confirm Data Source
Jun 14, 2007I 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 2 Replies View RelatedMDB....underlying Changing Data Source
Dec 1, 2006Hi!
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.
Complicated Form Data Source
Mar 18, 2005Well 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.
Data Source Field Is Read Only
Jun 13, 2006Hi, 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
Dynamic Link To Source Data
Nov 22, 2005Hello
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??
Reports :: Finding Source Of Certain Data
Oct 30, 2013I 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.