Search results

Hi everyone. I'm having a strange issue with data entry into forms. I have a Form with a Subform and sometimes I cannot enter data into textboxes on either form. Both recordsets are updateable and data entry using combo boxes works just fine. All other controls also work normally. I have...

Merry Christmas to everyone. I'd like to generate emails from my Access db, based on a series of about 20 signatures that I have set-up within Outlook. These standard emails are sent to chase up quotes, sending invoices etc. Is there a way to create an email from within Access 2003, based...

Hi all I'm working on a listbox to list all open forms so that I can use it as a quick shortcut to access any open form. I'm trying to use the AllForms collection and it is working to a point, but I can only access the form Name rather than it's Caption as this is not a property of the...

Morning everyone I'm trying to create an elegant way of switching between open forms in my database. I thought that a listbox that holds the names of all open forms could be ever present on the screen (like quickbooks which I also use). I've had a good look around but I can't quite figure out...

Hello I have a supplier who emails me a pricelist on a monthly basis. This consists of 200,000 products, each with a product group and an associated discount. ie: Product Group Item Discount HK52 Copper Pipe 15mm...

Dear all I am developping a database and I use a label on each form to write development notes as I go along. When I double click the label, a form opens up and temporarily writes a reference to the control that opened it and also the contents of the label to two separate text boxes so I can...

Dear fellow AWFers I have some VBA code that enables me to enter appointment data in Access and this creates appointments in the default Outlook calendar. I would like to be able to write data to different calendars so I can have one to handle the scheduling of jobs and say another to show...

Hi everyone. Improving database designer looking to progress.... I'm looking for some software that will capture my free-thinking database design ideas. I'm not after anything as structured as hardcore Entity Relationship stuff - just something I can create basic tables in while showing...

Hi everyone. I have a main form and subform, both displayed as datasheets. For each record in the main form, the subform contains a number of records, each with a date field. I want to show the Max(Date) field from each subform in a text box on the main form. I have tried putting a...

Dear Forumers I am after some help writing a database to manage my plumbing business. When I create an assembly of parts for a job, I select them from a combo box in a subform. There are many hundreds of items available within the combo box and I would like a facility to limit the number of...

I have an Outlook View Control (OVC) object on an Access form to view my Outlook Calendar. I would like to be able to double click the appointment item in the OVC and for this event to open a form in Access. This form contains the data that was originally used to create the appointment item...

I have created a form which contains the Outlook View Control, showing my Inbox. At the top of my form I have a contact field with one or more associated email addresses. I would like to filter the Outlook View Control to show only the emails received from the email addresses associated with...

Dear Experts, I have a string field whose value will appear many hundreds of times on a report and would like to make the report fit on as few pages as possible. As the length of the string varies greatly, I cannot use columns and am therefore trying to create a "Master String" which will...

I am designing a database for which I need some data modelling tools. Can anyone recommend some free / cheap tools as a first step into computerised data modelling. Many thanks.

Dear All I export a series of paths from an Access database which specified plumbing fittings and would like to automate the insertion of images in a word document for each fitting. The paths will be put into a table in the word document as shown below. The table could have a different number...

I have a main form with two subforms (sbf1 & sbf2) sbf1 has a module which contains a subroutine that is run by clicking a button. sbf2 has a combo box which I would also like to trigger the subroutine which resies in the module of sub1. I have tried declaring the subroutine as public in...

Dear Experts Whilst learning a little about Access over the last five years, I have developped the bare bones of an application to manage a small business in the construction industry. I will soon be undertaking a ground-up re-write to eventually create a product that I can take to market. I...