Search results

Hi Yes you have a fair bit to do and I probably wont get it all (almost certainly wont get it all!!) in one go. First thoughts are table for Teams (ie team 1, team 2) then a table for employees, then a table for products (ie Sky, BT), then a table (one table) for customers. Also your table for...

Odd When I got home and "built" it it worked fine. When I went in through RWW and "built" it I got the error mentioned. It now looks OK Thanks very much for the help. Suspect I will be back but only when I get stuck and cannot work out for myself. Best wishes

Thanks Kodo Kick applied but when I removed the / the original error disappeared and a new one came up Error 1 The 'system.web' start tag on line 13 does not match the end tag of 'authentication'. Line 54, position 9. (C:\DataFiles\EdinPharm\AspWeb\web.config line 54) I am afraid this is...

Hi This is my very first stab at asp.net so please be gentle! I am trying to implement the forms-based authentication using VB.net as per the MS KB308157 and I am getting a compile error. I may well have pasted something in the wrong place but it looks kind of logical to me as a raw newbie. The...

Thanks for that. I will move ahead and see about building to more like my previous specifications but will use perhaps a better quality motherboard next time. Best wishes

Might be = Sum(Me.txt1 + Me.txt2)

What you are looking for is called cascading combo boxes. You should be able to do a search and come up with good answers. They will only work if you get your data structures right. One table for categories i.d. 1=Bonds, 2=Downpipes One table for sub categories with field for the category and...

You are concatanating the results not adding them. I think =Sum([txt1]+[txt2]) will work but I might be getting muddled with Excel. Brain rapidly going dead! Good luck

Hi Best way might be to copy the fields you want to variables then use the same variables to populate the next record. Sort of strClientName = Me.txtClientName to copy then when you move to the next record you reverse using Me.txtClientName = strClientName I think this would do the trick. May be...

Hi Sorry this has left me stranded. I am just trying to see if I can get VB.NET from the Studio.Net 2005 Express working. I have started a new project, built a couple of forms, put together an outline database structure in SQL 2005 Express. And that is it so far. What I need to do now is add the...

Hi Thanks for the response It will be the latter, storage of data and dishing it out to client PCs on demand. I generally run my applications at the PC end within the network

Hi If the query has all the records and the alternative report print has all the records too, then I suspect your labels do too, but you may not have enough space in the textboxes to show them. One issue I have found is that if a field somewhere has a return key in it then you only see line one...

I think you problem lies in the address having two commas. Perhaps you could first of all identify the position of the two commas in the string - I think you would use Len You could have two variables lngComma1 and lngComma2. In your Kilmarnock example their values would be 18 and 30...

Ah It probably depends on whether the database designer wants you to! The fact that you ask the question suggests you may not! Anyway, what the hell ... If you can get to the password table and open it in design then you can change the input mask from password. Doing this will let you and...

Hi DatePart is your key. One of the parameters gives you the day of the week - I think it is "w" but better check. That returns a number between 1 and 7 where 1 is a Sunday and 7 is a Saturday. Once you have this it is easy to find out what day of the week a date is. An alternative is, again I...

Hi I built my last server and am wanting to upgrade but puzzling over spec. I wondered if someone could help. The server runs MS Small Business Server 2003 with ISA 2004 and has two purposes - first to power my own office network and second to keep myself fully familiar with SBS since I support...

Hi Steve No kick up butt was intended. Rather I knew there was something if you searched on those terms since had been there already! Glad you found a solution. I have to say you can find a solution for almost everything (well everything Access based) here. I also liked RuralGuy's link. Quite a...

Open your query in design view and in the first empty column on the right hand side enter Total: [Ext rent]+[Internal rent] assuming those are your field names This should give you the result you want I think Good luck

It sounds like there may perhaps be some confusion between US and UK dates perhaps? Access seems to default to US dates sometimes and it can cause problems. If so you need to apply a format to the date. I cannot remember the precise but it is something like Format([MyDateField], "dd/mm/yyyy")...

Good to know that if great minds think alike then just perhaps I am approaching greatness!