Search results for query: *

Hello. With regard to excel, in cell A1 I have a description of a product(SPAN2002 GR 1 SPANISH MATHEMATICS CALIFORNIA PUPILS EDITION) In cell A2 I would like to write a formula that would place the state inside cell A2. I've tried using the If function but can't seem to get it to work. Any...

Hello! If I have subtotal a spreadsheet in excel, can a code be created in order to allow a blank row to be placed each time the word total appears? This is a large spreadsheet with many various topics, therefore providing many "total's" throughout the spreadsheet. Can this be...

Disregard the above message Joe. It appears that I just needed to remove a bracket from the formula. The query works exactly the way I want it to!!! I owe you one. If you're ever in NY, drinks are on me! Regards FB

I tried the revised formula and a message pops up stating that this function contains the wrong number of arguments. Any suggestions? Will the new code allow only the selected units to sum while at the same time sum up each of the account #'s dollar amount. Thanks again FB

I tried the revised formual and a message pops up stating that this funtion contains the wrong number of arguments. Any suggestions? Will the new code allow only the selected units to sum while at the same time sum up each of the account #'s dollar amount. Thanks again FB

Thanks Joe for the help. The formla you've created is definitely what I've been looking for. Though, if you don't mind, I would need one more minor adjustment which will finally bring this matter to a close. On the query that you've sent, how would you alter the formula to allow AB12345...

In place of the existing code or underneath it? Joe would you mind if I sent you an unlinked database that's about 1/4 the size of the original? Thanks again FB

Joe, you have an enourmous amount of patience. Thank you! Below you'll find my initial inquiry. I hope I explained it well. If you had any idea how long it takes me to acquire the desired results, you'd understand why I'm in desperate need of assistance. Here it goes: Good morning. My...

Hello! If I send an excel file via email, how would I prevent someone from forwarding or copying that file to someone else? Can the code contain some type of username that only links to perhaps the receivers email, allowing only that person to open it? Any suggestions would be greatly...

Hello! Is there any way to add colors to Excel worksheet tabs? Cheers FB

Scotty, I don't see the relation between the form and the query. I was surprised myself that I was able to add a button to a form which would allow me to run the specified query from there. Problem is this, I simply click off forms and select Query and am right back where I started. I even...

Hey Scotty! Thanks for the response. I'm sure you've guessed by now that I'm new at Access. Here's the explanation: I left click on a column in my query, select the Build Icon and type in a code. Now, this file is to be shared with others; so how can I prevent someone from gaining access to...

I'm utilizing a shared file in which I want others to be able to run the query if necessary without gaining access to the code written in the query. I've tried all of MS Access security features along with disabling certain keyboard functions. When all is said and done, you can still expand...

Great, I fixed the problem. However I don't understand how I should implement the rest of this code: Select Region, Left([Acct#],7) As AcctNo, Sum([dollars]) As TotDollars From tbl Where Right([Acct#],1) In ("a", "c") Group By Region, Left([Acct#],7) If I'm appearing...

Hey Joe! Yes I am getting an error message upon running the query. Here it is! "The specified field '[Acct#]' could refer to more than one table listed the the FROM clause of your SQL statement." Any ideas? I posted it over here because I didn't want to keep bothering you...

Good morning. My initial description of the problem was incorrect which brings me back again with my dilemma. I’m almost there, so I just have a few more questions. I have a database consisting of 50,000+ lines of data, which are broken down into regions. e.g. East, West, Southwest.... and...

I forgot one thing. They can simply drag the column open and view it directly from the query screen. I want them to be able to run the query. I just don't want anyone to see the code. Thanks FB

I tried all of Ms Access Security fearures and although you can prevent others from modifying the query, if the appropriate column is selected, all they need to do is press Shift + F2 and they could view thew code. Any other suggestions? Regards FB

Thanks Joe for the response! This file is to be accessed by others via viewing and updating the database. Would I hinder anyone from utilizing this database if I changed it to a MDE file? Thanks Again FB

Hello to all! Is there any way to create a password in order to prevent others from viewing code that was utilized in a query? Thank You FB