Search results

Additional; I can type new records and amend existing ones directly into the underlying dynaset. No problem here. It seems like it's just the textboxes. I have also tried creating a new unbound textbox on the form but this does not allow data entry either.

I have been playing around little more and discovered the following; I can copy and paste text from fields into other fields using the CTRL+C and CTRL+V on the keyboard. It is just directly typing into the fields that is not working. If I select a word and press backspace then nothing happens...

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

Thanks Galaxiom I just tried it with a; Debug.Print CurrentProject.AllForms(i).Properties("Caption") but I'm getting the message; Rum-time error '2455': You entered an expression that has an invalid reference to the property 'Caption'. Does this mean that the property is unavailable to this...

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

Thanks Net This populates the listbox with all the forms in the database (open and closed). How could I restrict this to only the forms that are open, list their caption rather than their name and open the relevant form when I double click on the name? I also need to update this whenever a...

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

Thanks for your help John I think I've got it now. Larry

Thanks John. I've tried those but I can't seem to get the result I'm after. Can you give me any further guidance? Thanks.

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

Cheers Galaxiom - Perfect analogy! That is exactly what I did. Thanks for your help, Laurence

Hi Trevor I have figured out a different way of handling it whereby I have creted a table which stores the notes for each of the forms I am working on. Thank you very much for your help. Best wishes, Laurence

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

I was thinking of preventing the calendar being opened within Outlook and just using the Outlook View Control within Access as the calendar viewer. Not sure if I can get the viewer to open my access data entry form rather than the appointment entry form in Outlook if I double click the...

Thanks Boyd Are you suggesting that I should write all appointments to the same calendar and then use filters to view the required info?

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

Here's the database - hope it works. See the form frmInternalWorksReminders Many thanks, Laurence

It's a huge beastie that i've struing together over five years. I'll try and strip out the relevant tables and forms. It'll probably take me half an hour. Many thanks.