Search results

Hi David Please don't do cross postings within the forum. Mike Gurman has already answered this question under General. Rich Gorvin [This message has been edited by Rich@ITTC (edited 03-21-2001).]

Hi Anauz I agree with Ilkhoukx that in a field you can use ctrl+enter to move onto a new line. This is useful if you rarely have to make a new line. I also agree with skiphooper that you can use Chr(13) & Chr(10) in coding to achieve the same effect (though not possible when inputting data...

Hi Icalcagni I do not understand why you are having a problem. I have a number of tabbed forms in use, some with 7 -10 subforms (on different tabs) and there is no problem. Perhaps you have overlooked one of the key points with forms/subforms. Your form and subform should be based on...

Hi Ohio ElsVanMiert is right when he says that it may be necessary to re-consider the settings for record-locking. However, I do not think it is possible to have two identical AutoNumbers no matter how similar the moment is that the user chooses to save. There is another aspect to consider...

Hi Mike Thanks for your reply. I have played around with amending the code and have got it to take account of O'Brien, McDonald/MacDonald etc. However there is a problem when it comes to names like Machin which it converts to MaChin!! Any ideas on how one could get round that? I have only...

Hi Mike I take your point about vbProper .. but when I have tried it it doesn't seem to work for hyphenated names, or do you know differently!?! Rich Gorvin

Hi Anthony Yes you can achieve this but how you do it can determine how much it meets you requirements. You could use an input mask and use > before the first letter (capital) and then < to force all the characters afterwards to be lower case. L Letter (A to Z, entry required). ? Letter (A to...

Hi TommyEllis In your query you need to reference the text box on the form within the criteria row of the query. So, if you are looking for people with the last name of "Smith" you would add in the column/field LastName of the query the following in the crieria. Forms!frmMyform!txtMytextbox...

Hi TTownYankee Glad to hear you have got so much from this site ... it is one of the best Access resources on the internet IMHO. To get the user's input onto your report use exactly the same reference as you do when you prompt the user for your crosstab query. So, for example, if in your...

Hi Skiphooper Add me to the list please! Thanks for providing this on line to the forum. Rich Gorvin

Hi lcalcagni and HL I always wonder why database designers want to save calculated data to another field/table. Good relational database design prevents the necessity of storing the same information twice (which is in effect what you are doing - you have all the parts which you bring together...

Hi Harmony You must still, somewhere, have a field on a form or query undelying a form that draws upon that deleted field and table. You need to go through every object in your database in Design view and see if you can't locate the deleted field name. Access is like that - you need to be...

Hi Martin You will need to define Rent and Days in terms of the original fields - so if Rent is made up from, say, NoOfRooms x RoomRate and Days is calculated from LeaveDate - ArrivalDate you would need: =Sum((([NoOfRooms]*[RoomRate])/7)*([LeaveDate]-ArrivalDate])) Obviously the field names...

Hi Russi Don't think it is possible in one query, but I think you could break it down into 2-3 queries. First I will assume that your week is seven days from a Monday. On your form (from which you run the query via a command button) you could have a combo box or text box that allows you to...

Hi Lily You will need to familiarise me with the Function you are using - Format_Address. How is this set up? From what you describe in your follow up question you can already accept blanks in [Add 2] and [Add3] with the commas disappearing (or is this you just being economical with your...

Hi Mark Perhaps I have misunderstood your problem, but from what you have written it seems you are trying to duplicate the primary key for records. No error trapping will over-ride this feature of a relational database - that you cannot have two records with the same Primary Key (this defeats...

Hi Joe Try "Microsoft Access/Visual Basic Step By Step" - Evan Callan (Microsoft Press) ISBN 1-55615-890-4. It is very practical, but targets VBA in Access (so you don't go over all the basics about tables, forms etc again). HTH Rich

Hi Mr Moks Are you sure you have your one-to-many relationship set up correctly? The One side should be in the main table (tblOrders), the many in the tblOrderDetails (using the OrderID as the foreign key in this second table). Failing that, have you checked that OrderID in the...

Hi Lily You want something along these lines: =[Add 1]&", "&[Add 2]&", "&[Add 3]&", "&([City]+", ")&[State]&", "&[Zip] HTH Rich [This message has been edited by Rich@ITTC (edited 02-03-2001).]

Hi Talismanic I don't think there is a password property for a message box (though I don't profess to be an expert in that area). There is an input mask for a password available through a normal field on a form, so the way I have got round this is to use a Popup form, set to Modal, that has a...