Search results for query: *

I am trying to use the countif() function, however I need to specify 2 sets of criteria. Basically, I need to write something like =CountIf(A1:A20,"Apples" and "Oranges") I know what I wrote above wont work the way I have it, but is there anyway I can get the desired affect? Thanks.

I am trying to use vb code to specify a filter that a report is opened with. So strfilter is what I use in the docmd.openreport, however I can't figure out how the string is supposed to look. What I have is... strfilter = strfilter & " tblData.[RR DATE] BETWEEN 10/31/'&Me.txtFiscalYear-1&' AND...

I use this code to export a query that the user selects into excel. Private Sub btnSaveTo_Click() Dim FilePath1, FileNamePath1, Dataexport FilePath1 = LaunchCD(Me) strName = lstQuery.Column(0) If FilePath1 = "" Or IsNull(FilePath1) Then Else FileNamePath1 =...

Can anyone help me type this up right? The error I keep getting is "Error: Expected End of Statement" with the BETWEEN highlighted. Everything looks right to me, but I'm not very good with VBA. Thanks for any help. DoCmd.OpenReport Me.lstReport, acViewPreview, , tblData.[GC DATE] BETWEEN Now()...

I am using code that to fill the rowsource of a listbox, however 2 of the fields that I am using are comboboxes that pull their lists from another table. So when the listbox displays it shows ID value rather than the value selected from the table. How would I set up the listbox to display other...

Is there any way to export a form into Excel, and automatically format it a certain way? Or export 3 or 4 reports into one excel file as separate worksheets? Thanks for any help.

I am trying to find a way to automatically show the grade if the score is entered. So the fields name is SCORE and say if it is a number 0-24 it a field named GRADE will say "Fail" and 25-35 will say "D", so on and so forth. Any help would be appreciated. Thanks.

I have a continous form with a few Count fields in the form footer. When I filter the form, it recalculates fine, however when I remove the filter it #Errors out all those fields I use at the bottom to make calculations. Any way around this?

Is it possible to give users the ability to make changes to a table with the forms, but make them unable to open the table itself? There are a few fields that I dont want anyone but myself able to make any changes to, and if there is a way to do that without having to setup another relationship...

I have a field that lists every record with a number as the primary key. Example 1: ID Record 1 1 2 2 3 3 How would I add a new record in there without overwriting anything and making the old records just drop down a number? Example 2: ID Record 1 1 2 New record 3 2 4 3...

I am having trouble with some links that are setup in an excel spreadsheet to open picture files. When you click on the links it pops up with a registry entry saying microsoft photo editor has no registry entry. But even when I uninstalled and reinstalled the photo editor it didn't work. And...

I have a database set up on a network server. Its not split up or anything, just some basic user level security. My problem is when I need to create a new report or change the table I need to have the other users all logout. Is it possible to administratively log them out of the database?

I ran the User-Level Security Wizard and created the secured workgroup file, and I have a database in a shared folder. However, how do I ensure that the users that access the database have the joined the same workgroup file? Everytime I open the database it requires me to put in a password, but...

I created a database with user level security, however, now every time I try to open any access file, it asks for a username and password. Even ones that I did not want to have any security on. Why did it do this?

What is the best way to make updates to a form in Access when there are other users updating the database? Just wondering if there is a way to do that without the people currently making changes losing the changes they've made? Thanks for your help.

I am trying to link a table to an excel spreadsheet, but some of the fields it automatically assigns them the data type number, when they need to be text. as a result it shows a #NUM! for that entire field. and access wont let me change the data type in design view. I am at a loss. Can anyone...

is it possible to have a count function that counts all values that are greater than 2, but rather than excluding the values that are less than 2 from the query, have them show up as zeros?

rather than use ascending or descending order in a report, can i create my own order to display records? i need to show a list in a certain order not, alphabetically. thanks

is it possible to do this? and how would you setup the report? thanks

Is it possible to import a spreadsheet from excel as a query, and then have the query update a table based off of the primary key? Or maybe there is an easier way, I just need to get some data from a spreadsheet into a table that I already have created, without losing any of the data thats...