Search results

It crashes on mine as well. dont know why, but it is extremely annoying. forturnunetly I have windows XP so I do not need to reset my computer each time. I find it happens most when I click on the "New book Description" button. Some times it happens and sometimes it does not. we will soon see...

Simplycongy: I changed the DoCmd.RunCommand AcCmdDeleteRecord with a delete query it works now

I used your coding and had to rearrange it a little, It now works, but there is still a problem. This surprises me as much as it will surprise you; I get a warning dialog box popup and as you have already guessed It is not want is required. (if you don't believe me see attachment) Here is the...

Was sent to alternate email. Thanks

Simplycongy: I tried emailing it to you but you have some kind of download restriction on the hotmail account (or is full). File size when compressed: 1.13mb

Has been sent.

here is the coding: Public Function FFiveKey() 'this is where I want it to delete the record that was typed in 'tried the following to stop the validation error from appearing when the form is requeried. 'it did not work and i have resorted to taking out the validation rule so I can test it...

It is a bit big to post here. can email instead. Would you like me to email it to you? Thanks for helping

The person I am designing this for wants to be able to use the mouse as less as possible. the reason for this is if he has to type in something and then has to move his hand off the keyboard to the mouse to press a button and then back again to enter more records it is very inefficent for him...

hi llkhoutx, I have not tested it yet but would that be a lot of coding? for example the user may do a few other things and the undo would not undo the right action? Thanks for helping

Hi all Is there a way to cancel a record after half entering even without the primary key? (with coding, not the undo button on tool bar) I am having a problem with a unbound combo box and when the user starts typing in it, it will create a new record because its row source is sql code to look...

Depends on how big the porch is, the volume each appliance takes on the porch multiplied by the quantity of each appliance (of same type) and whether the porch takes the total weight of all appliances :p

GEORGE BUSH: When you rearrange the letters: HE BUGS GORE DORMITORY: When you rearrange the letters: DIRTY ROOM EVANGELIST: When you rearrange the letters: EVIL'S AGENT PRESBYTERIAN: When you rearrange the letters: BEST IN PRAYER DESPERATION: When you rearrange the letters: A...

Hi all Here are a couple of pictures, you have to see "Sicknote.jpg" before looking at "Sicknote attachment.jpg". Ps This is a adult joke and some people may be offended by it.

to add to what The_Doc_Man has just said, I have a form which has a Ontimer event, and in the ontimer event I have to have the subforms requery when user scans a barcode. the reason I needed Ontimer is because it needed to check for a entry in a text box, as it needed to lose focus so the...

Hi ken It does depend on which has focus (after testing). I think what I changed before was the deletion of the macro autokeys. I am now creating a new autokeys macro, but I still don't know how to make each key work differently in different forms. I have created a function in vb so that all...

I think it is possible to do this with a bit of coding. You may need a few dlookups and "&" to complete this. Supply us with a sample database and We'll be able to help you more.

I am thinking you may need a Many to many relation ship one to store the components, one to store the assembly names, and the table that joins both tables should be the one that has the components to make the assembly. Each component would get a new record, except if you had the same component...

Sezzy: I had my tables set up like that and now I wished I did not do it like that. Now it is better now because it is all stored in one table and the only thing that differences the records that I moved was the date sold field which is left null until a book is sold. and when I wanted results...

I had a problem once were when button was clicked it would just set the focus to the subform and goto the new record. the side effects of this was I had a event procedure in the field that got the focus and spent HOURS on this tring to figure this out. So question is: Do you have anything in...