I setup a form that has a button on it that runs a form. How can I get that button to run the form, but display the results as a datasheet? If I click on...

I want to be able to change the sort order of a report by the user selecting the preferred order on a form. I referenced that form field in the order by...

Hello, Using an update query, I'd like to concatenate a field named , so that the end result looks like this: a href="". Looks like the quote character...

I am trying to delete all records from tbl_XXdata where the tbl_MSEmployees shows a leaving date against it. I have the following code but keep getting the...

Is it possible to convert military time to standard time. examples: 15.00 to 3:00:00 PM 16.30 to 4:30:00 PM 10.00 to 10:00...

I have a query that I have set up to return a date range of BETWEEN 6/11/09 and 7/10/09 - this query is run early in the month, in this case july. Next month,...

I have a crosstab query client activities with the activity type as the value. The crosstab is based on the following Table of open client activities(sample...

I have a report that is based on a query of two tables. It works great except I would like to include some criteria that make the report more useful. The...

Hello, I'd like to remove the last character of a field, which happens to be a "#", in an update query. Thanks for your help, Ellen

i have a passthrough query that pulls both text and numbers but when i try to create a crosstab query i can only get one or the other is there any way to get...

(Please forgive me.. I am a newbie) How do i? If is 3 and Now then return "Yes" If is 3 and Now OR blank then return "No"

I have a number field and I want to extract the digits to the left of the decimal point. So that 10.7 would be 10. I do not want to round up at all. How...

Good day all; Vista Business / Access 2007 I am trying to manipulate a string of data from a barcode scanner, which will then be appended to a table. The...

I'm running Access 2003. I am working on a database for our programmers so that they can find all code that is affected whenever they change a program. ...

Hi Guys, I have a invocing form with an option to apply a discount to each line item. This value has been setup to apply a value discount to the item...

Someone helped me out with a problem I had in the past to select records for the month and up until the 5th of the next month. The criteria I have set up...

Hello, I have a string that looks like this: §74.1321#http://ecfr.gpoaccess.gov/cgi/t/text/text-idx?c=ecfr...

Hi, I have a master table (Two column) with ProjectID as primary key and received date as second column. ProjectID Received...

Hello, I am using access 2007 at the moment. There is a table in the database I run several queries on, but one of them doesn't seem to return the correct...

Hi I have been trying to append from a flat file to several tables. I have deleted the relationships. However there are two tables where I can't remove the...