Search results

i have created a logo in word, and which we use on all the documents but when i insert it into the database it only allows it to be one size and if i try making it smaller it just crops its, any ideas?

Hi on my data base i have a customer form which when opened doesnt bring up the records, it used to and its record source is tbcustomer any ideas, i have attached it aswell thanks

i have been messing with the form properties and not sure what i have done, but now when i view the form i cannot edit information or create a new record only view them, it is only within this one form, how can i change it back so view edit and creare records

i know this breaks first normalisation but on my report i have surname and forename together so you get the name and everything else looking like an address etc John smith 123 grant lane Manchester but my isssue is that i have to leave big enogh space for large first names like Alexandra...

Opening the Database how can i make so that when i open the database it opens on to my main form??

i have created alot of buttons, but i need to change add some things to them but i created them all by wizards but when i go to properties it says it is a emmbeded macro and comes up with a macro editted where i cannot find it? thanks hayden

hi i have created a button by a wizard in access 2007 on a form populated by a query, i have added a button so that it opens my invoice however when we click the button nothing happens but my all my other buttons work here is the code: Private Sub Command17_Click() On Error GoTo...

i have created an invoice and i want to create a sum of all the individual costs which are generated to form grand total i tried sum([total cost]) but it doesnt work [total cost] is the field i am adding up

I am having great trouble with this I have created a compare query which has tells me whether there is a clash or not but what i really need is a way in my form once i have selected the date only the available products for that day are displayed (i.e. booked out products not shown products...

I am trying to create a report which summarises information collected in my form i hace created a query which combines all the information however once i insert a query table into the design view and select the field i want when i run the query it comes up with multiple copies of the same...

I have gone into query design and want to know what function i use so that if value =1 in my table that it changes to so that grass is displayed

how do i create parameter query so that if i select a date that it shows all the relevant information what is required, so it can be printed out for my daily deliveries

hi im very new to access how do i once i have selected a date in the field on my form. how do i make it so that the same product cannot be double therefore dispears or cannot be selected from the drop down list for a particular date which the product already booked out for, i know i have to use...

In the design view of the tables at the bottom i have put validation in, with a personalised message too. How can i enter another validation and another tailored message as this is what is needed, how do i do length check too??

in the design view of a table on the general tab when i click validation rule so that the expression builder appears. what do i type in so that presence check occurs and i can get an error message saying enter a value also how do i apply length check. hayden

how do i apply a user name and password to my database so that it provides security, i only need one access level

hi im new to access i have created my tables, relationships and forms but i want to make a calculation in my tables for cost by multiplying two numbers, where do i enter the formula and also it relates to the names of the texts in my form e.g. 'text23' does this effect it? Hayden

Im new to access I used a wizard to create an option group and when assigning a value to each option i want a decimal (options for Discount) as i link it with the discount box so i can multiply it with the cost however it only allows whole numbers any help be great cheers

hey, i am a beginner in Access just to let you know I have in my form a combo box for all products which can be selected to be hired for a particular day, what i what to know is how can i once a date has been selected, how to make it that product is then removed from the combo box so it cannot...

i have a booking form and i have this button so that if a the customer doesnt have an account then when i click it opens up the customer form so add them, however my problem is that i cannot get it to open on a new record it always opens on a completed one ive looked through forum tried various...