Search results for query: *

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 tried that and get: Error in WHERE clause near '@'. Unable to parse query text.

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...

Hiya, After I did what you said with pre-populating the data it all works fine, again many thanks for you help:

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

Hi there, I have attached my project for you to see. Its not rocket science just a couple of basic forms.

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...