Make New Table From Another
Apr 9, 2007Hi
How to create new table from other with vba when the one table has records and the key record must be transferred to the new table.
Thanks
ADVERTISEMENT
Extracting Data From Linked Db2 Table Using Access Make Table Query
Aug 29, 2006Hi,
I am extracting data from linked db2 table using access make table query. First I create a select query and can view the linked db2 data, but when I change to a make table query I get an error message, "invalid argument", when I run the make table query. There is no selection critera specified. Has anyone had this happen? and Do you know a solution?
Thanks for your support
GinnyP
If A Make-table Query Result Is Null, How To Have A Default Message Appear In Table ?
Jan 21, 2005Hi everybody,
Beginner here needs help !
I'm building a make-table query for which if the result is null (no record correspond to the set of criterias), a default message like "there was no activity during the period" would appear in the table (not a message box...I need the message in the output table). The best I could think of is an IIF function but it doesn't seem to work... Is there any way to do this without using VBA?
Thanks in advance !
Tables :: Make Calculated Field In One Table That Calculates Values From Another Table Linked By Order ID
May 13, 2015I have what is probably a stupid question but I've been struggling with this one for a while. I have an ordering database which has an Orders table (containing Order ID, Date, Supplier etc) and an Order Line table within which I have a combo box for Product name, supplier, price, VAT rate, Line price etc. At the moment, I have the order line table as a subform within the Order form (run from the Orders table). The problem I'm having is the subtotal and total fields. At the moment these are in the Order Line table as I cannot figure out how to get these in the Orders table. In summary, can I make a calculated field in one table that calculates values from another table (linked by Order ID)?
View 3 Replies View RelatedModules & VBA :: Copy Structure Of A Table To Make A Temp Table
Apr 20, 2015I'm trying to copy the structure of a table to make a temp table. I'm using CopyObject (which also copies the data). So when I delete the data from the temp table, it also deletes data from the source table. Is the data linked? It should just be deleted from the temp table. Below is the beginning of the code. I've stepped through, and at the last step shown, the data in the source table deletes.
Code:
Dim strFile As String
Dim temp As String
Dim tbl As String
Dim db As DAO.Database
' error handle
On Error GoTo F_Error
[Code] .....
How To Make Two Table Entries Correspond To Single Entry Of Different Table
Nov 18, 2013I have one main table with a list of equipment. I have a second table where there will be a form for damage reports.
What is the easiest way to make multiple entries from the second table correspond with a single entry on the main table?
Some equipment pieces might have dozens of damage reports, while some might not have any.
How To Make Values In One Table Automatically Show In Another Table?
May 22, 2007Hi, I have a problem, I have a table were I list networkservices and their logical ports and I have another table were I list IPaddresses used by different machines. I'm using a multivalued lookupfield to pick which services I'm using for each Ipaddress, and thats working fine, but now I want to make the ports which is listed in another column, to automatically show in it's own column in the IPaddresses table depending on which services I'm choosing for the different IPaddresses. Is this possible?, and if it is how can I make this happen?
View 1 Replies View RelatedChanging The Name Of The Created Table In A Make-Table Query
Sep 23, 2007Dear Access Expert
I wanted to know if it is possible to change the name of the Table which is going to be created using a Make-Table Query via code (VBA).
For example if my Make-Table query currently creates a table with the name "Table1" I want to change it to name "Table2" and then change it Back to "Table1" or "Table3" etc.... depending on the users selection.
Queries :: Make Table Query - Find Table Name
Oct 14, 2013How can you determine the name of a table that has/is going to be created by a make-table?
View 2 Replies View RelatedMake-Table Query With Relationship To New Table
May 31, 2005I've got a problem with a make-table query that creates a new table which is then populated with new values that relate back to the original table the trouble is the make-table won't run with that relationship in place.
Is there a way to delete the relationship then reinstate it after the query? or any other way round that someone can think of.
Thank You
Make-Table Queries - Can Table Be Updated?
May 2, 2006I have created my first Make-table query and it actually worked!!!Yeah! But now, is there a way to make this table updateable each time the query is run?
View 3 Replies View RelatedMake Table Query From Filtered Table
Jul 31, 2007I have come across a snag in my access project I am currently undertaking and need some advise on what should be done next. . .
In a nutshell, this project's primary purpose is to perform a search on a table of information based on many fields and generate a report based on the records which match the search. I have the search form working (similar to this one here) http://allenbrowne.com/ser-62.html
It displays the results from the table based on the search criteria. The form is great for viewing the results which match search criteria; however, I am having trouble doing anything else with the data (perform operations on the data, send the results to the table, etc. . .). How should I go about moving this data to a table?:confused:
Make Table Query - With Date In Table Name
Aug 20, 2007I have used/am using the "INTO tbl_temp_copy" to create a temp table from a query called tbl_temp_comp. Everytime I run my query it deletes and then creates a new table with the same name - and this is what I have been wanting.
However now I would like to create a table with the date in the table name so:- "INTO tbl_temp_copy_Date()" but obviously this does not work and I do not know if it is even possible?
Anyone able to do this or know that it cannot be done?
Make-table Resetting Table Field Value?
Nov 5, 2007Hi,
I have a make table query that deletes the old table every time the new one is made. However every time the new table is made it resets the field property for the “Date” field to “Text” rather than “Date/Time”
Does anyone know how I can avoid this problem please?
I’ve tried an update query but Access won’t allow me to perform the sum function that I require the actual query to perform. Any suggestions would be very much appreciated.
Thank you
Dean
Modules & VBA :: Make New Table Using Fields From Another Table?
Jul 29, 2013I have a table with 3 fields. The fields are down1, down2 and down3. . I would like to use this table to create a new table (downtime). What I need too do is loop through each record in the table and place the three fields independently in my new table. For example, I would like to go to the first record in my original table, than place down1 as my first record in my new table, down2 as my second record and down3 as my third. Than I will go to the second record in my original table and place down1 as my fourth record, down2 as my fifth record, down3 and my sixth record and so on. I want to make a toggle button that will do this.
View 7 Replies View RelatedMake Table
Dec 22, 2005I have 3 tables with which i want to extract columns from each of them and place them into a new table. The problem i have is that none of the tables share a common member. each table contains the same amount o rows spo when outputted to the new table will match up
View 1 Replies View RelatedUsing Another Table As Criteria To Make Table
Nov 27, 2012I have two tables.
One table gives values for E-1 (execution week - 1 week) E-2 (two weeks til execution) and so on all the way up to E-15. This is called Weeks table.
There is a simple action that updates that table every week with new values.
Second table creator takes user input for what date the E-0 starts on (from the Weeks table). Multiple weeks tables are created based on > E-1 and < E-2 and so on and so on but this is all derived from input from the user when running the make table.
I would like in the criteria for the make table for the various schedule weeks to automatically pull the E-1 column (example being 11/25/2012 11:00 pm) instead of having the user input that information in everytime and every week to make new tables.
Make Table For Duplicates Only
Jan 11, 2005How do I make a table from another that will only display the duplicate records in a field .... I have add'l fields in addition to the partno but not relevant.
i.e. partno new table will show:
0001 0001
0002 0001
0001 0003
0003 0003
0003
Thanks for your help....
Can You Really Make A Table Invisible??
Aug 2, 2006Is it possible to make my Splash screen invisible after someone checked the "Do not show me this screen again" just while that current session? Is there a way of using flags and a system table or query that would allow me to do so? Thank you:)
View 2 Replies View RelatedMake Table With Code
Mar 24, 2007i am sorry
im new using access
how can i make a table with code? and how can i create relationship between tables with using code?
Make Table Query
Dec 22, 2005When using a make table query, can you include an ID tag. in the output table? if so how
View 2 Replies View RelatedMake Table Query Help
May 15, 2006:confused: I am using a Make Table Query to filter a Linked Excel Table. Is there a way to cut/drop the first 8 characters of the text out of one of the fields as it creates the new table?
Field NameExcel DataFinal Data
Model_NameLATITUDE D600D600
Also, the final table has two Relationships with two other tables. When I run the Make Table Query once a week, I have to break the relationship to get it to run. Is there an easier way to dial with this?
Make-Table Query ??
May 19, 2006Is there a way in a Make-Table query to tell the table to open when it's created? I would assume there is a function or SQL code that would do this, but I know very little SQL. Can anyone point me in the right direction? Thanks!
View 2 Replies View RelatedNever Use ‘make Table’ Queries.
Mar 14, 2007I know that this could open a can of worms but is the above statement true. I have always avoided using delet and append due to database bloat. I know its more difficult to set the field types in a make table query but it means that the database doesn’t need to be compacted nearly as much as delet and append.
If my understanding is incorrect please explain top me why delete and append are better.
Thanks
Make Table Query
Aug 27, 2007I have a database named NewUpdate.mdb. I have another database named MainDatabase.mdb. Almost all the tables in NewUpdate.mdb are linked tables that are in the MainDatabase.mdb file.
I've written a simple make-table query in NewUpdate.mdb that makes a backup of a table that is located in the MainDatabase.mdb file. (See code below.)
SELECT tblProviderRate.* INTO tblProviderRateSave
FROM tblProviderRate;
The only problem is that this new table is created in the NewUpdate.mdb file. I need the query to be stored in the NewUpdate.mdb file and the "new" table to be created/stored in the MainDatabase.mdb file.
This sound simple enough, but I'm drawing a blank as to what I need to do in order for this to occur. Can someone tell me what I'm leaving out??
Thanks,
CRhodus
Make Table Query
Nov 26, 2007How to make-table query to make a certain field a memo field instead of a text field? The reason I cannot use the text field is the limitation is 255 characters while I require 2000 characters?
View 4 Replies View Related