Search results for query: *

  • Users: chrisguk
  • Content: Threads
  • Order by date
  1. chrisguk

    Question Export to .CSV

    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?
  2. chrisguk

    Question Opening Form for same record

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

    Using the Query Builder to Make a Search Form

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

    Question Displaying the Value based on Criteria

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

    Using the DateTimePicker

    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?
  6. chrisguk

    I have a Combo Box Situation

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

    Deployment of a service based DB VB express2010

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

    Parent and Child Binding any help is great

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

    Using the tab Control

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

    Binding Basics

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

    How do I get started?

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

    Question Using the MDI?

    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?
Back
Top