Search results

Essentially the only entries affected by the weekend hours are those entered on Wednesday, Thursday or Friday so the following should provide what you need. Use the following where clause WHERE (((((Now()-[user_time])*24)-(IIf(Format([user_time],"ddd") In ('Wed','Thu','Fri'),48,0)))>=72)) or...

I am in the process of building a stand-alone version of our company's quotation package for distribution to our sales force. The system currently reads the required data from an internal Oracle database but I am changing it to read from an Access database. The issue I want to solve is that the...

I use the following module to get computer ID, user name, user full name, IP address, etc using API. HIH. Option Compare Database Option Explicit Declare Function wu_WNetGetUser Lib "advapi32.dll" Alias "GetUserNameA" (ByVal sUser As String, nBuffer As Long) As Long Declare Function...

You need to make the changes to the table first, then open the form and the new fields should appear for selection in the control source property.

To do what you ask would require the use of an update query to recalculate the balance but overall your current design may not be best suited to the situation. UPDATE YOURTABLE SET Balance = Balance + iif(TransactionType = 1,TransactionAmount, TransactionAmount * -1) Possible Better Design...

Generally to reset the auto-numbering you need to empty the table and then compact the database. The compacting generally resets the autonumber to start from 1.

You could use the InStr function to check if the required string is contained in the tag. See the Access help file for details on the Instr function.

You need to remove the quotations from around the [Forms]![School]![ClassCombo], otherwise you are asking the SQL to return all records where ClassID equals a string of [Forms]![School]![ClassCombo] rather than taking the value from the combobox.

You need to check if the Absence_Reason is null as follows ISNull(ABSENCE_REASON) OR ABSENCE_REASON=""

Do a search on the internet for Scheduled Tasks, it is an in-built functionality of Windows so Microsoft might be a good place to start looking. A sample of instructions from Microsoft is http://support.microsoft.com/default.aspx?scid=kb;en-us;308569&sd=tech

Look up randomize and Rnd in your help file, the following formula should give you what you need, a number between 1 and 99,999,999 with leading zeros. format(((99999999 * Rnd) + 1),"00000000")

You can use the DataEntry property of the openform method in code to set the form to open for adding data only, this will stop it displaying any current records. You then need to set the values of the employeeID to the value from the opening form, and lock this field so the user cannot overtype...

You can use Scheduled Tasks on a PC to open an Access database to run whatever needs to run. You will need to build the db to automatically run the required code either through the startup or a macro.

Just a few things first 1) The invoice you provided in your sample database is not properly defined for your tables, it is still using the tables from the 'Order Entry' database. You will first need to substitute the Order and Order Details tables with your Quote and QuoteDetails tables and...

Check out this post for details on hiding the Access background so the form appears against the desktop. http://www.access-programmers.co.uk/forums/showthread.php?t=100545

You need to use the Len function in the query as below SELECT * FROM YourTableName WHERE Len(YourFieldName) = 10;

Not sure if it's what you mean but will a group query taking the max of the date field not work. SELECT YourIDField, Max(YourDateField) AS MaxDate FROM YourTableName GROUP BY YourIDField;

Check out the bookmark property in the access help, should do what you want. See extract below. To test the following example with the Northwind sample database, you need to add a command button named cmdFindContactName to the Suppliers form, and then add the following code to the button's...

Try changing your stLinkCriteria to stLinkCriteria = "Year([OpenDate]) =" & Me![NCRYear]

Assuming you are dealing with a defined number of slots for each day then the following would be a way to achieve what you are looking for. Thus if you have x slots the assumption is that you will see only x customers per day. Doing Manually for small number of fixed slots Create a table with...