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 Replies


Modules & VBA :: Backup / Zip And Email Copy Of Database Programmatically

Sep 11, 2013

I need a way that I can simply have a User click a button on a form of the database and it will do automatically create a zip file of the entire database and start Outlook and attach the zip file and send it to me.....

View 4 Replies View Related

Making Daily Backup Of Database?

Oct 29, 2013

As my database is growing and hold more and more data i want to make a daily backup to the local hard disk (it works on a network now) automatically.The way i want it to work is as follows :

When a user quits the application i want to check if there is a copy already existing with the date of today.

If it does it skips the copy process and just quits.

If it doesn't, i want it to make a backup in a directory. if the directory doesn't exist it must be made.

The backup file name must hold the date of today off course.

I realize that i have to have a procedure to delete obsolete (outdated) backups as well, but ill worry about that later.

Off course Ive tried this a few times, otherwise i wouldnt ask it here. But i seem to fail every time..

View 5 Replies View Related

Is A Backup System Necessary When Server Is Backed Up Daily?

Apr 11, 2006

Hi everyone,
Do I need to have a backup system with my database for the backend? The backend is stored on a server that is backed up everyday and tapes are kept for a week. There will be 2 maybe 3 main users writing to the database.

View 7 Replies View Related

Modules & VBA :: Changing Linked Table Location Programmatically

Dec 18, 2014

I am after a script to change the linked table paths like the following.

It will only ever be the path that is changing not the file name and only ever linked tables

for each table in tabledefs
if table.path = c:Testing* then table.path = w:Testingfilename
if table.path = c:Jobs* then table.path = w:Jobsfilename
if table.path = c:Quotes* then table.path = w:QuotesNewfilename
next table

View 5 Replies View Related

General :: Append And Update Records Daily From One Table To Another

Jan 9, 2014

I need to know the best way to append,

table1=productid,ProductName,Qty to table2=Productid,productName,Qty,date daily

I want to be able to append Records daily from table1 into table2 OnClose. But i do not want duplication of record in the same day.

If changes occurs in table1 after append,table2 should be updated using If conditions

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

Do You Have To "open" A Table To Programmatically Add Records To It?

Dec 10, 2007

This is more of a general question (before I start trying to figure out how to do this in VBA) but do you have to actually "open" a table to add a new record or search the records it contains? For instance, if I have a form that is bound to one table and I want to create new records in *other* tables based on what the user enters into the form, do I have to actually open those tables (display them onscreen) or what? I'm working on an older Access application and I noticed that it does this: open table, add new record with appropriate data, close table. This seems silly to me.

View 6 Replies View Related

Need Help To Create Table Programmatically

Dec 7, 2005


I need help to create a table programmatically in access. I have 2 tables. For e.g.

Table A
Field1 Field2
abcde 12345
bbbbb 54321

and Table B
Field1 Field2
abcde 99887
bbbbb 76543

As you can see Field1 of both tables are the same. I just need to create a Table Table C such that

Table C
Field1 Field2 Field3
abcde 12345 99887
bbbbb 54321 76543

Can this be done using a macro? Thanks so much in advance

View 5 Replies View Related

Modules & VBA :: Sending Mouse Click Event To List Box Programmatically

Aug 31, 2013

I have a form (about patients) containing a listbox (list of visit dates) and a subform (showing medications at that date). When you click on the listbox, the subform is re-queried with the selected date as a parameter to show the medications that were in use on that date. This is working fine.

However, when you move to a new record (patient), the subform is initially blank because the listbox hasn't been clicked on yet. This means that it looks like the person isn't on any medications, which is causing some confusion.

I need a way to have the subform show the "top" (most recent) date because that is the current medication list, and the thing most people want to see first. It is always the top of the list, so I would like to do something like this (pseudocode)

Private Sub Form_Current()
Send MouseClick Event to line 0 of SelectDateBox
End Sub

View 2 Replies View Related

Change Table Field Properties - Programmatically

Nov 27, 2005


I have a table that when imported from an external program (sage) has a number based property.

To achieve linkage with other tables, I have to manually change the field fom a number to text.

Is this possible to achieve programmatically.

Much appreciated on any advise.



View 2 Replies View Related

Tables :: Change Table Field Property Programmatically

Apr 23, 2014

I am using Access 2010. How to change the property of a field in a table programmatically.

I have a table in which one field has Required property set to "Yes". I would like to set this property by using VBA code to "No", then add data into a table using a query and re-set the Required property to "Yes".

Is this possible and if so, how can I do it?

View 6 Replies View Related

Modules & VBA :: How To Make Daily Stock Inventory

Jan 5, 2014

I have an inventory app, how to make daily opening stock /closing stock.I want the system done automatically,that is as users exit,closing stocks & next day opening stocks as users log in.Then daily stock reports can be generated.

View 2 Replies View Related

Modules & VBA :: Automating Daily Import Of CSV File

Aug 10, 2013

We receive a daily csv file from another database and we are trying to automate this process as much as possible.

At the moment, the other system will extract any new records, save a file as importddmmyyyy.csv in a specified location e.g. c:importpendingimportddmmyyyy.csv and then make a call to open access giving access the file path as follows

masaccess.exe "C:mydatabase.mdb" /nostartup / Excl/ cmd Filepath="c:importpendingimport09082013.csv"

I have configured access to automatically open a form, "ImportForm" when it opens, and I have configured this form to automatically run an event procedure on loading "importdailyfile".

My problem lies in writing this procedure. Basically I need it to run the Transfer Text command (I have already create an import specification)

DoCmd.TransferText acImportDelim, "myimportspec", "table to append the data to", filepath, true

The problem I am facing is that as the filepath changes on a daily basis given the naming conventions (which i cannot change) and my knowledge of VBA s pretty basic, I don't know how to make the procedure pick up the filepath that the other system is providing in the call to open access.

View 3 Replies View Related

Modules & VBA :: Backup Backend Using Batch File?

Aug 14, 2014

I've created some code to make a backup of my database backend. I've tested it and it seems to work fine, I just have some questions about it's use. Here's the code:

Public Sub backupBackend()
Dim TestFile As String
Dim strReplFile As String
Dim copyFromLocation As String
Dim copyToLocation As String
copyFromLocation = "S:Trust 2 AnalysisData"


It will be triggered by a button push. It creates a batch file to do the copy operation and then delete itself.

In an ideal world I would schedule the backup at a safe time through the Windows scheduler, but our IT department won't allow me to do so.

The concern I have is that we could potentially press the backup button while a user is performing an action that writes/modifies data. If this were to happen would my backup potentially contain corrupted data?

If so, is the workaround to simply press the backup button when nobody is using the database?

View 3 Replies View Related

Modules & VBA :: Daily File Import Timestamp Shift

Mar 17, 2014

I have a daily file to import. If I hard code the entire file name my code works. My problem is getting around the daily name change of the file.The owner has an automated process that creates the file so the name every day is slightly different due to the timestamp. Here's an example

Today's file is "mydailyfile_20140317_1035.xls"
Tomorrow will be "mydailyfile_20140318_1033.xls"

I can account for date using "sFileDate = Format(Now(), "yyyymmdd")".The hour/minutes is never the there a wildcard solution??

View 5 Replies View Related

Modules & VBA :: Backup Code Getting Permission Denied Error

Aug 22, 2014

I got these three code routines for backing up an Access database file from two different forums. I installed them as is, on a test database, creating command buttons for each. The test database is not password protected. I intend (if I can get one of these working) to install it on simple, single file, password protected databases.The first two came from Access World Forums at: URL....


Function BACKUPS()
On Error GoTo Err_BACKUPS
Dim fso As Object
Dim sSourcePath As String
Dim sSourceFile As String
Dim sBackupPath As String
Dim sBackupFile As String


I got a compile error "Invalid use of property." on the button sub. Then there was a simple On Click sub:


Private Sub Backup_Click()
Dim fs
Set fs = CreateObject("Scripting.FileSystemObject")
fs.CopyFile CurrentProject.FullName, "C:", True
Set fs = Nothing
MsgBox "Database has been backed up successfully"
End Sub
Private Sub Command32_Click()
End Sub

On this one I got a "Permission denied." error on the CopyFile method. As I said before, my database is not password protected.I found this third bit of code on another forum: URL...

Public Function db_Backup()
On Error GoTo db_Backup_Err

Dim sourceFile As String, destinationFile As String
Dim aFSO As Variant
Dim path As String, name As String


On this one I got another "Permission denied." error on the CopyFile method. Again, my database is not password protected. This code had appeared to me to be the most promising of the three.

View 14 Replies View Related

Modules & VBA :: Create Backup Of Database On Exit In Different Directory

Dec 20, 2013

I am looking to create a backup of a database on exit in a different directory then where I am storing the database now.

View 3 Replies View Related

Modules & VBA :: Calling Public Function To Backup / Compact Back End?

Dec 23, 2013

I have the following function that I found online. Unfortunately I can't remember where I got it since I've had it for a little while. Today, when I tried to actually put it to use it didn't work.

I'm calling it from a form as follows: CompactDB (tblHotword)

tblHotword is just a random table from the back end. My understanding of the function was that it would use that table to connect and get the file name of the back end.

Whenever I run it, Access pops up a window that says "Object required" and nothing else. It doesn't look like a standard error message popup. When I click 'OK', Access continues with the rest of the code as if nothing went wrong. The function doesn't run though.

Public Function CompactDB(TableName As String) As Boolean
On Error GoTo Err_CompactDB
Dim stFileName
DoCmd.Hourglass True
stFileName = db.TableDefs(TableName).Connect


View 8 Replies View Related

Modules & VBA :: Command That Will Create Backup Of Access Database Once Every Week

Feb 24, 2014

Im trying to create a command that will create a backup of my access database once every week. here is the code I've got so far. it works, but not once a week but every time I start the access:

MsgBox ("Hello! Starting Backup procedure")

Dim DateOfBackup As Date
Dim strSourcePath As String
Dim strSourceFile As String
Dim strBackupFile As String
Dim SQL As String


View 2 Replies View Related

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.


View 1 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

Tables :: Set Up Table To Add Information On Daily Basis

Feb 4, 2013

I am tracking extreme useage on account numbers. I've set up a table to add the information on a daily basis.

Currently the table has the following Fields:

Report_Date / Account / Usage / Sent / Received / Comments / Notes
(the Sent and Received fields are Y/N)

I've gotten a report to send working as I want, but I am running like 6 queries to put all the data together correctly. For example; if an account was flagged today and sent today I do not want to send another notice for the next 5 days; but I still want to log the data in the table for historical reasons... Again, this all works. Just that it is not pretty..

The part that I keep fighting is the responses. When I receive a response I want to log that. Right now, I check the Received flag, and add in any comments the customer sends back. This is easy. But I also want to print that information out on the report - just the latest information. For example, if I send a notice out on 11/1/12, 11/18/12, 12/14/12, and 1/10/13 and I have responses back from all of these logged in the table, when this account number gets printed again - say today - I want to add to that report JUST the comments from the 1/10/13 report.

View 4 Replies View Related

How To Create Daily Table From Monthly Data

May 23, 2012

How do I create a daily table from monthly data? I have a monthly table and want to split it into a daily table by dividing each monthly value by the number of days in that month. I need this so I can compare the new daily values to other daily values.

View 1 Replies View Related

Modules & VBA :: Programmatically Find And Select Item In Multi Select List Box

Apr 23, 2015

I have a multi slect list box (simple) and I need to find and select an item using vba - e.g., the bound column is the ID field and I need to select a specific ID (which will be different each time) as opposed to selecting the 100th record for example. How do I do this?

View 2 Replies View Related

Modules & VBA :: Daily Renting Cars System - Adding Dates When Client Not Paying

Jan 16, 2015

I'm making a daily renting cars system. The client should pay every day ( day by day). Everything is ok but if the client pay at these days....


At the date 15/01/2015 i want to check the payments. How to let the system show me that the dates


the client didn't pay the fees

Opening the payment form and make a new record everyday even if the client didn't pay and finally by a query I'm getting a list where the payment date field Is Null, but is there any other solution without adding the dates manually.

View 3 Replies View Related

Copyrights 2005-15, All rights reserved