Search results

The stCriteria for the Between should not contain an =. It should read stCriteria = "[JobCodeDept] BETWEEN [cbxBegDept] And [cbxEndDept]"

Not exactly the format you are looking for but it'll give you something to work from ="Quarter " & DatePart("q",Date()) & " " & Year(Date()) This would give you 'Quarter 4 2002' for today. Put it in for default value and the value will set for all new records as for the date you are adding...

You could use a query to format your data to the required format and then export the query to get correct export file. You can use the following functions to add leading or trailing &'s as required. TrailingPad([YourFieldName],"&",YourRequiredLength) Using it on the field containing the names...

The OnChange event will only be called if you actually set the Text property of the field you are setting. Few things to note, the text box has to be enabled and visible and it has to have the focus to use the text property to set the value. The following code would work...

Create a Totals/Group query, put in your field, select 'Sum' from the group by line and this should give you a total for all records in the table. You can set criteria to filter so you get sums for only specific groups of records.

Try creating a new database and importing the tables one at a time. This will either work or should identify the table that is causing the error and may help you to fix the problem. If the imports work then just import all items from the old database and you should have a copy which should be...

If you have an intranet that all employees can access then you could develop ASP pages to allow users access their details and update them directly.

You need to call your second macro to set visibility from the OnChange event of your text field on the form. See help under 'OnChange'.

All you need to do is create the macro and enter the following lines SetWarnings No OpenQuery Query Name - YourQueryName, View - Datasheet, Data Mode - Edit Repeat the OpenQuery for eahc query you require in the specific order you require SetWarnings Yes The SetWarnings is used to stop the...

Build a TopValues query to place behind the report. See the help file for 'TopValues'.

Check the following posts http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=31031&highlight=explorer http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=10478&highlight=explorer

Set the default value to Date()

Put code behind the button to use the OpenReport method to open the report with a where condition to open to just the record you want. See the help file under OpenReport Method.

Check help for StrConv.

Try http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q193207&

Check this out http://board.quicktechusa.com/cgi-bin/ultimatebb.cgi?ubb=get_topic;f=1;t=002456

I have never heard of there being a limit of 1000 records in a table, it wouldn't be much use as a database if there was. In fact I have a table which has about 8 million records and although a bit slow to work with have no other problems with it. If you want to check details of Access's...

Try SELECT Amb_id, Location, IIf([amb1_time ]<=[amb2_time] And [amb1_time]<=[amb3_time],[amb1_time],IIf([amb2_time]<=[amb1_time] And [amb2_time]<=[uttr3],[amb2_time],IIf([amb3_time]<=[amb1_time] And [amb3_time]<=[amb2_time],[amb3_time]))) AS min_callout_time FROM YourTableName;

Assuming the text file you are referring to is a fixed width file which is essentially a flat file of a table that you want to import into Access then the Import Specifications in Access should suit your requirements. Open the database and select File / Get External Data / Import. This will...

The following should do what you require: Function LastBusDay(D As Variant) As Variant ' Returns the date of the last business day (Mon - Fri) in a month Dim D2 As Variant If VarType(D) <> 7 Then LastBusDay = Null Else D2 = DateSerial(Year(D), Month(D) + 1, 0) Do While...