Search results

Dim wrd As Integer wrd = Forms!FormName!Ward ElseIf Not IsNull([Outcome]) And Me.PAROnDisch = -1 And Me.UnitNo <> wrd Then msgbox "No PAR score on discharge entered. Please enter.", vbOKOnly, _ "Missing Information" DoCmd.GoToControl "PAROnDisch"

I presume that the region field would be empty for the zip code. if so then try this create a qry, and simply put Is Null in the criteria for the region field

DoCmd.OpenQuery "qryMissedEntriesC"

well, I dont know a great deal about asp, but am learning. you could check out http://forum.snitz.com/ and download this (it is free) this is an ASP forum that stores the information in an Access db, go through the codes provided, they may help

well, I have never tried multi be, but I have just put a db live that stores a lot of records and is running ok (single be)

well for the last 8 months, I have been working on writing a database (amongst other things) which is to be used at a busy distribution center (around 300 users tracking 15 trailers per hour), and will control all activities about trailers, security, unloading, loading, movement around site...

go into the design of the table that has the field to store this date. select the field and make the default value =Date() when you open the form, the field will then show current date, it will also store that date when the record is saved, so when you go back to the record it will show when the...

as the field name has no spaces, try the field name without brackets

do you know if it's stopping on form name or field name? if it's the field name, are you using the fields Name or the fields Control Source in the code? if you are using the fields control source, try using field name, which you can change to anything (checking references to it in the rest of...

OK try Forms![Form Name].Filter = "FieldName > ' '" if the field has a space in then it would be [Field Name] Hopefully that will sort it

which version of access are you using? I tried this on Access 97, that me cause a difference. If you are using Access 2k I will not be able to test until I get home, as my work is too cheap to upgrade :p

not entirely sure, as I tested the above and it worked OK don't mean to sound sarcastic but have you put Forms!FormName.Filter = "FieldName > ' '" as in = "FieldName > '(single quote) Space '(single Quote)"(double Quote)

try this create a button (make sure you have the wizard off) then place this code in the onclick event (change field name to which field you are filtering by and the form name to the form name you are using) Forms!FormName.Filter = "FieldName > ' '" Forms!FormName.FilterOn = True EDIT - if...

This is what I use Dim Db As Database Dim Rs As Recordset Set Db = CurrentDb Set Rs = Db.OpenRecordset("TableName", DB_OPEN_DYNASET) then use the RS.whatever to achieve what I want I use DB_OPEN_DYNASET as I more commonly split my databases, if it is not split then use DB_OPEN_TABLE instead...

Greetings all I have an on exit event which runs an MSDOS NET SEND command, but when it does tis, it gets in the way and will most definitely confuse the user Is there any way that I can run the command so that the MSDOS window remains hidden?

thats got it, thanks for the reply

Thanx for the reply, but when I do this, the following result is displayed 230337 hours and 45 minutes

Greetings all I have the following script from the Microsoft Knowledge base, but it is not working Function GetTimeCardTotal () Dim db As Database, rs As Recordset Dim totalhours As Long, totalminutes As Long Dim days As Long, hours As Long, minutes As Long...

I have recently started testing a database using Run Time Access, although I'm using Access 97, this may be an area for you to look at. Items that worked fine using full A97, brought up compile errors in Run Time. What I did was create a shortcut on the Run Time PC for the database, i.e. target...

here's what I am now using, this is in the OnExit event for the field On Error GoTo Err_CustCode_Exit Const conErrNotInList = 2427 Other Code Here Err_CustCode_Exit: If Err.Number = conErrNotInList Then DSPMSG "This is not a valid Customer Code, please check the number and try...