Search results for query: *

I have a main form and subfrom in it. When I go for new record in subform, enter data in subform, I also have to put value of Device_ID which i already selected from comboBox in mainform. So I want Device_ID feild in subform should have the default value,no need to write.The following code...

Creating a form, I have made serveral group boxes, how do get these boxes to not interact with one and other. Group 1 = Yes No Group 2 Lost Damaged Obsolete Group 3 New Used Rebuild I want to click one option in each...

Hi All I am looking for bullets/Numbering in Excel. Please tell me how can I find it. Thanks in Advance

Hi All, Is there any way to make invisible/hide A,B,C written in sheet.In the same way Rownames like(1,2,3,.....).I dont want to be visible. Any suggestion is most appreciated.

Hi guys, I am working on excel very first time. So need guidness. Actually what I am trying to do is ,I want to send data which is accessible through textboxes by clicking button in my table of AccessDB. So what is the connection string or what is the procedure of sending data,looks as excel...

Is there any tab control in Excel .Any idea?

Is there any tab control in Excel or Sheets are used in its replace.Any idea?

Hi All I have this code working fine in Access2002. But giving error on 'AddItem property' in Access97.Because it doesnt support it in Access97. Through my search on net,i realize that recordsource is used by replacing it.So please help me out how to resolve it. Private Sub...

hi All I have made my .mdb and .mde file in Access2002 SP3 format for users. But now i came to know that users have Access97 on there PCs. What should I do or what is the solution because neither .mdb nor mde file is running on there PCs. Any help will be greatly appreciated.

Hi all, http://www.mvps.org/access/forms/frm0031.htm This is helpful link for refering controls whether you are on mainform,subform1 or subform2 ....

Hi All, I have stuck in great trouble. When I click on command button to view Query which selects StoreNo from List.It works fine if some stores selected.But when I select round about 300 stores from list,it gives runtime error:3360 'query is too complex '.Following is code. Private Sub...

I want to show date on the Form.For this I made controlsource property of textbox =Date().But the problem is whenever user clicks over it,it gets focus(blinking cursor on it).Where I want that it should not get focus and behave like label. I think you got my point.Any suggestion is most appre...

Hi All, Is there any way to secure tables from users. So that they cannot be able to make any change directly into it,only through forms. In my Db All forms open maximise but on minimise,User is able to see tables,reports,forms. Any suggestions please.

I converted my .mdb file into mde file.Users are using that .mde file and entering data through forms into tables. Now that tables have most recent data. The problem is if somehow that .mde is crashed or mishandled by someone so how I can recover those tables.Can i ever convert .mde file again...

I have excel sheet and I want to change its view. To make rows as columns.Like Sr. 1 2 name Keyboard Scanner type w/y mn model 0021 3256 Into Sr. name Type model 1 Keyboard w/y 0021 2 Scanner mn 3256...

When I uncheck 'Menu Bar' from Tools-->Customize-->Toolbar.It doesnt so. Why? Is it possible to do so.

Actually the following code was working excellent and meet my criteria. CurrentDb.QueryDefs("Query2").SQL = "SELECT " & strList & " from Store_t where " & GetCriteria() DoCmd.OpenQuery "Query2", acViewPreview, acReadOnly But this query opens behind all the forms.So that i cannot see it.I want...

I am getting error "The report name 'rptStore' you entered is mispelled or refer to a report that isnt open or doesnt exist." So please tell me should I make the report through wizard or design view.How should be the report.Why its giving error? CurrentDb.QueryDefs("Query2").SQL = "SELECT...

I have this code. Which modifies Query2 and then open it in preview format. I want to make this query datasource of a report. I want to show this modifies query through report.Is it possible CurrentDb.QueryDefs("Query2").SQL = "SELECT " & strList & " from Store_t where " & GetCriteria()...

In my Access Database,I made my Startup Form the first form to be appear and is maximized.I did this through Startup option. Startup form is switch board. I only want to know that when user clicks on .mdb database file,he sees that switchboard (Startup)form first. In this way is my VB code is...