Search results for query: *

Hi i wonder if anyone would know this? I want to get a field value from the recordset. I've got a date field in the table xflag which is tested for the current date at the opening of the switchboard. If the test doesn't find today's date as the last record then emails are sent out otherwise no...

Hi, I know that a closed Access database can be updated i.e receive new records even when the actual database is not open. An example of this would be the way that MS Front Page sends records to an Access database. What I want to know is, if there is any way an event can be triggered in a...

Hi there, When you have a form on web page, Front Page allows you to either send the information as an email or as a record to MS Access. Does anyone know if you can do both, and if so, how do you do it?? Many Thanks

Thank you everyone for the tips on the leap year issue & although the 2000 % 4 isn't ideal - i only need to test for leap year's from 2000 to 2010. On another point, I'd like to find out if it's possibe to store controls on a form within an array & and then use the array indices to reference...

Hi, I need to test for a leap year within a form - I could achieve this within 'C' using the modulus operator '%' -which tests for whole numbers & returns the remainder i.e 2000 % 4 = 0 2001 % 4 = 3 Is there an equivalent operator or function within Visual Basic? I'd be grateful for any info...

Hello there, this may be something simple i don't know - but this is my code for counting all the records within my table 'CONTRACTORS': [/code] Dim RS As DAO.Recordset Dim DB As DAO.Database Set DB = CurrentDb() Set RS = DB.OpenRecordset("CONTRACTORS") With RS .MoveFirst .MoveLast...

Hi, I wonder if anyone knows about this...I want to set up a web based form which allows users to enter answers which will update a central database. I'm not really looking for detailed, specific answers at the moment as i want to establish a few things first. i. Is it possible for Access to...

Hello, This is my code: Dim DAO As Database Dim RS As DAO.Recordset Set DB = CurrentDb Set RS = DB.OpenRecordset(&quot;SELECT * FROM MAIL WHERE_ _NAME= '&quot; & NAME & &quot;' and XOPEN<>-1;&quot;, dbOpenDynaset) With RS .Movefirst .Movelast End With TOT=RS.Recordcount:msgbox tot...

Hi, I'm hoping someone can help produce a Crosstab Query Report. I've managed to produce a simple crosstab report for monthly overtime hours. The row headings are the names of the staff and each month is a column headings containing the hours worked, and the final column is a total of all hours...

HI, This is related to a previous thread posted last week - Stop Blank Entries & I would like to thank PGK for all the help & I did finally get it to work & I'm now happier working with the recordset. A new problem has now arisen. I've got a mail system which staff log in to in order to check...

Hi, I wonder if anyone can help me? I've got a Mail Logging System running over a network. Mail is logged by admin then technical staff are required to access the system via a password which opens a form filtered so that only mailed addressed specifically to them is displayed. They can't change...

Hi, Is there a way of storing the number of the last record in a variable. My form needs to know how many records are in the table connected to it. The form contains a VB procedure which tests & changes some of the field values where appropriate. I need to tell the procedure how many records to...

Hi, This should be a simple one, but i can't seem to work this one out. I'm running a parameter query which prompts on a YES/NO field. If you enter &quot;yes&quot; or &quot;no&quot; the query produces an error message. However it will accept -1 for &quot;yes&quot; and 0 for &quot;no&quot;, but I...

Hi, This should be a simple one, but i can't seem to work this one out. I'm running a parameter query which prompts on a YES/NO field. If you enter &quot;yes&quot; or &quot;no&quot; the query produces an error message. However it will accept -1 for &quot;yes&quot; and 0 for &quot;no&quot;, but I...

Hi, Can someone tell me how u can delete all the records from a particular table without opening it, using a command button from an unbound form? Thank you

Hi, Is there any way to change the text in disabled controls in a form so that they are easier to read. The read-only data currently displayed is a light grey which is hard to see. Any suggestions?

I've successfully created a form to enter report criteria - which opens another form displaying all the records matching the criteria. I want tp know how to automatically close the form if there aren't any records to display with the message 'No Records To Display', trystan