Search results

Not That I know of. One way to do this would be to use an image behind the text box. Where your image is gradiented from top to bottom. any one else?

HI I hope this is a simple one for someone. I have a combobox set as a lookup field in a table. where row source set to: "Sole Trader";"Partnership";"Private Ltd";"Public Ltd";"Other" on my form I have its default value set to sole trader what I would like to do is beable to show a new text...

Hi all I have a continous sub form and there are 4 fields however only one can be changed. I therefore would like to be able to go from record to record. I have used: docmd.gotorecord ,, acnext however this causes a problem when I reach the end of the table. How can I find out if there are...

For all of you that looked at this post and have a similar problem. The solution to my problem was to move the combo box queries to the sub form and then when I requery the combo box it is only the sub form that is requried and not the main form. It seems that if you issue a requerry to a combo...

Hi I have replace the data source back to the original table and my code works as I wanted. This therefore looks like the query is is doing a requery after my code and hence reseting the record back to the first. Therefore where would I need to put my code inorder after the query

HI I have a form that contains a subform. The subform collects its data from a query. based on an id code from the main form. The sub form is also a continuous form. what I am trying to do is beable to select any record on the form and change a percentage value. This will give me a new total...

Hi All hope some one can help with this. I have a sub for which is set to sort by ascending order for a given field which happens to be a text field with vales set something like abc1.1,abc1.2 ect. The problem is, is that when you get to abc1.10, and more these are then sorted as so abc1.1...

HI I am creating a booking system. I would like to have a form that only shows 10 records for each event. As this is the max number of people that can attend at any one time. How would I go about this. do I use single form, continous for or what ? thanks for any help paul

HI SamDeman Thanks a million that was just what I wanted. Paul

Hi I have a form pop up calendar that returns the date in a date field on a form. This was a free popup and is activated by a double click which issues the command popupcalendar(screen.ActiveControl). I select the date from the calendar form and this date does update the correct filed with the...

Hi Ken Thanks for pointing me in the right direction. Only my query was a selct query and does not work in a action satement. However ran this through a list box and works brill. Thanks for your help. Paul

Hi Neil Sorry I posted your name wrong in my last post must really apologise for that. HAve sorted this now by runing a setup form that runs query in the back ground can post sample if you would like to see. Paul

Thanks This looks as it may be the way I need to go. Im a little new to all this and at some point I need to convert my Database to sql server. The query I have at the moment checks on a field called postcode and depending on the value ie if there is any information or not then it the query...

Nick Again I have looked at what you have done and think I could use this by having a setup form. From there I can run query 1 and 2 then start a second form which is bond to query 2. I am unfortunatley still new to all this and find that if I run the query in vba then the results are...

Hi I am looking at being able to run a query but would like the results not to be displayed. Ie I would like the query to run in the background. I open the query using a command button from a form. thanks for any help Paul

Thanks Neil I have had a better look this morning and I now think I under stand how it works. So any way the user can update figures and run that query will be brill. Paul

HI Thanks again both. Neil this is just what I want it to do I am not sure how automated this is for an end user unless I am missing something (Very probable). why can I no longer enter values in my form? I can only do this is another form Thanks paul

Well guys thanks for your help but I do not seem to be getting any where is the .picture a reference that needs to be included in my DB. To see if you can help further I have included a simple version of what I am trying to achieve. I check if there is a postcode and what should happen is if...

ok still new to this so what type of query do I use for this is it a straight forward query or do I use append, update. Thanks for any more help. A simple example would be great. Paul

Hi I would like to be able to create a continous form that different type of inage depending on values set in a given field. I have found that if I put an image field in my table and use this idea it works ok. The problem I am getting is to change the image based on the value in the given...