Search results for query: *

We have a database that is on a server with four users two users have read/write/update permission and the other two have only read permission to it. Depending who accesses the DB first all other users get the "The database 'xxx' is read-only" message. Anyone have any ideas why? Any help...

I have a database with requests from customers. When a new request is needed I have it that you view the customers make sure they are in the table in form (Schcustomer) from that point you select which customer the request is for by clicking a button next to record that brings up all information...

Could someone help me on using the “Like” expression against a text field that contains Roman Numerals (I, II, III, & IV)? When I use the “Like” expression for example (I) it selects all records and that’s because it does match the other numbers. But I would like to run this query if this field...

Could someone help me use the “ActiveX Datepicker” to pass date to a query to select records based on the date selected? Thanks in advance.

Could someone help me on setting a default value on an unbound textbox? Thanks in advance.

I enter text into an unbound control on a form that is referred to in the criteria section of a query. And from this, I can change the criteria of the query each time.The name of the control on the form (called Formtype) is Controlname. And I refer to this control in the criteria section of the...

I have both a start time and finish time, in my table define as date & time. I would like to calculate the amount of time between the 2 fields in minutes; I used the “datediff” MIN: DateDiff("n",[Table1]![strTime],[Table1]![endTime]) and it works great when my time runs over the 24...

Not sure what to do new to access and where do you put the code. I want to validate two fields on my form but only one need to have data. For example if (field1 is blank and field2 is blank) send a message “field1 or field2 must have data” else one of them have data which is ok. Thanks in...

I want to select records between certain dates. If I place the dates in the criteria section it works great. But what I would like to do is have a table with one record and two fields fromdate and todate. I changed my criteria to look like Between [table]![fromdate] and [table]![todate] this...

I’m new to Crystal Reports but with some help and guidance I might be able to do this. I need to create a statistical summary report based on monthly records stored in an Access database. In the table are these fields. DATE CATEGORY (Only 2) PROCEDURES (10 types) OTHER PROCEDURES...

This date field is coming from an AS/400 file the field type is numeric the length is 6 with out leading zeros for single digit months (EX. “12111” mmddyy) when viewing this field with CR it looks like this “12,111” I would like to be able to format it like “01/11/11” mmddyy. If anybody can...