Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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