Search results

I have a form that has a bunch of project information and scrolling buttons at the bottom to browse by next/last. Right now the form is sorted by the ID associated with the project, which kinda sucks because they were and are not put in alphabetically. I discovered if you right click on a...

I have a form field with a date in it, is there any way I can make the value in that field display one thing, but still run a query based on the original text? for example: txtDate is 1/1/1000 if txtDate = 1/1/1000 then display = "*" but the query still runs on 1/1/1000 I am asking this...

I am running a query that links to a "wildcard" form so that the user can basically run a query filtered on any field they want. For some reason when I try to use wildcards along with Criteria in my query the query will not return any results. I know the link to the textbox is right because if...

I have a report that uses the code found below the filter the report by date. I have no idea where I found the code as I made this a long time ago, but now it has been requested that I add another filter to the actual report in addition to the date filter. This isn't the same setup as I have...

I have two tables, each has a "status" for a project. In the left table there is only one instance of each set, but in the right hand table, each set may be used more than once by different Projects. I need the Status field of the left table to be set to "Assigned" if ANY of the sets assigned...

I have two tables, each has a "status" for a project. In the first table there is only one instance of each project name, in the second table there may be more than 1, will always have the same name but may have a different "Status" (field). I need the Status field of the first table to be set...

Is there any way to make a date change to the current date/time whenever something on a report is edited? I have a "Last Updated" field but I want it to automatically update itself.

I have a query that feeds a report. This report shows a "Set" and the "Charge Numbers" associated with it. Each set could have a possibility of more than one set of IT numbers. This means there could be say 2 entries for set "D7" and IT numbers for both of them. As a result when I run the...

I currently have a network shared database. I setup permissions but only one PC shows a login screen when it starts up. The other just logins to "Admin" account which I have taken permissions away from and therefore cannot make any DB changes. Any idea how to fhix this?

Is there any way to change the order that the tab button cycles through the different fields in a form? Right now mine jumps ALL over the place and in some case even misses a field.

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...

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"...

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?

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.

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...

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...

Is there any way to have a query box on one form and have it "filter' persay a list of entries in a form/query in a subform below? I can't seem to get it to work or find any help on the subject.

I have a search tool, but right now it is 100% case sensitive in the sense that if i search for "test" and my entry is "Test" it will not return any results. is there any way to setup so I could say search for "Test" and it would find "test" properly? Or even to the extreme where I searched...

I have a form with a subform inside of it. On the subform I have created a field for a check box. I wish for the user to be able to click 1 or more check boxes in the subform and then click a delete button that removes all selected entries. I have this code from a seperate post regarding this...