Comming To Coming

Feb 8, 2006

Hi all

ive just been asked this by a co worker on a remote site


they have a client name they want to input to a table in Access 2000

in a surname field which is just a txt field

the name to be input is 'comming'

when they tab to the next field access changes it to 'coming'

i tried it this end in a new database and it does tha same thing ..and in Acc 97

any thoughts ...or a fix?

Thanks

View Replies


ADVERTISEMENT

Checkbox Count Comming Up With Neg Value

Sep 24, 2007

Hello all,
I have a main Query (qryMain) which is the basis for other queries. It gets its criteria from a form with a calendar control and it works a treat. The main table in my db has a check box QuoteAccepted (yes/no) which is on the Query. The main purpose of the db is that it is a quote register. I have another query based on the main query and when i do a count of the yes no fields it comes up a negative number. eg :
total quotes=8
quotes accepted=-2
when 2 quotes have been accepted
I then want to convert this to a percentage of quotes accepted. I have searched this forum and have tried the following criteria
yes
true
-1
I have no problem with the formula (it will be on a report) i just need it to show a positive and not a negative thanks in advance.:(

View 5 Replies View Related

Coming Up With A Formula To Calculate Age.

May 4, 2005

I have built a table with a field name of Birth date and have applied an input mask to have the data shown as: ##/##/##. Now, I would like to have another field labeled age. Is there a formula that I can create to have access calculate this in my table? I have tried "=mydate()-"Date Of Birth"" in the validation rule under the properties of the Age field; however, I keep getting an error. Any suggestions?

View 2 Replies View Related

Database Window Not Coming To Front

Sep 15, 2006

This is I think a very simple query.

with a number of forms/ queries etc open and you click on at the back it is not coming to the front for amendment.

It is probably an indicator somewhere but I just can't find it

any help appreciated

Ta

humph

View 3 Replies View Related

Over Coming Slow Network Speed

Nov 6, 2006

Hello,
I have split a database useing the database spliter wizard. But I still have network speed problems. What I am wondering is if anyone knows if useing an ODBC connection between the front and back ends is more efficient than file sharing across the network?
Thanks for any information on this
Tim

View 4 Replies View Related

Maximized Form Coming 'unstuck'

Aug 15, 2006

Thanks if anyone can offer a suggestion, I cannot find a similar problem described on the forum.

I have a form which runs at startup maximised. Pop-up and Modal are set to 'NO', Auto Resize and Center are also set to 'NO', Border style has been set to various settings, and Moveable has also been tried at 'YES' and 'NO'.

A command button on this form opens another form with the same settings which I want to take the original form's 'place' in the application window.

This all works fine, just that when I close the second window (using DoCmd.Close), the original window is then no longer maximised underneath it. I want to make sure certain windows are maximised at all times.

I know I could hack this with a DoCmd.Maximise somewhere, (or by switiching to full Pop-up/Modal mode and hiding the Application window) but the results of these are all a bit of a hack.

Can anyone shed light on the mysteries of Access's default form maximisation behaviour?

Or does anyone do what I have described successfully?

View 4 Replies View Related

Records Coming Through In Wrong Order!!

Aug 19, 2005

Hi,

i was working with a database and accidently deleted the first row, i couldnt get the automatic number to number another row 1, so i took out this table and created another one. however even though my new record is in order, when i pull this through to the website it's coming in the order 1,3,4,5,6,2... and the coding for the page worked fine with the db beforehand!!! so now i'm a bit lost

if anyone has any ideas, they'd be appreciated!!!

Thanks in advance!!!
Megan

View 14 Replies View Related

DSum Not Coming Up With Correct Total

Sep 6, 2012

I have an Inventory DB Table called [EngData] that has a subform table called [Inventory]. I have in the subform a calculated text box that Sums three columns, StockQtyMade, StockQtySold and StockQtyShrink. This works perfectly.

On the Main form I have a calculated text box that references the subform calculated field. This also displays correct info.

On another Form I wanted other users to see the total stock on hand by using a calculated field called PullTotalQty. This is set by using DSum(...). The only problem is that the DSum(...) keeps giving totals that are not accurate. Sometimes the quantity is a few pieces less then the correct amount and in other cases the qty is many times what it should be.

Whatever the amount in error it is consistent each time a particular record is displayed. I have tried many things to get this to work but nothing has fixed the issue. I have also tried changing the query and nothing works. Changing the query and using the [Inventory] table in the DSum domain gives a different wrong quantity.

Here is the code: I reduced the code down to one column to be summed (StockQtyMade) just to see if I could get that working first. I will add the other two columns later. for testing purposes I am only looking at the StockQtyMade amounts.

Me.PullTotalQty.Value = DSum("[tblInventory subform].[Form].[StockQtyMade]", "[SumStockQuery]", "[tblInventory subform].[Form].[PartID]= " & Me.[ID])

Here is the SumStockQuery SQL:

SELECT Inventory.TransactionID, Inventory.PartID, Inventory.PrintNo, Inventory.StockRev, Inventory.StockQtySold, Inventory.StockQtyMade, Inventory.StockQtyShrink, Inventory.StockQtyXIncomplete, Inventory.StockLoc, Inventory.TransactionDescription
FROM Inventory
WHERE (((Inventory.TransactionDescription)<>"xNextOP"))
ORDER BY Inventory.TransactionID DESC;

Why the totals are incorrect??

View 3 Replies View Related

Coming Back From Report - Form Out Of Position

Jun 23, 2006

hi i have a button that loads a report. If i then close the report the form, which is set with no border/no max/min/close/non movable and opens maximised, places itself off centre. I want it to stay maximised full screen. The only work around i currently have is when the use moves the mouse over the form it maximises itself. Will this then be calling this function everytime the mouse moves(cant be very efficient). is there a better way to maximise the form Immediately after closing the report.

View 5 Replies View Related

Queries :: Make DSum For Products Coming In And Out?

Nov 9, 2014

I am trying to make a dsum for products coming in and coming out. find the example below

Products In
Apple 10
Mango 5

Products out
Apple 5

Now I want to show statement for sum as follows

Product. In. Out. Net in hand
Apple. 10. 5. 5
Mango. 5. 0. 5

But it is showing only

Product. In. Out. Net in hand
Apple. 10. 5. 5

what I understand is dsum cannot find the out field for mango as there is no field found for mango

View 14 Replies View Related

Forms :: Prevent Button From Coming To Top When Focused

Feb 22, 2014

I currently have a button with a checkbox on top (z-axis wise). This works exactly like I want, except that whenever the button is clicked or focused, it gets brought to the top and hides the checkbox. The only idea I've been able to come up with is maybe making the button completely transparent, with an image of a button behind it.

View 1 Replies View Related

Export To Excel Coming In Chinese Instead Of English

Mar 20, 2015

But in my access database I have a SQL code in which excel sheet opens automatically with required data. Now problem is one column in the excel sheet since this morning is showing up in Chinese instead of English. I don't know what to do.

View 1 Replies View Related

Property Sheet Not Coming Up Although Tab Exists On Ribbon Bar

Mar 24, 2015

I have recently split my DB and distributed the front ends to respective users. I dont know why for this particular user, the property sheet does not show up even though the the Property sheet button is clicked on the Ribbon bar. For others it seems all fine. This user runs on 2 monitors , but that should not be a problem I guess?

I am currently running 2010 version , and i have tried doing run>msaccess/safe which does not work.

How the user can customize reports or queries , or I can modify designs if I want to on his front end...

View 3 Replies View Related

Tables :: Autonumber From Table1 Not Coming Across In Number Field In Table2

May 5, 2013

I have created 2 tables:

StaffID
StaffTrainingID

Table 1 (StaffID) - contains all personal details in the form of forename + surname + position + email + contact numbers ect. Each field/person has an autonumber.

Table 2 (StaffTrainingID) - contains all mandatory training/lectures (18 fields in total). I don't wish to list each staff member again in table 2 so have put a StaffID field in (data type is number).

However, when I try to type in the StaffID number in that field so I can link that person to the relevant training he/she has taken, Access won't allow it.

View 4 Replies View Related

Forms :: Multiple Field Screen Search - MSG Box Not Coming Up If No Records Found

Aug 18, 2015

I have created a multiple field search screen. The script is attached.

I would like to add a MSG Box "No records found" when the user types in information in any field where no records are available.

Just cannot get this working.

View 10 Replies View Related







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