#Error And Logical Test
Dec 27, 2006Is there a way of doing a logical test to see if a filed has a "#Error" instead of a value?
If so what is the expression and syntax?
ADVERTISEMENT
Modules & VBA :: Test String Test Based On Table Data
Oct 31, 2013my issue is i have multilble text box in my form & based on change in one of this text box i need the code to compare between data in the form & table & returm Msg if it is not matching. attached screen FYI.
i look in the internet but i could not figuer out the VBA code since i do not know VBA. what comes to my mind to to use select case.
Two Logical Problems?
Aug 26, 2007Hi,
I’m using MS Access 2000 – I’ve been building, using and updating an Access database for a while now, and I’ve been living with two problems that are causing problems to its use.
The first problem appears minor, but relates to the second problem….
I keep the database in my shared documents folder on my PC, so a colleague and I can both use it at the same time.
When we have the same form open – if I click on the “save” icon it comes up with an error “you do not have exclusive access to the database at this time” and the recordset that I am working on cannot be saved. This is causing problems because if I enter fresh data into the form, and then click a command button to run a query against it, it comes back with blank results because it has not been saved to the table yet – so I have to exit out of the form so it saves the data, then go back into the form so the query runs properly.
Are there any settings I can apply so I can save the data to the table without having to exit and re-enter the form again?
The second problem is more difficult and has had me tearing my hair out for a very very very long time – if anyone could help me with this problem I would be indebted to them…
After I’ve entered all the data into my form, I need to export/transfer 4 of the fields to a .csv file.
I would have thought that the logical thing to do would be to have a command button that performs a macro, which it turn;
Saves the data to the table
runs a query which selects the 4 fields I require
then exports the Query’s results to the csv file.
When I’ve tried this, obviously the problem of saving the data remains, but even when I exit out of the form and re-enter so the data has been saved to the table – I can’t get the export to work!
I’ve tried exporting the query manually from the query view, however it comes up with an error stating that “TOO FEW PARAMETERS. EXPECTED 1”
I’ve tried Macros that “Outputs to” and “Transfer Text” – however I can’t get any of them to work. I managed to export a table and save the export procedure, then tried to use this procedure when exporting a query, but again I couldn’t get this to work. I’ve also tried adapting VB codes that have been posted on this forum before, however as I’m not too hot on coding I’m not sure whether I’ve been making mistakes or if there is something wrong with the architecture of my database that is preventing the export from working.
Would anyone be able to take a look at the database for me please? I’ve uploaded it here – http://www.qualitytoolsltd.co.uk/accessdatabase.zip - I’ve deleted everything except for the tables, queries and forms that rely on the export query.
It contains a table (“Orders”) that stores the form’s data, a query (“QuotefromorderstblQuery”) that filters our “Quotes” from our “Orders” (I keep “Quotes” and actual “Orders” in the same table but have a [Quote/Order] field that distinguishes them apart), and a form (“QuoteEntryForm”) that is linked to the query to show our Quotes.
Also included is the query (“exporttocsvquery”) that I am trying to export to a csv file. On the form there is a command button called “Run CSV Query” that runs the query – but I’ve deleted all the various buttons and code that I’ve tried to get it to export to avoid confusion.
Also on the form is a button called “Process Order” – this can be ignored as clicking this just changes the [Quote/Order] status to “Order” and the recordset won’t show on this form anymore.
If anyone could please try and help me understand how to overcome these problems – I would be extremely greatful!
The four fields that I am trying to export are;
[Customer Name],[Customer Address],[Customer Postcode] & [Total Selling Price inc VAT] – I have highlighted them with red text on the form
If I can solve the first problem of saving, what I am trying to achieve is the creation of a Macro, which is programmed to:
1.Saves the data to the “Orders” table
2.Runs the “Exporttocsvquery” using the Order ID as the select criteria , so it shows the current records being displayed on the form as the query’s results.
3.Exports the Query results to a .csv file on my hard drive.
4.Launch a custom application that I’ve programmed to run using the data in the .csv file.
Thank you very much for taking the time to read this marathon post. Any help, advice, guidance, anything at all would be appreciated very much indeed.
Thank you again.
Dean Rowe.
deanrowe [at] qualitytoolsltd.co.uk
Unsure Of Logical Operators
Dec 6, 2006Hey
Can someone answer me if Like "Red" and Like "Blue" Or Like "Red" is a logical operator?
Thanks for the help
Logical Diagram - Plsssss Helpppppp
Jun 4, 2006hi everyone, this is first post, i have this task and i think i have the solution but im not sure, so plsplsplspsssssssss someone help!!!!
its called class scheduling. below is the physical model. i need to make the logical, i have been told that course and section share a many to many relation as well as section and faculty and also bwee/ faculty and course, thus the creation of the intersection tbl, the OFFERINGS TABLE. i have inserted the foreign keys (FK's) into that table (which are the primary keys for the 3 main tables). what i need to know is that:
1. do i need anymore FK's?
2. wen i make my logical diagram, do i show it like the way i have shown it in the word file? i made it as such that course and section have the PK of the 2 tables and are now FK which allow duplication ie 1 course can have many sections etcc pls helpppppppppppp
Courses table
CourseID (PK)
Title
Credits
Sections table
SectionsID (PK)
Days
Time
Faculty table
FacultyID (PK)
Firstname
Lastname
department
Title
FullTime or partime
hiredate
Offerings table (intersection table)
OfferingID (PK)
CourseID (FK)
SectionID (FK)
FacultyID (FK)
Building
Room
Continuous Forms & Logical Tests
Oct 5, 2005I have a continuous form, that displays in the body the results of a number of selections from a previous form.
In the header I have a message that I want to either shown or hide depending on the result of the following code in the "On Current” event;
Private Sub Form_Current()
If Text29.Value = 0 Then
Label32.Visible = False
End If
End Sub
The default form Label32 is for it to be visible. Text29 is unbound and derives it's value from "=Min([WareHouseID])-Max([warehouseid])" no problem there.
The problem is that test does not perform as I expect it to. I have tried all sort of combinations and permutations but can not get it to respond correctly. It seems to think that Text29.Value is equal to zero regardless of the result it is showing
I'm guessing that there is something about continuous forms I have not yet learned :(
Test For New Employees
Jul 26, 2007Hi Folks!
I've been asked to make a 5 questions test to evaluation potential new employees' knowledge of MS-Access. Honestly, I need your input on what to ask. The goal is not to make a very hard test, but rather to see if somebody as at least basic knowledge of SQL and Ms-Access.
Some background information of what we do with MS-Access
We use MS-Access as a central hub for different download from different systems. We make a lot of daily imports. We export queries in Ms-Excel. We open it from Access and format the report. We make hundreds of reports every day. We don't really use forms or reports.
What questions to ask?
I was thinking of having 2 questions about SQL. One simple query with a formula, and a query with 2 tables (perhaps a left join). On what should my other questions be?
Test / Servey
Sep 23, 2005Hey all, I'm trying to design a Test / Survey database.
I have posted regarding this problem before if it looks familiar to you.
Please look at the .jpg attached
I have looked at some previous survey/tests design posted on this forum and had a good table design based off of a Pat Hartman suggestion. Now i am wanting more out of the database and need more advanced options.
The main problem is how to tell which answer/OptionDetail is the correct answer for both Surveys and Tests. Maybe it would be better to separate the two? All suggestions welcomed.
Case Survey
Here is what i am trying to do. When a user decides to make a new question for a survey they will have to choose what type of question the question will be. For example say the user wants to make a survey with a answer grid question. They would choose Answer Grid from the tquestionstypeMaster combobox. Then they would have the option of choosing a type of answer grid (Satisfy3) from the tQuestionTypeOptionsMaster combo box. Say the user chose Satisfy3 then they would be presented with a list of all possible answers that the test taker would see for the Satisfy3 choice ( Very Satisfied, Somewhat Satisfied, Not Satisfied).
This is what i want as far as the survey section goes.
Case Test
A user decides to make a new question for a test they will have to choose what type of question the question will be. For example say the user wants to make a test with a Multiple Choice question. They would choose Multiple Choice from the tquestionstypeMaster combobox. Then they would have the option of choosing a type of answer grid (Single Answer, Multiple Answer) from the tQuestionTypeOptionsMaster combo box. Now comes the part where im stuck. I have to somehow get the Multiple choice selections that the test maker is entering into the tAnswers table and figure out how to tell the program to look at tAnswers insted of tQuestionTypeOptionsMasterDetails when the test taker opens up the form. I also need to figure out how to tell which multiple choice selection is the correct answer.
I hope this makes sense to everyone.
Thanks Hooks
IF Statement With More Than One Test
Jul 17, 2006I need to evaluate a string, if the string is ?-* or ???-*, then I return the string, if not I use the Left function.
I would like to do this with IIF statement in my query, or a VBA function that I could place is my query.
This is what I have so far:
VBA:
Function change()
Dim str_sku As String
If str_sku = "???-*" Then
str_sku = str_sku
Else
str_sku = Left("str_sku", 5)
End If
End Function
I get a type mismatch error. I tested on change(Function change(983-00245)
In the IIF statement, I am not able to figure out the Or part.
SKU: IIf([ITEM] Like "???-*",[ITEM],Left([ITEM],5))
Missing the "1-*" part.
Any help would be appreciated.
Thanks
Password Test Box
Sep 20, 2007How does one change the characters shown on a text box to *. For example if i enter 12345, it displays ***** in the textbox.
View 3 Replies View RelatedTest For The Existence Of A File
Mar 3, 2006If i hold a record in a table with the path and file name held in one field, is it possible to code Access 2000 to check that this file exists? I want the database to perform a certain action should it not be found.
Any help most appreciated.
Many thanks
A Level Database Test Please
Apr 26, 2006I have offered to help a local school ICT Dept with their A level projects. the first database they send me and I can't get further than the sub menus.
I would appreciate any assistance as I don't know wether it is something I am doing wrong or something within the structure. I've opened it using the Shift key to look at the code and can't see anything wrong. Any help will be very much appreciated. Regards. Bernard
Database Test... Feedback?
Jun 14, 2006Hey all,
So I'm pretty much done with this database project, but I've got a few minor snags... 3 actually.
1) get error when use delete button and select any option other than "yes"
2) my listbox selection does not load the record in the main subform area as it is supposed to (but I think I just don't know how to set this one up)
3) the frmAdd does not allow user to enter values into the fields for some reason, don't know what's up with that one
If anyone could take a peak, check it out, let me know if there is anything I need to fix, or more importantly, how to get those above things sorted out. It would be greatly appreciated. thanks in advance
Age At Time Of Test Date
Mar 2, 2007I am trying to create a field that will calculate a persons age at the time of a test date. I have the DOB field that gives for example :
3/10/1993
Then I have a field that turns this into the Age in Year and months
14 yrs 0 mos
I have a TEST Date field that tells me when they took the test:
10/1/2001
Now I need a field that will calculate how old they were at the time they took the test. I tried using this formula:
AgeAtTest([DOB], [TestDate])
but then in my field I am getting this : #Name?
It should calculate them to be: 6 yrs old at the time of the test. How can I make this happen?
Thanks!
Help Wanted With System Test...
Jun 13, 2007I'm not looking to spam anyone or sell their data but need help to test a simple market research system that i have built. I'm looking for about 25-50 people to let me send them an email inviting them to a webform to see if the "process" works correctly from start to finish.
The form asks for limited data about people but nothing that can identify them personally. Just gender, age group and postcode prefix.
Can anyone who is OK with sending me their email address to enable me to test this please send to:
mailconnection@dsl.pipex.com
Your help is greatly appreciated.
Thanks
Vince
Test! I Dont Have Access And Need Help Bad Plz.
Oct 30, 20041.) What is the File Extension associated with Microsoft Access database files?.........MAF or MAD
2.) A Field Name may contain a maximum of ________ characters.
3.) A ____________________ determines the kind of values that users can store in a field.
4.) A Field Description is required for all data fields......T/F
5.) Use of Field Descriptions dramatically increases the size of the database and, in general, should be avoided.....T/F
6.) FirstName, PhoneNumber, and ZipCode are fields which typically include an Input Mask.......T/F
7.) A Field Name is required, but a Field Caption is optional.....T/F
8.) A 5 digit Zip Code should use this Data Type......
9.) An INDEX speeds up updates, but may slow searches and sorting on a field.......T/F
10.) A Default Value is a value that is automatically entered in a field for new records......T/F
Test Score Ranges
Feb 13, 2008Hi all
I have a bunch of student test scores. The test is scored out of 100. I want to COUNT the scores (ie I want to know how many kids scored 50 etc...). This is easy enough except the crosstab query will be very wide ie 100 columns.
I cant seem to reduce the size by grouping them into ranges (ie count the number of kids that scored between 50 and 60 in a cross tab. I've tried variations with select queries but without luck.
Maybe there is a way to code it.. and then show it on a report??
Any ideas?? Thanks
How To Test If Delete Successful
Oct 18, 2013I have some code to delete a record from a table, which does not delete the record, presumably because of referential integrity settings. That is fine of course, that's what should happen. However I want to be able to notify the user if a delete did not succeed. How can I check this? I tried this code, but it did not return an error.
Code:
strsql = "DELETE * FROM " & tblAddress & " WHERE GenAddressID = " & Me.tb_edtID
Err.Clear
CurrentDb.Execute (strsql)
If Err.Number <> 0 Then
MsgBox (Err.Description)
End If
Test: Multiple Choice Template
Feb 18, 2006Can any one do this i need it real fast let me know!!
View 5 Replies View RelatedTest Incoming Files For Bytes
Apr 19, 2007I need to add some code to our access 2002 database to test incoming files for bytes, zero byte files in particular. Our system will then pick out the zero byte files for emailing to our customers. Can someone provide code for testing for bytes or provide me some direction on this matter? Thank you!
View 7 Replies View RelatedTest / Survey Table Design
Aug 25, 2005Hey all, I'm trying to design a Test / Survey database.
Please look at the .jpg attached or download the sample database.
I have looked at some previous survey/tests design posted on this forum and had a good table design based off of a Pat Hartman suggestion. Now i am wanting more out of the database and need more advanced options.
Here is what i am trying to do. When a user decides to make a new question for a test/survey they will have to choose what type of question the question will be. For example say the user wants to make a answer grid question. They would choose Answer Grid from the tblquestionstypes combobox. Then they would have the option of choosing a type of answer grid (Dual Scale, Rating Choice, Ranking Choice) from the tblQuestionOptionTypes combo box. Say the user chose Ranking Choice then they would be presented with a list of options for the Ranking Choice. For example 5 sets of rankings, 4 sets of rankings. 3 sets of rankings. (These are just coming off of the top of my head but i think you know what i mean.)
Question, Is this close to being correct. mind you i have just started this and am just throwing ideas around.
Where could i store the correct answer for each question. Sometimes there will be a answer and sometimes there will not be an answer due to the fact that it could be a test or a survey.
Any help or suggestions would be appreciated. Thanks
Forms :: Test For Null Date?
Feb 18, 2015A form with a text box expecting a date has the validation property as, >#1/1/2010# And Is Not Null. If a date is entered older that this the error is caught however if the field is left null it is not caught as an error. I have tried several modifications of this statement with the same results.
View 3 Replies View RelatedCopying Changes From Test Environment Into Live
Jul 2, 2015 I've gotten to a point with my database where I have split it into front and back ends, and then made a copy so that I have a test version and a live version. I have users in live who've started keying data, and I'm working on forms and tables in test that I then copy to live as they are completed. Up to now, I've been just copying the individual item in test, and then pasting it over the version that exists in live (example: I made some changes to a form in test, copied that form, and then pasted over the version of the form that was in live).
Where it gets tricky is that I am also in the process of designing and insurance underwriting feature that's going to be a part of this application. I've set up all the tables in test, and now that I'm working on setting up the relationships, I'm wondering how I'm supposed to copy the relationship setup into live. Am I supposed to be copying the entire front-end from test when I have changes, and replacing the existing "live" front end with it? And if I do that, will I have to edit it every time to keep the new live front end from sending data keyed into it to my test version (had that happen when I initially split it)?
Creating Database For Test Scores
Jun 16, 2015I am looking to create a database that collects data from past tests, predict probable future score, and compare to goal score. Currently I am studying for the Bar Exam and want to track (in all 7 subjects):
-my current scores for practice exams
-prediction of what my score will be on exam day
-comparison of actual and goal score
-comparison of predictive and goal score
-all of the above, separated by different types of Tests for each subject
Below is an example of the type of data :
Ex: Civil Procedure--06/15/15-Kaplan questions-> 6/10 (60% practice score)-> (predict gain 1 point 70%)-> (actual exam goal 20/28=71%)
Civil Procedure --06/15/15--past MBE questions->7/10 (70% practice score)->(predict gain 1 point 80%)-> (actual exam goal 20/28=71%)
Also from this data I want to generate graphs
Would this be possible in Access? Should I use excel instead?
Syntax For Empty Query Recordset Test
Sep 6, 2006Can someone tell me the VBA code for testing whether a query recordset is empty or not?
View 1 Replies View RelatedGeneral :: Creation Of Test Environment Locked
Jun 20, 2013I have attempted to create a test environment, by creating a blank database in SQL and restoring a backup of the live environment over the blank database (now called test db). I then took a copy of the Access MDB file,and renamed this to testMDB. I then created a new ODBC link to the test db and refreshed the links to the tables by the importing the tables.
Majority of the system works, but I have noticed that after doing this, the forms that access some tables appear to be 'locked', in that no additional data can be added. The page effectively looks greyed out. If data already exists on this tab, then it can be viewed, but cannot be edited. In the live environment, the form shows an additional line is so that more data can be entered if required and any existing data can be amended.
I have attached two screen shots showing the difference.