Search results

I'm trying to count the number of records in a table, normally i'd do a dcount. But I'm trying to correct a problem in some VB code, which appends new data to an Access dB. How can I code it to count the records in the database from VB? cheers Rich

I always base all my forms on a query even if it is exactly the same design as a table. This way if you have to change something unexpectedly later on, such as inserting criteria, you can do so straight away. Just a thought. Rich

Check that the forms underlying query has the name field set to ascending. Why do you want to use the navigation buttons if you can select the name from the combo box, anyway? Rich

That's a good way of doing it, I hadn't used that Doevents code before, so now I know how can use it in future. Ric

Hi, I'm using the code below to put a password on the tabchange event. The problem is when the user enters the password - "password" it's not starred out, seeing as it's not a field I can't get rid of the problem with an input mask. Does anyone know how I can get the text entered into the input...

Yeah that's spot on. Cheers, Rich

Drew, I kinda like that code you demonstrated for the on keypress event. It prevents the mistake from happening in the first place, and I can certainly use it in my project. It's good to see that there are many alternative ways for this type of problem. I've been looking in help for...

Sorry, I should have realised it might do that. I just tried to see if I could do it with some of my data, but VB didn't like it. Rich

Try this: =DCount("[Location]", "domainfacts", "[Location] = '" & Me.ccfind & "'")

I've got loads of records in a student form (single form view) and would like to know how to use the DoCmd.FindRecord method or if their are other ways to find a record of a student by say searching through a surname field. I know you can just use the find button on the toolbar, to do this, but...

Thanks Drew that worked fine. I also didn't know about that isNumeric function Hicksy, so will be able to use that in future. Rich

On my form I want to code the before_update event to check if there are any characters in a txt box, cos I only want the user to enter figures. I couldn't find the answer in help. I reckon it must be pretty simple though, anyone know how? Rich

Yeah i've got it now, found it in help, I couldn't find it earlier. I had to do the syntax like this 'PG' Thanks anyway Rich [This message has been edited by Howlsta (edited 09-01-2001).]

What's wrong with the sql in my code below? It's something to do with setting the criteria to PG I think. I tried putting the PG bit in "" but that didn't work either. Anyone know why it's not working? It comes up with an input box with text PG above the text box at the moment. I want it to just...

I can't be arsed with this any more, there's simpler ways of finding records so it's not that important. Thanks anyway. I tried using recordsets in the load event too, but that was pissing me off too. Rich

I get this msg when i try to run the code below: Object doesn't support this property or method The error is caused by the following line. I got it straight from a book so it should work. It doesn't seem to like me using Find: Me.Recordset.Find "LastName = " & strName, Start:=1 Private...

I want to check if a course selected from a cbo is in the category UG or PG. CourseIDF and UG/PG are in the same table. I'm trying to use a dcount, but keep getting the syntax wrong. Both fields are numbers. Anyone spot the problem. DCount("[CourseIDF] ", "tblCourses", "[CourseIDF] = " &...

Mastering Microsoft Access 2000 by Alison Balter has loads of good examples, but also remember how good the Access and VB help is. Rich

The code below will create a table, just change it so it fits the fields you require, then you can add your tuples from the query. HTH Rich Sub CreateTable() Dim cat As ADOX.Catalog Dim tdf As ADOX.Table Dim idx As ADOX.Index Set cat = New ADOX.Catalog...

Hi Drew, Yeah, the other parameter is working fine, in fact they both are now. The DLookup worked OK, I didn't know about that method else I would have used it, cos speed is not really an issue as you mentioned. Now I know for next time as well. Cheers, Rich