Help Wanted With System Test...
Jun 13, 2007
I'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
View Replies
ADVERTISEMENT
Oct 31, 2013
my 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.
View 14 Replies
View Related
Mar 13, 2014
I have our primary web based inventory system that I am exporting to Excel and using this as an import to Access for the main raw data for my database. This being inventory it changes daily so I am updating this table every day. When I try to append the table it ads all the records. I am wanting an easy way to add only the new records/take out the ones that are no longer there. Basically update the table with what is currently there.The only have I have found to do this is by running non-matching queries and update queries.
View 2 Replies
View Related
Jun 20, 2006
I have an idea for an Access application which is sports related and need a contact for discissing if it is possible and also for help developing the application for a future business. If anyone is interested in helping please leave your email address here.
Look forward to hearing from you.
View 1 Replies
View Related
May 15, 2007
I just wanted to say... what a wonderful resource this forum is, without it and the willingness to help and patience of the members and moderators to help others I would have given up looooong ago on my project. It is however becoming addictive, not a day goes by without my forum "fix" and I don't seem to be able to get to bed before 2am, her who must be obeyed is getting suspicious but I just cant help myself searching for answers and trying to increase my knowledge (limited as it still is) I think I have a problem...A BIG thankyou to everone:D
View 6 Replies
View Related
Jan 25, 2006
Hello fellow users,
Just a quick note, i would like to know if anybody has come across any good internet site for download of icons ideally free ones.
Alastair
View 4 Replies
View Related
Aug 22, 2005
Hi, I've had a db built and my gurus gone missing. Anyone out there willing to help me out on issues I've got.
This is a genuine request
Regards
Saf
View 1 Replies
View Related
Aug 23, 2005
Hi
I run a small domestic house cleaning company in the UK. We are currently franchising our concept throughout the UK. I have a requirement for 2 databases, one for my clients & one for cleaners.
Would anyone be interested in creating something like this for me? One of the most frustrating things about databases on the market is that they do not come with a functionality to key in a letter code so that you can easily send letters/e-mails to the people in the database.
If anyone is interested please email me at csinclair@easynet.co.uk (put Access World in the subject box) I will then supply you with screen shots of the type of database I'm looking for.
Thanks
Chris124
View 1 Replies
View Related
Jun 8, 2004
I only want the record that was just created to be in a report that is e-mailed to my supervisor. Is it possible to do this or will I am I stuck with all of the records in the table? How would I go about fixing this?
Thanks
learnasugo
View 14 Replies
View Related
Jun 9, 2005
Ok I have a function that imports some spreadsheets into our db (it's a timer/scheduler on another db)>
The file coming from oracle discoverer originally. Can't figure out in that 4i version how to remove the headers.
What could I add into my code in the function to import only the data and not the column names/headers? I can provide code if needed?
View 13 Replies
View Related
Sep 3, 2005
I have two tables tbl1 and tbl2
tbl1 has 10 fields named tbl1.id tbl1.field2 tbl1.field3 tbl1.field4
tbl2 has only three fields tbl2.field1 tbl2.field2 tbl2.field3
Now i need to insert values into tbl1::
tbl1.field1 tbl1.field2 tbl1.field3
from
tbl2.field1 tbl2.field2 tbl2.field3
respectively, but i need to make sure if tbl2.field3 value is already there in tbl1.field3 then we don't need import those records. so we only need records if value of tbl2.field3 is not already there in tbl1.field3.
Please let me know What statement do I need to write so i can import all data from tbl2 into tbl1 by comparing as above.
View 2 Replies
View Related
Mar 4, 2013
I am about to set up a database but wanted to check the relationship of the main tables before I add to it. I have attached the relationship design
For a PROJECT, there can be many TESTS, for a TEST, there can be many PRODUCTS
Is my design reasonably sensible?
View 6 Replies
View Related
Jul 26, 2007
Hi 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?
View 2 Replies
View Related
Sep 23, 2005
Hey 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
View 1 Replies
View Related
Jul 17, 2006
I 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
View 1 Replies
View Related
Sep 20, 2007
How 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 Related
Mar 3, 2006
If 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
View 2 Replies
View Related
Apr 26, 2006
I 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
View 3 Replies
View Related
Jun 14, 2006
Hey 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
View 1 Replies
View Related
Mar 2, 2007
I 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!
View 3 Replies
View Related
Dec 27, 2006
Is 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?
View 3 Replies
View Related
Oct 30, 2004
1.) 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
View 5 Replies
View Related
Feb 13, 2008
Hi 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
View 7 Replies
View Related
Oct 18, 2013
I 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
View 6 Replies
View Related
Feb 18, 2006
Can any one do this i need it real fast let me know!!
View 5 Replies
View Related
Apr 19, 2007
I 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 Related