Automated Table Creation And Backup

Aug 17, 2005

Hello all,

I need some advice for an ASP.NET web application I am working on. I am trying to automate the making of a new table within a database and then have all records from an old table migrated to the newly made table. I would like this task to run from the scheduled tasks on the server in the way of an .exe

The new table would be created on the first day of every month, taking the name of that month. I was thinking to use an empty template table which already has all the fields, and then making a copy and renaming it to the current month.

After the new table has been created I need to copy all the records from the table that represents the previous month over to the new table that represents the current month.

Any advice would be much appreciated.

Thanks

View Replies


ADVERTISEMENT

How To Make Creation Of A Record In A Table Trigger Creation Of New Table

Jul 17, 2013

I have a table that is a list of all of my events. Each record of events should have a child table that list all of the things that happened at the event. When a new record (event) is added how can I have a new child table created and linked to that record. Also I have a blank table to serve as a template for what each child should look like. How do I make sure this occurs? The child tables can have the same name as the index. I am just using numbers 1- for the index with 1 being the first event and so on?

View 8 Replies View Related

Automated Entries In Table

Jan 26, 2006

Hello,
I have a table which identifies my database users with the following fields:

INITIALS
USER
TITLE

I than have another table named MASTER with two fields named USER and TITLE. The field user, get it's data from the first table INITIALS. I would like that the field TITLE would be updated with the users TITLE once it is entered.


I know how to do this with a form (I place in a txt box =[USER].[Column](2) but have noticed that it only displays the info but not actually stores it into the field.

Is there a way I can do this directly from the table so that I can remove the TITLE control from my form? Thanks.

View 1 Replies View Related

New Table Creation Using SQL

Apr 9, 2008

How would I archive all orders place by customer 'x' in to a new table called tblArchive?

something like:

CREATE INDEX tblArchive ON tblCustomers WHERE customername = "x" ?

View 5 Replies View Related

New Table Creation

Apr 15, 2005

I created a new table for my database that contains three fields. A first name, last name, and a full name field. Is there a way in the definition of the table that I can define the full name to =[TrackComposerFirstName] & " " & [TrackComposerLastName]? I'm not sure where I would define a formula in data elements of a table.

View 10 Replies View Related

Log Creation For Editing On A Table

Dec 7, 2005

Hello,

I have created a table containing jobs that need to be done from my team (IT production). Each time someone start or finishes a job, he must fill a box that updates a specific row in the table. I want to log the time of that action.

Any ideas of how I could set this up in Access? I have tried the Now() function in the Default Value of the field End Time, but this is updated everytime I refresh the table

View 5 Replies View Related

Table Calculated Field Creation?

Feb 12, 2008

Is it possible (and logical) for me to create a table with a calculated field from 2 other fields in the same table? Example; I have a long time field (mm/dd/yyyy hh:mm:ss) aka StartTime, and a long time field EndTime. I would like to subtract the StartTime field from the EndTime field to get the total time elapsed, but in hh:mm:ss format. I can get it in hh:mm format, but I really need the hh:mm:ss format. Any Ideas? :cool:

View 4 Replies View Related

Automatic Record Creation In Table

Feb 18, 2014

I have two tables; Customers and contracts.

I would like access to automatically create a record in the contracts table when I change the status in one of the Customer Fields from prospective to Customer.

The two tables are linked using the Customer ID field.

Is this possible?

View 1 Replies View Related

Conditional Tallying, Linked .xls, Access Table Creation

May 14, 2007

Hi all-
I work for a staffing firm and I'm trying to figure out a way to turn exports from our vendor-based sql gui (i.e. I can only get .xls files out of it, can't just run SQL queries) into spiffy reports using Crystal Reports. My grand plan is to use Access to process these various XLS files (one for each client) by linking them to an Access DB and coding a table to conditionally tally individual records based on different criteria.

The criteria are company name, position name, date submitted, active, and status. I was able to code an Excel template that did the trick perfectly, but required each file to be edited to reflect the new report format, and updated as more positions are added. My question is this: is there some way for me to create a DB that links to the XLS files for each client and puts each company name, position name, date submitted (pulled straight from XLS files) and then the following tallies:

submitted (just # of pos name by date)
accepted (status != "s" AND active = "y" by date)
etc.

I don't really expect someone to do all my coding for me, maybe just point me in the right direction, as the only coding outside of excel formula coding (which I feel doesn't really count despite my proficiency) that I've done has been over a decade ago. Any suggestions?

View 4 Replies View Related

Replacing Data From A Backup Table

Sep 5, 2004

Hi, can anyone tell me how to replace the data in one table with data from a backup table? I've tried:

Insert into Customer
Select *
From CustomerBackup;

but I keep getting key violations.

View 1 Replies View Related

Modules & VBA :: Create Backup For Table In Another Database?

Jan 7, 2014

How to create backup for my table in another DB with VBA ....

View 3 Replies View Related

Table Creation : Big Table Or A Lot Of Small Ones

May 14, 2007

I want to create a dynamic page which will be composed of quite a lot of elements and will be filled with elements from my database.
First is the headline, 10 or so attributes, separate. Then 30 lines on the same model : Title (different for each line of course), Boolean, String, Date, Another String, Another Date, Another String. These lines are independent.
There will be approximately 1000 pages.
I wonder if I should create one huge table with everything in it (like Id, Headline, Title1, Boolean1, String1, Date1, String1, Date1.2, String1.2, Title2, Boolean2, String2, Date2, String2, Date2.2, String2.2, ...) or one table for each line (on the model : IdPage, Title, Boolean, String, Date, Another String, Another Date, Another String) plus the headline in a separate table?
I think I should take the "lot of tables" solutions, am I right? will it be a problem for Access?

View 4 Replies View Related

Modules & VBA :: Backup Records Programmatically Daily To Another Table

Jan 8, 2014

i have 2tables,table1=productid,ProductName,Qty table2=Productid,productName,Qty,date(). I want to be able to backup Records programatically daily from table1 into table2 OnClose.But i do not want duplication of record in the same day. If changes occurs in table1 after backup,table2 should be updated Programatically.

View 1 Replies View Related

Automated Query

Jun 21, 2007

I'm trying to run a make table query, and I'd like to automate it. Is there any way I can do this through a script so that I don't have to answer Yes/No to any of the pop ups? I turned off the notifications, but I still get the odd pop up.

View 1 Replies View Related

Automated Reports To Acrobat

Sep 2, 2005

Hi,

After much frustration and hair pulling I have managed to get the code below to work.. It prints out reports from access one at a time cycling through the list of schools in our county. My question is that I would like to save each report with a filename eg KS1_3000_version1.pdf where 3000 is the unique school ID.

So my question is how can I get the code/acrobat to save my file in a desired location with a pre-specified filename?

this would make the whole process a real click of a button! I know it is possible because we have a national database that does the same thing.. but I cannot crack the backend to see the code

bah!

thanks in advance

john

***********

Option Compare Database

Private Sub Command1_Click()
Dim repQuery As QueryDef
Dim dBase As Database
Dim rsRep As DAO.Recordset
Dim strrep As String
Dim data1 As String

Set dBase = CurrentDb()
Set repQuery = dBase.QueryDefs("john_test_ks1")
Set rsRep = CurrentDb.OpenRecordset("2_KS1_Performance_review_report")

Do While Not rsRep.EOF
data1 = rsRep.Fields("ESTAB_FK").Value
repQuery.sql = "SELECT SCHOOL_BASE_DATA_SCHOOL_BASIC_DATA.DFES, * FROM 2_KS1_Performance_review_report INNER JOIN SCHOOL_BASE_DATA_SCHOOL_BASIC_DATA ON [2_KS1_Performance_review_report].ESTAB_FK = SCHOOL_BASE_DATA_SCHOOL_BASIC_DATA.DFES WHERE ((([2_KS1_Performance_review_report].ESTAB_FK)= " & data1 & "));"
repQuery.Close
DoCmd.OpenReport "john_test_KS1_report"
DoCmd.Close acReport, "john_test_KS1_report"
MsgBox "done"
rsRep.MoveNext
Loop

Set rsRep = Nothing

Exit_Command1_Click:
Exit Sub

Err_Command1_Click:
MsgBox Err.Description
Resume Exit_Command1_Click

End Sub

View 7 Replies View Related

Automated File Transfer

Jan 17, 2008

I want to automate the file transfer from a remote site to my pc over a WAN. Can anyone please suggest an industry standard secure file transfer tool for a windows environment?

I am looking for an industry accepted, more secure than traditional FTP.
Thanks!

View 2 Replies View Related

Automated Date Entry?

Nov 29, 2007

the pieces of the puzzle are coming together, I am near completion of my database now...but have 1 or 2 more final questions!

Can today's date in the YYMMDD format be automatically entered in a table's column when I import a .csv file into access?? - this would obviously change daily and as such the table would need to be updated with the YYMMDD date when I carry out the daily import of the .csv file .

it will need to be fixed length of 6 characters so I can create my exported file.

Thanks again for any help! I have not been using Access for too long, but with the support from these forums, I am developing a greater understanding every passing minute! :)

-Venom-

View 6 Replies View Related

Automated Adding Of Records

Apr 6, 2005

Hi All. I hope this is in the right forum.
This is an example of the sort of thing that I am trying to acheive.

I am building a database to connect rooms. i.e (Building1, Floor1, Room1) connected to (Building2, Floor2, Room2)

I have 2 forms (frmBuilding) to add building names and (frmFloor) to add floor numbers.
On the other form (frmConnect) , I have the current location (Building and Floor) and I have a subform in datasheet view. I have 2 combo box's (both with a query as the source), one to pick a building I added in frm building, and the other to pick a floor I added in frmfloor. I also have a text box, where I add the room number.

This is would like to do if possible.

Try and automate the adding of records, so, for example, if I am adding records of (Building1, Floor1, Room1), (Building1, Floor1, Room2), (Building1, Floor1, Room3) to the subform, it will ask me how many rooms I want to connect, in this case 3, and then add them, keeping the building and floor numbers the same.
(I think I am explaining this more complicated than it is, sorry!!)

Can someone point me in the right direction? I have been playing about with queries.....is this correct?
Any help is greatly appreciated.

Many Thanks.

Frank.

View 2 Replies View Related

Automated Email Report

Mar 24, 2006

I have set up a process to automatically email reports from MS Access 2006. Everything would would perfectly except that when the process runs, a messagbox pops up stating that 'an unknown prgram is trying to send an email on your behalf'. Before the email is sent you have to click on the button to allow sending. I need this program to run very early in the morning when no one is around to click the button.

I have tried several things to get a round this by digitally signing my Access project and setting up certificates in outlook but nothing has worked.

Is there any way around this without lowering my security level, my antivirus or antispyware software?

Thanks
GEM1204

View 4 Replies View Related

Automated Field For Stock Control, Need Help, Please

Jun 22, 2005

Hello, I have been learning how to use Ms Access in order to design my own Database, I have done quiet a bit but i found myself kind of stuck witth the following issue. My question is pretty simple (I think…) Please, can someone help me? :o

I need a field that update itself automatically for each record.
For example, if I have 2 initial fields called [Stock balance] and [Quantity delivered]; I need to find a way to have the [Stock balance] updating itself just by entering a value for [Quantity delivered] where [Stock balance (actual record)] = [Stock balance (previous record)] – [Quantity delivered]

I could create a third field Called [Quantity left]
with [Quantity left (actual record)] = [Stock balance (previous record)]
and [Stock balance] = [Quantity left]-[Quantity delivered]

but it doesn’t seem right to create a third field that is equal to an other field just with one record difference.

Anyone with an advice?

View 4 Replies View Related

Automated Press Adverts - Via The Use Of A Database?

Jan 31, 2006

Hi I really hope some one can help me out here.

Here the outline of the situation. Every Friday evening I get sent a load of press adverts, which I have to put on the Intranet. This will involve detaching the ads, renaming them, adding them to the site with the Name of the paper, the date, and the organisation they belong to. What I want to know is if there is a more automated way of doing this. I was thinking weather I could detach and drop the ads into a folder and get a Access database connection to the press ads page. Which in-turn would allow me to insert the ads for the last seven days, yet keep a account of all ads which can be a called upon, via perhaps the use of a search function. This is just one idea I have had, are there any other ways I could make this mundane job easier?..

http://i24.photobucket.com/albums/c42/budgy/adverts.gif

All your suggestions and feedback will be much appreciated.

Thanks in Advance

Budgy

View 1 Replies View Related

Automated Field Colour Change

Apr 17, 2005

Is it possible to get Access to automatically change the colour in a form field via code etc. My problem is that i would like to easily pick/see any out of date quotations for my customers, so when the quotation date is 30 days old the text changes to red. Any advice would be gratefully received.

View 1 Replies View Related

Automated Database And Report Generation

Aug 30, 2006

I have a multi-layered question regarding setting up an access database for fluid samples sent in by a customer.

Ideal Setup:
The database would prompt me for the Sample ID number which is a unique code we give to each sample. It would then prompt me for the customer name and if given an existing customer name it would pull up all the contact information for the customer. It would then prompt me for the machine ID# that the sample came from, from which it will pull up the data from 10 previous reports and place into the current report.

I would then input the current data for the sample after analyzing it. I then have an automated control to convert the report to a .pdf file and send it via outlook. It would also be nice if the report was uploaded onto a website that the customer could access, but this is a whole different issue.

Is this setup possible with Access 03 and if so is it even remotely possible for a newbie like me to create? Additionally, what would the time investment be for a project like this for a beginner? Are there any other more effecients ways or programs to accomplish this level of automation?

Thanks for any help you might lend!

View 1 Replies View Related

Modules & VBA :: Automated Caps In Code?

Jun 3, 2015

I am having a few issues with my module code in Access 2002. for some reason every time I write some code Access is automatically making the first letter a capital so for instance [Our Ref] should be [Our ref] but it simply will not let me do it!

Temp = rstHTML!html1 & rstProp![Our Ref] & rstHTML!html2 & rstProp![Our Ref] & rstHTML!html3 & rstProp![Property Title]

View 6 Replies View Related

General :: Automated Top 10 Customers Calculation?

Mar 7, 2014

I am in the process of putting together a database for use in a hotel to log details of customers, enquiries, and sales.

I have one table for storing customer contact details in ("Customers"), another table for storing enquiry details in ("Enquiries") and a third table for storing sales data in ("Sales").

Each record in Sales is linked to a customer from the Customer table, so with a simple query you can see what any given customer has spent their money on.

My boss would like to have a list of who her "top 10" customers are, over a given period, so she can work out who spends the most. I was wondering if there is a simple way to do this?

The only way to do this that I can think of is to run a query for every customer (to isolate their sales data), use the total function to add their sales together, note down the total, and input into excel (to work out the ranking). However, seeing as we have been collecting data for around a month now and have around 400 customers in the database this would clearly take a very long time. Is it possible to automate this process?

View 3 Replies View Related

Reports :: Automated Rotating Schedule

May 2, 2013

What I would like to accomplish is to make a report similar to this, except make it automated so I won't have to change the dates. Users would be able to bring up a current schedule without worry that it's updated or not. The schedule repeats itself every 6 weeks. I made a cross-tab query, but I must admit that I'm not too familiar with working on them.

View 14 Replies View Related







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