Search results

try this http://support.microsoft.com/default.aspx?scid=kb;en-us;161007

try something like If Me.Leased = True OR Me.Leased = False Then PropSearchstr = PropSearchstr & " AND [Leased]= " & Me!Leased Forms![PropertySpaceSearch]![PropertyList].Form.Filter = PropSearchstr Forms![PropertySpaceSearch]![PropertyList].Form.FilterOn = True DoCmd.Requery ("PropertyList")...

not sure if any objects in that code are a yes/no field, but refer to the values of a yes/no field in code as True / False eg If Me.YesNo = True Then MsgBox "Yes" Else MsgBox "No" End If

try this site http://www.microsoft.com/sql/techinfo/deployment/70/msdejet.asp?LN=en-gb&gssnb=1

set the Required property to yes for the fields that are compulsary

thats got it, ta

no the Me!StartDate is a combo box with the DateID field as it's root which is a number.

I am working on creating a holiday booking database, and am currently trying to get the form to look and see if a person has booked a certain day already. I am using findfirst but it's not going quite how I wanted. this is the part of the code I'm having trouble with StrStaffSearch =...

Thanks Pat, the process now takes 30 mins for 24000 records. The reason it's stored is because this database will not be for any users, it simply generates a table which is then exported to another machine which is incapable of doing this calculation (it was originally intended to, but they no...

ta

is there an easy way to delete duplicates from a table?

there's always one :p it means Previous Cumulative

I'll give that a try, might take a while as I've done only very basic SQL queries before. Thanks for the tips

the updated is a Y/N flag just for the code to identify that that record has been done, and is reset when the code is finished ready for the next set of code. the code is basically for a calculation - information for a current week + information from a previous week for the same product from...

try lblName.Caption = IIf(IsNull([LastName]), "", "Member: " & [LastName] & "," & [FirstName])

I have been working on a database and have set a loop to calculate a value based on imported information. The problem is, when testing with basic information, the process took 2 minutes to run through the 1100 records and do the calculation, I now have some more data to 'play' with and it...

you need to put it in the target field in the shortcut, so it should look something like this "C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" "\\Glidalnt06\field\MD OPS\GM SPO\Container Database.mdb" /wrkgrp "\\Glidalnt06\field\MD OPS\GM SPO\System.mdw" I have C:\Program Files\Microsoft...

you could use the Left function if the length of data in the field is consistant e.g Left([FieldName],5) would return the first 5 characters from the field

copy the mdw file to the server, and set a shortcut to the database on peoples computers that look at this file e.g "C:\PROGRAM\Microsoft Office\Office\MSACCESS.EXE" "Database Path\database.mdb" /wrkgrp "MDW Path\security.mdw"

try checking the security settings, the error executing command message comes up when access security is set up so that user can't get in that item