Search results for query: *

I must say that I agree with visitor, I've been attempting to learn about the recordset & querydef aspects of Access or some time & wheras there are very helpful & simple explanations of the recordset, there are no complete or easy clarifications concerning Querydefs. I find the Microsoft help...

Thank you kindly for your very quick & excellent response, hope you have a pleasant weekend, Cheers T

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 there the first thing that springs to mind is probably not the best way, but it's pretty simple. You could create 3 hidden combo-boxes in exactly the same place on the form and have an event procedure based on your main combo-box which activates only one of the three hidden boxes when the...

Hi, Yes I though that would be the case, but thank you for your advice. I've got a web page based form written in Front Page - which is a staff suggestion form - new ideas are sent from the form to an access database. When these new records are sent or added I want the relevant people notified...

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, I've done something similar to this some time ago and if you look in the Northwind database you can see that the employees and products tables have OLE image fields. There must be some component missing as this should be as straight forward - you should be able to link to an outside...

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

Maybe the best way to do this would be to link the tables, rather than try to pass the variable from one database to an other. T

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...

The answer to your problem would seem to lie in the creation of an Event procedure triggered by a text box losing its focus. For clarity here is an example. I have 2 text boxes , the first [NAME] & the second [DAYS OFF]. The second cannot be modified by the user as the value has been calculated...

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...

Hi Neil, Have you tried this: CRNTUSR = CurrentUser() "...WHERE Table.Name = '" & [CRNTUSR] & "'") I had problems getting the recordset to recognize the value of the variable until I tried that. It might work for you, Trystan

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 my procedure to delete any 'empty' records which is triggered when the user clicks the MAIN MENU button on the form to exit. My problem is that is that i can count every record in the recordset but I don't know how to count the amount records which have been filtered, so my TOT1...

Hello, Yes, the record is created in the main table called MAIL LOG & does have a unique autonumber field called LETTER NUMBER The field for the name of the person is ADDRESSEE & the parameter query that the Mail form is based on, looks for this value in the logging in form. The Mail form opens...

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...