I am using Access 97 and I have the Table and text box formats set to fixed and decimal place is 1. Access appears to be rounding.
Is this normal or id there something I can change?
Thanks for your help.
I am trying to create a query to find missing sequential numbers in a text field. I am using this specific field as a case number which is designated as two letters, the # sign, two digits indicating the year, a dash, and then a four digit number; For Example: AB#13-1234.
The reason for this query is to tell the user of this database that a specific case number has yet to be entered and needs to be. The case numbers are unique and will never be referenced more than once.
My table name is "MainDataTbl" and the field i'm trying to find the missing case numbers is titled "CaseNumber".
I created a time clock module where you input the time in and time out and it takes the difference of the two to give total time worked. However the boss wants the time worked represented in hours and tenths of hours not minutes. How can I take the time, seperate the hours...find out how many tenths of an hour worked and then add the hours and tenths together.
View 2 Replies View RelatedI am trying to get a form to display certain information based on the data in another box. I have to input some exam results and want to assign a level to them. So, if they score < 13, the result would read "Below Entry 3" if between 13 and 21 "Entry 3" etc If this was a spreadsheet I would use an if function, but I am not sure that I can do this here
View 14 Replies View RelatedA newbie problem: Trying too display a linked picture using Win 8.1, get error picture too large. OK in Win 7.
Am using Access 2002 (10.6501.6567) SP3. The instruction flagged is:
Me![ImageFrame].Picture = Me![ImagePath]
I have a payroll database and my report that lists vacation time is not displaying correctly (for one person only). Every entry into my payroll tables are in this format: ##.## (24hr) I've double checked all entries that they are entered in this fashon, and found nothing out of the ordinary.
So when I run my report's query I grab VACATION_EARNED from my EMPLOYEE table; subtract VACATION_USED (as a sum from my PAYROLL table) and subtract VACATION_SCHED (as a sum from my FORCAST table) to get VACATION_REMAINING.
if I look at this in a query instead of a report; my results are exactly what I would expect to see. I.E. JohnDoe, 40, 32, 8, 0 Yet when I view the data in the report, instead of the 0 showing for VACATION_REMAINING I get -2E-15
Now I recognize this as a scientific notation, but why?!?! I've set the report field's properties and backtracked all my number fields to be sure all of them are set to the same properties
Hi,
I am trying to display the records (counts) on my Invoice form.
I tried to put one text box and typed as follows:
=Count-[n]
This kind of text box we normaly use to count records on Reports and it counts well. But this did not support me on form.
I need, it should display records from 1,2,3 and so on upto the last record entered for that invoice.. Each new invoice should start from 1 to the last record number.
Any idea ?
With kind regards,
Ashfaque
I have a main form and a subform. The main form displays the information as combo box = column.2 (in other words it shows the actual word not recorded y/n checkbox = obviously shows which is checked
However the subform shows
combobox = 1 or 2 etc the recordid
y/n check box 1 for yes 2 for no
How do I get the subform to display the words instead of numbers? (can live with the Y/N)
have basically the same issue with a split form (combo only) shows words and datasheet view shows corresponding record id number
tried using =[coffeetype].[column.2] on both the subform and split form datasheet but doesn't work.
- I have a table "Quotes" with fields "UserID" and "Quotenumber"
- I have a form "Make quote" with a textfield "txtQuotenumber" and "txtUserID"
With the following code "txtQuotenumber" gets the highest quotenumber for the current "txtUserID" from the "Quotes" table:
Code:
=DMax("[Offertenummer]";"[Offertes]";"[Offertes].[Gebruikers-ID]=" & Formulieren![Offerte formulier]!txtGebruikersID)+1
It displays quotenumber 1 as "1" but what I actually want is it to be displayed as "0001". Quote 211 will then be displayed as "0211". I tried this by entering "0000;;_" into the property "input mask" of "txtQuotenumber" but that results in "1".
I am trying to display a total based on 3 separate combo boxes in a form. there is a name with an associated number value using 2 fields. the values come from a linked value spreadsheet. the name field is "text" and the number is "number". the user selects their name and number using a combo box drop down window. this occurs 3 times in my form and i want to sum them in a 4th combo box. this is about how it should look, where "Total" happens automatically depending on the name selected.
Lewis 3 Smith 2 Parks 2 Total= 7
thanks for helping.
dave
I have a question regarding the display of a list of numbers that are stored into a field of my database. Currently the numbers are comma-delineated which is fine with me, but I was wondering if there is a way to change the display of those numbers on the form so that it is easier to read.
Example:
current format - 1,2,3,4,7,8,9,10
desired format - 1-4, 7-10
I'm having multiple problems with my database like things such as -
i'm currently working on the Query 2 - On the Phone database (ignore Query 1) and i want to search for multiple plot numbers preferably in one parameter prompt with a comma to seperate numbers. (this could be a multitude of numbers so i would like to be able to input as many as needed). Also when i do search on this query since the Criteria is a 'Between' Value i would expect everything between the 2 numbers input to show up - but a lot of numbers out of the range show up too - why is this? (The Numbers are like "69 to 136" and they will show up - but 1-69 and 136-170 would too
I would also like to implement the search results from Query 2 into the Form i currently have made but it just opens up a access table when the search is made?
i cannot link my database as it is too big for the server - But here are the Criteria for Query 2:
Plot No - (criteria = Between [Enter First Plot No:] And [Enter Last Plot No:])
Site - (criteria = Like "*" & [Enter Site:] & "*")
Product - (criteria = Like "*" & [Enter Product:] & "*"
The Query is the one im most concerned about , i can live without a form.
Ok so in excel I have some numbers that are stored as text. The reason being that they are zip codes and some begin with 0 and excel doesn't want numbers to start with 0....so when I import these into an access field that has an input mask for zip codes...will it convert these correctly since the field is a text with input mask?
View 1 Replies View RelatedI have 2 fields that I would like to automate if possible
One field is called "p/o number" and another field called "line no"
These fields are part of an ordering database
Let say I have 200 items to purchase form 10 suppliers
And form example 20 items from each supplier
What I do at present is put the order number on each line item and the line number
example
p/o number line no
1 1
1 2
1 3
2 1
2 2
2 3
2 4
What I want to do is just put the first po number in the required line . Put the first line number in i.e. "1" and the macro will complete all the p/o numbers and line numbers for me as per the ones marked in red.
Example
1 1
2 2
3 3
2 1
2 2
2 3
I have a table with fields like this one but the weeks go all the way up to 52. What I am trying to do is count the number of consecutive zeros and if it is more than five, count how many of the following fields have a number in them and if that number is less than the number of zeros preceding it identify that person.
For example Joe would be identified below because he had 6 consecutive zeros and then he had 5 weeks of numbers immediately following the string of zeros. Bob would not be identified because he had 5 consecutive zeros and then 5 sets of numbers immediately following the string of zeros so the zero frequency isnt higher than the number frequency immediately following.
ID
Name
Date of Hire
1
2
3
4
5
[code]...
I have created access2K application with 4 clients (forms+query+macro+reports) residing on workstations and database on server. I have created MDE of 3 frontends but unable to do so on one computer. When I goto Tools->Database Utilities->Make MDE File... (Disabled)
Its disabled I cannot continue so no error message. Any idea?
Prodigy
I am unable to upload a zipped copy of my database. I just get this message:
--------------------------------------------------------------------------
Invalid Post specified. If you followed a valid link, please notify the administrator
The file is 134k...
Contacted admin as suggested
-------------------------------------------------------------------------
Anyone?
Thanks,
Dave
Hiya
I have created a query (Weekend) from 2 other querys (BCV & Daily Sales). The BCV & Daily Sales queries work fine but when they are added together I am unable to add new records. I only have 1 line of data that can not be updated.
I thought it was a relationship problem and have been and double checked all the relationships but can't see an error.
Heres a screen shot if it will help!
Thanks in advance
http://img364.imageshack.us/img364/2458/clipboard022zc.jpg
Hello everyone,
Can anyone help?
I have a data entry form via which I want to add records to a table. However, when I've entered data in the last field, the cursor remains there and the system just beeps. I added a command button on the form to go to a new record but when I click on the button i get the following message:-
You can't go to the specified record
You may be at the end of a recordset
Any suggestions??
Thanks
Will
I have main form("client Status") which contains information about client order and showing the calculations. The subform is also there for receiving the payment from client. I would like to get the sum of amount received(from sub from) and would like to show it on main form that how much amount received from a client. As payment received from client the form should be updated automatically by showing the sum of amount received.
how to take sum of particular field in subform using vba and storing it in main form field.the forms are created from tables and there is no unbound field.
Created three tables and one linking table, created two queries linked to a form to display the results and have now setup the code to display details. Next step to create a form to add a new record to the database.
Initially I used the form wizard, dragged the fields in and then viewed the form to see if I could add a record.However the new record button at the bottom is greyed out.I checked the Form properties and allow editions, deletions and edits are all set to yes.the source for the form is:
Code:
SELECT [tblGraves].[Plot], [tblGraves].[GraveNo], [tblGraves].[GraveID], [tblDeceased].[Forenames],
[tblDeceased].[Surname], [tblDeceased].[DayOfDeath], [tblDeceased].[MonthOfDeath],
[tblDeceased].[YearOfDeath], [tblDeceased].[DayOfBurial], [tblDeceased].[MonthOfBurial],
[tblDeceased].[YearOfBurial], [tblDeceased].[Age], [tblDeceased].[pp], [tblDeceased].[Notes],
[Code] .....
and it is a dynaset record set type.So I thought ( dangerous I know) use a query, I created the query setup the joins etc etc.I double clicked on the query and all my records were listed, I then selected the new record and the bottom but that is greyed out as well.
The Word attachment describes recent problems I have encountered, most significantly, the inability to save changes on certain forms. the questions, listed at the end of the document, are:
a) How can I identify which objects are corrupt other than assuming it is only those that wont save changes?
b) What is the best way to overcome the inability to make form changes on certain forms and reports?
c) How or can I continue to use the Students Extended query with different criteria for different forms, other queries or reports. Can I create (advanced) filter queries and use as a record source for each as needed?
d) Do the messages about the PC making changes or placing the database in states have any bearing and why is that happening?
e) What causes and how can I prevent messages that fields could refer to more than table (see 2, D, vi)?
Unable to create MDE file WHY?????????????????????
View 3 Replies View RelatedNot sure if someone has come accross this probelm but I am unable to link/import tables from excel or text files.
I am able to import tables from other databases but as soon as I want to import an excel file it seems that the import wizard simply doesn't exist.
re-installed office several times but to no avail.
Access/office 2003 running on windows 2000 sp 4
Microsoft help is no of use.
I am also running 97 on my pc and have no problems here.
:confused:
I have two databases. One is 'live', one is for development. Once i get something working in the latter, I import it into the former. This has been working fine for just over two months.
Today, however, i'm trying to import a form and get one of the following messages:
"The search key was not found in any Record"
"No current record"
I'm unable to import the form.
Any ideas what could be causing this?
Hi,
I have created a database with approx ten tables with many queries (make table and append and delete queries). I need to compact this database as I would normally do (usually deal with databases of 500MB and more with no issue) however after over an hour I still get the message 'not responding'. I have tried creating a new one from scrath and get the same issue. Can anyone help please?