Search results

Thanks for the help everybody, but I figured it out. If you run the function on the keydown event rather that the keypress event it works just fine. Thanks for all your help

Thanks for the replies. I still don't quite understand how to fix my problem though. I don't see how creating a new record is going to help anything. I just need it to save what has been entered on the form's existing record before it closes. Thanks again for the help.

I tried doing the refresh but it doesn't help. I don't know if it matters but my tables are linked tables to an odbc data source. It won't even save if I click on the save icon before I press the esc key. Thanks for the reply.

I have a form that I want to close when the users presses the 'esc' key. It work fine but none of the information that I have entered on the form is saved. When I reopen the form I don not see any of my data. Here is my code: Private Sub Form_KeyPress(KeyAscii As Integer) If KeyAscii = 27...

I have a form that has several subforms on a tab control on it. I need to be able to run some code from one of these subforms everytime the record changes on the main form. I need to tell the subform to run its code everytime the record is changed on the main form. Thanks for your help.

I have a main form that has a tab control on it with several subforms, one on each page of the tab control. I want my users to be able to key down, use the tab key, or use the enter key to scroll through all these forms without using their mouse. I can change the focus from one subform to the...

I resolved the RI error, now I just need to know how copy one recordset to another from code with out using append queries.

I have a database which has multiple users that are not connected. What I would like to do is make it possible for me to automate synchronization with these databases when they do come together. For example copy all the new records in a certain table to that same table in a different database...

I have created a beautiful database, atleast I think, to track all the information for my organization. It is really not that large, only about 4 mb, without data in it. The problem I have is that my organization has many different sites across a large geographical area. We do not have the...

I have a form that contains a subform. I have a combo box inside the main form and when the user selects a certain value inside the combo box I change the recordset for the subform based on that value. I do this by opening a DAO recordset and setting the subforms recordset equal to this...

I have a database which tracks children's information, a lot of children's information. The problem is that I also want to track their individual and classroom attendance. I need to be able to print out an "attendance sheet" of sorts to hand to the teacher so she can mark what kids are there...

I don't want to copy the whole thing, but I would like to append one whole recordset to another one. I know that I can do this through an append query but I would like to do it totally from code. Anyhelp would be appreciated. thanks

I am writing my own synchronization program to work with our company database. There are a few things that I needed to do that replication didn't work right with. Anyways I was wondering if anyone knew if there was any way to copy one whole recordset at a time without setting all the fields...

I have 3 questions: 1st, Is there any way to change a design master that is ready for replication back to its orginal state, with no replication involved? 2nd, What I want to do is have one large database at a central site and have databases at other sites that are not networked together...

What kind of conditions and how exactly do I do that?

How do I change the text of only certain boxes on a continuous form. What I am talking about is one text box in design view, but if I change it there it changes all of them in form view, there has to be some way from code to change only the boxes i want to change. thanks.

Something is definetly wrong, I tried the debug.print "test" and I got test i the immediate window but still no breakpoints work and now even when there is an error in my code it doesn't stop and no errors are displayed so I cannot debug at all, It used to stop in the code where the error was...

I was hoping someone would know a way to change a text box's font color in VB Code. Now I know how to change 1, but my form is continuous with several text boxes containing a date and I want to change only the overdue ones to red. In design view it is just one box but in form view it is...

I have a large access project that I have been working with for months now. I have been debugging all of my code with no problems but for some reason now it will not stop at my breakpoints. The code is behind a form and I know the lines that I am setting the points on are being executed, but...

Is there any way to suppress a database project from showing the database window when F11 key is hit. I am making an application for users who do not need to see the database window and I can't figure out how to keep it from happening.