Hi,
I have a form based on a query. In this query I sorted the columns year and month in a chronological order. However, on the form this does not appear that way on the form. How can I enforce this?
Thank you
Stacey
Hello All
Does any know how to index months of the year in chronological order, such as
Jan
Feb
Mar
Etc.
Regards
Terence
Nairobi
Please can anyone help, I have a query that gets its date field from a table that is set to short date.
I use this query to generate a graph in a report.
The problem i have is that i have formatted the short date to ww,yyyy and when i view the query the week No. does not follow chronological order.
ie, it sorts them as follows, 1`2008/10`2008/ 11`2008/3`2008/ 4`2008 etc...
I think a way to resolve this would be to get all the week No`s to 2 digits ie, 01`2008/ 02`2008/ 03`2008 etc....
I have tried everything but cannot get the week No. to format in this way.
Any advice would be much apprieciated.
how to get some information to show up in chronological order.
For example,
It is showing up like this..
Week 1
Week 10
Week 2
Week 20
Week 3
Week 4
and so on
I want it like week 1
week 2
week 3
week 4
week 10
week 20
I have my query set up, but I want it to sort by chronolological month and not alphabetically. Below is the SQL statement.
GROUP BY [Implementation Pipeline].[Parent Company], PUR_OWN_ASC_11.CUST_ID, MonthName(PUR_OWN_ASC_11!PERIOD,False), [Implementation Pipeline].[Transition to FSCR/AM]
HAVING (((MonthName([PUR_OWN_ASC_11]![PERIOD],False))<"October"))
ORDER BY MonthName([PUR_OWN_ASC_11]![PERIOD],False) DESC;
Dear All,
Please see attached word document with a screenshot of my tables and their relationships. I'm trying to link from Table:Line,Field:Line to Table:Shift-Line and similarly with the shift table and access is not able to maintain referential integrity.
Can anyone explain why? and generally what I've done wrong with my relationships please?
Much Appreciated
Keji
Does anyone have a good technique for enforcing a minimum number of records in a table?
I am attempting to ensure that in a table of Roles, there be a minimum of two Roles defined as Technicians. The field which identifies a Role as Technician is a Boolean.
I wrote a Function which does a domain lookup to count the number of Roles defined as Technician and am calling it from the BeforeUpdate event.
However, if there are 2 Technician Roles, and I mark a third Role as Technician, change my mind and try to unmark it...of course the Function can still see just the 2 existing.
I realize I can Undo the edit, but a user may not.
Thanks for any help.
Hello again,
Does anyone know if this is possible and is there an easy way to set it up?
My db has many relationships, hence if you attempt to delete a record from the table, it will not allow it if there are related records.
This is great, however.
My intention is to disable any record deletions. Instead, once a record is no longer live, the status of that record is set to disposed,exipired, etc.
I want to force the same rules as if attempting to delete this record but set to the status field.
Example message.
ie, Warning! You cannot dispose of this PC. There a related records in the Software License and Contracts Tables. Please reassign them and try again!
Any clues would be great.
Thanks All.
Hi,
I opened the relationship window to do the relationships among my tables; however, the check box 'Enforce Referential Integrity' is disabled. I don't understand why is that? And is there anyway to change it?
Also, where should relationships be implemented? is it the FE or BE?
Any help will be very much appreciated.
B
Hello everyone. I'm not sure should I post this question here or at SQL Forum? However, my problem is this. I have 2 Tables, Table1 has AutoNumber as primary key, my second Table2 has index key field. I have one-to-many relationship on those two fields, with enforce referential integrity, cascade update and delete
The access program works fine until I upsized to SQL server. [u]Then I was unable to perform cascade update or delete. I have check SQL table (which I have little knowledge about) and seems to be okay, the relationship exists. But at ms-access I was unable to make the cascade update and delete.
I appreciate any help …. Thanks.
Hello..
I have a simple database of 4 tables.
luTblJobTitle
JobTitleID (pk)
JobTitle
luTblReason
ReasonID(pk)
Reason
tblDateReason
DateReasonID(pk)
EntryNumber(fk)
Date
Reason
Entered
tblEmpMain
EntryNumber(pk)
EmployeeNumber
Etc//
I have a 1 to many setup between tblEmpMain and tblDateReason.
When I try to setup the relationship between the "reason" field in tblDateReason and luTblReason, Referential Integrity along with the other two check boxes are greyed out.
It still shows one to many but it will not let me enforce referential intergrity.
Why is this? Did I setup the database wrong? Or am I trying to do something I shouldn't be doing??
I have attached the db.. It is split with both the backend and the front end.
R~
I have build a database with which I can create quite a lot of reports. When creating them I run out of memory with run time error "2004".
When investigating I detected that a lot of memory is used when creating the reports in PrintPreview mode. When closing the reports the memory is not automatically freed.
Is there a way to enforce garbage collection? Local variables of called routines I set to Nothing.
I am building a new project which has some core tables..
The key tables are:
Countries
CountryID
CountryName
Businesses
BusinessID
BusinessName
CountryID
Clients
ClientID
ClientName
BusinessID
CountryID
I want to enforce the rule that a Business can only have clients within the same country.
Can I enforce this through referential integrity in Access ? Do I need to redesign my tables ?
I have a problem when I want to create an "ORDER" form, that will allow user to enter more than one order.
I have no clue how to do it.
I want to use buttons on a form to change the sort order on a continuous form. In the buttons click event I am using a public function (named Sort_1) to change the sort order. The first element of the event call is the name of a generic query (named Sort_1_Query1) and the query field to sort (LAST_NAME OR FRIST_NAME, depending on the button.)This is the Click Statement.
=Sort_1("Sort_1_Query1","LAST_NAME")
This is the Public Function
Public Function Sort_1(SortName As String, FieldName1 As String)
DoCmd.ApplyFilter SortName, FieldName1 & "between 'A' and 'Z'"
End Function
I think the problem is in the use of quotation marks or trying to pass the query field name to the Do Command or the use of an ampersand.
Hello,
Is their a a way I can have a button or something in which duplicates all the data in the text boxes instead of re-entering data?
Also how can I sort data (DATES) that is in a form in descending order.
Thank you,
Onofrio
I have a form (Members of the club), linked to a sub form (payments of membership).
When I open the record of Mr John, I want to see all his payments order by date of payment.
How do I do?
Thanks in advance,
Jackske - Belgium
:confused:
I have a form (Members of the club), linked to a sub form (payments of membership).
When I open the record of Mr John, I want to see all his payments order by date of payment.
How do I do?
Thanks in advance,
Jackske - Belgium
:confused:
I've been trying to sort out my order form for quite a while now with no luck but i am hoping someone will be able to help me so that i can complete the form and finish off the system. I want the order form to have combo boxes that actually work (At the moment all my combo boxes bring up a message at the bottom saying something like 'control cannot be edited'), The product subform does not work where i want to be able to created the order (and i need the rest of the boxes in the row to be updated some how with the product information when i choose the product), Also non of the other boxes seem to work either and need to know how to update fields when employee and customer are selected in the combo boxes. Also i want to be able to show previous customer orders in the 'View Customer' form.
Here is the system:
Gamez System (http://www.savefile.com/files/6926006)
Any help is appreciated but please try and keep any help simple as i haven't really been using access for very long.:)
I have a form/subform linked to 2 tables, staff and training. The subform lists training done and is sorted by course. How can I change the sort order to a different field? E.g. date?
Thanks.
Hello,
i am really struggling in access creating an order form and an invoice report.
the attached example shows what i have so far.
however for the order form what i would like to do is have a drop down menu at the top which will have a list of invoice reference number for that particular student. which will in in the format of surname/date eg Bannister11/01/2006
as people will be ordering things at different times and need a new invoice each time. i see this as the easiest way. could any body help me with this??
Help is much appreciated
Aaron
Hi,
I have a form containing several fields for users to import data. The data comes from multiple sources, and I have arranged my layout the way I want it on the page. I have noticed though, that when you are using the database and pressing the TAB key, it isn't in a particular order (shoots to different fields across the form). Can you change the order of the fields that are selected when the TAB key is pressed?
sugar05
Guys,
please save me!!!!
I have an order form called OrderForm. It has multiple combo boxes, where i select data.
e.g i have a page in this form, where i select the company details, and a second page, where i select the order specifications, all based on combo boxes. The form is linked to 2 tables, Order and Customers. First page is linked to Customers, second to OrderForm.
When i open the form, i can select the company name in the first page, where the fields are automatically filled. When i go to the second page, i select the type of product, e.t.c. Ok by now. What i can do to save this new order? I mean the Order specs to create a new order at Order table, and link this order to Customers table. The tables are linked correct.
Thanks in advance
Iannisro9
On a form i have a combo box called DATE
The row source for this box is
SELECT tblCleftClinics.Date FROM tblCleftClinics ORDER BY tblCleftClinics.Date DESC;
On the form what do i put in the "Order by" field to make the dates appear in descending order?
OK....I have done a search but am still none the wiser regards allowing for VAT (added to an old thread but no luck!).
I am designing a little DB for an accountant at work. He wants to be able to keep tabs on orders he places with various vendors (currently uses excel) but he needs to generate reports etc. I have done this but would like to afford him the ability to add VAT to the order total if required.
So here is what I want to do. I want to add a check box to an Order Form that will add VAT at the current rate. If the VAT rate changes at some point in the future I do not want historic data updated to the new rate.
I want to add it to the Order Form as not all companies being invoiced are VAT registered. This will give the user the option to add VAT or not.
I have had a little play (see attached) but do not know how to get it all working!
Help, advice appreciated (or if anybody has a working example of VAT?).
Cheers,
Phil.
I want to order the data on a tabular form.
I realise I could do it by basing the form on a query like:
Select *
from table
order by field
But I have allready made andlaid out the form, after basing it just on the table. Is there a way I can now order the data on the form, after having created it?