Recent content by Khalid_Afridi

  1. Khalid_Afridi

    SQL Server as Default BE to Access FE

    Why i can not create new thread???????
  2. Khalid_Afridi

    Closing Command Button Won't Bring Up Prompt

    I think you want the users to save or discard data to database? Access has a default behavior to save the current record automatically as soon you edit it and then move to another record. This happens with a bound form to a table / query or directly in a table or query. In your case, if you...
  3. Khalid_Afridi

    What's wrong with this INSERT stored procedure

    it was not the issue of missing of ; semi colon. The problem was the BEGIN...END block in SQL STORED PROCEDURE. I was missing the END statement at the end of my Stored procedure, anyhow it is solved.
  4. Khalid_Afridi

    What's wrong with this INSERT stored procedure

    Kindly see the SQL stored procedure which is simple INSERT statement on a single table 'tblSOF' -- ================================================ -- Template generated from Template Explorer using: -- Create Procedure (New Menu).SQL -- -- Use the Specify Values for Template Parameters --...
  5. Khalid_Afridi

    auo populate diffrent form

    Yes It's possible. You need little VBA code to populate controls on form to your desired / default data. There are many ways to do it. One way is to put desired/default data under each control under data tab while form in design mode so your new form will Auto populate each time with the same...
  6. Khalid_Afridi

    Closing Command Button Won't Bring Up Prompt

    Which version of Access you are using? Is it behave only for the specific form OR all forms created earlier? Did you use the SetWarnings to False in any of your VBA code? If so, then change it back to true.
  7. Khalid_Afridi

    Access Project - ADP (subform)

    Yes they are :)
  8. Khalid_Afridi

    Access Project - ADP (subform)

    I can not edit already recorded data too, sample sub-form's screen shot is attached with 'qryQty_sp' retrieved data.
  9. Khalid_Afridi

    Access Project - ADP (subform)

    Thanks JHB The link says that they don't have the primary key one of the table and by creating the primary key and re-creating the table have solved the problem. In my case I have two tables (tblQty and tblItem) with INNER Join. 'ItemID' comes from 'tblItem' in 'tblQty' as foreign key and...
  10. Khalid_Afridi

    Access Project - ADP (subform)

    Thanks Bilbo There is no error in SQL, tables and stored procedures work fine. Problem starts in ADP form, I remove all Access default connection for DAO, and changed them to ADODB recordset etc in codes. The main form is bound to a huge table 'tblSOF' with more than 250,000 records. There...
  11. Khalid_Afridi

    Access Project - ADP (subform)

    Hello Friends, I am in process to upsize Access 2010 database to SQL Server 2008R2. The This was a back-end database on network and was linked to some front end applications, now as database become HUGE and the users increased the database need to transfer to SQL server. Database is up-sized...
  12. Khalid_Afridi

    Ohh Agnieszka :) Good Evening! How are you, how's your study and lab going on. Me too busy in...

    Ohh Agnieszka :) Good Evening! How are you, how's your study and lab going on. Me too busy in Exam :( and I came here after one year I believe. I will search you on FB, my FB id si "Khalid Afridi" lets see how we meet there :) Take care
  13. Khalid_Afridi

    How to resolve Error 3043 (Re-link all the tables automatically)

    Thanks JHB and David, Yeah that what I need, I want to run the code whenever the errors 3043 or 3044 occur. The problem is I have so many modules and forms and I don't know by the time which form is or module is running by which application? there should be a common place which should be opened...
  14. Khalid_Afridi

    How to resolve Error 3043 (Re-link all the tables automatically)

    Thanks JHB, My DB is connected to several applications (around 5) and more than 100 users each for different type of application. The company has a huge network, sometime it is overloaded and it get interrupts and disconnects. There is a module on each application which trig every 60 seconds...
  15. Khalid_Afridi

    How to resolve Error 3043 (Re-link all the tables automatically)

    Hi, guys I have a problem on a fe, be linked tables. I get Error 3043 whenever network disconnected. On fe application there is a module which fetches the network data every 60 seconds and have linked tables. I want to re-link the interrupted tables automatically without closing the...
Top Bottom