Emptying A Database Aftre Completeing And Testing The Application

Feb 16, 2007

what is the best way to do it without harming anything.

is it also possible to reset autonumbers

thanks

View Replies


ADVERTISEMENT

Emptying Out A Database To Start Over

Jul 6, 2007

I have been testing data entry forms in a new database. Is there an easy way to reset the whole thing, autonumbers and all to new, as if nothing had ever been in the tables?

Thanks for your input.

View 9 Replies View Related

Core Testing Database

Sep 1, 2005

Hi,

I hope someone can help me. Thanks ahead for taking the time to read through my post.

I am new to Access (I know the basics,) and will ask my question by hand of describing what I want to do with my database.

I work as a laboratory technician, where I need to test UTP cores (cores are what's called one of the 8 cables inside a UTP/Network cable.) I want to create a database where I can store these test results.

To make it easier to envision my database, I'll explain a bit about the actual testing. Cores are grouped together, and tested, according to batches. There are 40 cores in a batch. Each core has a unique job number. Further, the cores are divided into 8 different colors (Green, W/Green, Orange, W/Orange, Brown, W/Brown, Blue, W/Blue.)

A standard test procedure is done on EACH core: dimensions on the insulation on a X and Y axis; dimensions on the copper on a X and Y axis; a test to determine if the copper sits centre. There are thus 5 values I want to record.

My problem is: I want all 40 cores, each with their 5 values, on one form. I want to save this as one batch, or one record. How would I go about doing this? . It’s a bit more complex than your standard table-query-form-report database.


As I said, I am acquainted with the basics of Access. I can do tables, queries, forms and reports.

Thanks ahead.

View 3 Replies View Related

Beta-testing A Database While Making Improvements?

Jul 23, 2015

I need to start using the database I've created (desktop database). However, I don't want my current version to be the final version.

Should I create another file to work in and use the old version for data entry? When I am ready to start using my new version, is it easy enough to transfer all the data from the old?

View 3 Replies View Related

Database Creation And Testing Complete / Will Making It ACCDE Clear Everything Except Forms

Feb 7, 2015

I've created and tested my database. What step or steps do I take now to make it so it's a program that only shows the forms and menu's I created, not all the Tables, Queries etc and the formatting options? Is there a link that explains what to do step by step?

View 2 Replies View Related

Writing C# Application That Uses An Access Database

Mar 28, 2007

Hi,
My question is how do I write a C# application which performs operations on an access database, such as searching and adding records. My problem is the basic how to : how do I connect between the C# file and the access database ?

p.s.
I don't know if it's the right place to ask this question, but I also need to present the application in a form like manner. How do I connect between the c# file, the HTML file which consists of the form, and the Database ?
Or should I write the form in c# also ?

All help appreciated:)

View 2 Replies View Related

Read Only Database When Opened With Application

Jan 5, 2012

We have an application that copies a mde file local and then runs it under msaccess 2003.

It runs fine as a local administrator when using the application.

When a regular user logs onto the system then it opens with a read only message. It does not create the ldb file.

The mde works fine if launched directly as regular user or as an admin.

This same application works fine on other PCs with anyone logged on.

The application is developed locally but we have lost the source code.

View 3 Replies View Related

General :: Access Database To Application (EXE File) To CD?

Nov 24, 2012

Okay so I created a database inventory. I know I can turn it into a "application" making it a EXE file. I was wondering after that being done could I burn that into a CD? So it would boot from the CD. Pretty make it work like a program application as in word, excel, etc..

View 1 Replies View Related

Backend Database - Front End Application Linking Issue

Nov 25, 2007

Hello all,

I have a back end database that i cannot access at the moment. Is it possible to set the link of the tables for the front end application based on the location that the database will be even though i can't see that location now?

Thank you in advance.

View 1 Replies View Related

General :: Create A Front End Application For Access Database

Apr 10, 2013

I was looking to see if there was an easy way to create a user front end desktop application for a small access database.I have three users on different computers i would like them to input or amend data within one table of the access database.

View 2 Replies View Related

General :: Cannot Open A Database Created With A Previous Version Of Application

Oct 22, 2012

I am trying to open a MS Access Database which was made in MS Access 1997 or MS Access 2000, at the moment i am using MS Access 2010, i cannot open the database or link the tables.i do not have MS Access 2000 anymore.

View 1 Replies View Related

Opening Access Application Like Desk Application Done With Java Or Vb

Jan 5, 2014

it is possible to Open access application like desk application done with java or vb, or install access application as exe or similar methods. My requirements is to giving a access application to customer with data base for printing an invoice. when he running the aplication he can see access open and tables, queries forms left hand. how to hide these thing ?

View 4 Replies View Related

General :: Distributing MS Access Database File With Creating Application Shortcut

Nov 4, 2014

I read in the book (Access 2013 inside out), one of the way to distributing access database is creating an application shortcut.

Now i have an Access 2013 file on my computer (with office 2013 and windows 7) other users have office 2007 and windows (XP) on their computers. now i want to give a copy of this file to other users without save as that to 2007.

I would like to know how i can do that with creating an application shortcut , if it is possible because in the book I could not find the way if there is?

View 2 Replies View Related

Is It Possible To Integrate MS Access Application To A Web Application??!!

Jun 11, 2007

We have an extensive reporting application in Access and would like it to be available through a web application. I've went down the road of migrating this application to SQL to use SQL Reporting Services; this is a good tool but I am wondering if MS Access has an easier solution for me other than migration to SQL.

I'm looking for a solution that will make these reports available over the web for many users. Price tag is a consideration...need to know if there is any.

Please help...thanks in advance for any thoughts!!!!

View 2 Replies View Related

Testing

Oct 9, 2004

hi is this working yert?

View 1 Replies View Related

Testing For A Sunday?

Feb 22, 2008

Hello peeps,
I have been working on a hours checking application, in which the user can enter their worked hours for the week and the application calculates how many hours at normal rate , time and half rate or double time rate have been worked for the week. All has been going swimmingly, with some help from here of course :)

What I would like to achieve now however, is, testing for a Sunday. This is because all hours worked on a Sunday, is paid at double time, regardless of the previous hours already worked for that week.

Example if a person worked 60 hours in a given week, there would be 47.5 hours of normal rate, 7.5 hours of time and a half rate and the remaining 5 hours would be at double time rate. But, if a person worked 60 hours in a week and 10 of those hours are worked on a Sunday, this would mean 47.5 at normal rate, only 2.5 hours at time and half rate and the remaining 10 hours at double time.

Therefore, is there a way I can test for a Sunday and perhaps automatically set a flag for the overtime calculation? Or is it possible with DateDiff() function, and if so could someone please assist me with the syntax or at least point me in a direction where I could solve this?

All replies gratefully recieved. Thanks in advance to anyone taking the time to read this post.

View 6 Replies View Related

New Record, Testing For

Jun 11, 2005

I need to disable a custom goto next record button. How do I find out if the current record is both the last and new or if a new record is possible?

Many thanks in advance,

Aidan

View 4 Replies View Related

Testing For Null

May 2, 2008

I know this is an easy one but have to ask...I am trying to test wether or not a Textbox in my form is Null or not...

Cant get it to work

Thoughts?


Code:If Text45 = "" Then MsgBox "45"Else MsgBox "THERE IS SOMETHING"End If

View 4 Replies View Related

Testing For Null Fails

Oct 19, 2004

I have a table where some of the values of MyField are null.

I am creating a function that depends on the value of Myfield which I pass to a variable varMyField and am testing it with If IsNull(varMyVariable) but it errors. Have tried setting the variable as a variant but no difference.

Function Test(varMyField as variant)

If isnull(varMyField) then
Dosomething,
Else
Dosomething Else
End if

End function

Any suggestions please?

View 3 Replies View Related

Tables :: AutoNum While Testing

Feb 6, 2013

I created a table and a form. One of my tables fields is AutoNum. Each time I test the form layout, the AutoNum field increase and yet I am only testing at this stage!How can I bring back this field to zero? Where is my data stored (extension)?

View 1 Replies View Related

General :: Testing Folder For A Value

Aug 1, 2013

This code below works, but alot of what it does is unnecessary. I have a directory structure named 1000-2000, 2001-3000, 3001 - 4000 etc and within that is the individual folders 1000, 1001, 1002 etc

How do I test to search top level folder thats no larger than correctNum to then test the subfolder for correctNum? I've looked at instr and a few other funtions, but can't find a solution. Below is what I have now, it works but I know it searches everything and that's not correct

Dim filesys
Dim Subdir
Dim folder
Set filesys = CreateObject("Scripting.FileSystemObject")
Dim oDir
Dim bDir
CorrectNum = Serial.Value

[Code] ....

View 3 Replies View Related

Logic Testing For Incremental Numbers

Jan 7, 2005

I need some help with code. I can do this in Excel, but I am not sure how to do it in Access.

Here are the fields:

PoundsPerBox
PoundsPerOrder
BoxesToOrder

Here is the scenario: If a customer orders custom paint for their equipment, we need to total how many pounds of Powder Coat paint it takes to paint all the units (PoundsPerOrder). When we order this from the vendor we have to order it by the box which is measured in pounds. In this example, the vendor will sell us a box of white Poweder Coat paint in increments of 55 pounds. (55, 110, 165,...)

Verbally, the logic reads like this: If PoundsPerOrder is less than or equal to PoundsPerBox, then BoxesToOrder equals 1. This logic needs to be tested for each increment value (indefinately) of PoundsPerBox.

Am I making sense? How do I accomplish this in Access? And, as a side note, I need to capture and store this value in a table for future reference.

View 7 Replies View Related

Displaying Data - Whle Testing -

Oct 18, 2006

I know this is really silly.
How do I display data that I am working with in a report? I want to do the equivalent of alert or response.write. I am using msgbox, but it's getting old. What is the syntax for just displaying it ? Can I do that on a form? I tried using document.write, but it didnt like it. thanks-

View 1 Replies View Related

Forms :: Testing Subform Conditions

Sep 25, 2014

I do not want to allow the main form record to be submitted unless there is at least one subform entry.Initially I thought it would be as simple as a "Before Update" event which would test the record count of the subform. This works... kind of... not really. It does check successfully, however the conundrum is that if the user has completed the main form and tries clicking INTO the subform to add records, this fires the Before Update event and Cancels the update event.

How can I force a user to complete the subform without running into this issue? I dunno how easy this is to do considering you kind of HAVE to exit the main form to enter the subform, at which point the record HAS to be saved...

View 1 Replies View Related

Modules & VBA :: Testing For Out Of Context Errors

Apr 9, 2014

I have quite a simple function. I am calling it in a query (through the Build window) like this:

Code : AbsMag: getAbsoluteMagnitude([Tbl]![m],[Tbl]![Distance])

When the input value for m is empty/Null, the response returned in the query is #Error. Problem is, any way I try to test for this in the function, it still returns #Error.The Watch for m reads "<Out of Context>" for these errors. Anyway to test/trap for this within the function itself?

Code:
Public Function getAbsoluteMagnitude(m As Double, d As Double, Optional dUnit As String = "Mpc") As Double
Dim absoluteMag As Double
' IsError(m) returns False
' IsNull(m) returns False
' IsEmpty(m) returns False

[code]...

View 3 Replies View Related

Modules & VBA :: Testing Combo Box Null Value

Sep 22, 2013

Windows vista
Access 2007

I can't seem to figure out how to test a combo box null value.I try:

Code:
If IsNull(Me.cboManufacturer) Then
MsgBox ("Please select category")
Else
DoCmd.OpenReport "rptItemCategory", acViewPreview
End If

This works if the combo box IS NOT NULL, but if null it gives me:

PHP Code:

Run-time error '3071': This expression is typed incorrectly, or it is too complex to be evaluated. 
For example, a numeric expression may contain too many complicated elements. 
Try simplifying the expression by assigning parts of the expression to variables. 

I then tried:

Code:
If IsNull(Me.cboManufacturer.Column(0)) Then
MsgBox ("Please select category")
Else
DoCmd.OpenReport "rptItemCategory", acViewPreview
End If

This works if the combo box IS NULL but if i've made a selection, it still gives me the message box as if I've selected nothing....

View 1 Replies View Related







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