Search results

Hi, I have designed a database that needs refreshing on current for different reasons. However, should I go on to create a new record in a form, then change my mind, a message appears saying, 'you cannot add or change a record because a related record is required in another table'. I know this...

Thanks, Is there any way of doing it without adding a button, some way so it does it automatically? Cheers Lee

Hi, I have designed a database that needs refreshing on current for different reasons. However, should I go on to create a new record in a form, then change my mind, a message appears saying, 'you cannot add or change a record because a related record is required in another table'. I know...

Thanks for that Don, That is brilliant Cheers Lee

Hi, I am designing a simple database to be used at a local environment fair, where people can enter their opinions about the environment in a simple database format. However, once somebody has entered their opinions, the user should not be able to look at previous records when in form view...

I need a basic understanding of how I send a letter, say an introductory thank you letter, from a current record. I would like to have a command button on the record that would generate a letter automatically. Do I create the letter in Microsoft Word using mail merge ? and if so how do I get it...

I have used a Union Select Query to combine the data from two tables. Is there anyway of changing the colour of the data in one of the tables so that the user can tell the difference between the different sets of data?

Thanks Travis. Colin, the code is attached to a form.

Hi, I want to say "Between 8.30 and 17.00" in code. Is this possible? Thanks in advance Lee

Thanks for all your help.

What do you mean? What font should I use on Labels, and text fields. at the moment I have been using Arial for text fields and Bold Arial for Labels, but I have been advised not to use Arial when designing databases. Cheers

Hi, Just designing a database, wondered what the best choice of font to use is on forms? Any ideas? Thanks Lee

Hi, thanks for helping. Wonder if you can help me with this similar problem. Should I want to order from a quote, I would enter an order date into a field. However, the countdown date would continue to count down. is there anyway of freezing the field so that it always contains the number...

Thanks, that works fine. cheers Lee

Thanks ListO. Yep, there are 2 logos

Hi, I am designing a procurement database. When we receive a quote for a piece of equipment, we have 30 days in which to order it. I have a field that counts down the number of days remaining that we have to order. Is there any way that after the 30 days are up, the database can prompt the...

Hi, I am trying to design a helpdesk database. If we log a call through our IT company, we receive a call number. If we enter a call number, I want their logo to be displayed on the relevant form. However, if we solve the call and enter a reference into a seperate field, I want our company's...

Hi, I have a combo box on a form to select a username from another table. When a name is selected, all personal information is shown on this form as I have including a refresh command. However, as the primary key has not been entered yet, it says a record is required in a related table. Any...

Thanks Pete, will try.

I am trying to design my forms and want to insert the company logo and various other images. However, when I try to insert them, they are too big, so I resize them in MS Word and paste them into Access. Then, pictures that were fine in Word seem to look 'blocky' in Access. Any ideas welcome?