Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: yummy7
  • Content: Threads
  • Order by date
  1. yummy7

    Default value in Subform

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

    Option Buttons in Excel2002

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

    Bullets in Excel ?

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

    How to make invisible Columns(A,B,C,......)

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

    Sending data fron Excell to Access DB

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

    Tab Control in Excel?

    Is there any tab control in Excel .Any idea?
  7. yummy7

    Tab Control in Excel?

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

    .AddItem property in MSAccess97?

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

    Opening Access2002 mde file in Access97?

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

    How to refer controls whether you are on Main/subform

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

    RunTime Error: 3360

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

    How to set date on Form

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

    Securing Tables

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

    How to secure data when Db is in.mde format

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

    Excel File

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

    Menu bar is not disappearing

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

    set focus on Query

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

    Not showing report

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

    To open report through Query

    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()...
  20. yummy7

    Is my Database secure?

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

Part and Inventory Search

Back
Top