Perhaps i was not clear.
I have 2 fields [Date of Trave] and [Days]
I just want to know what the expression would be for a calculated field.
[Date of Travel]-[Days]
25-sep-15 - 14
As a newbie i need some help with a form that i have.
My DB has a form that is working fine in isolation. However when i place this on my startup form as a continuous form (dynaset) it then doesn't allow me to edit values even though Allow Edit is set to "yes".
Any help is really appreciated.
Thanks so much for responding however i feel that with my limited knowledge of MS Access i need to do some more research as i am not quite sure on how to effect the Meetings Table as per your response.
My database essentially has 2 tables and a query that helps me combine the fields of the...
I have a customer database which consists of 2 tables.
1. Companies
2. Contacts
In the relationships there is a one to many between company and contacts (often more than one contact at each company).
I now want to create a meetings notes table to log notes on meetings held. this will consist...
Thanks this has helped me better understand however i still getting a blank line where the company name should be using the following:-
My Database used a check box to determine if the record is a company or direct customer. if the box is checked then i want the address block to ignore the...
I need some urgent help with a report. I have created a standard letter and the address field block is giving me some problems.
The letter is sent to companies and direct customers (No company name). In my database if we have a direct customer we populate the Company Name Field with the...
This is 2 questions rolled into one.
I have a form and one of the controls is a combo box which correctly returns a list of contacts to select once the company name is selected.
If the company selected only has one contact there there would be no need for the user to select the contact. How do...
A Control on my Form returns negative numbers however i want to manipulate the value and return "21 Days since Departure" EG replace -21 with 21 and adding "Days since departure" string.
Appreciate any help.
Thanks
Yes i quickly came to realise that removing the Group by still did not help.
How can i get around this if i am forced with these 2 outer joins?
Regards
Hi all
Not an expert however i am struggling with this.
I have a query which has built up from 3 seperate tables however for some reason i am not able to edit the query.
I have a check box (yes/no) which i want to use and the idea would be for the query to return only unchecked values (no)...
Thanks for replying and I understand that.
What i want to do is also include in the caption the number of count records from a query.
Me.YourButtonName.Caption = "New Follow-up Records" + Record count if that makes sense.
Thanks
Is it possible to include a field value on a Button Caption?
The idea is to show a button "New Follow-up Records(5)"
The number in brackets would represent the number of records returned in the underlying query.
Any Help would be must appreciated.
Regards
A relative novice to Access however i normally get by reading forum pages etc. This one beats me so need some help.
I have a Select query which is based on fields taken from 3 separate tables however i want the user to check a box once a record has been printed.
It works when query is based on...
Thanks for that but it is not happy with the coding for the &".xls" part.
Application.FollowHyperlink "\\londcfs1\Data\" & txtNumber& ".xls",, True
Am i doing something wrong?