Search results

Cameron, Thank you for your reply. I did the following and it corrected it. Thanks for pointing out the boundcolumn = 3 that fixed a different problem for that drop down. It didn't allow to be select anything when bound column was 3 now that it's two it works. Here is the code I used to get...

I have a combo box I have to populate based on a query. I'm also doing an import within my app and if I hard code my query within my drop down I get an error during my import about it being used by someone else. My import effects the table that is used in my drop down. So i'm trying to use the...

Thanks for all the info guys I really appreciate it. Jerry

missinglinq, thank you that did the trick. Does Keycode= 0 disable all the keys when the focus is on that control? Jerry

Sorry guys for the weak explanation. I have about 6 things in the list. I want the drop down to acted like a web drop down. Then click the drop down and select and they aren't able to type anything in. I can't use a list box it has to be a drop down. Thank You Jerry

I would like to know what property stops the drop down from being edited at all. I have only in list set to yes but the user can still type in the drop down. I don't want them to be able to do that.

I have many date fields that I want to validate a range for. I created this function to pass in the text so that it will verify the date and then display a message if it is out of range then cancel the change so it isn't committed. Private Sub txtInDate_BeforeUpdate(Cancel As Integer)...

I have an access front end that compacts and repairs after each time it closes. What it is doing is setting the modified date to all of the forms to the system time and date when the front end is closed. This is the link from Microsoft but it doesn't have any resolution. Does anyone know how...

I have two db's a front end and a back end db. One of my users recently got this error "Could not update currently locked" Access "3218". I have a form tied to a table. She changed a drop down that puts an ID in the table row and the error occurred. This has never happend before and the...

I need to execute an append query from my vba code but I have to pass in a parameter. I can't set the parameter equal to a form control. I have to actually pass in a value. I don't want to use a querydef because I don't have any result sets. Any help would be great. Thanks

Code ' Forms For i = 0 To CurrentProject.AllForms.Count - 1 fName = CurrentProject.AllForms(i).Name bOpen = CurrentProject.AllForms(i).IsLoaded If Not bOpen Then DoCmd.OpenForm fName, acNormal End If If Forms(fName).Module.Find(sFind, StartLine, StartColumn...

I'm trying to create a find that will search through all my forms and let me know where a specific control is. I have it working if the forms are open but I can't open every form to run the find. Does anyone know of a way I can search all the controls on the forms to find where a specific...

Thanks Thanks that did it

I would like to know if anyone knows if I can create a query that will give me a count of the number of queries within my access DB? Thank You

Thanks Thank You everyone for all your help. It helped so much.

Does anyone know of a way that I could search all of my queries and VBA Code for specific columns? We add and remove columns all the time and our reports and forms crash when we miss taking them all out. We have so many that it is very hard to do manually. Thank for any help

Fixed it. The query was way too complex. I broke it down and eveything worked fine. Thanks for the help.

I tried putting the code in another query and it still closed out when I saved. When I opened it back up in the query list the new query showed up but completely empty.

I've Tried Compact and repair that didn't help. I will try putting it into a new query window and see if it lets me save.

When I try and save an older query my entire access shuts down without warning. I tried "Save" and "Save As". I even tried saving to a different name. Any Ideas?