Search results

Hi, It would help if you could post a pic of the Table relationships. It sounds like you may have some normalization problems that need dealing with first. TS

Hi, Here is an example. The address table TBL_ADDRESSES has a Compound Primary Key and an Autonumber ID set to No duplicates. The address form uses a query [QRY_ADDRESSES] with all the fields from the TBL_ADDRESSES. The forms View report button opens a report that uses a copy of QRY_ADDRESSES...

mwhhhaaaa :D More than likely.

I fanstastic film that nearly got me kicked out of the Cinema for laughing so loudly. The scene with the lads throwing records at the zombies is a classic. :D

Glad your happy with it:)

Where is the current code running Excel or Access? Could you not create a DTS package on the server to append the records to Access? You could trigger this in either Excel or Access or time the package itself to do it without intervention. Call a DTS package from VBA...

That is just the job cheers :)

Hi I'm just starting to design some basic pages with Visual Studio .net I've created a web application project and a form which connects to a db and displays some data. I was wondering if the forms allow persistant variables i.e. If i add a variable "above" the code is it able to persist it's...

Hi The data is on my webserver i've got full access to the server. I want to be able to distribute an Excel app that will let remote - i.e. not part of our intrannet - users access the data they are inputting via the website in the form of graphs in Excel on their desktop. I've tried all sorts...

Hi Try steping through the code using the debugger at least that will give you - and us :) - an idea of which line is causing the problem. TS

Hi, Access 2003. I found some stuff on Ip connections for SQLServer but i've only just got a copy of SqlServer Express - read still learning - and i'm loathe to redeploy the DB and do redo all my code to work with it just for the sake of the graphs. TS oConn.Open "Driver={SQL Server};" & _...

Hi, Is it possible to create a recordset from a db on a webserver if you know the ip address and the path to the db? I'm struggling to provide some complex graphing using vbscript in an ASP page so i wondered if i could create a package in Excel that would connect to the database from the...

Hi, Try the column property; If Len(Criteria) = 0 Then Criteria = ctl.Column(1, Itm) Else Criteria = Criteria & vbCrLf & ctl.Column(1, Itm) End If Next Itm HTH TS

Were you around for Mike375? :eek: :D

Ok but what if you had to put a roof that you are responsible for on the wall that you are not?

I totally agree, sometimes what we need are people managment skills as much as db management skills. If your boss, client, user is making your life difficult finding a way of managing them is just as important as delivering what they want.

http://www.datamodel.org/NormalizationRules.html

Sarah it may help if you posted the DB scheme/relationships that you have set up, that way people could actually see what's going on. I've been designing DB's for 5 years now and i still make mistakes with normalization. Trust me if you mess it up at the start you'll spend forever trying to put...

No worries.

Hi, Set the controls rowsource type to table/query. Then change the code to; SQL = "SELECT DISTINCTROW Sum(buys.pris) AS [Sum Of pris] FROM buys WHERE (((buys.kunde_id)='" & Me.OpenArgs & "'))" Me!Liste26.RowSource = SQL HTH TS