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 Rhinorhino 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: RonnieDobbs
  • Content: Threads
  • Order by date
  1. RonnieDobbs

    Criteria Help - WHERE, IF, AND, or OR?

    Hello, I have imported an excel spreadsheet into Access and I am looking to create reports based on this one sheet, (one table in Access) Data is results from a survey. So basically people are asked who much they know about something, 1 is expert, 2 average, 3 need help. I want to get...
  2. RonnieDobbs

    Query to show typed in name, could have duplicates.

    I am looking to run a query to display's ALL companies with a certain word in it. To clarify, I have criteria which asks for the company name to be dispalyed. If I have names in my table like Blue Inc., Blue Tooth, Blue chemicals, etc.... I want all of these companies to be displayed if I type...
  3. RonnieDobbs

    Pull record info from subform to form

    I would like a form which has a combo box that searches for company information by name. For instance if I type in blue, company's like blue tech, blue tech AG, blue tech OY, etc..., are brought up a list in a subform. Thats not the problem. What I am wondering is, when the list of companies...
  4. RonnieDobbs

    Required text code in form's Before Update NOT WORKING properly

    Hello I have the following code in my forms before update in order to check if there is text in the field: If IsNull(Confirmed) Then MsgBox "Data is required." Confirmed.SetFocus Cancel = True End If However, when I exit my form via the close form button, a message says: "data...
  5. RonnieDobbs

    Required text code in form's Before Update NOT WORKING

    Hello I have the following code in my forms before update in order to check if there is text in the field: If IsNull(Confirmed) Then MsgBox "Data is required." Confirmed.SetFocus Cancel = True End If However, when I exit my form via the close form button, a message says: "data...
  6. RonnieDobbs

    Required text Macro at completion of form.

    I have a form that should be fully completed by an employee. At the end of the form the final step is selecting, by combo box, whether an assignment is confirmed or not. I am wondering if it is possible, when an employee selects "yes" in the confirmed combo box, to have a macro that will check...
  7. RonnieDobbs

    msgbox for yes/no combo box.

    I know this is elementary but I am trying to get a message box to appear when a user selects yes. I have tried: If (controlsourcename) = "yes" Then MsgBox "Do you need approval?" End If i have placed in after update....what am i doing wrong? be nice, thanks! ab
  8. RonnieDobbs

    Any ideas??? Continuous fixed fields in row...

    Not quite sure how one might do this but I thought I would post to see if anyone had any ideas. Basically there are 4 people who rotate passing or failing assignments. They go in the same order every day when the assignments come in. Now, we have the assignment numbers in different colours...
  9. RonnieDobbs

    User Level Security trouble on a shared P Drive...

    I have an Access 2000 database set up on a public drive at work where many users can use at the same time. I tried user level security setting up with just myself as the administrator. It gave me a shortcut to the database on the desktop, and works just fine. My question is how do I set up...
  10. RonnieDobbs

    Trouble with user level on shared p drive

    I have a database set up on a p drive at work where many users can use at the same time. I tried user level security setting up with just myself as the administrator. It gave me a shortcut to the database on the desktop, and works just fine. My question is how do I set up other users within...
  11. RonnieDobbs

    SQL date parameter

    Would anyone know how to put a date parameter in this??? SELECT [Confirm].[ID], [Confirm].[Fees], [Confirm].[Offlimits], [Confirm].[Office] FROM Confirm WHERE ((([Confirm].[Fees])='Non-Standard') And (([Confirm].[Offlimits]) In ('std','none'))) UNION SELECT [Confirm].[ID], [Confirm].[Fees]...
  12. RonnieDobbs

    SQL date parameter syntax

    I have a select/where query with a few different conditions. I would like to have this query pull info between two entered dates. In normal design view in a query you would add Between [Enter Start Date] And [Enter Ending Date]. How would you put this as SQL? thanks, ab
  13. RonnieDobbs

    Select Query Problems!!!

    Ideally this query should pull only "non-standard" from fees and only "std" or "none" from offlimits. However this is not the case. I tested this and altered a record in the one table this query is based on. I put "Blah" in the fees and "none" in the offlimits. the query picked it up? Why...
  14. RonnieDobbs

    Calculation on Report from huge query

    First off, I am new to this site and I think I am asking the same thing in differnt ways. I hope this is clearer: I have a query from one table which gathers office names, fee, off limits and ID of certain assignments. From this I have made a report, which looks like the folowing:(query looks...
  15. RonnieDobbs

    Sub Report from Multiple Reports --- HELP, (please)

    I was wondering if you can create a subreport that pulls sums from multiple reports. All four reports pull from the same table. Basically I have four reports that query assingment terms, (standard fee, non-standard fee, Off limits,no offlimits, ect....) I have totaled these by office on each...
  16. RonnieDobbs

    Multiple Table/duplicate record query

    I have several tables that deal statuses of assignments. A form for each of these tables allow users to enter statuses off assignments. I would like to run a query to browse through these tables and pull information. Example: An assignment, with its own unique ID, could have been on hold...
  17. RonnieDobbs

    Back End table editing on a secured split DB

    Hello- Access 2000, I was messing around with a backup DB trying to work out User Level security. I am the Admin and should have access to modify table formats. Where can I do that??? User Level security works fine. The front end obviously I can't change table format and the back end turned...
  18. RonnieDobbs

    Back End table editing on a secured split DB

    Hello- I was messing around with a backup DB trying to work out User Level security. I am the Admin and should have access to modify table formats. Where can I do that??? User Level security works fine. The front end obviously I can't change table format and the back end turned into a...
  19. RonnieDobbs

    !!!! Mouse wheel scroll code for two forms !!!

    Hello, all! Just let me say that this site again, is amazing. Secondly, I have used the following link from a thread on this site, http://support.microsoft.com/default.aspx?scid=kb;... to prevent the mouse wheel form scrolling through records. I have the code in one form and want to use it...
  20. RonnieDobbs

    Mouse wheel scroll code for two forms

    Hello, all! Just let me say that this site again, is amazing. Secondly, I have used the following link from a thread on this site, http://support.microsoft.com/default.aspx?scid=kb;en-us;278379 to prevent the mouse wheel form scrolling through records. I have the code in one form and want...

Part and Inventory Search

Back
Top