Search results for query: *

Hi All, I can't seem to find this answered anywhere on this forum, but I have a problem when I import a file and it leaves the trailing field out of the data imported. The issue seems to be the first 150 records or so don't contain any data in this field and even though its specified within an...

Hi All, Does anyone know how to capture Ctrl + Alt + Del key combinations and stop the windows shut down from occurring? I cant figure it out using the KeyDown KeyPress events! [pipe] Thanks Woody [sadeyes]

Sorry the above was for Bitech. Thanks Woody [sadeyes]

jvogel, Make sure your form has Modal set to Yes as well as having Popup set to yes, I think this will solve your problem as it did for me. Thanks Woody [sadeyes]

Thanks SBendBuckeye, I appreciate the response and it now seems I'll be able to continue on my merry way. Thanks Woody [sadeyes]

Thanks again Rick, I like the last idea, I think Ill just have to do that! Thanks Woody [sadeyes]

Thanks Rick, I have tried to disable the subform as a whole before but am unable to enable it afterwards through the program, do I have to disable all the objects on the subform and enable them all for what you have suggested or is there a way to disable the whole subform. Thanks Woody [sadeyes]

I have a form/subform set up that sets initial focus to a text field but I need a text field to: 1 Contain a value and not be left blank 2 Contain a valid value before continuing to enter data anywhere else on the form. Ive tried the AfterUpdate event but this only works if a value is entered...

Thanks Shane, Its certainly does help. While I can recognise all the individual expressions I would have never put them all together like that to come up with a solution. I suppose its practice and forums etc like this where you learn the things most books cant teach. Thanks Woody [sadeyes]

Thanks Steve101, It was trying to create a new record each time. These things I suppose are sent to try us. Thanks Woody [sadeyes]

How can I use a combo box to display Primary Key data such that when a selection is made it goes to that record and doesnt display an error message saying that you cant duplicate that record. [sadeyes] Woody

I have a main form which has Job details on and a subform which lists Media details. What I want to achieve is if I entered a job number of 2000 that the media number on the sub form is assigned 1 if no other media is assigned to that job or is incremented by 1 if other media exist. This rule...

everytime, Thanks again, Ive just tried it and its exactly what I was looking for. Woody

everytime, Thanks for the response, Ill give it a go. Woody

hermanlaksko, Thanks for the help, however what Im trying to do in the program is once a user selects a database, it will populate the combo box with the names of the tables within the selected database. I believe what you have listed selects all fields from within a table if you know that the...

I want to add 'Table' names to a combo box at runtime after a database has been chosen within the program, so I wont know what these table names are until the program is running. ie If the chosen database had tables Table1, Table2, Table3, etc, I would like these to appear in the combo box. I...

How do you have more than one database open at a time using ='dbengine.workspaces(0).databases(0)' and using the '=Currentdb' without having to close one and open the other.