Search results

Where have you put this? usually you would enter dates via a form control so would look something like: Dim strSQL As String strSQL = "SELECT * FROM tbla WHERE bDate Between #" & strDate & "# And #" & EndDate & "# " Then do what you want with strSQL. EDIT: Faster code slingers :)

Do the properties of the field in the table match those of that on the form as I tried the above with an unbound text box and got 23/03/2009 15:43:15 outputed so maybe the table field format is set to just 23/03/2009 (Date type) therefore cannot update? Just a thought good luck John

You could zip and attach here but tbh I only have access 2007 installed on my "test bed" machine which is at my partners so would be a while before I can look at generally use 2003 as most people I deal with are still on that version but someone else here may be able to help sooner... regards John

In the form properties you can disable the "X" close button and but a close form command button instead there are also tutorials around on how to prevent users from closing a form unless certain criteria have been met. Good luck - John

You could use a list box to display the data this would have scroll bars should the amount of data contained exceed its size.

Any chance you could post/attach a sample of your DB?

Do you just want to import the file location so the user can open the file or the actual "data" in the excel spreadsheet to a table in access?

Because on new record there is nothing for that code to do as a record has not been created yet I would imagine? try in the afterupdate of your first control/field might work then. regards john

Its a coshh assessment database I've been working on for a while... this particular bit checks if you have already done an assessment for the PPE (Personal protective equipment) then based on code will open exising or create new record. Sorry didn't trim it down but just thought the general...

I have used Dcount in the past to check for an existing record then if not used openargs to create a new one like: On Error GoTo Err_OpenRisk_Click Dim stDocName As String stDocName = "frmPPERisks1" 'Checks the table for duplicate entries prior to passing OpenArgs array if true...

You could use something like the following in your Not In List event of your combo box: Dim db As DAO.Database Dim newrec As DAO.Recordset Dim strMsg As String strMsg = "'" & NewData & "' is not an specified First Aid Action " & vbCrLf & vbCrLf strMsg = strMsg & "Do you want to add...

Have a look at the sample database here: http://www.utterangel.com/utterangel.aspx Its got a pretty good example for you to study :) Good luck john :) EDIT: In the format of the control you could put something like "BB/09/C/"0000 which would display what you want but have no idea how to...

You have already started a thread for this.... I have posted you an example of what you asked for maybe finish that thread first? http://www.access-programmers.co.uk/forums/showthread.php?p=822184#post822184

What do you mean you can't open/debug? what version of access are you using? do you mean you can't open the databse or unzip the file? Glad to help but need a bit more information.... John :)

You also mention excel why not try importing the information you have into access for a starting point using "Get external data" this will create your basic tables (provided the spreadsheets arr ok) sometimes you may get import errors but this is usually easily fixed. Then you could do as Simon...

As you say in your sig "ALWAYS more then one way to skin a cat" yours is the elegant solution :) and true....

Or you could write to a temp table then commit the record using a save button you could create on the form.

Hi, What about: If IsNull(Me![YourControl]) Then DoCmd.whatever_you_want Chould be in the OnLoad or OnOpen have a play :) Good luck John EDIT: Or if a subform control If (IsNull(Forms!YourMainForm!YourSubForm.Form.YourControl.Value)) Then DoCmd.Whater_you_want

Yeah found this one a while back hope you don't use tabbed pages tho as they will all be white now irrespective of setting e.g. transparent......;)

Hi Lil' Rascal, Yeah funny how people who have never or are not prepared to even try and create a working database can make the most inane comments.... I have created db's at near enough every company I have worked at although never employed to do so (I'm an electrical engineer by trade) You...