Search results

I currently have two forms: frmE_SAFind and frmE_SAOrderDataEntry frmE_SAFind shows results from a query including fields [txtIDPO] and [dtmDate] Example: btnOpnFrm IDPO Date btnOpnFrm 6543 2/1/05 btnOpnFrm 5681 1/1/05 frmE_SAOrder shows order details including [txtIDPO] and [dtmDate] I have...

I currently have two forms: frmE_SAFind and frmE_SAOrder frmE_SAFind shows results from a query including fields [txtIDPO] and [dtmDate] Example: IDPO Date btnOpnFrm 6543 2/1/05 btnOpnFrm 5681 1/1/05 frmE_SAOrder shows order details...

Count query needs to return "0" I am having trouble with my totals queries and their ability to show a zero value. -I am trying to query up totals for a my table: [tblCS_CT]. -I have two queries set up: [qryCS_CTMiss] & [qryCS_CTTotal]. -These two queries are linked to [qryCS_CTQueryDate]...

Do all of my users need access to view my data access pages?

ok that sounds good, is there a way for me to set up a print button that will set printed to yes and the dtmdateprinted field to date() once the print button has been pressed?

I currently have a form [order] that houses a subform [orderdetails]. is there a way for me to set up a print button on form [order] that will also update the [ysnPrinted] and [dtmDatePrinted] fields in subform [orderdetails]?

Am I correct in assuming then that time cannot be a calculated number if the number is greater than 24 hours? Thanks for the clarification!

DateDiff() Function Well since that worked so beatifully, I thought I would ask for more.. hehe I was wondering if it is possible to get the total difference in times [dtmEnd]-[dtmStart] to return the value in the format of HH:MM where I am able to sum up a total of the values to get a grand...

left() of decimal(.) yes the fields are set up as dtmfields

I currently have a calculation that takes a user driven start and end time[dtmStart] and [dtmEnd] and creates a calculated time frame ((dtmEnd-dtmStart)*60*24 AS [Minutes]) that returns the total number of minutes in between the two times. My next step converts the number into hours...

One of my co-workers had mentioned how they would like to see mobile integration with my database. Is it possible for me to work with access so that it will allow users to enter data into a palm pilot and sync the data to the database? Thanks for your comments!

Is there a way for me to set up my preview report buttons to pull up the reports in full screen mode so that the window is maximized instead of just a small portion of the screen? Thanks!

I have an existing report that shows me the following items(not exact names): Date, Tank, Beginning Gauge, Ending Gauge, Difference, Out of Range I currently have the db querying a list of records by date showing me the difference between the beginning gauge and the ending gauge. If the...

I have an existing database that has records tracking tanks that have been cleaned by date and shift. The way I have it set up now is a query calculates which tanks were cleaned on time and which tanks were cleaned later than policy suggests. Is there a way for me to query a count of how many...

Conversion to 97 Can someone convert and repost this access 2000 file as an Access 97 file? Thanks!

Here is my query: SELECT IDTank, MAX(dtmDate), ysnSterilized, ysnDetartrate From tblCleaned; This query is not returning only the records of my MAX(dtmDate) function. How do I enable the query to show the sterlized and detartrate information from the check boxes without including old records...

Resources You might try taking a look at Microsoft Access 2003 Inside Out. Its not a bad book at all. Its a lot of reading, but if you already have a good understanding of certain areas of Access you can use it to pin point specific problems like queries.. or reports for example.

How is the access developer version different from the professional version?

I am fairly new to the concept, so bear with me. I am attempting to create a database application that runs just like any other executable. Is it possible for me to create my user interface and have users access the database with my own toolbars and graphics without the user actually owning a...

One of my co-workers had mentioned how they would like to see mobile integration with my database. Is it possible for me to work with access so that it will allow users to enter data into a palm pilot and sync the data to the database? Thanks for your comments!