Search results

hi all i am new to access.I have a continous form with lots of coloumns.Is there a maximum size defined by access . I checked this on the forms properties ..its showing the width for the form as 22".i tried to increase this but everytime it sets to this value. Is there any way i can do...

any help on this pls?waited patiently for all the day.

rtnconnection is the connection string.Its defined in the global Module of my Project. The problem is in passing the parameters to the stored procedure.I checked this.If the SP is expecting params in varchar and from the code if i supplies the params like this- Set prm1 =...

Hi, I am calling a stored procedure..through vb.SP expects 2 parameters. but i m getting error "operation cannot be performed when the object is closed".This is the code Dim db1 As ADODB.Connection Dim cmd1 As ADODB.Command Dim prm1 As ADODB.Parameter Dim prm2 As ADODB.Parameter...

hi all, i have a adp project with backend as SQL server 2000.I have some queries.Today i made a new query but when i am executing it from access its saying that stored procedure executed sucessfully but didnot return any results. I cant execute the same sp an the Query Analyzer and its...

hi all, i m new to access reports.I have created a report using report wizard.Its fetching data from a stored procedure. Actually it has large no. of coloumns but the report is only showing 4 cols ,the rest are going to the next page. I looked for the properties where i can set the page size...

I wud also like to do this and i asked this question before.Pat replied that we can do this using the datasheetview which i dont want to use.

if u join two tables to make a view and then specify it as a record source for the form then u can only update the records as long as u r only updating one table.U cant update the both tables at the same time. Regarding the auto fill u can try some VBA Code in the after update of the combo box.

hi all, i m new to the access forms and the users for sytems are very used to excel for recording their data so they come up demanding the features which excel have. so in the excel when there are lot of columns u can freeze the coloumns so the coloumns will be visible to u when u move to the...

Thanks ..that works i have tested it. but i have a question.On the save button of the subform i m exiting the save sub if the checks are not satisfied. when i call the subform save sub from the main form save sub.It displays me the message but then docmd.saverecord gets executed. well i also...

well i m beginner in access.Thanks for all the replies but sorry its not solving my problem. I have main form with the save button and also the sub form with the save buton.so i have applied the mandatory checks for the controls of the subform on the click of the sub form save button. But the...

hi all, How can i access the controls of the subform in the mainform.I m using access 2k. I m using this syntax [forms]![formname]!contolname.but its saying that access cant find the form referred in the code. Thanks

got it,i m deleting the first record on the forms before_update event. thanks

thanks rich,that works but actually its not solving my problem..sorry i didnt explain it correctly first. Actually i m creating a workflow for 2 groups so on grp A screen user clicks on a checkbox to send the request to the grp B.The it appears on the tasklist of the grp B.but the grp B can...

hi all, i have a continous form as a subform.I want users to edit this only if there is a particular value in a one textbox..say if textbox has value "A" user can edit it else he is not allowed to edit it. so if i write code on the page load whenever it finds a value A it makes all the rows...

write code in the after update of the the employee name control that will fetch the dept of the specified employee and assign it to the dept textbox.

Thanks Pat for ur advice.I searched this forum from google too.

Thanks, No the buttons are on the subform.Yes i m using new version of access. any solutions for the second questions also??

Hi all, I m new to access.I have a subform that is bind to a datatabel.I have provided buuton add and undo record to the user. On the click of the add button i have written this code. On Error GoTo Err_cmdAdd_Click ' Save any existing changes DoCmd.DoMenuItem acFormBar...

Thanks Pat..appreciate ur help.I checked that site also.he is changing the backcolour of the entire row on the basis of the current record.But i need to change the col depending on the values of a particular textbox. The last u sent to me is ok but the only problem is that it changes the...