Quick Easy Answer Needed
Sep 28, 2006Text field
"CM#000001"
How do i write a where criteria to exclude all records that start with "CM#"
like "CM#*" does not work
like 'CM#' & "*" does not work
thanks
sportsguy
ADVERTISEMENT
Query Criteria Question, Quick Answer Needed
Aug 23, 2006Thanks for helping me out with this question. Im sure this is pretty easy to do. I have a query with a few paramaters set up... one of them runs a custom function all i want to do is this
query one
Average water flow:Avg([WaterFlow])
when run this just shows me the average water flow for the database... now if i have another criteria i want to base off the average how do i get the query to realize that. for example it would look something like this
[Average water flow]/[currentFlow]
how do i reference another criteria? hopefully this isnt to hard to understand.
Need Quick Answer To Barcode Scanner Question...
Jun 15, 2006Didn't know where to post this one...... But forms seemed logical..... I am doing some experimenting with using a barcodes. I can create them now, no problem. My next step is using a scanner to input to a textbox...... Problem isn't with the forms..... But more with the scanners. I thought if someone has done one of these DB's they might know.
So........ I need a cheap scanner to test with.... Found a few on Ebay. The cheapest being a Symbol- "Hotshot" LS2100-I000.Says it has "DB9" plug. The ebay ad says "comes with NO software". Only thing I am wondering about are drivers. I've read in a couple places claims that this scanner "Needs NO drivers"
So my question is.... Would this scanner work with Access on a Windows XP system? No drivers needed?
Hope this question isn't too "off the subject" But I am dealing with Access and hoping someone has done this.
Thanks
Curtis
Stupid Question Easy Answer?
Dec 2, 2004I saw that nobody read my first post so I figure I'll post my question here. I am trying to learn VB and am curious about how to make command buttons that will do the next/previous thing in VB and not using a macro. Any advice?
View 4 Replies View RelatedQuick And Easy One
Jun 20, 2006HI
I am creating this bloody db and I have created a form and when I open it, it shows, record no one, what I want it to do is open blank ready for a new bit of info to be put in. I know this is an easy one but im sick of the sight of access this week
With thanks
Quick Easy Question
Nov 29, 2004But not easy for me, as its been years since ive done this kinda stuff. I got a field called 'CreditCard#' in a table called Customer. The data type of this field, i've set to 'Number' but how do i format it so it only allows the user to enter in a 16 digit number?
View 2 Replies View Related(Hopefully!) A Very Easy Question To Answer - Running A Query From A Command Button
Dec 27, 2005Hi all
I'm currently working through developing my first database.
Basically, what I would like is for a query to run from a command button.
The query should look at a field in a table (a yes/no field) and report back the ones that have been filled in.
I know how to run the query from the access 'Query' window, BUT, I would like this query to run from a click of a command button on a form.
I've looked it up in a book, which explains about SQL, and didn't really understand it. I've also searched on here, but people talk about Macro's, and I don't know anything about them.
Can anyone help?
Cheers
Quick Easy Question, RE Error With Simple Code
May 24, 2007hiya every1, (access 2k3)
quick easy question, as im a noob when it comes to coding/vb.
Within our company database we have the usual timesheet table. With the table I have create a query (called "dailytimeforkeith") that gives me the sum of time for an individual person for one day (in fact its the previous day). What I have done then is created a form (called "keithyesterdaytime") that shows this query entry (called "sumoftimespent").
Each user has a different database screen logon and forms that are present when they log in. So what I then done is on one of these forms the load up, i attached this:
Private Sub Employee_Enter()
Me.Employee = User.FirstName
If Me.Employee = "Keith" Then
Dim stdocname As String
stdocname = "keithyesterdaytime"
DoCmd.OpenForm stdocname, , , acAdd
............
then on "keithyesterdaytime" opening the following code runs
------------------------------------------------------------
Private Sub Form_Open(Cancel As Integer)
Dim internal1 As Integer
internal1 = Forms!keithyesterdaytime.SumOfTimeSpent
If internal1 < 6 Then
DoCmd.Close
MsgBox " Less than 6 hours have been entered " & Chr(13) & " into your timesheet for yesterday. ", vbCritical, Title1
Else
DoCmd.Close
End If
End Sub
-------------------------------------------------------
Whenever i logon with the user keith, i get the following error 'runtime error 2427: You entered an expression that has no value.
If I open the form "keithyesterdaytime" on its own, the code works and i dont get an error.
What have i done wrong, and be gently. HEHEHE. Also is there any easy way i can do this instead of having to create the the form "keithyesterdaytime"
Access Admin/Contractor Needed, Easy Project.
Jun 27, 2005Hey i need some one that knows Access to help with a work Database, and just make sure everything is working and set properly.
This is for a Construction Managment Company.
Email me at *email removed* for more info, and i can send out the DB to be looked at.
Thanks
Kevin Maguire
President
GOT LOCAL MUSIC
How To: If Answer Is X Then Go To Y, If Not Go To Z
Apr 12, 2005I have a basic Access Form that contains a small number of questions.
Question 4 is a Yes / No combo box
If the user enters Yes, I want the focus to go to Question 5
If the user enters No, I want the focus to jump to Question 4.1
Completing question 4.1 will take the focus to question 5
I'll be hornswaggled if I can figure out how to do this.
I would love someone to help me out!
:confused:
Answer
Oct 31, 2006I have a receipts table with columns- Customer ID, Receipt #, Amount Paid, Date and in another table- customer Id, First name, Last name, Contact # ,Total Cost. How can I get the balance owing by a customer who have made several payments.
No question is stupid
Anyone Answer A Simple Q For Me???
Jan 15, 2006Hi all,
Just put some buttons together, and I notice when I click on them I get a box appear on the button itself. Strangely, some of the boxes are solid likes and some are dashed.
Just wondered what they are, and how to change/get rid of them.
See sample below
Thanks
Col
Answer From 2d Array
Jan 29, 2007Hi, totally new on MS access. Is it possible to solve this following task in Access. (using it in Excel today)
Ex.
2d table?
Prod 1 Prod 2 Prod 3
Prod 1 0 10 20
Prod 2 10 0 30
Prod 3 20 30 0
Question 1: What did you just create?
Answer: Prod 1
Question 2: What will you create?
Answer: Prod 3
Then Access will show 30.
Probably explaning it bad but hope you understand and can answer me if this is possible to solve in Access....
The mission is to create a database with setup times between diffrent products, and make it possible to ask a question to get the answer.
/Martin
Top 10 Ways To Not Get An Answer
Feb 3, 2007I've been here for two months and answered over 400 questions. I'm seeing a pattern here, and I have decided to post the best ways to make sure you are never answered.10) Blood, sweat, and tears are for losers. Spend no time figuring things out on your own.9) Announce almost ceremoniously that you have no VBA experience.8) Fail to use the search functions of this forum.7) Try to put every example you're given into a macro.6) Believe that this is the only source for answers, because Access Help provides nothing. Nothing, I tell you!5) Have us write your homework for you and then complain when you don't understand it.4) Post in German.3) Have a belief that your particular problem is the most important issue ever, and post in every sub-forum possible. Then bump it.2) Be vague, and then be belligerent.1) Have no appreciation for the people that are answering your questions in the first place. I know this sounds cold and mean and otherwise uncaring, but we are here to answer questions, not give you fish, as it were. This is a place to say, "I've done most of the work, but I need help over this hump," not "I have this crazy project/idea and I want you to write it for me." I've written over a dozen example DBs for people, and I know that I know what I'm doing. But, myself along with perhaps the majority of others that answer the majority of the questions, I'm asking on their behalf to please take the time to figure some of this out. If you can't do VBA, you are using 25% maybe of Access. If you can't understand your own DB, then asking us to fix it is a solution, but not a learning opportunity for you. If you can't understand what I'm getting at, it's that so many posts are the same. Again, I'm not trying to be an ass, but if you want to be a decent Access programmer and a programmer in general, then please, take the time to learn it. There are plenty of books (look at the bottom of this forum) and there are plenty of resources. I don't think any of us are teachers by trade, but the best teacher for something like programming is always trial and error. Programming is a language, a passion, a "something you figure out" if you will. If you're spoon-fed the entire time, you don't learn. I will continue to answer as I always do and I apologize if anyone was offended, but jeez, make sure you've tried everything offline before asking for help. And don't forget to search first, both here and Google.Sorry for the long read. :)
View 14 Replies View RelatedCan't Find The Answer - Can Anybody Help !!
Nov 12, 2007Hi Guys
I currently have a database and the powers at be want me to enable a button that will count how many times in the database a particular month is used. So for example how many times did we visit a particular place in September/october etc.
Is there a way of doing this that i can't see, I have tried searching the forum but to no avail.
my thanks in advance
Anthony
MTD, YTD, WTD (one Answer For Total)
Oct 13, 2005Please Help. I am tring to get the Month to date, year to date and week to date total in a query. I added a parameter for a date range. Instead of giving me the mtd, wtd, ytd, I get the whole months daily total. Can someone tell me what query caculation do I need to just get one number instead of daily numbers?
View 2 Replies View RelatedPlease Answer Need Help Desperately
Apr 19, 2006I have created a basic database but now need it to perform some difficult tasks (Well difficult to me) an havent a clue how to do this.
I need to be able to search the database for a vehicle type for a specific dat to see whether it is available or not?
and i need to be able to produc a list of vehicle & drivers that are not booked by entering a date?
Has anybody got any ideas on how to do this because its racking my brains
Thanks
Why So Many Repeats Of The Same Answer
Aug 30, 2004Why so many repeats of the same answer
Thank you MWalt for your reply about finding the stock in hand. It works, sort of. It gives the answer but I end up with each item being repeated about 141 times. So instead of ending up with a list of about 140 items, I have a list of 20000+ because each item is repeated. I'll include the code of the first query that you suggested called qryNotItem...where do I go from here.
This part works, but when I do the second part I run into an error.
SELECT [Equipment Inventory].EquipmentID, [Equipment Inventory].[OT Equipment type], [Loan details].LoanOccID, [Loan details].[Return date]
FROM [Equipment Inventory] INNER JOIN [Loan details] ON [Equipment Inventory].EquipmentID = [Loan details].EquipmentID
WHERE ((([Loan details].[Return date]) Is Null));
Thanks
Please Help Me Answer This Question -
Aug 20, 2004Hello, I am new here. I am practicing with a Certiport CD
to take a MOS exam and I am having a hard time with one
question on the practice test. The question seems to be asking
me to match output items to input items. There are four items
listed in middle column - they are: datatable, mailing list, report,
and form. I am supposed to (I think), move items from the list
that I think are "input" items in a left-sided column labeled
input, and put the items that I think match the items in the
input column, in a right sided column labeled "output". The middle
column would be left empty and the side columns should have
items that match. For instance, I have been putting "form" in the
input column, and to match it, I put mailing list in the output
column (you can get mailing lists from forms right??) No matter what
I do, it says the answer is wrong. Am I doing something wrong? I
tried all the combinations I can think of and nothing works. I called
the company that made the CD and they said they could not help me.
Could I be matching up the four items incorrectly. Could the question
be worded improperly? Anyone who can help me, please do. Help! thank you.
Help's Answer Wizard And Index Gone!
Jan 4, 2007Hi,
I don't know why, but my Microsoft Access 2000 Help's Answer Wizard and Index Tabs are completely empty! These pages are completely blank, with no dialog boxes or anything. How can I fix this?
Thanks,
Jean-Guy
Urgent Answer Welcomed!
Feb 16, 2007Hello,
I have a question. Is that possible to find a number of days between two dates BUT if those two days are from different record? (if we assume that dates are in ascending order) (uk date format)
For example:
StartDateEndDate
Record 1 01/02/0728/02/07
Record 218/03/0725/03/07
And now find number of days between EndDate from Record 1 and StartDate from Record 2??
Any ideas??
Thanks!
Having Access Solve For The Best Answer, Is It Possible
Aug 23, 2007I am fairly new to access and am curious if this is possible. I have a x number of procedures, I will use 4 as an example, with those 4 procedures I have a reference table that has certain devices for those 4 procedures that need to be compared against the device charges. ie
Procedure
1A
2B
3C
4D
Procedure Device Reference
1A has AAA,BBB,CCC,DDD
2B has AAA,EEE,FFF,GGG
3C has AAA,HHH,III,JJJ
4D has FFF,KKK,LLL,MMM
Device Charges has
AAA,III.LLL.ZZZ
Is there maybe a case statement that I can use to have access try to solve for the best combination of the devices with the procedure to give me the most matches possible and not match say AAA with 3C and LLL with 4D giving 2 out of 4 matches, instead of the result AAA with 1A,III with 3C, and LLL with 4D, and flagging ZZZ as not a match or it matches 3 out of 4
Im not sure if this is the best place for this but any help is greatly appreciated and if more information is needed please let me know thank you for your time in advance
A Simple Question (if You Know The Answer)
Oct 14, 2005:confused: Hi, I'm pretty new to this VBA stuff and do not know the correct foramt to access a table.
I have a form based on table1 which has a large number of records each with a unique primary key.
Very occasionally I want to add a new record and want to create a primary key within a specific range.
I don't want to use autonumber, so I have a single control record in a table (tblParams) with the LastRecordNo stored in it.
I want to programatically access this record along the lines of:
Private Sub Form_Current()
Dim NewID as Integer
If isnull(me.ID) then
NewID = tblparams.LastRecordNo.Value
me.ID = NewID + 1
tblparams.LastRecordNo.value = me.ID
End If
End Sub
Obviously this does not work, what should be the correct context please.
Question And Answer Database
Jul 27, 2007Hi
I am trying to create a question and answer database that will hold agent scores for future reference.
My idea is that I will have the following tables:
•Team
•Marker
•Agent
•Scorecard
•Question & Score
I want to have a Scorecard form which the marker completes based on the agents performance. The key requirement of this database ability to change the questions periodically and if necessary amend the score applicable to each question. This is why I think it’s best to have a Question and Score table so the questions can be updated and the changes will be reflected on any new scorecards that are created.
I have created the database structure which I think is correct and normalised to the best of my ability. The scorecard table grabs questions and applicable scores from the Question & Score table the marker completes the answer field based on the agent’s performance. So, on each Scorecard that is created the current questions and scores are displayed.
So here’s my question: Should the Scorecard table hold questions and scores, or should it just hold answers? I am thinking questions and scores. I know this is against the rules of normalisation as this data is already held in the Question & Score table however what if I change my questions then want to look at a historical scorecard (completed when the question were different). The questions and scores will have updated to the current set making that scorecard inaccurate.
Thanks
Such A Simple Answer! I Wish I Knew It
Apr 20, 2005I have a form that requires date, picker id, no of pallets, and a unique identifier (which is date + no of pallets). On my form, there is an unbound text box (displaydate) that takes the date field and converts it into a number, format([date], "mmddyy") so that 04/15/05 looks like 041505. And lets say the no of pallets would be 1961.
In the unique identifier field, my code is:
me.identifier.value = str(me.displaydate.value & me.nopallets.value) which should give me 0415051961. First problem is it doesnt put in the first 0 in the date, it puts 415051961. And I also wanted it to put in an - between display date and no of pallets to look like 041505-1961.
I tried the code several different ways such as str(me.displaydate.value & "-" & me.nopallets.value) which gave me an error.
So could you give me some suggestions? Thanks Noreene
2 Subforms.. One Command... One Answer?
Aug 30, 2005Hiya,
I have a form that uses two subforms. The first subform allows users to enter timecard details and the other subform shows all the hours worked. I have a refresh button on the form so that when users click the button the timecard details from subform one are automatically shown on subform two and the user can then enter more details. However i want my refresh button to only work if a user has enter details in the first subform otherwise i get a load of blank entries in my second subform. Let's say that if hours dont equal zero then the form will refresh else nothing happens. I would be able to do this normally its just that the hours field is in the subform.
Please help.
Andy