I have been searching the net and these forums for a couple of days to find a solution that will allow me to export my data to .csv
Are there any resources around for this function?
I have a form which has my main data. On the form is a button to open another form called AccountNotes.
The table keys are as follows:
tblAccounts
pkAccountID
AccountDetail
etc etc
tblAccountNotes
pkAccountNotes
NotesDetail
fkAccountID
When I open the form AccountNotes how do I...
Hi,
I have been trying to create a filter search as instructed by many Youtube tutorials but I am unable to get my code to work:
This is what I have. I created a query in the Query Builder like so:
SELECT SitesID, SiteCode, SiteName, fkStatoID, fkSimInstalledID, fkMeterInstalledID...
Hi,
I want to carry out the following action:
Main Form: Sites datasource tblSites
Subform: SiteInstallation datasource tblSiteInstallation
Columns in tblSiteInstallation: pkSiteInstall, InstallDetail, fkMeterStockID
fkMeterStockID is a combo pulling the data from tblMeterStock...
My form has a subform with a few fields including a datetimepicker.
When I select other items in the subform they save to that particular record within my DB no problem, but when I use the datetimepicker it does not seem to bind.
Any ideas?
I have created a service based DB with two tables as a test.
Table structure is as follows:
tblSIMStock:
pkStockID - int
StockDetail
DataNumber
fkStockLocationID
tblStockLocation:
pkStockLocationID - int
LocationDetail
There is a relation setup between fkStockLocationID and...
Hi,
Myapplication design:
I have a standard application with forms that connect to a service based DB via a connection string.
My goal:
We have two desktop computers, I want to install the application on both computers and to store the database on just one of them in a shared folder...
All I want is for my child detail to have unique records to each record in my parent detail. Please help?
Database is called: EMIDB
Dataset is called: EMIDBdataset.xsd
Within this dataset I have many tables with various primary and foreign keys.
The tables that I am talking about binding...
Hi,
I have a database added to my project using the Service based DB.
I have a main form called Sites which has a tab control on it.
In the tab control page 1 I have inserted a table from my dataset call Programme which has 4 fields. The Sites primary key is SitesID and the Programme table...
If I was using a MS Access DB it is possible to setup the following:
All tables normalised.
A form with 2 datasources. Main form and subform. You and independantly move the subform navigation controls seperate from the main form allowing you to add one to many records.
How can I easily...
Hi all,
JMC will probably remember some of my new posts and this is just another one of those beginner questions.
I do apologise if my questions are very basic, but I am just starting out and would really appreciate some in depth advice.
My end goal:
I want to create a very simple (to begin...
I have an MDI running as the parent. How can you stop the forms moving to the back when they are open if you click in the any part of the MDI area. Also I notice if I have more than one form open it creates form instances on my windows task bar?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.