I have found the answer now thanks to this reply on another board (Typical I find it half an hour after I gave up looking!)
http://www.tek-tips.com/viewthread.c...1591896&page=1
Turns out the Answer is all to do with sub queries.
Thanks for looking at my question anyway....
evilbungle
Last Activity: Nov 22 '10, 02:19 PM
Joined: Apr 2 '08
Location:
-
Hi Mate,
How are you firing the event? Might be that it is a new addition for 07, I am still using 03 but I am not sure when this event fires but it looks like the problem maybe that the event is not firing when you want it too.Leave a comment:
-
How to Identify Subsequent Dates from a first Date?
Good Morning,
I am struggling with something I am sure should be easy but I just can't find a good way to deal with it. I have a table which lists appointments.
There is a CaseID, An Appointment Date and an Appointment ID (Other fields as well but these are the identifyers.) what I need to do is to run a report showing how many subsequent visits have been made. (A subsequent visit is any visit other than the first... -
Thanks again but this still hasn't worked.
Should I have files downloaded onto the device anywhere? the files are not being copied which I think may be the issue.Leave a comment:
-
Hi Thanks for getting back to me,
Database1.sdf is listed under application files it says Publish Status: Data File (Auto) and Download Group (Required)
Also Database1.sdf.d eploy is one of the application files in the folder I am installing from.Leave a comment:
-
Problem Deploying Program to Tablet PC
Hi, I have created a program in VB.Net using Visual Studio 2008, the program works fine and everything is working until I try to install it.
I need to be able to add it to a flash drive so I can load it up on a handheld device. I have gone through the publish wizard on my PC and created the Application Manifest and other Files on my PC, I have then copied this folder onto a memory stick and then accessed it through the handheld and... -
Solved it, It is due to the debug and production Databases being different, A well known issue apparently but not to me. I simply have to copy the database back from Debug to the main folder and teh data is there.Leave a comment:
-
Sorry back again I have run through the Sub with the Table Adapter and again when I go back to view table data it does not show the updated data again, although the Autonumber keeps going up.Leave a comment:
-
Sorry I must be being really thick but I can not for the life of me work out how to INSERT the record, it is asking for five fields yet the first field is an AutoNumber field so I am not sure how to Insert this record.
EDIT:...Code:Dim taQuote As New HS_fieldDatasetTableAdapters.HS_QuoteDataTableAdapter taQuote.Insert(, Me.txtJobID.Text, Me.ItemIDNbr.Text, Me.nbrUnits.Text, Me.curSubTotal.Text)Leave a comment:
-
Ok thanks, I will try and see if I can find anything about that.
I have actually managed to get the data onto the table and to populate a listview to show it is there but when I go back to view the table the records are not there.Leave a comment:
-
Trying to Use INSERT INTO in VB.Net but is not INSERTing
Hi, I am using VB.Net in Visual Studio 2008 with a connected SQL Server Compact Database but for some reason I can not get a record to insert into my Database from my Windows Form.
I have used the data connection on the form already to populate a couple of combo boxes but when it comes to commiting the data the sub runs through but there is no additional data in my database.
my code is as follows
...Code: -
How to convert String to Number Format
Hi,
I have a field in my database which contains numbers stored as string, I need to output these as a number.
The numbers are 13 digits in length (i.e 1900026354527) they are stored in the table as a Text field called MPAN I thought it would be a simple convert function so tried.
Clng([MPAN]) but this returns #Error, I believe the numbers are well within the range of a Long Integer so I really can't... -
How to pass a Range to a Function in VBA (In Excel)
Hi,
I know this is for Access but I was hoping someone may know about Excel and can help me.
I have created a Function in VBA for looking up a value in a grid it works fine but only if I place the Range as a string and I really need to be able to just select the cells as you would with a standard function.
Here is my Function
...Code:Function GLookup(VLookup, HLookup, GArray) Dim TArray
-
Need to INSERT blank field into my database from Excel
Hi, I am sure this should be easy but can't get it working,
I have a database which needs to import fields from a spreadsheet, I can open the spreadsheet and load the fields I want to into an INSERT INTO statement. I had an issue with a previous INSERT INTO and solved it using the NULL keyword (rather than just leaving it blank) which now works fine.
Where I get stuck is in loading up a blank value, if the field is... -
No Read Permissions on Access 2003 Table
Good Morning,
I am trying to build an application that will take the details from an access database and use them as log in details but I can not get the App to open the table as I keep getting the error Record(s) cannot be read; no read permissions on tbl_users_agb I built the database that has the table so there should not be an issue with permissions. the code I entered is as follows.
...Code:Private Sub frmSwitchboard_Load(ByVal
-
This could be a great help, I just have to hope that IT let me have admin rights, ofcause if they were that reasonable I guess I wouldn't have to create programmes myself. :-)Leave a comment:
-
Is there anyway to compile the programme from Visual Studio that does not require .net 2.0?Leave a comment:
-
Loading Applications
I have a programme I have written in Visual Studio 2005 which I need to roll out to users accross several departments in my company, The problem is that it is trying to load .net framework 2.0 which needs to be loaded by an administrator.
My IT department will not allow users to have Admin rights on their machienes as the programme I am running allows users to update an access db and IT do not support Access.
Is there... -
Think I have it, sorry it appears that I was looking at making it overly complicatedLeave a comment:
-
Need to Update Access DB from Visual Basic
Good Morning,
Hopefully someone can help me with what I am assuming is a simple query that I simply can't get to work.
I am new to using Visual Basic and I am using Visual Studio 2005, Previously only been working in VBA.
I need to update a field in my database with the changes that are made in my application, I use the following code to call the Record Set.
...Code:Dim Conn97 As
No activity results to display
Leave a comment: