Recent content by soojosie

Moving in circles Hej ajetrumpet, This is a jpeg of my attempt. What I’m trying to do is populate the date from [NextProposedContactDate] into the field [ProposedContactDate] when new ContactLogDetail record is created. When using the following I continue to get an error message saying that...

thanks, will look at your code first, looks like there's a lot there for me.

Thanks ajetrupet Situation is Main Form = “frmCustomer” = tblCustomer Subform = "subContact" = tblContact Nested inside the Main Form “frmCustomer” is a subform "subContact" I create a new record in "subContact" for each contact with "customer"; enter details of contact, then at end we...

thanks FoFa - am a little further but bloodied :eek:sorry I am very slow, I have been working with the DLookUp idea until my head has turned mushy - and I still can't get it. I can get the last date in the table to be entered, but that only shows the same date on all subforms, whereas each...

:confused:I have created a small DB to keep track of meetings. Main Form customer Sub form meetings with customer At the end of each meeting I make notes on the sub form and enter an agreed date for next meeting. Q 1. I would like the sub form to open at new record, or last record and with...

MStef alias Štef Thank you for suggesting something so wonderfully simple and effective. Today I was thinking I HATE ACCESS, now with that problem solved I realise how much I enjoy working with it when I stop stressing and just play. Thanks for letting me see that too :)

:confused: Have not worked with access for a long time am trying to update an oldie. Main form has a sub form. With each new service to customer I select next on the sub forms navigation button. 1 customer might have 6 records on his sub form and another might only have 2. Problem is that when...

mail merge still a little tangled Hi adam_fleck, I'm still a little tangled. I've put in the query and that works great. but when I've open a module as below " Public Function set_NameLine(int_type As Integer, str_FirstName1 As String, _ str_FirstName2 As String, str_LastName1 As...

Hi, I have an access table with 3 different types of addressees. 1. Couples with same LastName 2. Couples with different LastNames 3. Individuals. I'm trying to use mail merge. But it can't differentiate between the 3 different varieties what I would like is: 1. Anna & Jay WHITE - This...

SMS Text :D sha7jpm, Delboy 2 - thanks for your response its great to get such help, and what a site! cheers Josie

How would I go about using mail merge from a query in access? I am doing a simple database for a group with several hundred members that keep contact via post. Letters and recipients will change depending on situation but mainly there are 3 groups of members, but letter content varies...

pda query Thanks for your reply Rich, no the pda has no zoom, I did try a query first off, pda said that it was too complicated. Only has 8 fields 3 of which are connected to very simple tables. When access runs the query there is no problem. Do you know of any site that might be of help...

I have a table containing info that I would like to access thru a PDA. Problem is when reading data the PDA can only screen the first column e.g. FieldID only shows the number not the details from the lookup, unless you tab and that gets messy on a small screen. Can I create a second table...

I am writing a very simple access database for a retailer friend. Currently it is a stand alone pc next to a cash register. I need to be able to open the Cash Register when a sale is finalized. Can anyone help? Firstly is this possible for all CR or only some? I need to know how/what is the...

When it all works Hayley, thank you so much , will try this tomorrow. For tonight I'm well and truely done!!! Thanks