Search results

In the properties of the form there's "dividing lines", this is probably set to Yes at the moment, changing it to No should get rid of them.

Hi, it's normally because a field name is spelt wrong. What I usualy do is Debug.Print rst, then copy and paste it into the Query Builder SQL and see what error that gives me. Usually something like "The field/table xxx cannot be found"

I don't know as I've never used it but the "SourceObject" property looks like a good bet - its in the help files.

or do you mean that the event isn't firing off? [This message has been edited by KDg (edited 11-26-1999).]

You could try opening a recordset rather than a table. Set rst=db.openrecordset("SELECT ...FROM...WHERE...") and then use rst.recordcount>0 to check it exists. then populate you boxes with "let text1=rst.fields(0).value" and "let text2=rst.fields(1).value". That's as long as you're sure there...

Thanks, but I need the code to work just for a form or report and not to go to a table anywhere. Did you get the student rankings working okay?

have you tried using *DD* as the parameter in your query? this should work as long as the field is a text field and not memo

Hi, unfortunately this is not a solution but I'm starting to play with ASP and would be interested in seeing how you're doing it. Would you be willing to post your code here?

If you create a table with the signuatures in and have an ID for each one you should be able to drop the ID into the new record that you are creating. Then they can be linked back at any time to pull the signature and data together

Its okay I've found Timer and DoEvents

I need a timer for an application that is open all day but used periodicaly. I need it to fire itself up every 45 minutes to grab the users attention. However, the timer cannot use all of the app as users may want to use it within the 45 minutes. Has anyone done similar that I could use?

the first bit is okay - read the records then so an Instr(field) for the space that seperates the first and surnames, you may need to run it backwards or create your own function to start at the end and work to the front. then you can do a StrComp(Surname, section of other name) to see if...

Hi, I've never used 2000 or autodial ( why am I replying to this, perhaps I shouldn't ) will 'sendkeys' work?

You need something along the lines of dim MyRepsonse as variant let myResponse=msgbox("Are you sure etc",vbyesno,"YOUR TITLE") if myresponse=vbyes then let me.controlname.enabled=false ( you can use Locked instead of Enabled here ) let ...cycle through all the controls you want to lock...

It's usually something to do with the field/text box names. Have you tried renaming them as in txtHours etc It may be that it doesn't know what box/record to read off

has anyone got a Round() type function that will let me get as many/ few decimal places as I want, I don't want to use Int, Fix or CInt and it only needs to work for +ve numbers. I've started but figured that someone must have done this before...Thanks

Hi Rdbui, sorry for the glitch - it was me reading it wrong! the error is proabably because one of the field names is wrong. If you pasted it exactly then you'll need to change StudentID as I typed it to StudID. For the text box it's probably easier to skip the wizard and just change Column...

have you tried using the input mask 'Password' in the box's properties?

If the code is in the On_Exit event of the box you can use Cancel=True to stop the focus leaving the box, that makes it a bit tricky to leave at all though - have you tried Me.Flight_End_Date.setfocus?

I have an adherrance DB that users log their activities on that write to a standard text file format ( User ID, LogIn Time, LogOut time, Logout reason, LogOut Duration ). Access is linked into this. Every morning the text files are deleted as the data is pulled elsewhere for storage. However...