Search results

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

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

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

Hi Every one! Happy New Year to everyone & Happy Birthday to me :) May Allah Bless all of you. May Allah fills your lives with success prosperity, sound health, wealth and lot of joys. May this year brings peace all over the world. (Ameen) I found lot of good friends in this forum, They are...

Hi everyone! I want to fill local tables in some application with disconnected recordset. The tables in the front end application having the same table structure as in the back end database. The front end application was linked with the back end password protected database tables. I want no...

Okay Guys, the scenario is: I have linked tables front end application running on network drive. The data is becoming huge and the users are becoming more, as a result the application become slower. Now, It has been decided to get the necessary tables data in a local tables when application...

Hi folk, Does anybody knows how to control the the below msg to something like this through VBA: "The Item: " & ItemNo & " already exists in the table." instead of this: Msg: "The changes you requested to the table were not successful because they would create duplicate values in the index...

Hi guys! I have invalid password issue with MakeTable Query Statement in (linked database) on the Network. I have created a MakeTable query which inserts records based on the criteria and creates a table in a linked database on the network drive. This was working fine in Access 2007 and earlier...

Hi Friends! Anybody knows how to Disable X button on a Form with win64bit configuration (API call)? The following API call is not working with 64 bit. Option Explicit Private Declare Function GetSystemMenu Lib "user32" _ (ByVal hwnd As Long, _ ByVal bRevert As Long) As Long ...

Compacting and recovering of Access-2007 database with Access-2010 format gives ridicules results. The Auto numbers seeds drop below the next seed numbers and give duplicate error, no new record can be Added to the effected table. See this Thread...

Dear All, We recently upgrade all the computers in our office from 32bit to 64bit configuration. From - To Windows XP - Windows 7 Office 2007 - Office 2010 Our back-end database is in 2007 format, while front end we upgraded to 2010 format in order to make it compatible with 64bit...

Hi! Two Questions! 1) Is it possible to create triggers in MS-Access? OR is it possible to record the system table's behaviour for insert,update and delete actions. 2) Is it possible to record the user's name/machine number if he/she made access to DATABASE window?

How do you do this? In a textbox1 if: 1. text length > 150 – including spacing 2. go to the 150th character 3. copy all the text starting from character 1 to 150 4. put them in a variable ‘txtText' 5. start from 151th character in the textbox till next 150th character 6. concatenate them with...

Hi Guys! Anybody knows how to clear the table links and re-esteblish them on Runtime? Regards

Hi Every One! I have linked database on network with be and fe distributed applications. There is a function which checks for certain activity on the form timer Event and Updates the be. Sometime Application gets the 3043 Error saying that there is network problem and that database needs to...

Hi All! Should we use Me. or Me! which one is prefferable? Thanks

Hi Every one! I get zero values while approving work orders? I don’t know where is the bug? The code is based on some queries which put back the total value of the issued items on the subform to a field on the main form. The field on the main form gets zero values some times. (not the...

Hi, I want to allow domain users to access a shared folder on a windows server 2003 using its local users as Impersonate User Account to access accdb database containing linked tables from that shared folder. the server 2003 is not a member of our domain. so i have created a local user which...

Hi Friendz! I have back-end database on Local Network, around 50 users are directly connected to the back end database from their front end applications. Sometime the server is too busy to pull the data and the application processing becomes very much slow and data get corrupt. I decided to...

Hi Friends! I have written the following code to backup my Database automatically everyday after 03:00pm on timer event. Sub BackupDatabase() On Error GoTo Err_Handler If Not bBacked Then If IsLoaded("Adminstrator_F") Then If Time() >= #3:00:00 PM# Then Call...