Search results

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.

Need help in my query to subtract [Days] (Numeric Value) from a date field [TravelDate] Appreciate any help. Regards

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?

I am not an expert in code so this may be a hurdle to high for me. Having said that if i understand correctly you are assuming that the file name remains 123. So that i am clear, the field value represents the contract number which equals the external .xls file name. We are storing several...

Need some help with my DB. I currently have a form which displays records. One of the field [Number] reflects a contract number for a document held on the office server. I simply wanted the user to click on [Number] on the form and this hyper-links to the office server where the underlying...

Tried this to but still no luck. So that you understand correctly i have a main menu form with a unbound form on it which returns information from an underlying query. The user can from the main form open a query and make an adjustment however the changes are not reflected on the form when the...

Need some help with a form that i have created. On my main menu[Form] i have a couple embedded forms that return information pertaining to outstanding balances to collected. On clicking a hyper-link button from the same main menu i can access the query and add that the balance has been...

Silly question but how do i requery?