Search results

thanks, cross post, because i did not find the solution yet. i am looking for a solution to solve my problem. i waited when i found i did not find a solution i put another post.

I have two tables. In table1 I have 2 columns like below, Doc No is (pk) Doc No Title -------- ----------- Doc-0001 test-0001 Doc-0002 test-0002 In table 2 I also have two columns Doc No (pk), Transmittal (pk) Doc No...

I have a main table that is consists of 4 fields like below and Doc No is a primary key in the table. <code> Doc No Rev Transmit Ct_Cs </code> data of my table1 is like below: <code> Doc No Rev Transmi Ct_Cs BB2-004-8115-1(4) 00 tt-0001 ct-cs-0001...

Thanks, I had not used filter(Not IN SELECT...) for append query, now is ok.

in my macro there are several append queries, now when i run the macro i got error "record is deleted, error 2950" on one of append query. before migration tables to sql server i was running this macro without problem , now after migration tables to sql server i got error "record is deleted" i...

when i change my append query to pass-through query it does in 5 seconds. when i use append query Access it takes 7 minuted for execution 6 append queries this time is alot, i do not know what is the problem, before migration tables to sql server it was fast but after migration it takes time...

about the "YourQueryName" parameter , it should be pass-through query or Access query. when i put pass-through query speed of execution is okey but some times have errors, when i put ACCESS query speed of execution is very slow. i would like to know what is the different between them and what...

after migration to sql when i run the macro for running append queries i got alot of error like "you can not set null value...." and error "primary key could not be duplicate" , .... i have tried to correct these queries with using NOT IN (SELECT.....) in the append queries but i still got...

Re: how to solve error "Violation of PRIMARY KEY Constraint "XXXXXXXX". Cannot Insert there is no Auto number field in my table and my primary key is a text.

how to solve error "Violation of PRIMARY KEY Constraint "XXXXXXXX". Cannot Insert Dup i am using 3 different append query for inserting records from ms access front-end to migrated sql server back-end. because of slow execution i changed theses queries to pass-through query, now when i run...

when i wanted to create a macro in my database, Add new action combo box is empty and does not show any action for selecting, i do not know what is problem? i can copy-paste in new action combo box but it is empty for selecting and adding new action in my database. for checking i made a new...

Before splitting my database I was using a macro for importing excel file to my table and it was okey. Now after splitting database when I use that macro from front-end I got error “You cannot record your changes because a value you entered violates the settings defined for this table or list...

I have a query inside that there is a hyperlink that comes from a hyperlink field in the table. now when i open this query in Excel, it shows hyperlink field like below text, 38687901-000-BE-DR-1011-00#\\bb2-1\DCC\Detail-ENG Documents\EQP\TBE\ZP11\38687901-000-BE-DR-1011-00.pdf# please help...

In my query there is a sub query, now when I join tables with inner joint there is no problem according to below code. <code> SELECT tblDocuments.[Owner Document Number], tblTransmittals.POI, tblPurposeofIssue.[Purpose of Issue Description], tblTransmittals.REV...

in my database i have imported several modules like (modAPI,modReportToPDF,ComDlg) from one trusted sample database. when i am working with my database on laptop it works without problem.but when copy it on another computer i got error ("The code in this project must be updated for use on...

I mean when i need connect to sql server that is on the server and it has user and password for login to sql server, the connection string how should be? when it was access i was using Set db = DBEngine(0)(0) now for connecting to sql server how should be?

For connecting to back-end access file I am using below code Dim db As DAO.Database, rst As DAO.Recordset ' Point to this database Set db = DBEngine(0)(0) ' Open a recordset based on user type Select Case Me.ogUserType Case UserType.Administrator...

I would like to know, How to point to sql database from MS access form after upsizing MS access file to sql server and linking tables from MS access to sql server. I mean If I made a sign in form in MS access for entering username and password and then click ok button, how to point to sql server...

I would like to know how I can encrypt vba codes in event procedures of forms.

I found a similar question in the below link, i hope it helps me: https://www.experts-exchange.com/questions/26923910/How-to-save-and-read-files-stored-as-FileStream-in-SQL-Server-2008-from-MS-Access-2007-vba.html