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 again,
It may be worth me putting it in a different way:
Basically I have three tables:
Table1: Columns = pkInstallationID, InstallationDetail, fkMeterStockID - (fkMeterStockID uses a combobox to pull MeterStockDetail from Table2)
Table2: Columns = pkMeterStockID, MeterStockDetaiil...
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?
Hi cjard,, me again.
I ran the project but everytime I goto save the SIMStock form the app throws out an error. due to the foriegn key contraint.
Any ideas?
Chris
Hi there,
Im actually lost for words because you have gone to great lengths to show me a way to understand. I cant thank you enough, I will study the concepts throughly and hope to build on them in the future.
Again thanks
Chris
Just one question how do I display the items in the "" (Quotes)
What worries me is that Combo boxes are used day in day out throughout millions of VB applications and I am wondering why I am finding this so difficult. Its not like I have not programmed in other languages. I will explain...
Hi,
Many thanks for your two replies, I am quite sure they will help a lot. I am kind of old school when we didnt have application designers etc and when they were first launched the rest of the community still wanted to hard code. Im talking UNIX based etc etc.
Anyway it is obvious that...
Hi John,
First of all I want to thank you for your patience with me. Im working my way to be an Excel MVP and I know how frustrating it can be when you are trying to explain things to people that have no idea.
VB is absolutely brand new to me and I only installed the program on my PC 4 weeks...
This is what I done, its completely wrong I know... but im pulling my hair out:
FkStockLocationComboBox.DisplayMember = StockLocationDetailColumn FkStockLocationComboBox.ValueMember = fkStockLocationID
FkStockLocationComboBox.DataSource = Me.SimStockTableAdapter...
You replied to a post before regarding this and gave a different example.How would I implement this and will it do what I need to, When I say implement where do I put my items in the quotes etc?
myComboBox.DisplayMember = "ParentName"
myComboBox.ValueMember = "ParentID"
myComboBox.DataSource...
John, thank you for your reply but as I said before you have to explain things to me like I have never used a computer before: I have annotated your quote below:
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...
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.