Search results

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

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...

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

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)...

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...

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...

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...

Need some help in tackling a problem. Devised a form that allows the user to add company information however to keep data clean the company field is a look up table to a Company table that stores company information. In instances when they add a record for a NEW company, not in the company...

I am having problems editing a database that i created which is very frustrating. We have recently changed server at work and that is the only difference that i am away of. In the past i was able to easily make changes the the DB structure etc without this problem. I am now being met with the...

i need to export a form which has 20 records as 20 separate PDF's Is this possible?

I am trying to sort data numerically from a select query which has extracted port of the postal code as i now want to group records by area. When i however sort data it does not sort it numerically but as follows. Area: Mid([Post Code],2,2) is used to extract data from post code. Any help on...

As a novice i want to be able to removed lines within an address block that contain blank fields. In my table i have following Fields Address 1 Address 2 Town/City County Post Code However the address 2 field is optional and often is left blank. I want to however display the address block...