Search results

  1. T

    connection error with webserver

    hello again i need your help i made a simple app that calls a webmethod and gets a json string as response everything worked fine up untill yesterday when suddenlly it stop working for no reason when the code tries to get the response the message i get is "A first chance exception of type...
  2. T

    mac os

    Hello there I would like to know if there is a way to make a form app in visual studio 2017 windows and build it for MacOS is there an extension or any other way ? i dont own a Mac but a client of as do
  3. T

    sql server before insert triger

    well hello again after a few months after i changed work i went from access to sql server 2016 and i am still not familiar with a few things one of that is triggers so here is my question i have a table named ownership it has 4 columns Ownership _ID Ship_ID Person_ID percentage what i...
  4. T

    check if table has the right type

    Hello i need some help i have made a function that it works but i need some help. The Function imports an excel into a tempary table then i want to make some checks before i import them to the main table all checks work great except one if every field has the right type of value and if the...
  5. T

    trim string after "\"

    hello hello i am back with one more small problem this time in C it was pretty easy here i need a bit of help i have this function that i take the full path name ex. C:\Folder1\test.xls i want to rename and nome this file to this folder with this kind of format...
  6. T

    culcuated field for SQL

    culcuated sequencial field for SQL Helloooooo i have a not so dubious problem but i need some help I have a that has 2 fields the first one has letters the second numbers that helps with the order by because the second field can change and leave gaps i want to create a new field tha will...
  7. T

    riddle me this

    well since i am here a have a question a have a report grouped by in only one level this report is outputed to excel through docmd.outputto now here comes the million dollar question can i remove the group by before i export it to excel ?
  8. T

    report export ot excel ,keep the alias

    i hace some reports that i have created through some sql queries and i export them to excel with the DoCmd.OutputTo acOutputReport, "Comments_Report", acFormatXLS, "C:\mpla_mpla.xls" the problem is that to some columns i has some alias for example select (NameID) as ID, (Surname) as Sur from...
  9. T

    Combined Left Joins

    Hello yet again here is my problem i have two tables one is Clients the other is Destinations in Clients i have ID , name and DEST1,DEST2,DEST3 in Destinations i have to fields DESTID and description now the thing i want to do is is after each DEST to get the maching description something...
  10. T

    Report export to excel by filter and columns

    So here is what i want to do I have a report created by two tables no problem so far i what the user to be able to select the columns that he wants to export and also filter them what i have done so far is that i created check buttons and each check button contains on part of the sql...
  11. T

    choose fields from report

    hello this is my problem i have a report that brings to many fields and i want to export some of them to an excel file does anyone has an idea of how to do that ? is thinking of something like a second report that by clicking the label of the field s you could get the names of the fields to an...
Top Bottom