Search results

  1. T

    connection error with webserver

    there was a windows update for net framework 4.7.3 i think i removed but the problem wasn't solved i forgot to mention that the application wasz build in VS 2010 and net framework 4.0 i made a new app in my laptop at vs 2017 build it and it run smoothly took the exe run it to the office...
  2. T

    connection error with webserver

    there was one about 5 days ago but the problem occured 2 to 3 days after the update
  3. 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...
  4. 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
  5. T

    sql server before insert triger

    well i can;t use a constrain this is what i came up GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER TRIGGER [dbo].[percentage] ON [dbo].[SHPt_Ships_Persons] AFTER INSERT AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT...
  6. 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...
  7. 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...
  8. T

    Random data missing from Access 2010 Db

    could it be that another form make this deletions also does the the columps get fully deleted or part of them? search for update and delete queries that have access to this columns there might be something that someone wrote a while ago and gets triggered by some action that is not that easy...
  9. T

    VBA Coding Error If/Else/ElseIF?

    first of all aufter the insert or update do a me.Undo instead of all the me.v10 = "" secondly i would suggest insert and update through DAO or ADO what ever you prefer that way you have full control over the data that you import. third the problem is in your insert statement or the update ? use...
  10. T

    trim string after "\"

    there is a slash char between the "" but for some reason it doesn't seem to want to appear in my thread (InStr(1, [filepath2], "") - 1)))
  11. T

    trim string after "\"

    well i did this and works great but i would like your opinion filepath = c:\folder\test1.xls filepath2 = StrReverse(filepath) filepath2 = Trim(Left([filepath2], (InStr(1, [filepath2], "\") - 1))) filepath2 = StrReverse(filepath2) filepath2 = "D:\folder2" & filepath2 FileCopy filepath...
  12. 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...
  13. 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...
  14. T

    riddle me this

    well i did something else I made a new report opened hidden export the new report into excel i also though about filtering the query but i abandoned the idea for 2 reasons first one there are more columns in that than i want to show and second this way i can keep the format
  15. T

    riddle me this

    yes i could but that way i could lose the filter that might be applied to that report
  16. 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 ?
  17. T

    report export ot excel ,keep the alias

    well i got the problem is that allthough if you put aliases to the sql query the outputto get the mane of the textbox and not of the sql query so all i have to do now is go through all of my reports and check the name of the fields btw Ranman docmd.transferspreadsheet will do the job done but...
  18. T

    report export ot excel ,keep the alias

    tranferspreadsheet is for table or query not for reports
  19. 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...
  20. T

    MS Access - apply filter to report, using combo boxes but can't apply a manual filter

    do an msgbox CurrentFilter and tell me the message propably the problem is that before you sent teh filter you must replace a part of that string to match the one to the new report
Top Bottom