Search results

Thanks alot :)

I have a form that has a status, and a button that changes that status when clicked. This should remove the record from the current form and put it in another. Is there anyway I can refresh the form after that button is clicked to show the record actually dissapearing instead of having to...

Does this post make sense? :P

Figured it out, very simple tbh.

Using a command button to change a field value I have a button in a form that needs to change the text in a field named idStatus from "Assigned" to "Returned" I have tried using an expression like this "[Form]![Field]=12" in the OnClick spot but it returned an error. There is no "custom made"...

For sure :)

I have a form that is just a display/edit type form and I don't want a blank "new" report to show at the bottom when it is opened up. Is there any way to turn this off or disable it?

Ahhh that makes sense, you choose column 1. Thanks!

I found this in another thread: I have tried to make a textbox whose control sources says this "=Combo3.itemdata(0)" where my combo box is labelled "Combo3" but it doesn't work properly. Is there anything specific I need to do with the itemdata(0) part?

Sorry I don't understand what you mean by this. Do you mean use the combo box as the control source of my text box? I tried that and it didn't work. If I just use the text box with the control source "idStatus" I still only get the Primary Key (Number) instead of the value associated with it.

Is there any way to remove the down arrow in a combo box? I only want it to display something and not have someone able to edit it and the downarrow when the field is set to "Locked" makes it seem like the person can click the downarrow and click the item.

Thanks!!!! This worked.

I don't want administrators access to the backend, just to add values to certain tables that are in the DB. Currently I have a simple key protect on the DB but if you goto design view you can see the password right there. Anyone else have ideas on the error?

Anyone? This is kind of important

http://support.microsoft.com/?kbid=209871 I was using this form tutorial to password protect my administrative tools. When I went to run it I received this: "User defined type not defined" and the line Dim rs As DAO.Recordset was highlighted. I have little experience with VB and I was...

That made more sense, thanks! (Ellipses)

DoCmd.Maximize when placed in the "On Open" Event field of the form gives me the error "Microsoft cannot find the Macro 'DoCmd'"

Is there any way to make a form auto maximize on opening? I can't seem to find anything on this subject. Thanks.

I have been trying to figure out a way to export my forms as a webpage or an exe that can be used without having Access installed. A database I am workingon currently needs to be utilized by hundreds of people and I wish for them all to not have to have access. I have tried exporting a form as...

I have a search box and a submit button. Below that in a sub form I have a form that lists all of the entries associated with a certain project #. So I want it to be like this |____1_____| Search ________Subform_____ 1. Josh Vermast 1. Dave Thomas 1. Bob Price...