Recent content by saleem

I have a module in Access Data Project that convert number into words..this module works fine on one machine but gives error on other. The mssg it gives is: "Compile Error....Cant find the project or Library" Pl help me sort this out Thanks

Thanks DTurrall I too have reached this hard, long and teasing solution after a applying and trying each and evert thing...but this problem should have been addressed to Microsoft.. anyway thanks again

i created a front end in access keeping database on sql server and using ODBC for connection..but the front end has started giving following messages whenever i try to open anything... "Microsoft Visual Basic Error accessing file. Network connection may have been lost " can anyone help me...

Thanks PAT & Haytham i use sqlserver2k as back end to my access application. when i use unbound form it opens faster...i think u are not correct in saying that unbound form is not faster than bound.. Is there any way out...making unbound child form accept more than on entry

when i use bound form it become so slow...thats y i turn to unbound form..i m not inserting sub form data into code..no thats not the case..my problem is how to get fast performing master/child form ???

hi..i hav same type of problem...i check the "Compact on Close" checkbox on the General tab of the Access Tools/Options dialog box....but then it takes too long to close...i have a moduled that whenever run make and drop tables and generate report..i want to run compact whenever user run this...

When I try to link child form with master it says..cant build a link b/w unbound form. I manually inserted field name in ‘link child’ and ‘link master field’..but still sub form not accepting more than one entry…

got it....thanks

I m trying to insert record in table via following code on click event Private Sub Command8_Click() Dim conn As ADODB.Connection Set conn = CurrentProject.Connection conn.Execute "INSERT INTO master VALUES ( & forms!m!Text2& ", " & forms!m!text2& );" when i give values here directly the...

it doesnt work..let me tell u i have unbound master and detail form and i use event on click to insert data into master and sub table...

i have master and sub form that i use to enter data in two tables with one to many relationship..my problem is that the sub form does not accept more than one entry....any idea saleem

Try this Tools > Startup > Display database window (Uncheck) U can redisplay db window by pressing F11 Saleem

I ran macro in excel and it generate this code for page setting with 0.5 inch from each side...i need same code for my access report..can any one help Sub pgsetup() ' ' pgsetup Macro ' Macro recorded 01/21/2002 by saleem ' ' With ActiveSheet.PageSetup .PrintTitleRows = ""...

i m saving it Hick but its reverting back to 1" from each side instead of of i fixed..0.5" from each side !!!!

I tried both but none of the suggestion work. Is there sny other way?